Pinterest Ads fields

Prev Next

Supermetrics brings all your Pinterest Ads data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

321 metrics139 dimensions

AD GROUP

ad_group_campaign_id
ad_group_id
ad_group_name
ad_group_status
ad_group_type
ad_group_auto_targeting_enabled
ad_group_bid_value
ad_group_billable_event
ad_group_budget_value
ad_group_budget_type
ad_group_lifetime_frequency_cap
ad_group_optimization_goal_metadata_conversion_tag_id
ad_group_optimization_goal_metadata_conversion_event
ad_group_optimization_goal_metadata_engagement_window
ad_group_optimization_goal_metadata_click_window
ad_group_optimization_goal_metadata_view_window
ad_group_optimization_goal_metadata_learning_mode_type
ad_group_optimization_goal_metadata_cpa_goal_value
ad_group_pacing_delivery_type
ad_group_pin_promotion_ids
ad_group_placement_group
ad_group_targeting_spec_app_type
ad_group_targeting_spec_gender
ad_group_targeting_spec_locale
ad_group_targeting_spec_location
ad_group_targeting_spec_geo
ad_group_tracking_urls
ad_group_start_time
ad_group_end_time
ad_group_created_time
ad_group_updated_time

ADVERTISER

advertiser_id
advertiser_name
advertiser_country
advertiser_currency
advertiser_owner_user_id
advertiser_roles

CAMPAIGN

campaign_id
campaign_name
campaign_start_time
campaign_end_time
campaign_daily_spend_cap
campaign_lifetime_spend_cap
campaign_status
campaign_objective_type
campaign_order_line_id
campaign_created_time
campaign_updated_time

CONVERSIONS ADD TO CART

total_click_add_to_cart
total_click_add_to_cart_quantity
total_click_add_to_cart_value
total_engagement_add_to_cart
total_engagement_add_to_cart_quantity
total_engagement_add_to_cart_value
total_view_add_to_cart
total_view_add_to_cart_quantity
total_view_add_to_cart_value
total_add_to_cart_desktop_action_to_desktop_conversion
total_add_to_cart_desktop_action_to_mobile_conversion
total_add_to_cart_desktop_action_to_tablet_conversion
total_add_to_cart_mobile_action_to_desktop_conversion
total_add_to_cart_mobile_action_to_mobile_conversion
total_add_to_cart_mobile_action_to_tablet_conversion
total_add_to_cart_tablet_action_to_desktop_conversion
total_add_to_cart_tablet_action_to_mobile_conversion
total_add_to_cart_tablet_action_to_tablet_conversion
inapp_add_to_cart_cost_per_action
inapp_add_to_cart_roas
total_inapp_add_to_cart
total_inapp_add_to_cart_value
total_inapp_click_add_to_cart
total_inapp_click_add_to_cart_value
total_inapp_engagement_add_to_cart
total_inapp_engagement_add_to_cart_value
total_inapp_view_add_to_cart
total_inapp_view_add_to_cart_value
total_web_add_to_cart
total_web_add_to_cart_value
total_web_click_add_to_cart
total_web_click_add_to_cart_value
total_web_engagement_add_to_cart
total_web_engagement_add_to_cart_value
total_web_view_add_to_cart
total_web_view_add_to_cart_value
total_offline_lead_value
add_to_cart_cost_per_action
add_to_cart_roas
total_add_to_cart
total_add_to_cart_value

CONVERSIONS APP INSTALL

total_click_app_install
total_click_app_install_value
total_engagement_app_install
total_engagement_app_install_value
total_view_app_install
total_view_app_install_value
total_app_install_desktop_action_to_desktop_conversion
total_app_install_desktop_action_to_mobile_conversion
total_app_install_desktop_action_to_tablet_conversion
total_app_install_mobile_action_to_desktop_conversion
total_app_install_mobile_action_to_mobile_conversion
total_app_install_mobile_action_to_tablet_conversion
total_app_install_tablet_action_to_desktop_conversion
total_app_install_tablet_action_to_mobile_conversion
total_app_install_tablet_action_to_tablet_conversion
inapp_app_install_cost_per_action
inapp_app_install_roas
total_inapp_app_install
total_inapp_app_install_value
total_inapp_click_app_install
total_inapp_click_app_install_value
total_inapp_engagement_app_install
total_inapp_engagement_app_install_value
total_inapp_view_app_install
total_inapp_view_app_install_value
total_app_install
total_app_install_value
app_install_cost_per_action

CONVERSIONS CHECKOUT

