Pinterest Ads Connector Reference

141 metrics54 dimensions

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.

Possible values (24)
30/30/1default0/0/11/0/01/1/17/0/07/1/17/7/17/7/714/14/130/1/130/7/130/7/730/30/730/30/3060/1/160/7/160/7/760/30/160/30/760/30/3060/60/160/60/760/60/3060/60/60
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.

Possible values (2)
TIME_OF_AD_ACTIONdefaultTIME_OF_CONVERSION

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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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 TIMESTAMP 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
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
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.
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.
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
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