Facebook Ads: Add creative-level call_to_action.value.link column to CREATIVE_HISTORY
Connector name: Facebook Ads
Table name: CREATIVE_HISTORY
Column to add: call_to_action_value_link
(and ideally call_to_action_value_app_link)
API documentation link:
https://developers.facebook.com/docs/instagram/ads-api/guides/use-posts-as-ads/
https://developers.facebook.com/docs/marketing-api/reference/ad-creative/
--- Additional context ---
Summary:
The creative-level `call_to_action.value.link` field is not synced. As a
result, the destination URL (landing page) of ads created from existing
Instagram posts cannot be obtained from any synced table.
Why this is inconsistent today:
- `CREATIVE_HISTORY.call_to_action_type` IS already synced (e.g. "LEARN_MORE"),
but the `link` inside the same `call_to_action` object is not.
- A parity column already exists for video creatives:
`CREATIVE_HISTORY.video_call_to_action_value_link`.
We are asking for the equivalent at the creative level.
- Meta's Marketing API does return this field. Per Meta's official guide
"Use Posts as Instagram Ads", the CTA is set on the creative as
`call_to_action: {"type": "...", "value": {"link": "<URL>"}}`.
Impact:
- Roughly 60% of our recently delivering ads have no obtainable landing page
URL, including our main conversion campaigns.
- UTM parameters live inside the same link, so campaign attribution mapping
is broken for those ads as well.
Already verified - the link is not available anywhere else:
- `link_url`, `object_story_link_data_link`, `video_call_to_action_value_link`,
`page_link`, `object_store_url`, `url_tags`: all NULL for the affected
creatives
- `AD_ASSET_FEED_SPEC_LINK_URL` and other `AD_ASSET_FEED_SPEC_*` tables:
no rows (these are not asset-feed creatives)
- `AD_SET_HISTORY` / `CAMPAIGN_HISTORY.promoted_object_object_store_url`: NULL
- Confirmed in Meta Ads Manager that these ads DO have a destination link
configured on their CTA button.
Environment:
- Destination: BigQuery
- Affected creatives: ads using an existing Instagram post
(`source_instagram_media_id` is set)
Please sign in to leave a comment.
Comments
0 comments