total_click_checkout
total_view_checkout
total_click_checkout_quantity
total_click_checkout_value
total_engagement_checkout
total_engagement_checkout_quantity
total_engagement_checkout_value
total_view_checkout_quantity
total_view_checkout_value
total_checkout_desktop_action_to_desktop_conversion
total_checkout_desktop_action_to_mobile_conversion
total_checkout_desktop_action_to_tablet_conversion
total_checkout_mobile_action_to_desktop_conversion
total_checkout_mobile_action_to_mobile_conversion
total_checkout_mobile_action_to_tablet_conversion
total_checkout_tablet_action_to_desktop_conversion
total_checkout_tablet_action_to_mobile_conversion
total_checkout_tablet_action_to_tablet_conversion
total_web_signup
total_web_signup_value
total_web_page_visit
total_web_page_visit_value
web_page_visit_roas
web_page_visit_cost_per_action
total_web_custom
total_web_custom_value
total_web_checkout
total_web_checkout_value
web_checkout_cost_per_action
total_web_click_checkout
total_web_click_checkout_value
total_web_engagement_checkout
total_web_engagement_checkout_value
total_web_view_checkout
total_web_view_checkout_value
web_checkout_roas
inapp_checkout_cost_per_action
inapp_checkout_roas
total_inapp_checkout
total_inapp_checkout_value
total_inapp_click_checkout
total_inapp_click_checkout_value
total_inapp_engagement_checkout
total_inapp_engagement_checkout_value
total_inapp_view_checkout
total_inapp_view_checkout_value
total_inapp_signup
total_inapp_signup_value
total_offline_checkout
total_offline_checkout_value
offline_checkout_cost_per_action
total_offline_custom
total_offline_custom_value
offline_checkout_roas
total_offline_lead
total_offline_signup
total_offline_signup_value
total_checkout
total_checkout_value
checkout_roas
checkout_cost_per_action
total_custom
total_custom_value
custom_cost_per_action
custom_roas
total_lead_value
lead_cost_per_action
lead_roas
total_offline_click_checkout
total_offline_click_checkout_value
total_offline_engagement_checkout
total_offline_engagement_checkout_value
total_offline_view_checkout
total_offline_view_checkout_value
total_signup_value
signup_cost_per_action
signup_roas

CONVERSIONS CUSTOM

total_click_custom
total_engagement_custom
total_view_custom
total_click_custom_quantity
total_view_custom_quantity
total_custom_desktop_action_to_desktop_conversion
total_custom_desktop_action_to_mobile_conversion
total_custom_desktop_action_to_tablet_conversion
total_custom_mobile_action_to_desktop_conversion
total_custom_mobile_action_to_mobile_conversion
total_custom_mobile_action_to_tablet_conversion
total_custom_tablet_action_to_desktop_conversion
total_custom_tablet_action_to_mobile_conversion
total_custom_tablet_action_to_tablet_conversion
total_click_custom_value
total_engagement_custom_quantity
total_engagement_custom_value
total_view_custom_value

CONVERSIONS LEAD

total_web_lead
total_web_lead_value
total_click_lead
total_click_lead_quantity
total_click_lead_value
total_engagement_lead
total_lead
total_engagement_lead_quantity
total_engagement_lead_value
total_view_lead
total_view_lead_quantity
total_view_lead_value
total_lead_desktop_action_to_desktop_conversion
total_lead_desktop_action_to_mobile_conversion
total_lead_desktop_action_to_tablet_conversion
total_lead_mobile_action_to_desktop_conversion
total_lead_mobile_action_to_mobile_conversion
total_lead_mobile_action_to_tablet_conversion
total_lead_tablet_action_to_desktop_conversion
total_lead_tablet_action_to_mobile_conversion
total_lead_tablet_action_to_tablet_conversion

CONVERSIONS PAGE VISIT

total_click_page_visit
total_engagement_page_visit
total_view_page_visit
total_click_page_visit_quantity
total_click_page_visit_value
total_engagement_page_visit_quantity
total_engagement_page_visit_value
total_view_page_visit_quantity
total_view_page_visit_value
total_page_visit_desktop_action_to_desktop_conversion
total_page_visit_desktop_action_to_mobile_conversion
total_page_visit_desktop_action_to_tablet_conversion
total_page_visit_mobile_action_to_desktop_conversion
total_page_visit_mobile_action_to_mobile_conversion
total_page_visit_mobile_action_to_tablet_conversion
total_page_visit_tablet_action_to_desktop_conversion
total_page_visit_tablet_action_to_mobile_conversion
total_page_visit_tablet_action_to_tablet_conversion

CONVERSIONS SIGNUP

total_click_signup
total_engagement_signup
total_engagement_signup_quantity
total_engagement_signup_value
total_view_signup_quantity
total_view_signup_value
total_signup_desktop_action_to_desktop_conversion
total_signup_desktop_action_to_mobile_conversion
total_signup_desktop_action_to_tablet_conversion
total_signup_mobile_action_to_desktop_conversion
total_signup_mobile_action_to_mobile_conversion
total_signup_mobile_action_to_tablet_conversion
total_signup_tablet_action_to_desktop_conversion
total_signup_tablet_action_to_mobile_conversion
total_signup_tablet_action_to_tablet_conversion
total_signup
total_view_signup
total_click_signup_quantity
total_click_signup_value

