How Can I Get the URL_TAG Information?

Question

I have a table in my Facebook Ads schema called URL_TAG, but it hasn't been updated in a long time. How can I get this information?

Answer

The URL_TAG table was deprecated.

This data is now stored as a JSON string in the CREATIVE_HISTORY table in your Facebook Ads dataset in a column called url_tag. This column contains all of the original fields that used to be in the URL_TAG table:

• key
• type
• value
• creative_id (id field the CREATIVE_HISTORY table)

Other URL_TAG information can also be found in the ASSET_FEED_SPEC_LINK_URLS or OBJECT_STORY_LINK_DATA_CHILD_ATTACHMENTS tables.

If you already have it, you can continue to update the URL_TAG table using a transformation when the data is ingested. If not, you can modify downstream queries to parse the new url_tag field instead.