Pinterest Ads data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

advertiser_business_address
Display name Business address
Description The business address of the advertiser. Please note that this field will be removed on 2023-05-24
Field type dimension
Data type string.text.value
advertiser_click_window_days
Display name Click window days
Description The tracking window for clicks in days. Please note that this field will be removed on 2022-01-17
Field type dimension
Data type int.number.value
advertiser_country
Display name Advertiser country
Description The country of the advertiser
Field type dimension
Data type string.geo.country.twolettercode
advertiser_currency
Display name Currency
Description The currency the advertiser uses
Field type dimension
Data type string.currency.code
advertiser_id
Display name Advertiser ID
Description The unique identifier for the advertiser
Field type dimension
Data type string.text.value
advertiser_merchant_id
Display name Merchant ID
Description The merchant ID of the advertiser. Please note that this field will be removed on 2023-05-24
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description The name of the advertiser
Field type dimension
Data type string.text.value
advertiser_type
Display name Advertiser type
Description The type of the advertiser. Please note that this field will be removed on 2023-05-24
Field type dimension
Data type string.text.value
advertiser_updated_time
Display name Advertiser updated date
Description The date the advertiser was last updated. Please note that this field will be removed on 2023-05-24
Field type dimension
Data type string.time.date
campaign_billing_group
Display name Billing group
Description The billing group of the campaign. Please note that this field will be removed on 2021-02-01
Field type dimension
Data type string.text.value
campaign_created_time
Display name Campaign created date
Description The date the campaign was created
Field type dimension
Data type string.time.date
campaign_daily_spend_cap
Display name Daily spend cap
Description The daily spend cap of the campaign
Field type dimension
Data type float.currency.value
campaign_entity_version
Display name Campaign entity version
Description The entity version of the campaign. Please note that this field will be removed on 2021-02-01
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The unique identifier of the campaign
Field type dimension
Data type string.text.value
campaign_lifetime_spend_cap
Display name Lifetime spend cap
Description The lifetime spend cap of the campaign
Field type dimension
Data type float.currency.value
campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_objective_type
Display name Campaign objective type
Description The objective type of the campaign
Field type dimension
Data type string.text.value
campaign_order_line_id
Display name Order line ID
Description The order line ID of the campaign
Field type dimension
Data type string.text.value
campaign_product_filter
Display name Product filter
Description The product filter of the campagin. Please note that this field will be removed on 2021-02-01
Field type dimension
Data type string.text.value
campaign_status
Display name Campaign status
Description The status of the campaign
Field type dimension
Data type string.text.value
campaign_updated_time
Display name Campaign updated date
Description The date the campaign was last updated
Field type dimension
Data type string.time.date
campaign_upgrade_status
Display name Campaign upgrade status
Description The upgrade status of the campaign. Please note that this field will be removed on 2019-10-03
Field type dimension
Data type string.text.value
CLICKTHROUGH_1
Display name Clicks paid
Description The number of clicks from your promoted Pins. This includes both paid clicks and over-delivered clicks
Field type metric
Data type int.number.value
CLICKTHROUGH_2
Display name Clicks earned
Description The number of clicks from Repins of your promoted Pins
Field type metric
Data type int.number.value
CLOSEUP_1
Display name Close-ups paid
Description The number of close-ups from your promoted Pins. Please note that this field will be removed on 2021-01-21
Field type metric
Data type int.number.value
CLOSEUP_2
Display name Close-ups earned
Description The number of close-ups from Repins of your promoted Pins. Please note that this field will be removed on 2021-01-21
Field type metric
Data type int.number.value
cost
Display name Cost
Description The money you spent for promoted Pins, in the currency of the advertiser
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
IMPRESSION_1
Display name Impressions paid
Description The number of impressions from your promoted Pins. This includes both paid impressions and over-delivered impressions
Field type metric
Data type int.number.value
IMPRESSION_2
Display name Impressions earned
Description The number of impressions from Repins of your promoted Pins
Field type metric
Data type int.number.value
REPIN_1
Display name Saves paid
Description The number of paid Repins of your promoted Pins
Field type metric
Data type int.number.value
REPIN_2
Display name Saves earned
Description The number of unpaid Repins of your promoted Pins
Field type metric
Data type int.number.value
TOTAL_CLICK_CHECKOUT
Display name Click-through conversions (checkout)
Description Checkouts that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_CHECKOUT_QUANTITY
Display name Click-through order quantity (checkout)
Description Clicks checkout quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR
Display name Click-through order value (checkout)
Description Clicks checkout value
Field type metric
Data type float.currency.value
TOTAL_CLICK_CUSTOM
Display name Click-through conversions (custom)
Description Custom conversions that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_CUSTOM_QUANTITY
Display name Conversion quantity from custom - clicks
Description Clicks custom quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_CUSTOM_VALUE_IN_MICRO_DOLLAR
Display name Click-through value (custom)
Description Clicks custom value
Field type metric
Data type float.currency.value
TOTAL_CLICK_PAGE_VISIT
Display name Click-through conversions (page visit)
Description Page visits that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_PAGE_VISIT_QUANTITY
Display name Conversion quantity from page visit - clicks
Description Clicks page visit quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_PAGE_VISIT_VALUE_IN_MICRO_DOLLAR
Display name Click-through value (page visit)
Description Clicks page visit value
Field type metric
Data type float.currency.value
TOTAL_CLICK_SIGNUP
Display name Click-through conversions (signup)
Description Sign ups that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_SIGNUP_QUANTITY
Display name Conversion quantity from signup - clicks
Description Clicks sign-up quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR
Display name Click-through value (signup)
Description Clicks sign-up value
Field type metric
Data type float.currency.value
total_clickthrough
Display name Clicks
Description The number of clicks from earned and paid sources
Field type metric
Data type int.number.value
total_closeups
Display name Close-ups
Description The number of close-ups from earned and paid sources. Please note that this field will be removed on 2021-01-21
Field type metric
Data type int.number.value
TOTAL_CONVERSIONS
Display name Conversions
Description This is the sum of all website conversions. For example, if you track sign ups and checkouts on your website, it's the sum of all sign ups and checkouts attributed from clicks, engagements and views on Pinterest
Field type metric
Data type int.number.value
TOTAL_CONVERSIONS_QUANTITY
Display name Conversions quantity
Description Conversions quantity
Field type metric
Data type int.number.value
TOTAL_CONVERSIONS_VALUE_IN_MICRO_DOLLAR
Display name Conversions value
Description Conversions value
Field type metric
Data type float.currency.value
total_engagements
Display name Engagements
Description Total engagements from earned and paid sources
Field type metric
Data type int.number.value
total_impressions
Display name Impressions
Description The number of impressions from earned and paid sources
Field type metric
Data type int.number.value
TOTAL_VIEW_CHECKOUT
Display name View-through conversions (checkout)
Description Checkouts that can be traced back to times when people repinned or clicked your promoted Pin to see it close-up, staying on Pinterest
Field type metric
Data type int.number.value
TOTAL_VIEW_CHECKOUT_QUANTITY
Display name View-through order quantity (checkout)
Description Views checkout quantity
Field type metric
Data type int.number.value
TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR
Display name View-through order value (checkout)
Description Views checkout value
Field type metric
Data type float.currency.value
TOTAL_VIEW_CUSTOM
Display name View-through conversions (custom)
Description Custom conversions that can be traced back to when somebody saw your promoted Pin
Field type metric
Data type int.number.value
TOTAL_VIEW_CUSTOM_QUANTITY
Display name Conversion quantity from custom - views
Description Views custom quantity
Field type metric
Data type int.number.value
TOTAL_VIEW_CUSTOM_VALUE_IN_MICRO_DOLLAR
Display name View-through value (custom)
Description Views custom value
Field type metric
Data type float.currency.value
TOTAL_VIEW_PAGE_VISIT
Display name View-through conversions (page visit)
Description Page visits that can be traced back to when somebody saw your promoted Pin
Field type metric
Data type int.number.value
TOTAL_VIEW_PAGE_VISIT_QUANTITY
Display name Conversion quantity from page visit - views
Description Views page visit quantity
Field type metric
Data type int.number.value
TOTAL_VIEW_PAGE_VISIT_VALUE_IN_MICRO_DOLLAR
Display name View-through value (page visit)
Description Views page visit value
Field type metric
Data type float.currency.value
TOTAL_VIEW_SIGNUP
Display name View-through conversions (signup)
Description Sign ups that can be traced back to when somebody saw your promoted Pin
Field type metric
Data type int.number.value
TOTAL_VIEW_SIGNUP_QUANTITY
Display name Conversion quantity from signup - views
Description Views sign-up quantity
Field type metric
Data type int.number.value