CONVERSIONS WATCH VIDEO

total_click_watch_video
total_click_watch_video_quantity
total_click_watch_video_value
total_engagement_watch_video
total_engagement_watch_video_quantity
total_engagement_watch_video_value
total_view_watch_video
total_view_watch_video_quantity
total_view_watch_video_value
total_watch_video_desktop_action_to_desktop_conversion
total_watch_video_desktop_action_to_mobile_conversion
total_watch_video_desktop_action_to_tablet_conversion
total_watch_video_mobile_action_to_desktop_conversion
total_watch_video_mobile_action_to_mobile_conversion
total_watch_video_mobile_action_to_tablet_conversion
total_watch_video_tablet_action_to_desktop_conversion
total_watch_video_tablet_action_to_mobile_conversion
total_watch_video_tablet_action_to_tablet_conversion
total_web_watch_video
total_web_watch_video_value
total_web_click_watch_video
total_web_click_watch_video_value
total_web_engagement_watch_video
total_web_engagement_watch_video_value
total_web_view_watch_video
total_web_view_watch_video_value
web_watch_video_cost_per_action
web_watch_video_roas

CORE METRICS

impressions_paid
impressions_earned
frequency
reach
total_impressions
clickthrough_paid
clickthrough_earned
total_clickthrough
ctr_rate
ctr_rate_paid
ctr_rate_earned
outbound_clicks_paid
outbound_clicks_earned
outbound_clicks
outbound_ctr_paid
outbound_ctr_earned
outbound_ctr
total_conversions
total_conversions_quantity
total_conversions_value
saves_paid
saves_earned
total_saves
save_rate
save_rate_paid
save_rate_earned
carousel_swipes_paid
carousel_swipes_earned
carousel_swipes_total
engagements_paid
engagements_earned
total_engagements
cpm
cpe
cpe_paid
cpe_earned
cpc
cpc_paid
cpc_earned
cost
cost_eur
cost_usd
cost_gbp
conversion_rate
cost_per_conversion

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEPRECATED

campaign_billing_group
advertiser_click_window_days
campaign_is_one_tap
campaign_product_filter
ad_group_bid_type
campaign_measurement_partner_campaign_id
advertiser_is_agency
ad_group_entity_version
advertiser_created_time
advertiser_updated_time
advertiser_vat_number
advertiser_vat_exempt_number
advertiser_represented_advertiser_country
advertiser_business_address
advertiser_is_agency_paying
ad_group_targeting_spec_term
advertiser_is_one_tap
ad_group_conversion_learning_mode_type
advertiser_merchant_id
campaign_upgrade_status
advertiser_test_account
campaign_entity_version
advertiser_type
campaign_type
ad_group_upgrade_status
campaign_placement_exclusion
ad_group_targeting_type
campaign_creative_type
ad_group_targeting_value
advertiser_view_window_days
advertiser_engagement_window_days
onsite_checkouts
onsite_checkouts_cpa_billable
closeups_rate_paid
closeups_rate_earned
closeups_rate
total_closeups
closeups_earned
closeups_paid
onsite_checkouts_value

PIN PROMOTIONS

pin_promotion_id
pin_promotion_pin_id
pin_promotion_name
pin_promotion_status
pin_promotion_created_time
pin_promotion_updated_time
pin_promotion_click_tracking_url
pin_promotion_creative_type
pin_promotion_destination_url
utm_source
utm_medium
utm_campaign
utm_content
utm_term
pin_promotion_is_pin_deleted
pin_promotion_review_status
pin_promotion_view_tracking_url
targeting_value
targeting_type

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

TARGETING BREAKDOWNS

targeting_keyword
targeting_gender
targeting_age
targeting_country
targeting_country_name
targeting_region
targeting_region_name
targeting_location
targeting_app_type
targeting_feed_type
targeting_placement
targeting_targeted_interest
targeting_pinner_interest
targeting_audience_include

TIME

today
year
yearOfWeek
yearOfWeekIso
yearMonth
month
yearWeek
yearWeekIso
week
weekIso
dayOfMonth
dayOfWeekName
dayOfWeekNameIso
date

VIDEO ENGAGEMENTS

video_avg_watchtime_in_second_2
video_avg_watchtime_in_second_1
video_p0_combined_2
video_p0_combined_1
video_mrc_views_2
video_mrc_views_1
video_3s_views
video_p100_complete_1
video_p100_complete_2
video_p25_combined_1
video_p25_combined_2
video_p50_combined_1
video_p50_combined_2
video_p75_combined_1
video_p75_combined_2
video_p95_combined_1
video_p95_combined_2