Pinterest Ads Connector Reference
The Pinterest Ads conenctor retrieves Pinterest ads data on an adveriser, campaign and pin level.
https://connectors.windsor.ai/pinterest?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source,transactions,transactionrevenue
The Pinterest Ads connector exposes 195 fields (141 metrics, 54 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available options
attribution_window Attribution Window (click/engagement/view)
Conversion attribution window for a pin click / engagement / view. Applies to Pinterest Tag conversion metrics. Engagements include saves, closeups, link clicks, and carousel card swipes. Prior conversion tags use their defined attribution windows. If not specified, defaults to 30/30/1 days.
conversion_report_time Conversion Report Time
The date by which the conversion metrics returned from this endpoint will be reported. There are two dates associated with a conversion event: the date that the user interacted with the ad, and the date that the user completed a conversion event.
Pinterest Ads Fields
Pinterest Ads audience_insights fields
The audience_insights report of the Pinterest Ads connector includes 5 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| audience_age | TEXT | Audience Insight Age | Age bracket of the ad account's audience (audience insights, not a targeting breakdown). |
| audience_gender | TEXT | Audience Insight Gender | Gender of the ad account's audience (audience insights, not a targeting breakdown). |
| audience_insight_type | TEXT | Audience Insight Type | Audience segment the demographics describe: 'YOUR_TOTAL_AUDIENCE', 'YOUR_ENGAGED_AUDIENCE' or 'PINTEREST_TOTAL_AUDIENCE'. |
| audience_share | PERCENT | Audience Insight Share | Share of the audience segment in this demographic bucket (0-1). Multiply by Audience Size for the bucket's population. |
| audience_size | NUMERIC | Audience Insight Size | Rounded total population of the audience segment. |
Pinterest Ads targeting_type fields
The targeting_type report of the Pinterest Ads connector includes 11 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| age | TEXT | Age | Age bracket breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| app_type | TEXT | App Type | App type breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| country | COUNTRY | Country | Country breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| gender | TEXT | Gender | Gender breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| geo | TEXT | Geo | Geo breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| keyword | TEXT | Keyword | Keyword breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| location | TEXT | Location | Location breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| pinner_interest | TEXT | Pinner Interest | Pinner Interest breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| placement | TEXT | Placement | Placement breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| region | REGION | Region | Region breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
| targeted_interest | TEXT | Targeted Interest | Targeted Interest breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other. |
Pinterest Ads other fields
The Pinterest Ads connector has 179 fields that do not belong to a named report, or belong to a report with only one or two fields.
Pinterest Ads other fields (account_id to engagement_paid)
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Your Pinterest Advertiser ID |
| account_name | TEXT | Account Name | The account (advertiser) name |
| ad_group | TEXT | Ad Group | Alias for ad group name. |
| ad_group_budget | NUMERIC | Ad Group Budget | Ad group budget in the account currency. Interpreted according to the ad group budget type (daily or lifetime). |
| ad_group_budget_type | TEXT | Ad Group Budget Type | Ad group budget type ('DAILY', 'LIFETIME', 'CBO_ADGROUP'). CBO_ADGROUP means the budget is set at the campaign level and distributed automatically across the campaign's ad groups. |
| ad_group_entity_status | TEXT | Ad Group Entity Status | Your ad group entity status. |
| ad_group_id | TEXT | Ad Group ID | Your ad group ID. |
| ad_group_name | TEXT | Ad Group Name | Your ad group name. |
| ad_group_status | TEXT | Ad Group Status | Your ad group status. |
| ad_id | TEXT | Ad ID | Your ad ID. |
| adnetwork_conversions | NUMERIC | Ad Network Conversions (alias for Conversions) | Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction |
| adnetwork_revenue | NUMERIC | Ad Network Revenue (alias for Total conversion value) | The value from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| advertiserid | TEXT | Advertiser ID | Your Pinterest Advertiser ID |
| average_order_value_checkout | NUMERIC | Average Order Value (Checkout) | Average value per checkout event, calculated as checkout order value divided by the number of checkout conversions. |
| campaign | TEXT | Campaign | Alias for Campaign Name |
| campaign_daily_spend_cap | NUMERIC | Campaign Daily Spend Cap | Campaign-level daily spend cap in the account currency (converted from micro-currency). Null or 0 means no cap is set. |
| campaign_end_time | Campaign End Time | Campaign end time converted from Unix timestamp. | |
| campaign_id | TEXT | Campaign ID | Campaign ID |
| campaign_lifetime_spend_cap | NUMERIC | Campaign Lifetime Spend Cap | Campaign-level lifetime spend cap in the account currency (converted from micro-currency). Null or 0 means no cap is set. |
| campaign_name | TEXT | Campaign Name | Campaign Name |
| campaign_objective | TEXT | Campaign Objective | Campaign objective type ('AWARENESS', 'CONSIDERATION', 'SALES', 'LEADS', 'APP_INSTALL', 'VIDEO_COMPLETION'; legacy: 'WEB_CONVERSION', 'CATALOG_SALES') |
| campaign_start_time | Campaign Start Time | Campaign start time converted from Unix timestamp. | |
| campaign_status | TEXT | Campaign Status | Campaign status ('ADVERTISER_DISABLED', 'ARCHIVED', 'COMPLETED', 'NOT_STARTED', 'PAUSED', 'RUNNING') |
| checkout_revenue | NUMERIC | Total Order value (Checkout) | Total value of checkout events resulting from interactions with your ad. |
| clicks | NUMERIC | Total number of Pin clicks (alias for Pin clicks) | The total number of clicks on your Pin to content on or off of Pinterest (paid and earned) |
| clickthrough | NUMERIC | Pin clicks | The total number of clicks on your Pin to content on or off of Pinterest (paid and earned) |
| clickthrough_earned | NUMERIC | Earned Pin clicks | Total number of Pin clicks from ads saved to another person's board |
| clickthrough_paid | NUMERIC | Paid Pin clicks | The total number of clicks on your Pin to content on or off of Pinterest |
| cpa | NUMERIC | CPA | The average CPA for all event types using the Pinterest Tag integration after an ad interaction |
| cpc | NUMERIC | Cost Per Click | Cost-per-click (CPC) bidding means that you pay for each click on your ads |
| cpm | NUMERIC | CPM | Cost per 1000 impressions (paid and earned) |
| ctr | PERCENT | CTR | Click-through rate of clicks on your Pin to content on or off of Pinterest (paid and earned) |
| currency | TEXT | Currency | Account currency |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row |
| date | DATE | Date | Date |
| day_of_month | TEXT | Day of month | Day of the month |
| earned_saves | NUMERIC | Earned Saves | Number of times your ad was saved from another person's board. |
| engagement_earned | NUMERIC | Earned engagements | Earned actions from ads saved to boards |
| engagement_paid | NUMERIC | Paid engagements | Paid actions taken as a result of your ads |
Pinterest Ads other fields (engagements to total_click_signup)
| ID | Type | Name | Description |
|---|---|---|---|
| engagements | NUMERIC | Engagements (alias for Total Engagements) | The total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves |
| frequency | NUMERIC | Frequency | The average number of times each user saw your ad. |
| impressions | NUMERIC | Impressions | Number of times someone saw your ad (paid and earned) |
| impressions_earned | NUMERIC | Earned impressions | Total number of times your ad was viewed after being saved to another person's board |
| impressions_paid | NUMERIC | Paid impressions | The number of times your ad was seen |
| month | TEXT | Month | Number of the month |
| now | Now | Current timestamp | |
| outbound_clicks | NUMERIC | Outbound clicks | The total number of clicks to the destination URL associated with your ad (paid and earned) |
| outbound_clicks_earned | NUMERIC | Earned outbound clicks | The total number of clicks to the destination URL associated with your ad saved to another person's board |
| outbound_clicks_paid | NUMERIC | Paid outbound clicks | The total number of clicks to the destination URL associated with your ad |
| paid_saves | NUMERIC | Paid Saves | Total number of saves for ad. |
| pin_promotion_id | TEXT | Pin Promotion (Ad) ID | Your ad ID. |
| pin_promotion_name | TEXT | Pin Promotion (Ad) Name | Your ad name. |
| pin_promotion_status | TEXT | Pin Promotion (Ad) Status | Ad status ('ACTIVE', 'OTHER', 'PAUSED') |
| reach | NUMERIC | User Reach | Total number of unique users who saw your ads |
| roas | PERCENT | ROAS | The average ROAS from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| roas_checkout | PERCENT | ROAS (Checkout) | Average return on ad spend for checkout events. This metric may include conversions that are modeled. |
| source | TEXT | Source | The name of the Windsor connector returning the row |
| spend | NUMERIC | Spend | Total amount you've spent during the reporting time period. Represents the spend amount depending on the level of detail of the report. If requested fields are at the campaign level, the spend is the sum of the spend for all ads in the campaign. If requested fields are at the ad group level, the spend is the sum of the spend for all ads in the ad group. If requested fields are at the pin promotion level, the spend is the spend for the pin promotion. |
| today | DATE | Today | Today's date |
| total_add_to_cart | NUMERIC | Conversions (Add to cart) | Total number of add to cart events resulting from interactions with your ad |
| total_add_to_cart_value | NUMERIC | Conversion value (Add to cart) | Total value of add to cart events resulting from interactions with your ad, in account currency |
| total_checkout | NUMERIC | Conversions (Checkout) | Total number of checkout events resulting from interactions with your ad |
| total_checkout_value | NUMERIC | Conversion value (Checkout) | Total value of checkout events resulting from interactions with your ad, in account currency |
| total_click_add_to_cart | NUMERIC | Click-through conversions (Add to cart) | The number of add to cart events resulting from clicks on your ad |
| total_click_add_to_cart_value | NUMERIC | Click-through conversion value (Add to cart) | Total value of add to cart events resulting from clicks on your ad, in account currency |
| total_click_checkout | NUMERIC | Click-through conversions (Checkout) | The number of checkout events resulting from clicks on your ad |
| total_click_checkout_value | NUMERIC | Click-through conversion value (Checkout) | Total value of checkout events resulting from clicks on your ad, in account currency |
| total_click_checkout_value_micros | NUMERIC | Click-through conversion value (Checkout) in micros | Total value of checkout events resulting from clicks on your ad, in micros of account currency |
| total_click_contact | NUMERIC | Click-through conversions (Contact) | The number of contact events resulting from clicks on your ad |
| total_click_contact_value | NUMERIC | Click-through conversion value (Contact) | Total value of contact events resulting from clicks on your ad, in account currency |
| total_click_custom | NUMERIC | Click-through conversions (Custom) | The number of custom events resulting from clicks on your ad |
| total_click_custom_value | NUMERIC | Click-through conversion value (Custom) | Total value of custom events resulting from clicks on your ad, in account currency |
| total_click_lead | NUMERIC | Click-through conversions (Lead) | The number of lead events resulting from clicks on your ad |
| total_click_lead_value | NUMERIC | Click-through conversion value (Lead) | Total value of lead events resulting from clicks on your ad, in account currency |
| total_click_page_visit | NUMERIC | Click-through conversions (Page visit) | The number of page visit events resulting from clicks on your ad |
| total_click_page_visit_value | NUMERIC | Click-through conversion value (Page visit) | Total value of page visit events resulting from clicks on your ad, in account currency |
| total_click_search | NUMERIC | Click-through conversions (Website search) | The number of website search events resulting from clicks on your ad |
| total_click_search_value | NUMERIC | Click-through conversion value (Website search) | Total value of website search events resulting from clicks on your ad, in account currency |
| total_click_signup | NUMERIC | Click-through conversions (Signup) | The number of signup events resulting from clicks on your ad |
Pinterest Ads other fields (total_click_signup_value to total_signup)
| ID | Type | Name | Description |
|---|---|---|---|
| total_click_signup_value | NUMERIC | Click-through conversion value (Signup) | Total value of signup events resulting from clicks on your ad, in account currency |
| total_click_view_category | NUMERIC | Click-through conversions (Category view) | The number of category view events resulting from clicks on your ad |
| total_click_view_category_value | NUMERIC | Click-through conversion value (Category view) | Total value of category view events resulting from clicks on your ad, in account currency |
| total_click_watch_video | NUMERIC | Click-through conversions (Watch video) | The number of watch video events resulting from clicks on your ad |
| total_click_watch_video_value | NUMERIC | Click-through conversion value (Watch video) | Total value of watch video events resulting from clicks on your ad, in account currency |
| total_contact | NUMERIC | Conversions (Contact) | Total number of contact events resulting from interactions with your ad |
| total_contact_value | NUMERIC | Conversion value (Contact) | Total value of contact events resulting from interactions with your ad, in account currency |
| total_conversions | NUMERIC | Conversions | Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction |
| total_conversions_value | NUMERIC | Total conversion value | The value from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| total_custom | NUMERIC | Conversions (Custom) | Total number of custom events resulting from interactions with your ad |
| total_custom_value | NUMERIC | Conversion value (Custom) | Total value of custom events resulting from interactions with your ad, in account currency |
| total_engagement | NUMERIC | Total engagements | The total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves |
| total_engagement_add_to_cart | NUMERIC | Engagement conversions (Add to cart) | Total number of add to cart events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_add_to_cart_value | NUMERIC | Engagement value (Add to cart) | Total value of add to cart events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_checkout | NUMERIC | Engagement conversions (Checkout) | Total number of checkout events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_checkout_value | NUMERIC | Engagement value (Checkout) | Total value of checkout events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_contact | NUMERIC | Engagement conversions (Contact) | Total number of contact events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_contact_value | NUMERIC | Engagement value (Contact) | Total value of contact events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_custom | NUMERIC | Engagement conversions (Custom) | Total number of custom events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_custom_value | NUMERIC | Engagement value (Custom) | Total value of custom events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_lead | NUMERIC | Engagement conversions (Lead) | Total number of lead events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_lead_value | NUMERIC | Engagement value (Lead) | Total value of lead events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_page_visit | NUMERIC | Engagement conversions (Page visit) | Total number of page visit events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_page_visit_value | NUMERIC | Engagement value (Page visit) | Total value of page visit events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_search | NUMERIC | Engagement conversions (Website search) | Total number of website search events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_search_value | NUMERIC | Engagement value (Website search) | Total value of website search events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_signup | NUMERIC | Engagement conversions (Signup) | Total number of signup events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_signup_value | NUMERIC | Engagement value (Signup) | Total value of signup events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_view_category | NUMERIC | Engagement conversions (Category view) | Total number of category view events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_view_category_value | NUMERIC | Engagement value (Category view) | Total value of category view events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_watch_video | NUMERIC | Engagement conversions (Watch video) | Total number of watch video events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_engagement_watch_video_value | NUMERIC | Engagement value (Watch video) | Total value of watch video events resulting from engagements with your ad. Engagements includes saves, closeups, carousel swipes, collection secondary closeups, and collection secondary saves. |
| total_lead | NUMERIC | Conversions (Lead) | Total number of lead events resulting from interactions with your ad |
| total_lead_value | NUMERIC | Conversion value (Lead) | Total value of lead events resulting from interactions with your ad, in account currency |
| total_page_visit | NUMERIC | Conversions (Page visit) | Total number of page visit events resulting from interactions with your ad |
| total_page_visit_value | NUMERIC | Conversion value (Page visit) | Total value of page visit events resulting from interactions with your ad, in account currency |
| total_saves | NUMERIC | Total Saves | The number of Repins from earned and paid sources. |
| total_search | NUMERIC | Conversions (Website search) | Total number of website search events resulting from interactions with your ad |
| total_search_value | NUMERIC | Conversion value (Website search) | Total value of website search events resulting from interactions with your ad, in account currency |
| total_signup | NUMERIC | Conversions (Signup) | Total number of signup events resulting from interactions with your ad |
Pinterest Ads other fields (total_signup_value to video_p100_complete_paid)
| ID | Type | Name | Description |
|---|---|---|---|
| total_signup_value | NUMERIC | Conversion value (Signup) | Total value of signup events resulting from interactions with your ad, in account currency |
| total_video_75_combined | NUMERIC | Total 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) |
| total_video_p0_combined | NUMERIC | Total video starts | Total number of times your video ad started playing (paid and earned) |
| total_video_p100_complete | NUMERIC | Total 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) |
| total_video_p25_combined | NUMERIC | Total 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) |
| total_video_p50_combined | NUMERIC | Total 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) |
| total_video_p95_combined | NUMERIC | Total 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) |
| total_video_views | NUMERIC | Total video views. | Total video views. |
| total_view_add_to_cart | NUMERIC | View-through conversions (Add to cart) | Total number of add to cart events resulting from views of your ad |
| total_view_add_to_cart_value | NUMERIC | View-through conversion value (Add to cart) | Total value of add to cart events resulting from views of your ad, in account currency |
| total_view_category | NUMERIC | Conversions (Category view) | Total number of category view events resulting from interactions with your ad |
| total_view_category_value | NUMERIC | Conversion value (Category view) | Total value of category view events resulting from interactions with your ad, in account currency |
| total_view_checkout | NUMERIC | View-through conversions (Checkout) | Total number of checkout events resulting from views of your ad |
| total_view_checkout_value | NUMERIC | View-through conversion value (Checkout) | Total value of checkout events resulting from views of your ad, in account currency |
| total_view_checkout_value_micros | NUMERIC | View-through conversion value (Checkout) in micros | Total value of checkout events resulting from views of your ad, in micros of account currency |
| total_view_contact | NUMERIC | View-through conversions (Contact) | Total number of contact events resulting from views of your ad |
| total_view_contact_value | NUMERIC | View-through conversion value (Contact) | Total value of contact events resulting from views of your ad, in account currency |
| total_view_custom | NUMERIC | View-through conversions (Custom) | Total number of custom events resulting from views of your ad |
| total_view_custom_value | NUMERIC | View-through conversion value (Custom) | Total value of custom events resulting from views of your ad, in account currency |
| total_view_lead | NUMERIC | View-through conversions (Lead) | Total number of lead events resulting from views of your ad |
| total_view_lead_value | NUMERIC | View-through conversion value (Lead) | Total value of lead events resulting from views of your ad, in account currency |
| total_view_page_visit | NUMERIC | View-through conversions (Page visit) | Total number of page visit events resulting from views of your ad |
| total_view_page_visit_value | NUMERIC | View-through conversion value (Page visit) | Total value of page visit events resulting from views of your ad, in account currency |
| total_view_search | NUMERIC | View-through conversions (Website search) | Total number of website search events resulting from views of your ad |
| total_view_search_value | NUMERIC | View-through conversion value (Website search) | Total value of website search events resulting from views of your ad, in account currency |
| total_view_signup | NUMERIC | View-through conversions (Signup) | Total number of signup events resulting from views of your ad |
| total_view_signup_value | NUMERIC | View-through conversion value (Signup) | Total value of signup events resulting from views of your ad, in account currency |
| total_view_view_category | NUMERIC | View-through conversions (Category view) | Total number of category view events resulting from views of your ad |
| total_view_view_category_value | NUMERIC | View-through conversion value (Category view) | Total value of category view events resulting from views of your ad, in account currency |
| total_view_watch_video | NUMERIC | View-through conversions (Watch video) | Total number of watch video events resulting from views of your ad |
| total_view_watch_video_value | NUMERIC | View-through conversion value (Watch video) | Total value of watch video events resulting from views of your ad, in account currency |
| total_watch_video | NUMERIC | Conversions (Watch video) | Total number of watch video events resulting from interactions with your ad |
| total_watch_video_value | NUMERIC | Conversion value (Watch video) | Total value of watch video events resulting from interactions with your ad, in account currency |
| totalcost | NUMERIC | Total Cost | Total amount you've spent during the reporting time period. Represents the spend amount depending on the level of detail of the report. If requested fields are at the campaign level, the spend is the sum of the spend for all ads in the campaign. If requested fields are at the ad group level, the spend is the sum of the spend for all ads in the ad group. If requested fields are at the pin promotion level, the spend is the spend for the pin promotion. |
| transactionrevenue | NUMERIC | Transaction Revenue (alias for Total conversion value) | The value from web conversions from your promoted Pins, including both first-order and downstream, in account currency |
| transactions | NUMERIC | Transactions (alias for Conversions) | Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction |
| video_p0_combined_earned | NUMERIC | Earned video starts | Total number of times your video ad started playing after it was saved to another person's board |
| video_p0_combined_paid | NUMERIC | Paid video starts | Number of times your video ad started playing |
| video_p100_complete_earned | NUMERIC | 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 |
| video_p100_complete_paid | NUMERIC | Paid video played at 100% | Number of times your video ad reached 100% of its length, including views that skipped ahead to this point |
Pinterest Ads other fields (video_p25_combined_earned to year_week_iso)
| ID | Type | Name | Description |
|---|---|---|---|
| video_p25_combined_earned | NUMERIC | 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 |
| video_p25_combined_paid | NUMERIC | Paid video played at 25% | Number of times your video ad reached 25% of its length, including views that skipped ahead to this point |
| video_p50_combined_earned | NUMERIC | 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 |
| video_p50_combined_paid | NUMERIC | Paid video played at 50% | Number of times your video ad reached 50% of its length, including views that skipped ahead to this point |
| video_p75_combined_earned | NUMERIC | 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 |
| video_p75_combined_paid | NUMERIC | Paid video played at 75% | Number of times your video ad reached 75% of its length, including views that skipped ahead to this point |
| video_p95_combined_earned | NUMERIC | 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 |
| video_p95_combined_paid | NUMERIC | Paid video played at 95% | Number of times your video ad reached 95% of its length, including views that skipped ahead to this point |
| week | TEXT | Week | Week (Sun-Sat). |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). |
| year | TEXT | Year | Year |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
Windsor vs Coupler.io