Table: AD

ad_group_auto_targeting_enabled
Display name Auto targeting enabled
Description Whether auto targeting is enabled or not
Field type dimension
Data type bool
ad_group_bid_in_micro_currency
Display name Bid
Description The bid amount of the ad group in the currency of the advertiser account
Field type dimension
Data type float.currency.value
ad_group_billable_event
Display name Billable event
Description The billable event of the ad group
Field type dimension
Data type string.text.value
ad_group_budget_in_micro_currency
Display name Budget
Description The budget of the ad group in the currency of the advertiser account. Ad group budgets will be blank if they belong to a campaign that is using campaign budget optimisation
Field type dimension
Data type float.currency.value
ad_group_budget_type
Display name Budget type
Description The budget type of the ad group
Field type dimension
Data type string.text.value
ad_group_conversion_learning_mode_type
Display name Conversion learning mode type
Description The type of conversion learning mode of the ad group. Please note that this field will be removed on 2021-02-25
Field type dimension
Data type string.text.value
ad_group_end_time
Display name Ad group end date
Description The end date and end time of your ad group in UTC
Field type dimension
Data type string.time.datetime
ad_group_entity_version
Display name Ad group entity version
Description The entity version of the ad group. Please note that this field will be removed on 2021-02-25
Field type dimension
Data type string.text.value
ad_group_id
Display name Ad group ID
Description The unique identifier of the ad group
Field type dimension
Data type int.number.value
ad_group_lifetime_frequency_cap
Display name Lifetime frequency cap
Description Lifetime frequency cap of the ad group
Field type dimension
Data type int.number.value
ad_group_name
Display name Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
ad_group_optimization_goal_metadata_click_window
Display name Optimization goal click window
Description The click attribution window in days
Field type dimension
Data type int.number.value
ad_group_optimization_goal_metadata_conversion_event
Display name Optimization goal conversion event
Description The conversion event of the ad group
Field type dimension
Data type string.text.value
ad_group_optimization_goal_metadata_conversion_tag_id
Display name Optimization goal conversion tag ID
Description The unique identifier for the conversion tag of the ad group
Field type dimension
Data type string.text.value
ad_group_optimization_goal_metadata_cpa_goal_value
Display name Optimization goal CPA value
Description The CPA goal value of the ad group in the currency of the advertiser account
Field type dimension
Data type float.currency.value
ad_group_optimization_goal_metadata_engagement_window
Display name Optimization goal engagement window
Description The engagement attribution window in days
Field type dimension
Data type int.number.value
ad_group_optimization_goal_metadata_learning_mode_type
Display name Optimization goal conversion learning mode type
Description The learning mode type of the ad group
Field type dimension
Data type string.text.value
ad_group_optimization_goal_metadata_view_window
Display name Optimization goal view window
Description The view attribution window in days
Field type dimension
Data type int.number.value
ad_group_pacing_delivery_type
Display name Pacing delivery type
Description The pacing delivery type of the ad group
Field type dimension
Data type string.text.value
ad_group_pin_promotion_ids
Display name Pin promotion IDs
Description The unique identifiers for the pin promotions of the ad group
Field type dimension
Data type string.text.value
ad_group_placement_group
Display name Placement group
Description List of placements group for the ad group
Field type dimension
Data type string.text.value
ad_group_start_time
Display name Ad group start date
Description The start date and start time of your ad group in UTC
Field type dimension
Data type string.time.datetime
ad_group_status
Display name Ad group status
Description The status of the ad group
Field type dimension
Data type string.text.value
ad_group_targeting_spec_app_type
Display name Targeting app type
Description List of app types the ad group is targeting
Field type dimension
Data type string.text.value
ad_group_targeting_spec_gender
Display name Targeting gender
Description List of genders the ad group is targeting
Field type dimension
Data type string.text.value
ad_group_targeting_spec_geo
Display name Targeting geo
Description List of geolocations the ad group is targeting
Field type dimension
Data type string.text.value
ad_group_targeting_spec_locale
Display name Targeting locale
Description List of locales the ad group is targeting
Field type dimension
Data type string.text.value
ad_group_targeting_spec_location
Display name Targeting location
Description List of locations the ad group is targeting
Field type dimension
Data type string.text.value
ad_group_tracking_urls
Display name Tracking URLs
Description The tracking URLs of the ad group
Field type dimension
Data type string.text.value
ad_group_type
Display name Ad group type
Description The type of the ad group
Field type dimension
Data type string.text.value
ad_group_updated_time
Display name Ad group updated date
Description The date the ad group was last updated
Field type dimension
Data type string.time.date
campaign_daily_spend_cap
Display name Daily spend cap
Description The daily spend cap of the campaign
Field type dimension
Data type float.currency.value
campaign_id
Display name Campaign ID
Description The unique identifier of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_order_line_id
Display name Order line ID
Description The order line ID of the campaign
Field type dimension
Data type string.text.value
campaign_product_filter
Display name Product filter
Description The product filter of the campagin. Please note that this field will be removed on 2021-02-01
Field type dimension
Data type string.text.value
CLICKTHROUGH_1
Display name Clicks paid
Description The number of clicks from your promoted Pins. This includes both paid clicks and over-delivered clicks
Field type metric
Data type int.number.value
CLICKTHROUGH_2
Display name Clicks earned
Description The number of clicks from Repins of your promoted Pins
Field type metric
Data type int.number.value
CLOSEUP_1
Display name Close-ups paid
Description The number of close-ups from your promoted Pins. Please note that this field will be removed on 2021-01-21
Field type metric
Data type int.number.value
CLOSEUP_2
Display name Close-ups earned
Description The number of close-ups from Repins of your promoted Pins. Please note that this field will be removed on 2021-01-21
Field type metric
Data type int.number.value
cost
Display name Cost
Description The money you spent for promoted Pins, in the currency of the advertiser
Field type metric
Data type float.currency.value
dataSourceName
Display name Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
date
Display name Date
Field type dimension
Data type string.time.date
IMPRESSION_1
Display name Impressions paid
Description The number of impressions from your promoted Pins. This includes both paid impressions and over-delivered impressions
Field type metric
Data type int.number.value
IMPRESSION_2
Display name Impressions earned
Description The number of impressions from Repins of your promoted Pins
Field type metric
Data type int.number.value
REPIN_1
Display name Saves paid
Description The number of paid Repins of your promoted Pins
Field type metric
Data type int.number.value
REPIN_2
Display name Saves earned
Description The number of unpaid Repins of your promoted Pins
Field type metric
Data type int.number.value
TOTAL_CLICK_CHECKOUT
Display name Click-through conversions (checkout)
Description Checkouts that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_CHECKOUT_QUANTITY
Display name Click-through order quantity (checkout)
Description Clicks checkout quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_CHECKOUT_VALUE_IN_MICRO_DOLLAR
Display name Click-through order value (checkout)
Description Clicks checkout value
Field type metric
Data type float.currency.value
TOTAL_CLICK_CUSTOM
Display name Click-through conversions (custom)
Description Custom conversions that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_CUSTOM_QUANTITY
Display name Conversion quantity from custom - clicks
Description Clicks custom quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_CUSTOM_VALUE_IN_MICRO_DOLLAR
Display name Click-through value (custom)
Description Clicks custom value
Field type metric
Data type float.currency.value
TOTAL_CLICK_PAGE_VISIT
Display name Click-through conversions (page visit)
Description Page visits that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_PAGE_VISIT_QUANTITY
Display name Conversion quantity from page visit - clicks
Description Clicks page visit quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_PAGE_VISIT_VALUE_IN_MICRO_DOLLAR
Display name Click-through value (page visit)
Description Clicks page visit value
Field type metric
Data type float.currency.value
TOTAL_CLICK_SIGNUP
Display name Click-through conversions (signup)
Description Sign ups that can be traced back to when somebody clicked a promoted Pin and continued to your site, leaving Pinterest
Field type metric
Data type int.number.value
TOTAL_CLICK_SIGNUP_QUANTITY
Display name Conversion quantity from signup - clicks
Description Clicks sign-up quantity
Field type metric
Data type int.number.value
TOTAL_CLICK_SIGNUP_VALUE_IN_MICRO_DOLLAR
Display name Click-through value (signup)
Description Clicks sign-up value
Field type metric
Data type float.currency.value
total_clickthrough
Display name Clicks
Description The number of clicks from earned and paid sources
Field type metric
Data type int.number.value
total_closeups
Display name Close-ups
Description The number of close-ups from earned and paid sources. Please note that this field will be removed on 2021-01-21
Field type metric
Data type int.number.value
TOTAL_CONVERSIONS
Display name Conversions
Description This is the sum of all website conversions. For example, if you track sign ups and checkouts on your website, it's the sum of all sign ups and checkouts attributed from clicks, engagements and views on Pinterest
Field type metric
Data type int.number.value
TOTAL_CONVERSIONS_QUANTITY
Display name Conversions quantity
Description Conversions quantity
Field type metric
Data type int.number.value
TOTAL_CONVERSIONS_VALUE_IN_MICRO_DOLLAR
Display name Conversions value
Description Conversions value
Field type metric
Data type float.currency.value
total_engagements
Display name Engagements
Description Total engagements from earned and paid sources
Field type metric
Data type int.number.value
total_impressions
Display name Impressions
Description The number of impressions from earned and paid sources
Field type metric
Data type int.number.value
TOTAL_VIEW_CHECKOUT
Display name View-through conversions (checkout)
Description Checkouts that can be traced back to times when people repinned or clicked your promoted Pin to see it close-up, staying on Pinterest
Field type metric
Data type int.number.value
TOTAL_VIEW_CHECKOUT_QUANTITY
Display name View-through order quantity (checkout)
Description Views checkout quantity
Field type metric
Data type int.number.value
TOTAL_VIEW_CHECKOUT_VALUE_IN_MICRO_DOLLAR
Display name View-through order value (checkout)
Description Views checkout value
Field type metric
Data type float.currency.value
TOTAL_VIEW_CUSTOM
Display name View-through conversions (custom)
Description Custom conversions that can be traced back to when somebody saw your promoted Pin
Field type metric
Data type int.number.value
TOTAL_VIEW_CUSTOM_QUANTITY
Display name Conversion quantity from custom - views
Description Views custom quantity
Field type metric
Data type int.number.value
TOTAL_VIEW_CUSTOM_VALUE_IN_MICRO_DOLLAR
Display name View-through value (custom)
Description Views custom value
Field type metric
Data type float.currency.value
TOTAL_VIEW_PAGE_VISIT
Display name View-through conversions (page visit)
Description Page visits that can be traced back to when somebody saw your promoted Pin
Field type metric
Data type int.number.value
TOTAL_VIEW_PAGE_VISIT_QUANTITY
Display name Conversion quantity from page visit - views
Description Views page visit quantity
Field type metric
Data type int.number.value
TOTAL_VIEW_PAGE_VISIT_VALUE_IN_MICRO_DOLLAR
Display name View-through value (page visit)
Description Views page visit value
Field type metric
Data type float.currency.value
TOTAL_VIEW_SIGNUP
Display name View-through conversions (signup)
Description Sign ups that can be traced back to when somebody saw your promoted Pin
Field type metric
Data type int.number.value
TOTAL_VIEW_SIGNUP_QUANTITY
Display name Conversion quantity from signup - views
Description Views sign-up quantity
Field type metric
Data type int.number.value