Question

I used to 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?

Environment

Connector: Facebook Ads

Answer

This data is now stored as a JSON string in the table creative_history 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
• The id field of the creative_history table is also the creative_id.

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.

Cause

The url_tag table was deprecated in the most recent Facebook Ads connector.