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 | |
| Row filtering | ||
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
Setup guide
Follow our step-by-step StackAdapt setup guide to connect StackAdapt with your destination using Fivetran 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.
Schema information
This schema applies to all StackAdapt connections.
Explore StackAdapt schema ERD
Limitations
- Historical syncs for StackAdapt connections may take longer than usual to complete because Fivetran always starts syncing data from January 1, 2013, regardless of when the StackAdapt account was created. This behavior is due to a limitation in the StackAdapt API.
- Initial syncs may take longer than expected due to the large volume of data in the incremental tables and their child tables.