Facebook Ads: Url Report

Description

• Each record represents the daily performance of a Facebook ad at the URL level.

Supported Data Sources

• Facebook Ads

Columns

Type	Name	Description
STRING	source_relation	The source of the record if the unioning functionality is being used. If not this field will be empty.
DATE	date_day	The date of the performance.
INTEGER	account_id	The ID of the related account.
STRING	account_name	The name of the related account.
INTEGER	campaign_id	The ID of the related campaign.
STRING	campaign_name	The name of the related campaign.
INTEGER	ad_set_id	The ID of the related ad set.
STRING	ad_set_name	The name of the related ad set.
INTEGER	ad_id	The ID of the related ad.
STRING	ad_name	The name of the related ad.
INTEGER	creative_id	The ID of the related creative.
STRING	creative_name	The name of the related creative.
STRING	base_url	The base URL of the ad, extracted from the page_link and template_page_link.
STRING	url_host	The URL host of the ad, extracted from the page_link and template_page_link.
STRING	url_path	The URL path of the ad, extracted from the page_link and template_page_link.
STRING	utm_source	The utm_source parameter of the ad, extracted from the page_link and template_page_link.
STRING	utm_medium	The utm_medium parameter of the ad, extracted from the page_link and template_page_link.
STRING	utm_campaign	The utm_campaign parameter of the ad, extracted from the page_link and template_page_link.
STRING	utm_content	The utm_content parameter of the ad, extracted from the page_link and template_page_link.
STRING	utm_term	The utm_term parameter of the ad, extracted from the page_link and template_page_link.
INTEGER	clicks	The number of clicks the ad had on the given day.
INTEGER	impressions	The number of impressions the ad had on the given day.
DECIMAL	spend	The spend on the ad in the given day.