Last updated: August 5, 2025
39 dimensions
68 metrics
This reference covers all available dimensions and metrics for Pinterest Ads data through Detrics. Use this guide to understand what data you can extract and how to structure your queries.
Supported destinations:
Google Sheets

Dimensions

Dimensions are the attributes you can use to segment and group your Pinterest Ads data.

Account

Account Id


Field Name: AD_ACCOUNT_ID
Type: dimension
Account Name


Field Name: AD_ACCOUNT_NAME
Type: dimension
Account Country


Field Name: AD_ACCOUNT_COUNTRY
Type: dimension
Account Currency


Field Name: AD_ACCOUNT_CURRENCY
Type: dimension

Campaign

Campaign Id


Field Name: CAMPAIGN_ID
Type: dimension
Campaign Name


Field Name: CAMPAIGN_NAME
Type: dimension
Campaign Objective Type


Field Name: CAMPAIGN_OBJECTIVE_TYPE
Type: dimension
Campaign Status


Field Name: CAMPAIGN_STATUS
Type: dimension
Campaign Created Time
The time when the campaign was created

Field Name: CAMPAIGN_CREATED_TIME
Type: dimension
Campaign Updated Time
The time when the campaign was last updated

Field Name: CAMPAIGN_UPDATED_TIME
Type: dimension
Campaign Start Time
The time when the campaign started

Field Name: CAMPAIGN_START_TIME
Type: dimension
Campaign End Time
The time when the campaign ended

Field Name: CAMPAIGN_END_TIME
Type: dimension
Campaign Budget Optimization
Whether the campaign uses budget optimization

Field Name: CAMPAIGN_IS_BUDGET_OPTIMIZATION
Type: dimension
Campaign Summary Status
The overall status of the campaign

Field Name: CAMPAIGN_SUMMARY_STATUS
Type: dimension
Campaign Performance Plus
Whether the campaign is a Performance Plus campaign

Field Name: CAMPAIGN_IS_PERFORMANCE_PLUS
Type: dimension
Daily budget
The maximum amount you’re willing to spend in one day

Field Name: CAMPAIGN_DAILY_SPEND_CAP
Type: dimension
Lifetime budget
The maximum amount you’re willing to spend over the lifetime of your campaign

Field Name: CAMPAIGN_LIFETIME_SPEND_CAP
Type: dimension

Ad Group

Ad Group Id


Field Name: AD_GROUP_ID
Type: dimension
Ad Group Name


Field Name: AD_GROUP_NAME
Type: dimension
Ad Group Status


Field Name: AD_GROUP_STATUS
Type: dimension
Ad Group Created Time
The time when the ad group was created

Field Name: AD_GROUP_CREATED_TIME
Type: dimension
Ad Group Updated Time
The time when the ad group was last updated

Field Name: AD_GROUP_UPDATED_TIME
Type: dimension
Ad Group Start Time
The time when the ad group started

Field Name: AD_GROUP_START_TIME
Type: dimension
Ad Group End Time
The time when the ad group ended

Field Name: AD_GROUP_END_TIME
Type: dimension
Ad Group Budget Type
The budget type of the ad group

Field Name: AD_GROUP_BUDGET_TYPE
Type: dimension
Ad Group Billable Event
The billable event type for the ad group

Field Name: AD_GROUP_BILLABLE_EVENT
Type: dimension
Ad Group Lifetime Frequency Cap
The lifetime frequency cap for the ad group

Field Name: AD_GROUP_LIFETIME_FREQUENCY_CAP
Type: dimension
Ad Group Placement Group
The placement group for the ad group

Field Name: AD_GROUP_PLACEMENT_GROUP
Type: dimension
Ad Group Summary Status
The overall status of the ad group

Field Name: AD_GROUP_SUMMARY_STATUS
Type: dimension
Ad Group Bid Strategy Type
The bid strategy type for the ad group

Field Name: AD_GROUP_BID_STRATEGY_TYPE
Type: dimension
Ad Id


