Connector Improvement: TikTok Ads - Add `tiktok_item_id` field to ad_history
AnsweredHi,
Could you please add the `tiktok_item_id` field to the `ad_history` table? It is returned by the API endpoint that Fivetran is currently consuming, but is not presently persisted to our warehouse: https://ads.tiktok.com/marketing_api/docs?id=1708572923161602
My company would like to use this field to join the Ads data against our TikTok Organic data. There is currently a field, `tiktok_ads.ad_history.video_id`, which seems that it would be a valid choice for a join key, but per the documentation linked above, this field is not populated for ads sourced from organic videos:
The documentation recommends using the `tiktok_item_id` field instead:
I have manually validated that this field would be sufficient for joining ads records to the organic records returned by the list videos endpoint (https://ads.tiktok.com/marketing_api/docs?id=1733327057319937).
Please let me know if there's any additional information I can provide to assist with your review of this feature request!
Best,
Matt
-
Official comment
Hey Matthew, Mahesh from product team here.
Thanks for making this feature request, and we have added this tiktok_item_id field to the AD_HISTORY table. Thanks!
Best,
Mahesh
TPO
Please sign in to leave a comment.
Comments
1 comment