Pinterest Raw Data Guide

This guide shows you how to use the raw data coming from this specific data source APIs, so we can support you achieve your reporting needs. In this guide, some recommendations are provided as well as examples of use cases for the most commonly used fields. If you’d like to dig deeper into the raw data from each API, we recommend you to refer to our integrations documentation which provides links to each API documentation. For more guidance on how to build your reports and BI metrics, please inquire us about the Beginners Journey, Data Modelling Guide, Marketing Attribution and/or BI Metrics Guide.

Note: There may be several ways to achieve the use cases that has been indicated below, but these columns are the ones commonly used for most of the use cases we've encountered.

 

Most Used Tables

Table Name

Description

campaign_delivery_metrics

Returns delivery metrics for a campaign

pin_promotion_delivery_metrics

Returns delivery metrics for a pin promotion.

ad_group_pin_promotions

Returns all pin promotion objects for an ad group.

 

Most Used Fields

Column Name

Description

Use Cases

Table Name

name Pin promotion name Entity field/ Dimension to breakdown your metrics by different Pin promotions ad_group_pin_promotions
pin_id The ID of the pin Use for breaking down your ads metrics by the pin ad_group_pin_promotions
ad_group_id The ID of the Ad group. Use for breaking down your ads metrics by the ad group ad_group_pin_promotions
campaign_id The ID of the campaign Entity field/ Dimension to breakdown your metrics by different campaigns, or join metrics on each unique campaign ad_group_pin_promotions
created_time The autogenerated date and time when the ad was created. For analyzing ad performance overtime, grouping by metrics by time frames, or joining on sales data for a daily summary analysis and other advanced ananlysis. ad_group_pin_promotions
campaign_name The name of the ad Campaign. Entity field/ Dimension to breakdown your metrics by different campaigns campaign_delivery_metrics, ad_group_pin_promotions
day The date formatted as yyyy-MM-dd For analyzing ad performance overtime, grouping by metrics by time frames, or joining on sales data for a daily summary analysis and other advanced ananlysis. campaign_delivery_metrics, pin_promotion_delivery_metrics
IMPRESSION_1 Metric names ending in _1 represent first order ad events. For example, IMPRESSION_1 is the number of views/impressions on a Promoted Pin. Metric field to be used for calculating the CTR, among other conversion rates. campaign_delivery_metrics, pin_promotion_delivery_metrics
IMPRESSION_2 Metric names ending in _2 represent downstream (“earned”) events. These are actions taken on saved instances of Promoted Pins. Advertisers are not billed for earned activity. Metric field to be used for calculating the CTR, among other conversion rates. campaign_delivery_metrics, pin_promotion_delivery_metrics
CLICKTHROUGH_1 Metric names ending in _1 represent first order ad events. For example, CLICKTHROUGH_1 is the number of direct clicks on a Promoted Pin. Metric field to be used for calculating the CTR, among other conversion rates. campaign_delivery_metrics, pin_promotion_delivery_metrics
CLICKTHROUGH_2 Metric names ending in _2 represent downstream (“earned”) events. These are actions taken on saved instances of Promoted Pins. Advertisers are not billed for earned activity. Metric field to be used for calculating the CTR, among other conversion rates. campaign_delivery_metrics, pin_promotion_delivery_metrics
TOTAL_CONVERSIONS Metrics that begin with TOTAL refer to conversion data. TOTAL_CONVERSIONS is total number of conversions for the requested reporting period. If you are passing order quantity and order value in Pinterest Tag conversion events, these totals will show in TOTAL_CONVERSIONS_QUANTITY and TOTAL_CONVERSIONS_VALUE_IN_MICRO_DOLLAR. Metric field to be used for calculating the CVR, among other conversion rates, as well as CPC and so on. campaign_delivery_metrics, pin_promotion_delivery_metrics
TOTAL_CONVERSIONS_VALUE_IN_MICRO_DOLLAR Metrics that begin with TOTAL refer to conversion data. TOTAL_CONVERSIONS is total number of conversions for the requested reporting period. If you are passing order quantity and order value in Pinterest Tag conversion events, these totals will show in TOTAL_CONVERSIONS_QUANTITY and TOTAL_CONVERSIONS_VALUE_IN_MICRO_DOLLAR. Metric field to be used for calculating the ROI, CPC, and so on. campaign_delivery_metrics, pin_promotion_delivery_metrics
TOTAL_CONVERSIONS_QUANTITY Metrics that begin with TOTAL refer to conversion data. TOTAL_CONVERSIONS is total number of conversions for the requested reporting period. If you are passing order quantity and order value in Pinterest Tag conversion events, these totals will show in TOTAL_CONVERSIONS_QUANTITY and TOTAL_CONVERSIONS_VALUE_IN_MICRO_DOLLAR. Metric field to be used for calculating the CVR, among other conversion rates, as well as CPC and so on. campaign_delivery_metrics, pin_promotion_delivery_metrics
SPEND_IN_MICRO_DOLLAR It represents the spend in the micro currency (millionth of a currency unit) of the Advertiser. Metric field that measures the amount you spent on avertising, for calculating ROAS, etc. campaign_delivery_metrics, pin_promotion_delivery_metrics
OUTBOUND_CLICK_1 Paid outbound clicks Metric field that measures the amount of clicks generated by a paid pin campaign_delivery_metrics
REPIN_1 Metric names ending in _1 represent first order ad events. For example, REPIN_1 is the number of direct clicks on a Promoted Pin. Repins are used by Pinterest’s algorithm to determine which Pins are popular. This metric can support detecting most popular paid pins. campaign_delivery_metrics, pin_promotion_delivery_metrics
REPIN_2 Metric names ending in _2 represent downstream (“earned”) events. These are actions taken on saved instances of Promoted Pins. Advertisers are not billed for earned activity. Repins are used by Pinterest’s algorithm to determine which Pins are popular. This metric can support detecting most popular paid pins. campaign_delivery_metrics, pin_promotion_delivery_metrics
PIN_PROMOTION_ID The ID of the Pin Promotion Entity field/ Dimension to breakdown your metrics by different Pin promotions, or join metrics on each unique pin promotion pin_promotion_delivery_metrics
PIN_PROMOTION_CAMPAIGN_ID The ID of the Pin Promotion Campaign Entity field/ Dimension to breakdown your metrics by different campaigns, or join metrics on each unique campaign pin_promotion_delivery_metrics
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.