Field Name: AD_ID
Type: dimension
Ad Name


Field Name: AD_NAME
Type: dimension
Ad Status


Field Name: AD_STATUS
Type: dimension
Ad Created Time
The time when the ad was created

Field Name: AD_CREATED_TIME
Type: dimension
Ad Updated Time
The time when the ad was last updated

Field Name: AD_UPDATED_TIME
Type: dimension
Ad Creative Type
The type of creative used in the ad

Field Name: AD_CREATIVE_TYPE
Type: dimension
Ad Grid Click Type
The type of click interaction for the ad

Field Name: AD_GRID_CLICK_TYPE
Type: dimension
Ad Summary Status
The overall status of the ad

Field Name: AD_SUMMARY_STATUS
Type: dimension
Destination Url


Field Name: DESTINATION_URL
Type: dimension

Metrics

Metrics are the numerical values you can measure and analyze from your Pinterest Ads campaigns.

Most Used

Spend
Total amount you’ve spent during the reporting time period in US Dollars.

Field Name: SPEND_IN_DOLLAR
Type: metric
Clicks
The total number of clicks on your Pin to content on or off of Pinterest (paid and earned).

Field Name: TOTAL_CLICKTHROUGH
Type: metric
Impressions
Number of times someone saw your ad.

Field Name: TOTAL_IMPRESSION
Type: metric
Frequency
The average number of times each user saw your ad.

Field Name: TOTAL_IMPRESSION_FREQUENCY
Type: metric
Reach
Total number of unique users who saw your ads

Field Name: TOTAL_IMPRESSION_USER
Type: metric
Page Visits
Total number of page visit events resulting from interactions with your ad.

Field Name: TOTAL_PAGE_VISIT
Type: metric
Conversions
Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction

Field Name: TOTAL_CONVERSIONS
Type: metric
CPM
Average cost per 1k paid impressions

Field Name: CPM_IN_DOLLAR
Type: metric
CPC
Average cost per click

Field Name: ECPC_IN_DOLLAR
Type: metric
CTR
Total Pin clicks divided by total impressions

Field Name: ECTR
Type: metric
Paid Clicks
The total number of clicks on your Pin to content on or off of Pinterest.

Field Name: CLICKTHROUGH_1
Type: metric
Paid Impressions
The number of times your ad was seen.

Field Name: IMPRESSION_1
Type: metric
Paid Outbound Clicks
The total number of clicks to the destination URL associated with your ad

Field Name: OUTBOUND_CLICK_1
Type: metric
Paid Engagements
Paid actions taken as a result of your ads.

Field Name: ENGAGEMENT_1
Type: metric
Paid Saves
Total number of saves for your ad

Field Name: REPIN_1
Type: metric
Paid CTR
Paid Pin clicks divided by paid impressions

Field Name: CTR
Type: metric
Paid engagement rate
Paid engagements divided by paid impressions

Field Name: ENGAGEMENT_RATE
Type: metric
Paid save rate
Paid saves divided by paid impressions

Field Name: REPIN_RATE
Type: metric

Earned Metrics

Earned clicks
Total number of Pin clicks from ads saved to another person’s board

Field Name: CLICKTHROUGH_2
Type: metric
Earned Impressions
Total number of times your ad was viewed after being saved to another person’s board

Field Name: IMPRESSION_2
Type: metric
Earned Outbound Clicks
Earned Metrics are indirect or ‘earned’ results that come from organic sharing of your ad content. The total number of clicks to the destination URL associated with your ad saved to another person’s board.

Field Name: OUTBOUND_CLICK_2
Type: metric
Earned Engagements
Earned actions from ads saved to boards

Field Name: ENGAGEMENT_2
Type: metric
Earned Saves
Number of times your ad was saved from another person’s board.

Field Name: REPIN_2
Type: metric
Earned CTR
Earned Pin clicks divided by earned impressions

Field Name: CTR_2
Type: metric

Commerce

