Pinterest Ads: Pin Promotion Report

Description

• Each record in this table represents the daily performance of ads at the advertiser, campaign, ad group, and pin 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_id	The ID of the related Campaign.
	campaign_name	Name of the campaign.
	campaign_status	Status of the campaign.
	ad_group_id	The ID of the related Ad group.
	ad_group_name	Name of the ad group.
	ad_group_status	Status of the ad group.
	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".
	pin_promotion_id	The ID of the related Pin promotion.
	pin_name	Name of the pin.
	pin_status	Status of the pin.
	destination_url	Pin destination URL.
	base_url	The base URL of the ad, extracted from the destination_url.
	clicks	The number of paid and earned clicks that occurred on the day of the record.
	impressions	The number of paid and earned impressions that occurred on the day of the record.
	spend	The amount of spend that occurred on the day of the record.