Reddit Ads: Url Report

Description

• Each record in this table represents the daily number of clicks, impressions, and spend per url and utm parameters, along with post,ad, account, campaign, and ad group information.

Supported Data Sources

• Reddit 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	YYYY-MM-DD formatted date
STRING	ad_name	Name of ad.
STRING	ad_id	The ID of the ad.
STRING	account_id	The ID of the account.
STRING	campaign_name	Name of campaign.
STRING	campaign_id	The ID of the campaign.
STRING	ad_group_name	Name of ad group.
STRING	ad_group_id	The ID of the ad group.
STRING	currency	The currency this account uses (ISO-4217)
STRING	post_id	The ID of the post.
STRING	post_url	The URL belonging to the post.
STRING	click_url	The destination url, or the website address, that a visitor goes to when they click on the ad
STRING	base_url	The base URL of the ad, extracted from the click_url.
STRING	url_host	The URL host of the ad, extracted from the click_url.
STRING	url_path	The URL path of the ad, extracted from the click_url.
STRING	utm_source	The site that sent traffic to your page. Microsoft Advertising sets this to Bing; extracted from the click_url.
STRING	utm_medium	Which channel was used. Microsoft Advertising sets this to cp; extracted from the click_url.
STRING	utm_term	Which keyword brought people to your website; extracted from the click_url.
STRING	utm_content	Which ad group the keyword came from; extracted from the click_url.
STRING	utm_campaign	Which campaign the keyword came from; extracted from the click_url.
INTEGER	clicks	The number of clicks detected for this report period
INTEGER	impressions	The number of impressions served for this report period
INTEGER	spend	Spend converted out of microcurrency (so Spend/1,000,000)