Add to Carts (Clicks)
The number of add to cart events resulting from clicks on your ad.

Field Name: TOTAL_CLICK_ADD_TO_CART
Type: metric
Add to Carts (Views)
Total number of add to cart events resulting from views of your ad.

Field Name: TOTAL_VIEW_ADD_TO_CART
Type: metric
Checkouts
Total number of checkout events that resulted from interactions with your ad.

Field Name: TOTAL_CHECKOUT
Type: metric

Video

Video Starts
Total number of times your video ad started playing (paid and earned)

Field Name: TOTAL_VIDEO_P0_COMBINED
Type: metric
Video Views
Total number of times your video ad played continuously for at least 2 seconds while 50% visible (paid and earned)

Field Name: TOTAL_VIDEO_MRC_VIEWS
Type: metric
3s Video Views
Total number of times your video ad played continuously for at least 3 seconds while 50% visible (paid and earned)

Field Name: TOTAL_VIDEO_3SEC_VIEWS
Type: metric
Video Watchtime Average (sec)
Averaged across all videos that begin playback, including seeks and loops. Start time triggered when video begins playback.

Field Name: TOTAL_VIDEO_AVG_WATCHTIME_IN_SECOND
Type: metric
Video played at 25%
Total number of times your video ad played 25% of its length, including views that skipped ahead to this point (paid and earned)

Field Name: TOTAL_VIDEO_P25_COMBINED
Type: metric
Video played at 50%
Total number of times your video ad played 50% of its length, including views that skipped ahead to this point (paid and earned)

Field Name: TOTAL_VIDEO_P50_COMBINED
Type: metric
Video played at 75%
Total number of times your video ad played 75% of its length, including views that skipped ahead to this point (paid and earned)

Field Name: TOTAL_VIDEO_P75_COMBINED
Type: metric
Video played at 95%
Total number of times your video ad played 95% of its length, including views that skipped ahead to this point (paid and earned)

Field Name: TOTAL_VIDEO_P95_COMBINED
Type: metric
Video played at 100%
Total number of times your video ad played 100% of its length, including views that skipped ahead to this point (paid and earned)

Field Name: TOTAL_VIDEO_P100_COMPLETE
Type: metric
Earned 3s video views
The number of times your video ad played continuously for 3 seconds while 50% in view after being saved to another person’s board

Field Name: VIDEO_3SEC_VIEWS_2
Type: metric
Earned video views
The number of times your video ad played continuously for 2 seconds while 50% in view after being saved to another person’s board

Field Name: VIDEO_MRC_VIEWS_2
Type: metric
Earned video starts
Total number of times your video ad started playing after it was saved to another person’s board

Field Name: VIDEO_P0_COMBINED_2
Type: metric
Earned video played at 100%
Total number of times your video ad reached 100% of its length after it was saved to another person’s board, including views that skipped ahead to this point

Field Name: VIDEO_P100_COMPLETE_2
Type: metric
Earned video played at 25%
Total number of times your video ad reached 25% of its length after it was saved to another person’s board, including views that skipped ahead to this point

Field Name: VIDEO_P25_COMBINED_2
Type: metric
Earned video played at 50%
Total number of times your video ad reached 50% of its length after it was saved to another person’s board, including views that skipped ahead to this point

Field Name: VIDEO_P50_COMBINED_2
Type: metric
Earned video played at 75%
Total number of times your video ad reached 75% of its length after it was saved to another person’s board, including views that skipped ahead to this point

Field Name: VIDEO_P75_COMBINED_2
Type: metric
Earned video played at 95%
Total number of times your video ad reached 95% of its length after it was saved to another person’s board, including views that skipped ahead to this point

Field Name: VIDEO_P95_COMBINED_2
Type: metric

Web Checkout

ROAS (Checkout)
Average return on ad spend for checkout events. This metric may include conversions that are modeled.

Field Name: CHECKOUT_ROAS
Type: metric
Total CPA (Page visit)
Average cost per page visit event. This metric may include conversions that are modeled.

