Pinterest Ads: Url Report

Description

• Each record in this table represents the daily performance of ads at the advertiser, campaign, ad group, and url level.

Supported Data Sources

• Pinterest Ads

Columns

Type	Name	Description
	source_relation	The source of the record if the unioning functionality is being used. If not this field will be empty.
	date_day	The performance date of the record.
	advertiser_id	The ID of the related Advertiser.
	advertiser_name	Name of the advertiser.
	campaign_status	Status of the campaign.
	ad_group_status	Status of the ad group.
	destination_url	Pin destination URL.
	pin_promotion_id	The ID of the related Pin promotion.
	pin_name	Pin promotion name.
	pin_status	The status of the Pin promotion. One of "ACTIVE", "ARCHIVED", "PAUSED"
	creative_type	The creative type. One of "APP", "APP_VIDEO", "BOARD", "CAROUSEL", "CINEMATIC", "COMMERCE", "MAX_VIDEO", "NATIVE_VIDEO", "REGULAR", "SEARCH_PROMINENCE", "SEARCH_PROMINENCE_CAROUSEL", "SHOPPING", "SHOP_THE_PIN", "THIRD_PARTY", or "VIDEO".
	base_url	The base URL of the ad, extracted from the destination_url.
	url_host	The URL host of the ad, extracted from the destination_url.
	url_path	The URL path of the ad, extracted from the destination_url.
	utm_source	The utm_source parameter of the ad, extracted from the destination_url.
	utm_medium	The utm_medium parameter of the ad, extracted from the destination_url.
	utm_campaign	The utm_campaign parameter of the ad, extracted from the destination_url.
	utm_content	The utm_content parameter of the ad, extracted from the destination_url.
	utm_term	The utm_term parameter of the ad, extracted from the destination_url.
	campaign_id	The ID of the related Campaign.
	campaign_name	The name of the related Campaign.
	ad_group_id	The ID of the related Ad group.
	ad_group_name	The name of the related Ad group.
	impressions	The number of paid and earned impressions that occurred on the day of the record.
	clicks	The number of paid and earned clicks that occurred on the day of the record.
	spend	The amount of spend that occurred on the day of the record.