Ad Reporting: Url Report

Description

• Each record represents daily metrics by URL (and if applicable, URL UTM parameters), ad group, campaign and account.

Supported Data Sources

• Facebook Ads

• Tiktok Ads

• Twitter Ads

• Snapchat Ads

• LinkedIn Ad Analytics

• Reddit Ads

• Microsoft Advertising

• Google Ads

• Pinterest 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 report.
STRING	platform	The ad platform associated with this record.
STRING	account_id	The ID representing the account.
STRING	account_name	The name of the account, if present in the source data.
STRING	campaign_id	The ID representing the campaign, if present in the source data.
STRING	campaign_name	The name of the campaign, if present in the source data.
STRING	ad_group_id	The ID representing the ad group, if present in the source data.
STRING	ad_group_name	The name of the ad group, if present in the source data.
STRING	base_url	The base url of the ad.
STRING	url_host	The URL host of the ad.
STRING	url_path	The URL path of the ad.
STRING	utm_source	The utm_source parameter of the ad.
STRING	utm_medium	The utm_medium parameter of the ad.
STRING	utm_campaign	The utm_campaign parameter of the ad.
STRING	utm_content	The utm_content parameter of the ad.
STRING	utm_term	The utm_term parameter of the ad.
INTEGER	clicks	The count of clicks.
INTEGER	impressions	The count of impressions.
DECIMAL	spend	The cost of the ads.