Spotify Ads
Spotify Ads is an online advertising platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | check | |
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Spotify Ads setup guide to connect Spotify Ads with your destination using a Fivetran connector.
Sync overview
You can sync your Spotify Ads data either for all your Spotify accounts or for specific accounts.
For Spotify Ads, Fivetran runs two types of syncs: Incremental sync and Rollback sync.
Incremental sync
An incremental sync is a regular sync that starts according to the sync frequency that you configure. Each incremental sync captures changes for the past three days.
Rollback sync
A rollback sync is a sync that automatically runs once a day. Rollback syncs capture the changes that happen outside of the incremental sync time frame. The rollback sync time frame for our Spotify Ads connector is 90 days for reports with the DAY granularity and 14 days for the HOUR granularity.
Schema information
Fivetran provides custom aggregated reports and metadata tables for Spotify Ads:
- You can configure a custom aggregated report in the setup form. Supported entities for report are as follows:
CAMPAIGNAD_SETADAD_ACCOUNT
- Metadata tables provide information about Spotify Ads API entities and their configuration.
This schema applies to all Spotify Ads connectors.
To zoom, open the ERD in a new window.Updating data
The maximal sync frequency you can set for the Spotify Ads connector is 15 minutes.
For reports with the HOUR granularity, historical sync captures only previous 14 days' worth of data.