Pinterest Ads Field Reference

Sample

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


Fields

IDTypeNameDescription
account_idTEXTAccount IDYour Pinterest Advertiser ID
ad_groupTEXTAd GroupAlias for ad group name.
ad_group_entity_statusTEXTAd Group Entity StatusYour ad group entity status.
ad_group_idTEXTAd Group IDYour ad group ID.
ad_group_nameTEXTAd Group NameYour ad group name.
ad_group_statusTEXTAd Group StatusYour ad group status.
ad_idTEXTAd IDYour ad ID.
adnetwork_conversionsNUMERICAd Network Conversions (alias for Conversions)Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction
adnetwork_revenueNUMERICAd 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
advertiseridTEXTAdvertiser IDYour Pinterest Advertiser ID
ageTEXTAgeAge bracket breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
app_typeTEXTApp TypeApp type breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
campaignTEXTCampaignAlias for Campaign Name
campaign_idTEXTCampaign IDCampaign ID
campaign_nameTEXTCampaign NameCampaign Name
campaign_statusTEXTCampaign StatusCampaign status ('ADVERTISER_DISABLED', 'ARCHIVED', 'COMPLETED', 'NOT_STARTED', 'PAUSED', 'RUNNING')
clicksNUMERICTotal 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)
clickthroughNUMERICPin clicksThe total number of clicks on your Pin to content on or off of Pinterest (paid and earned)
clickthrough_earnedNUMERICEarned Pin clicksTotal number of Pin clicks from ads saved to another person's board
clickthrough_paidNUMERICPaid Pin clicksThe total number of clicks on your Pin to content on or off of Pinterest
countryCOUNTRYCountryCountry breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
cpaNUMERICCPAThe average CPA for all event types using the Pinterest Tag integration after an ad interaction
cpcNUMERICCost Per ClickCost-per-click (CPC) bidding means that you pay for each click on your ads
cpmNUMERICCPMCost per 1000 impressions (paid and earned)
ctrPERCENTCTRClick-through rate of clicks on your Pin to content on or off of Pinterest (paid and earned)
currencyTEXTCurrencyAccount currency
datasourceTEXTData SourceThe name of the Windsor connector returning the row
dateDATEDateDate
day_of_monthTEXTDay of monthDay of the month
earned_savesNUMERICEarned SavesNumber of times your ad was saved from another person's board.
engagement_earnedNUMERICEarned engagementsEarned actions from ads saved to boards
engagement_paidNUMERICPaid engagementsPaid actions taken as a result of your ads
engagementsNUMERICEngagements (alias for Total Engagements)The total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves
frequencyNUMERICFrequencyThe average number of times each user saw your ad.
genderTEXTGenderGender breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
geoTEXTGeoGeo breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
impressionsNUMERICImpressionsNumber of times someone saw your ad (paid and earned)
impressions_earnedNUMERICEarned impressionsTotal number of times your ad was viewed after being saved to another person's board
impressions_paidNUMERICPaid impressionsThe number of times your ad was seen
keywordTEXTKeywordKeyword breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
locationTEXTLocationLocation breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
monthTEXTMonthNumber of the month
outbound_clicksNUMERICOutbound clicksThe total number of clicks to the destination URL associated with your ad (paid and earned)
outbound_clicks_earnedNUMERICEarned outbound clicksThe total number of clicks to the destination URL associated with your ad saved to another person's board
outbound_clicks_paidNUMERICPaid outbound clicksThe total number of clicks to the destination URL associated with your ad
NUMERICPaid SavesTotal number of saves for ad.
pin_promotion_idTEXTPin Promotion (Ad) IDYour ad ID.
pin_promotion_nameTEXTPin Promotion (Ad) NameYour ad name.
pin_promotion_statusTEXTPin Promotion (Ad) StatusAd status ('ACTIVE', 'OTHER', 'PAUSED')
pinner_interestTEXTPinner InterestPinner Interest breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
placementTEXTPlacementPlacement breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
reachNUMERICUser ReachTotal number of unique users who saw your ads
regionREGIONRegionRegion breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
roasPERCENTROASThe average ROAS from web conversions from your promoted Pins, including both first-order and downstream, in account currency
sourceTEXTSourceThe name of the Windsor connector returning the row
spendNUMERICSpendThe money you spend for promoted Pins, in account currency
targeted_interestTEXTTargeted InterestTargeted Interest breakdown (Targeting type). Up to 5 targeting types allowed. Note: The reporting per targeting type is independent from each other.
todayDATETodayToday's date
total_add_to_cartNUMERICConversions (Add to cart)Total number of add to cart events resulting from interactions with your ad
total_add_to_cart_valueNUMERICConversion value (Add to cart)Total value of add to cart events resulting from interactions with your ad, in account currency
total_checkoutNUMERICConversions (Checkout)Total number of checkout events resulting from interactions with your ad
total_checkout_valueNUMERICConversion value (Checkout)Total value of checkout events resulting from interactions with your ad, in account currency
total_click_add_to_cartNUMERICClick-through conversions (Add to cart)The number of add to cart events resulting from clicks on your ad
total_click_add_to_cart_valueNUMERICClick-through conversion value (Add to cart)Total value of add to cart events resulting from clicks on your ad, in account currency
total_click_checkoutNUMERICClick-through conversions (Checkout)The number of checkout events resulting from clicks on your ad
total_click_checkout_valueNUMERICClick-through conversion value (Checkout)Total value of checkout events resulting from clicks on your ad, in account currency
total_click_checkout_value_microsNUMERICClick-through conversion value (Checkout) in microsTotal value of checkout events resulting from clicks on your ad, in micros of account currency
total_click_customNUMERICClick-through conversions (Custom)The number of custom events resulting from clicks on your ad
total_click_custom_valueNUMERICClick-through conversion value (Custom)Total value of custom events resulting from clicks on your ad, in account currency
total_click_leadNUMERICClick-through conversions (Lead)The number of lead events resulting from clicks on your ad
total_click_lead_valueNUMERICClick-through conversion value (Lead)Total value of lead events resulting from clicks on your ad, in account currency
total_click_page_visitNUMERICClick-through conversions (Page visit)The number of page visit events resulting from clicks on your ad
total_click_page_visit_valueNUMERICClick-through conversion value (Page visit)Total value of page visit events resulting from clicks on your ad, in account currency
NUMERICClick-through conversions (Website search)The number of website search events resulting from clicks on your ad
total_click_search_valueNUMERICClick-through conversion value (Website search)Total value of website search events resulting from clicks on your ad, in account currency
total_click_signupNUMERICClick-through conversions (Signup)The number of signup events resulting from clicks on your ad
total_click_signup_valueNUMERICClick-through conversion value (Signup)Total value of signup events resulting from clicks on your ad, in account currency
total_click_view_categoryNUMERICClick-through conversions (Category view)The number of category view events resulting from clicks on your ad
total_click_view_category_valueNUMERICClick-through conversion value (Category view)Total value of category view events resulting from clicks on your ad, in account currency
total_click_watch_videoNUMERICClick-through conversions (Watch video)The number of watch video events resulting from clicks on your ad
total_click_watch_video_valueNUMERICClick-through conversion value (Watch video)Total value of watch video events resulting from clicks on your ad, in account currency
total_conversionsNUMERICConversionsTotal number of conversions for all event types using the Pinterest Tag integration after an ad interaction
total_conversions_valueNUMERICTotal conversion valueThe value from web conversions from your promoted Pins, including both first-order and downstream, in account currency
total_customNUMERICConversions (Custom)Total number of custom events resulting from interactions with your ad
total_custom_valueNUMERICConversion value (Custom)Total value of custom events resulting from interactions with your ad, in account currency
total_engagementNUMERICTotal engagementsThe total number of engagements on your ads, including clicks, saves, carousel swipes, and collections secondary saves
total_engagement_add_to_cartNUMERICEngagement 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_valueNUMERICEngagement 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_checkoutNUMERICEngagement 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_valueNUMERICEngagement 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_customNUMERICEngagement 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_valueNUMERICEngagement 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_leadNUMERICEngagement 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_valueNUMERICEngagement 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_visitNUMERICEngagement 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_valueNUMERICEngagement 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.
NUMERICEngagement 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_valueNUMERICEngagement 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_signupNUMERICEngagement 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_valueNUMERICEngagement 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_categoryNUMERICEngagement 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_valueNUMERICEngagement 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_videoNUMERICEngagement 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_valueNUMERICEngagement 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_leadNUMERICConversions (Lead)Total number of lead events resulting from interactions with your ad
total_lead_valueNUMERICConversion value (Lead)Total value of lead events resulting from interactions with your ad, in account currency
total_page_visitNUMERICConversions (Page visit)Total number of page visit events resulting from interactions with your ad
total_page_visit_valueNUMERICConversion value (Page visit)Total value of page visit events resulting from interactions with your ad, in account currency
total_savesNUMERICTotal SavesThe number of Repins from earned and paid sources.
NUMERICConversions (Website search)Total number of website search events resulting from interactions with your ad
total_search_valueNUMERICConversion value (Website search)Total value of website search events resulting from interactions with your ad, in account currency
total_signupNUMERICConversions (Signup)Total number of signup events resulting from interactions with your ad
total_signup_valueNUMERICConversion value (Signup)Total value of signup events resulting from interactions with your ad, in account currency
total_video_75_combinedNUMERICTotal 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_combinedNUMERICTotal video startsTotal number of times your video ad started playing (paid and earned)
total_video_p100_completeNUMERICTotal 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_combinedNUMERICTotal 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_combinedNUMERICTotal 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_combinedNUMERICTotal 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_viewsNUMERICTotal video views.Total video views.
total_view_add_to_cartNUMERICView-through conversions (Add to cart)Total number of add to cart events resulting from views of your ad
total_view_add_to_cart_valueNUMERICView-through conversion value (Add to cart)Total value of add to cart events resulting from views of your ad, in account currency
total_view_categoryNUMERICConversions (Category view)Total number of category view events resulting from interactions with your ad
total_view_category_valueNUMERICConversion value (Category view)Total value of category view events resulting from interactions with your ad, in account currency
total_view_checkoutNUMERICView-through conversions (Checkout)Total number of checkout events resulting from views of your ad
total_view_checkout_valueNUMERICView-through conversion value (Checkout)Total value of checkout events resulting from views of your ad, in account currency
total_view_checkout_value_microsNUMERICView-through conversion value (Checkout) in microsTotal value of checkout events resulting from views of your ad, in micros of account currency
total_view_customNUMERICView-through conversions (Custom)Total number of custom events resulting from views of your ad
total_view_custom_valueNUMERICView-through conversion value (Custom)Total value of custom events resulting from views of your ad, in account currency
total_view_leadNUMERICView-through conversions (Lead)Total number of lead events resulting from views of your ad
total_view_lead_valueNUMERICView-through conversion value (Lead)Total value of lead events resulting from views of your ad, in account currency
total_view_page_visitNUMERICView-through conversions (Page visit)Total number of page visit events resulting from views of your ad
total_view_page_visit_valueNUMERICView-through conversion value (Page visit)Total value of page visit events resulting from views of your ad, in account currency
NUMERICView-through conversions (Website search)Total number of website search events resulting from views of your ad
total_view_search_valueNUMERICView-through conversion value (Website search)Total value of website search events resulting from views of your ad, in account currency
total_view_signupNUMERICView-through conversions (Signup)Total number of signup events resulting from views of your ad
total_view_signup_valueNUMERICView-through conversion value (Signup)Total value of signup events resulting from views of your ad, in account currency
total_view_view_categoryNUMERICView-through conversions (Category view)Total number of category view events resulting from views of your ad
total_view_view_category_valueNUMERICView-through conversion value (Category view)Total value of category view events resulting from views of your ad, in account currency
total_view_watch_videoNUMERICView-through conversions (Watch video)Total number of watch video events resulting from views of your ad
total_view_watch_video_valueNUMERICView-through conversion value (Watch video)Total value of watch video events resulting from views of your ad, in account currency
total_watch_videoNUMERICConversions (Watch video)Total number of watch video events resulting from interactions with your ad
total_watch_video_valueNUMERICConversion value (Watch video)Total value of watch video events resulting from interactions with your ad, in account currency
totalcostNUMERICTotal CostThe money you spend for promoted Pins, in account currency
transactionrevenueNUMERICTransaction Revenue (alias for Total conversion value)The value from web conversions from your promoted Pins, including both first-order and downstream, in account currency
transactionsNUMERICTransactions (alias for Conversions)Total number of conversions for all event types using the Pinterest Tag integration after an ad interaction
video_p0_combined_earnedNUMERICEarned video startsTotal number of times your video ad started playing after it was saved to another person's board
video_p0_combined_paidNUMERICPaid video startsNumber of times your video ad started playing
video_p100_complete_earnedNUMERICEarned 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_paidNUMERICPaid video played at 100%Number of times your video ad reached 100% of its length, including views that skipped ahead to this point
video_p25_combined_earnedNUMERICEarned 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_paidNUMERICPaid 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_earnedNUMERICEarned 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_paidNUMERICPaid 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_earnedNUMERICEarned 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_paidNUMERICPaid 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_earnedNUMERICEarned 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_paidNUMERICPaid video played at 95%Number of times your video ad reached 95% of its length, including views that skipped ahead to this point
weekTEXTWeekWeek (Sun-Sat).
week_dayTEXTDay of week and day numberWeekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_isoTEXTDay of week and day number, ISOWeekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_isoTEXTWeek ISOWeek, ISO format (Mon-Sun).
yearTEXTYearYear
year_monthTEXTYearmonthYear and month, e.g. 2024|3
year_of_weekTEXTYear of weekThe year that contains first day of the week (Sun-Sat).
year_of_week_isoTEXTYear of week, ISOThe year that contains first day of the ISO week (Mon-Sun).
year_weekTEXTYear weekYear and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_isoTEXTYear week ISOYear and week for ISO weeks (Mon-Sun), e.g. 2024|20