Support AD_ASSET_FEED_SPEC_CAROUSELS Table in Facebook Ads Connector
Answered
Problem
The Meta Marketing API Asset Feed Spec supports a carousels object as part of the Asset Feed Spec schema:
Fivetran currently exposes multiple Asset Feed Spec entities through dedicated tables, including:
-
ad_asset_feed_spec_bodies -
ad_asset_feed_spec_titles -
ad_asset_feed_spec_descriptions -
ad_asset_feed_spec_images -
ad_asset_feed_spec_videos -
ad_asset_feed_spec_link_urls
However, there is currently no corresponding ad_asset_feed_spec_carousels table.
Requested Enhancement
Add support for the Meta Asset Feed Spec carousels object and expose it through a dedicated ad_asset_feed_spec_carousels table, following the same modeling approach used for the other ad_asset_feed_spec_* entities.
Business Use Case
Our team uses the Facebook Ads connector to analyze Meta ad creatives. For carousel ads specifically, understanding the carousel-level asset configuration and asset ordering is critical.
Without access to the carousel asset feed specification:
-
It is difficult to determine how individual creative assets are assembled into carousel ads.
-
Asset ordering and presentation logic cannot be accurately reconstructed.
-
Analysis of creative performance at the carousel-card level is limited.
Providing the ad_asset_feed_spec_carousels table would enable users to fully model carousel creative structures and maintain parity with the Asset Feed Spec objects exposed by the Meta Marketing API.
Expected Outcome
A dedicated ad_asset_feed_spec_carousels table containing carousel asset feed specification data, linked to the relevant ad creative identifiers and consistent with the existing Asset Feed Spec table structure.
This enhancement would improve completeness of the Facebook Ads connector schema and provide access to data currently available through the underlying Meta Marketing API.
-
Official comment
Hi,
Luka, thanks for submitting this request. TLDR: the data you're after doesn't appear to be in the Asset Feed Spec, and may already be in your warehouse.
The Ad Asset Feed Spec handles dynamic creative assets like images, videos, titles, and bodies. It uses ad_formats to signal carousel format, but there's no carousel sub-object on it per the API docs: https://developers.facebook.com/docs/marketing-api/reference/ad-asset-feed-spec/.
Per-card data lives elsewhere: on the AdCreative's object_story_spec, under link_data.child_attachments. Each entry in the child attachments array is one carousel card with fields like name, description, link, image_hash, call_to_action, and video_id:
- https://developers.facebook.com/docs/marketing-api/reference/ad-creative-object-story-spec
- https://developers.facebook.com/docs/marketing-api/reference/ad-creative-link-data/
- https://developers.facebook.com/docs/marketing-api/reference/ad-creative-link-data-child-attachment/
That data is already synced via the creative_history table as the object_story_link_data_child_attachments column, stored as a JSON array with one element per card. I'd check there first before we figure out the next steps.
If parsing JSON is fine, you may already have what you need. If you want the cards as normalized rows and columns, let me know. We could handle that as a feature improvement, although it will be complicated given the structure of object_story_link_data_child_attachments.
Let me know if you have questions or if I've missed something.
Cheers,
Luke -
Hi, Luke,
I see you shared a link from the official Graph API documentation. I also sent one, where it says that `carousels` is a field available in asset feed spec through the Graph API. We also verified this behavior on some examples. Here's the link to official Graph API docs: https://developers.facebook.com/documentation/ads-commerce/marketing-api/ad-creative/asset-feed-spec/options.
This `carousels` field is important to us because we can get the correct order and references to images/videos from this field.
Best, Luka
Please sign in to leave a comment.
Comments
2 comments