How Can I Get the Website URLs Associated With My Facebook Ads?
Facebook stores the website URL (also called the click URL or destination URL) for an ad in different places depending on how you created the ad. We sync all of these locations to your destination. To find the URL for an ad, check the table and column that correspond to its type.
| Ad type | Table | Column | Details |
|---|---|---|---|
| Standard link ads | CREATIVE_HISTORY | object_story_link_data_link | Contains the website URL as a string. |
| Carousel ads | CREATIVE_HISTORY | object_story_link_data_child_attachments | Contains a JSON array. Each item has a link value with the URL for that carousel card. |
| Video ads | CREATIVE_HISTORY | video_call_to_action_value_link | Contains the call-to-action URL as a string. |
| Dynamic creative ads (ads that use an asset feed spec) | AD_ASSET_FEED_SPEC_LINK_URL | website_url | Contains the website URL, including any UTM parameter data. To find the ad, join creative_id to CREATIVE_HISTORY.id. |
If a column is empty for an ad, check the other locations. Facebook returns the URLs for dynamic creative ads in the asset feed spec, so object_story_link_data_link may be empty for those ads.
For more information on available columns and corresponding Facebook Ads API references, see our Facebook Ads Schema documentation.