StackAdapt Lite
StackAdapt is an advertising platform.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | ADVERTISER, AUDIENCE, CAMPAIGN, CAMPAIGN_GROUP, CONVERSION_TRACKER, CREATIVE, CUSTOM_SEGMENT_OPTION, DEAL_GROUP, RETARGETING_AUDIENCE, and SUPPLY_SOURCE_OPTION tables |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step StackAdapt setup guide to connect StackAdapt with your destination using Fivetran connectors.
Schema information
This schema applies to all StackAdapt connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
INSIGHT_CAMPAIGN_AUDIENCEINSIGHT_CAMPAIGN_AUDIENCE_ABINSIGHT_CAMPAIGN_BID_FACTORINSIGHT_CAMPAIGN_CATEGORYINSIGHT_CAMPAIGN_CREATIVE_TACTICINSIGHT_CAMPAIGN_DEALINSIGHT_CAMPAIGN_DEMOGRAPHICINSIGHT_CAMPAIGN_DEVICEINSIGHT_CAMPAIGN_GEOINSIGHT_CAMPAIGN_GROUP_AUDIENCEINSIGHT_CAMPAIGN_GROUP_AUDIENCE_ABINSIGHT_CAMPAIGN_GROUP_BID_FACTORINSIGHT_CAMPAIGN_GROUP_CATEGORYINSIGHT_CAMPAIGN_GROUP_CREATIVE_TACTICINSIGHT_CAMPAIGN_GROUP_DEALINSIGHT_CAMPAIGN_GROUP_DEMOGRAPHICINSIGHT_CAMPAIGN_GROUP_DEVICEINSIGHT_CAMPAIGN_GROUP_GEOINSIGHT_CAMPAIGN_GROUP_RETARGETING_SEGMENTINSIGHT_CAMPAIGN_GROUP_SUPPLY_SOURCEINSIGHT_CAMPAIGN_RETARGETING_SEGMENTINSIGHT_CAMPAIGN_SUPPLY_SOURCESTATS_DELIVERY_ADVERTISERSTATS_DELIVERY_CAMPAIGNSTATS_DELIVERY_CAMPAIGN_GROUPSTATS_DELIVERY_CONVERSION_TRACKERSTATS_DELIVERY_NATIVE_AD
To capture updates and deletes, we re-import the remaining tables and their child tables during every sync.
Due to StackAdapt limitations, historical syncs start with data from January 1, 2013 no matter when the account is created. Because of this, historical syncs take a lot of time.
Limitations
Due to the large volume of data, the incremental sync tables and their child tables take a long time to sync. As a result, your initial syncs may take longer than usual to complete.