How Can I Get URL_TAG Facebook Data?
Find out why the URL_TAG Facebook Ads table isn't updating and where you can find the data now.
Why isn't the URL_TAG table updating?
The URL_TAG table was discontinued. We now sync the relevant data to a different table in your destination.
Where can I find the URL_TAG table data?
We store the data as a JSON string in the url_tag column of the CREATIVE_HISTORY table. This column contains all of the original URL_TAG table fields:
keytypevaluecreative_id(idfield theCREATIVE_HISTORYtable)
You can find additional URL_TAG data in the ASSET_FEED_SPEC_LINK_URLS or OBJECT_STORY_LINK_DATA_CHILD_ATTACHMENTS tables.
If the URL_TAG table already exists in your destination, you can continue to update it using a transformation when the data is ingested. Otherwise, consider modifying downstream queries to parse the new url_tag field instead.