Field Name: PAGE_VISIT_COST_PER_ACTION
Type: metric
Web ROAS (Page visit)
Average return on ad spend for page visit events. This metric may include conversions that are modeled.

Field Name: PAGE_VISIT_ROAS
Type: metric
Total conversion rate (Checkout)
The number of conversions per the number of total ad impressions that can be tracked to a conversion during the same time period.

Field Name: TOTAL_CHECKOUT_CONVERSION_RATE
Type: metric
Click-through conversions (checkout)
Total number of checkout events resulting from clicks on your ad. This metric may include conversions that are modeled.

Field Name: TOTAL_CLICK_CHECKOUT
Type: metric
View-through conversions (checkout)
Total number of checkout events resulting from views of your ad. This metric may include conversions that are modeled.

Field Name: TOTAL_VIEW_CHECKOUT
Type: metric
Web conversions (Checkout)
Total number of web checkout events resulting from clicks on your ad. This metric may include conversions that are modeled.

Field Name: TOTAL_WEB_CHECKOUT
Type: metric
Web click-through conversions (Checkout)
Total number of web checkout events resulting from clicks on your ad. This metric may include conversions that are modeled.

Field Name: TOTAL_WEB_CLICK_CHECKOUT
Type: metric
Web view-through conversions (Checkout)
Total number of web checkout events resulting from views of your ad. This metric may include conversions that are modeled.

Field Name: TOTAL_WEB_VIEW_CHECKOUT
Type: metric
Web CPA (Checkout)
Average cost per web checkout event. This metric may include conversions that are modeled.

Field Name: WEB_CHECKOUT_COST_PER_ACTION
Type: metric
Web ROAS (Checkout)
Average return on ad spend for web checkout events. This metric may include conversions that are modeled.

Field Name: WEB_CHECKOUT_ROAS
Type: metric

Gross

Gross Pin clicks
Unfiltered number of times someone clicks your ad (paid)

Field Name: CLICKTHROUGH_1_GROSS
Type: metric
Gross impressions
Unfiltered number of times your ad was on screen (paid)

Field Name: IMPRESSION_1_GROSS
Type: metric

Ratios

CPOC
Average cost per total outbound click (paid and earned)

Field Name: COST_PER_OUTBOUND_CLICK_IN_DOLLAR
Type: metric
CPCV (100%)
Average cost per video view that was played until completion, including views that skipped ahead to this point

Field Name: ECPCV_IN_DOLLAR
Type: metric
CPCV (95%)
Average cost per video that was played until 95% of its length, including views that skipped ahead to this point

Field Name: ECPCV_P95_IN_DOLLAR
Type: metric
CPE
Cost per engagement

Field Name: ECPE_IN_DOLLAR
Type: metric
CPV
Average cost per video view

Field Name: ECPV_IN_DOLLAR
Type: metric

Conversion Rates

Total conversion rate (Add to cart)
The number of conversions per the number of total ad impressions that can be tracked to a conversion during the same time period.

Field Name: TOTAL_ADD_TO_CART_CONVERSION_RATE
Type: metric
Total conversion rate (Page visit)
The number of conversions per the number of total ad impressions that can be tracked to a conversion during the same time period.

Field Name: TOTAL_PAGE_VISIT_CONVERSION_RATE
Type: metric
Total conversion rate (Website search)
The number of conversions per the number of total ad impressions that can be tracked to a conversion during the same time period.

Field Name: TOTAL_SEARCH_CONVERSION_RATE
Type: metric
Total conversion rate (Category view)
The number of conversions per the number of total ad impressions that can be tracked to a conversion during the same time period.

Field Name: TOTAL_VIEW_CATEGORY_CONVERSION_RATE
Type: metric

Engagement

Engagements
The total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves

Field Name: TOTAL_ENGAGEMENT
Type: metric
Save rate
Total saves divided by total impressions

Field Name: TOTAL_REPIN_RATE
Type: metric