Connector Improvement: Allow for Deleted or Archived Ads/Campaigns/Adgroups to be exported
For many media partners such as Facebook, TikTok, etc there is the ability to delete or archive campaigns/accounts/ads etc from the UI/API. The reason why media partners allow this varies, but when it comes to pulling data off their API, it appears most partners default to not including these deleted objects without explicitly calling for them. We'd like to include the ability when setting up a connector to include deleted/archived campaigns. In our case, we have media that was run, and billed, but later deleted. As a result, we are not pulling all data via Fivetran as is reflected via finance and accounting.
Here are specific references for Facebook and tiktok on how a param can be included to include these assets:
- FB: https://developers.facebook.com/docs/marketing-api/insights#deletearchive
- TikTok: https://ads.tiktok.com/marketing_api/docs?id=1751443975608321. related request for the same feature already submitted - https://support.fivetran.com/hc/en-us/community/posts/4415541216791-Connector-Improvement-TikTok-deleted-ads?input_string=Allow%20for%20Deleted%20or%20Archived%20Ads%2FCampaigns%2FAdgroups%20to%20be%20exported
Other vendors this feature should be enabled for -
- Bing (microsoft ads)
- Apple
- Spotify
Notes:
- Once assets are deleted in Snapchat they are gone forever so this setup does not need to be considered for them - https://businesshelp.snapchat.com/s/article/manage-campaigns?language=en_US
- Twitter appears to return all analytics data whether something is deleted or not - https://developer.twitter.com/en/docs/twitter-ads-api/analytics/overview
-
Hi Bowen, Calvin from the Product team here!
Thanks for the context on this feature request. Can you please elaborate on your use case for historical objects that are now deleted or archived?
-
Hi Calvin,
This has to do with how agencies will sometimes buy media. Due to platform limitation only a certain number of assets my be "live" or available in a platform at at time. When these limits are hit, agencies will at times "delete" old campaigns or other media object to free up space. When this is done, if we are not pulling deleted objects, we do not get an accurate view of spend, impressions, etc. This might only be an issue during historical loads of data, which is where we spotted the issue, but that i think has to do with how fivetran ingest changes and I can't comment on.
Please sign in to leave a comment.
Comments
2 comments