Connector name: Snapchat Ads

Table name: creative_history

Column to add: url_macro_parameters 

API documentation link: https://developers.snap.com/marketing-api/Ads-API/creatives

Additional details:

For COLLECTION-type creatives, the connector currently returns NULL for both web_view_url and creative_url_tag_history on creative_history.

This is distinct from the nested collection_properties.web_view_properties.url field, which is inconsistently populated (present only when a static fallback web-view interaction is configured, absent on dynamic/catalog-driven Collection ads). We are not asking about that field.

What we found (verified via read-only GET /v1/creatives/{creative_id} against Snapchat's live API, same endpoint the connector already calls):
COLLECTION-type creatives — both static and catalog-driven/dynamic — return a separate, top-level url_macro_parameters string field (not nested inside collection_properties), e.g.:

"url_macro_parameters": "utm_medium=cpc&utm_source=snapchat&utm_campaign={{campaign.name}}&utm_content={{creative.name}}&utm_term={{adSet.name}}"

This field is absent (null) on WEB_VIEW-type creatives, which instead carry the equivalent data embedded directly in web_view_properties.url. Unlike the nested fallback URL, url_macro_parameters's presence does not depend on whether the Collection ad is render_type=STATIC or render_type=DYNAMIC — it's populated regardless.

Ask: Add url_macro_parameters as a synced column on creative_history, sourced from the existing Creatives endpoint (adaccounts/{ad_account_id}/creatives) response — no new endpoint or resource type needed, just an additional top-level field from the response the connector already fetches.