Reddit Ads data warehouse table groups

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

Table: CAMPAIGN

account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
admin_approval
Display name Admin approval
Description Admin approval
Field type dimension
Data type string.text.value
attribution_type
Display name Attribution type
Description Attribution Type
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
click_attribution_window
Display name Click-attribution window
Description Click-attribution window
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of clicks detected for this report period
Field type metric
Data type int.number.value
comment_downvotes
Display name Comment downvotes
Description The number comment downvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comment_upvotes
Display name Comment upvotes
Description The number of comment upvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comments_page_views
Display name Comments page views
Description The number of times the comments page was viewed for the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
configured_status
Display name Campaign configured status
Description The status that the user has configured this entity to have. Can differ from the effective status depending on the context such as pending billing information
Field type dimension
Data type string.text.value
conversion_add_to_cart_clicks
Display name Click: add to cart
Description Number of add to cart click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_total_items
Display name Cart size: add to cart
Description Total size of the shopping cart
Field type metric
Data type int.number.value
conversion_add_to_cart_total_value
Display name Total value: add to cart
Description Total value of shopping cart
Field type metric
Data type float.currency.value
conversion_add_to_cart_views
Display name View: add to cart
Description Number of add to cart view-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_clicks
Display name Click: add to wishlist
Description Number of add to wishlist click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_items
Display name Cart size: wishlist
Description Total size of wishlist
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_value
Display name Total value: wishlist
Description Total value of wishlist
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_views
Display name View: add to wishlist
Description Number of add to wishlist view-through conversions
Field type metric
Data type int.number.value
conversion_lead_clicks
Display name Click: lead
Description Number of lead click-through conversions
Field type metric
Data type int.number.value
conversion_lead_total_value
Display name Total value: lead
Description Total value of leads
Field type metric
Data type float.currency.value
conversion_lead_views
Display name View: lead
Description Number of lead view-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_clicks
Display name Click: page visit
Description Number of page visit click-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_views
Display name View: page visit
Description Number of page visit view-through conversions
Field type metric
Data type int.number.value
conversion_purchase_clicks
Display name Click: purchase
Description Number of purchase click-through conversions
Field type metric
Data type int.number.value
conversion_purchase_total_items
Display name Cart size: purchase
Description Total number of items purchased
Field type metric
Data type int.number.value
conversion_purchase_total_value
Display name Total value: purchase
Description Total value of purchase
Field type metric
Data type float.currency.value
conversion_purchase_views
Display name View: purchase
Description Number of purchase view-through conversions
Field type metric
Data type int.number.value
conversion_search_clicks
Display name Click: search
Description Number of search click-through conversions
Field type metric
Data type int.number.value
conversion_search_views
Display name View: search
Description Number of search view-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_clicks
Display name Click: sign up
Description Number of sign up click-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_views
Display name View: sign up
Description Number of sign up view-through conversions
Field type metric
Data type int.number.value
conversion_signup_total_value
Display name Total value: sign up
Description Total value of signups
Field type metric
Data type float.currency.value
conversion_view_content_clicks
Display name Click: view content
Description Number of content view click-through conversions
Field type metric
Data type int.number.value
currency
Display name Currency
Description Currency of the account
Field type dimension
Data type string.currency.code
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
effective_status
Display name Campaign status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of impressions served for this report period
Field type metric
Data type int.number.value
objective
Display name Campaign objective
Description The objective type of a campaign
Field type dimension
Data type string.text.value
pixel_partner_preferences
Display name Pixel partner preferences
Description Advertiser-set pixel partner preferences
Field type dimension
Data type string.text.value
spend
Display name Amount spent
Description The amount spent for this report period in the account currency
Field type metric
Data type float.currency.value
timezone
Display name Time zone
Description The time zone ID preference for this account
Field type dimension
Data type string.time.timezone
video_fully_viewable_impressions
Display name Full video views
Description The number of times your video ad was played for at least three continuous seconds with at least 100% of its pixels visible
Field type metric
Data type int.number.value
video_plays_expanded
Display name Video plays expanded
Description The number of times the video was played while expanded (full-screen) mode
Field type metric
Data type int.number.value
video_plays_with_sound
Display name Plays with sound
Description The number of times the video ad was played with the sound on
Field type metric
Data type int.number.value
video_viewable_impressions
Display name Video views
Description The number of times your video ad was played for at least two continuous seconds with at least 50% of the video in view on the page
Field type metric
Data type int.number.value
video_watched_10_seconds
Display name Video watched 10s
Description The number of times your video ad was viewed for at least ten seconds
Field type metric
Data type int.number.value
video_watched_100_percent
Display name Watches at 100%
Description The number of times the ad was served and a user watched the entire video, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_25_percent
Display name Watches at 25%
Description The number of times the ad was served and at least 25% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_3_seconds
Display name Video watched 3s
Description The number of times your video ad was viewed for at least three seconds
Field type metric
Data type int.number.value
video_watched_5_seconds
Display name Video watched 5s
Description The number of times your video ad was viewed for at least five seconds
Field type metric
Data type int.number.value
video_watched_50_percent
Display name Watches at 50%
Description The number of times the ad was served and at least 50% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_75_percent
Display name Watches at 75%
Description The number of times the ad was served and at least 75% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_95_percent
Display name Watches at 95%
Description The number of times the ad was served and at least 95% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
view_attribution_window
Display name View-attribution window
Description View-attribution window
Field type dimension
Data type string.text.value
viewer_comments
Display name Viewer comments
Description The number of times a user saw the post, and also commented on it. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value

Table: AD_GROUP

account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
ad_group_id
Display name Ad group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
ad_group_name
Display name Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
bid_type
Display name Bid type
Description The bidding strategy for the ad group
Field type dimension
Data type string.text.value
bid_value
Display name Bid
Description The amount to pay in US dollars per bidding event
Field type dimension
Data type float.currency.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of clicks detected for this report period
Field type metric
Data type int.number.value
comment_downvotes
Display name Comment downvotes
Description The number comment downvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comment_upvotes
Display name Comment upvotes
Description The number of comment upvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comments_page_views
Display name Comments page views
Description The number of times the comments page was viewed for the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
configured_status
Display name Campaign configured status
Description The status that the user has configured this entity to have. Can differ from the effective status depending on the context such as pending billing information
Field type dimension
Data type string.text.value
conversion_add_to_cart_clicks
Display name Click: add to cart
Description Number of add to cart click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_total_items
Display name Cart size: add to cart
Description Total size of the shopping cart
Field type metric
Data type int.number.value
conversion_add_to_cart_total_value
Display name Total value: add to cart
Description Total value of shopping cart
Field type metric
Data type float.currency.value
conversion_add_to_cart_views
Display name View: add to cart
Description Number of add to cart view-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_clicks
Display name Click: add to wishlist
Description Number of add to wishlist click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_items
Display name Cart size: wishlist
Description Total size of wishlist
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_value
Display name Total value: wishlist
Description Total value of wishlist
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_views
Display name View: add to wishlist
Description Number of add to wishlist view-through conversions
Field type metric
Data type int.number.value
conversion_lead_clicks
Display name Click: lead
Description Number of lead click-through conversions
Field type metric
Data type int.number.value
conversion_lead_total_value
Display name Total value: lead
Description Total value of leads
Field type metric
Data type float.currency.value
conversion_lead_views
Display name View: lead
Description Number of lead view-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_clicks
Display name Click: page visit
Description Number of page visit click-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_views
Display name View: page visit
Description Number of page visit view-through conversions
Field type metric
Data type int.number.value
conversion_purchase_clicks
Display name Click: purchase
Description Number of purchase click-through conversions
Field type metric
Data type int.number.value
conversion_purchase_total_items
Display name Cart size: purchase
Description Total number of items purchased
Field type metric
Data type int.number.value
conversion_purchase_total_value
Display name Total value: purchase
Description Total value of purchase
Field type metric
Data type float.currency.value
conversion_purchase_views
Display name View: purchase
Description Number of purchase view-through conversions
Field type metric
Data type int.number.value
conversion_search_clicks
Display name Click: search
Description Number of search click-through conversions
Field type metric
Data type int.number.value
conversion_search_views
Display name View: search
Description Number of search view-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_clicks
Display name Click: sign up
Description Number of sign up click-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_views
Display name View: sign up
Description Number of sign up view-through conversions
Field type metric
Data type int.number.value
conversion_signup_total_value
Display name Total value: sign up
Description Total value of signups
Field type metric
Data type float.currency.value
conversion_view_content_clicks
Display name Click: view content
Description Number of content view click-through conversions
Field type metric
Data type int.number.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
effective_status
Display name Campaign status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
end_datetime
Display name End datetime
Description Datetime when the ad group will stop delivering
Field type dimension
Data type string.time.datetime
end_time
Display name End time
Description Date when the ad group will stop delivering
Field type dimension
Data type string.time.date
goal_type
Display name Budget type
Description The type of budget for the ad group
Field type dimension
Data type string.text.value
goal_value
Display name Budget
Description The budget value for your goal. This is measured in US dollars for monetary goals types
Field type dimension
Data type float.currency.value
impressions
Display name Impressions
Description The number of impressions served for this report period
Field type metric
Data type int.number.value
objective
Display name Campaign objective
Description The objective type of a campaign
Field type dimension
Data type string.text.value
spend
Display name Amount spent
Description The amount spent for this report period in the account currency
Field type metric
Data type float.currency.value
start_datetime
Display name Start datetime
Description Datetime when the ad group will begin to deliver
Field type dimension
Data type string.time.datetime
start_time
Display name Start time
Description Date when the ad group will begin to deliver
Field type dimension
Data type string.time.date
video_fully_viewable_impressions
Display name Full video views
Description The number of times your video ad was played for at least three continuous seconds with at least 100% of its pixels visible
Field type metric
Data type int.number.value
video_plays_expanded
Display name Video plays expanded
Description The number of times the video was played while expanded (full-screen) mode
Field type metric
Data type int.number.value
video_plays_with_sound
Display name Plays with sound
Description The number of times the video ad was played with the sound on
Field type metric
Data type int.number.value
video_viewable_impressions
Display name Video views
Description The number of times your video ad was played for at least two continuous seconds with at least 50% of the video in view on the page
Field type metric
Data type int.number.value
video_watched_10_seconds
Display name Video watched 10s
Description The number of times your video ad was viewed for at least ten seconds
Field type metric
Data type int.number.value
video_watched_100_percent
Display name Watches at 100%
Description The number of times the ad was served and a user watched the entire video, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_25_percent
Display name Watches at 25%
Description The number of times the ad was served and at least 25% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_3_seconds
Display name Video watched 3s
Description The number of times your video ad was viewed for at least three seconds
Field type metric
Data type int.number.value
video_watched_5_seconds
Display name Video watched 5s
Description The number of times your video ad was viewed for at least five seconds
Field type metric
Data type int.number.value
video_watched_50_percent
Display name Watches at 50%
Description The number of times the ad was served and at least 50% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_75_percent
Display name Watches at 75%
Description The number of times the ad was served and at least 75% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_95_percent
Display name Watches at 95%
Description The number of times the ad was served and at least 95% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
viewer_comments
Display name Viewer comments
Description The number of times a user saw the post, and also commented on it. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value

Table: AD

account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
ad_configured_status
Display name Ad configured status
Description The status that the user has configured this entity to have
Field type dimension
Data type string.text.value
ad_effective_status
Display name Ad status
Description The effective status for the ad
Field type dimension
Data type string.text.value
ad_id
Display name Ad ID
Description The ID of the ad
Field type dimension
Data type string.text.value
ad_name
Display name Ad name
Description The name of the ad
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
click_url
Display name Ad click URL
Description The ad's click URL
Field type dimension
Data type string.text.url
clicks
Display name Clicks
Description The number of clicks detected for this report period
Field type metric
Data type int.number.value
comment_downvotes
Display name Comment downvotes
Description The number comment downvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comment_upvotes
Display name Comment upvotes
Description The number of comment upvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comments_page_views
Display name Comments page views
Description The number of times the comments page was viewed for the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
configured_status
Display name Campaign configured status
Description The status that the user has configured this entity to have. Can differ from the effective status depending on the context such as pending billing information
Field type dimension
Data type string.text.value
conversion_add_to_cart_clicks
Display name Click: add to cart
Description Number of add to cart click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_total_items
Display name Cart size: add to cart
Description Total size of the shopping cart
Field type metric
Data type int.number.value
conversion_add_to_cart_total_value
Display name Total value: add to cart
Description Total value of shopping cart
Field type metric
Data type float.currency.value
conversion_add_to_cart_views
Display name View: add to cart
Description Number of add to cart view-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_clicks
Display name Click: add to wishlist
Description Number of add to wishlist click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_items
Display name Cart size: wishlist
Description Total size of wishlist
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_value
Display name Total value: wishlist
Description Total value of wishlist
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_views
Display name View: add to wishlist
Description Number of add to wishlist view-through conversions
Field type metric
Data type int.number.value
conversion_lead_clicks
Display name Click: lead
Description Number of lead click-through conversions
Field type metric
Data type int.number.value
conversion_lead_total_value
Display name Total value: lead
Description Total value of leads
Field type metric
Data type float.currency.value
conversion_lead_views
Display name View: lead
Description Number of lead view-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_clicks
Display name Click: page visit
Description Number of page visit click-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_views
Display name View: page visit
Description Number of page visit view-through conversions
Field type metric
Data type int.number.value
conversion_purchase_clicks
Display name Click: purchase
Description Number of purchase click-through conversions
Field type metric
Data type int.number.value
conversion_purchase_total_items
Display name Cart size: purchase
Description Total number of items purchased
Field type metric
Data type int.number.value
conversion_purchase_total_value
Display name Total value: purchase
Description Total value of purchase
Field type metric
Data type float.currency.value
conversion_purchase_views
Display name View: purchase
Description Number of purchase view-through conversions
Field type metric
Data type int.number.value
conversion_search_clicks
Display name Click: search
Description Number of search click-through conversions
Field type metric
Data type int.number.value
conversion_search_views
Display name View: search
Description Number of search view-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_clicks
Display name Click: sign up
Description Number of sign up click-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_views
Display name View: sign up
Description Number of sign up view-through conversions
Field type metric
Data type int.number.value
conversion_signup_total_value
Display name Total value: sign up
Description Total value of signups
Field type metric
Data type float.currency.value
conversion_view_content_clicks
Display name Click: view content
Description Number of content view click-through conversions
Field type metric
Data type int.number.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
effective_status
Display name Campaign status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
event_trackers
Display name Event trackers
Description The event tracker URLs
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of impressions served for this report period
Field type metric
Data type int.number.value
objective
Display name Campaign objective
Description The objective type of a campaign
Field type dimension
Data type string.text.value
post_id
Display name Post ID
Description The ID of the post
Field type dimension
Data type string.text.value
post_url
Display name Post URL
Description The URL of the post
Field type dimension
Data type string.text.url
preview_expiry
Display name Preview expiry date
Description The expiration date of test mode
Field type dimension
Data type string.time.date
preview_url
Display name Preview URL
Description The test mode preview URL
Field type dimension
Data type string.text.url
search_term
Display name Search term
Description The 'Search Term' that is displayed on a promoted trend
Field type dimension
Data type string.text.value
spend
Display name Amount spent
Description The amount spent for this report period in the account currency
Field type metric
Data type float.currency.value
video_fully_viewable_impressions
Display name Full video views
Description The number of times your video ad was played for at least three continuous seconds with at least 100% of its pixels visible
Field type metric
Data type int.number.value
video_plays_expanded
Display name Video plays expanded
Description The number of times the video was played while expanded (full-screen) mode
Field type metric
Data type int.number.value
video_plays_with_sound
Display name Plays with sound
Description The number of times the video ad was played with the sound on
Field type metric
Data type int.number.value
video_viewable_impressions
Display name Video views
Description The number of times your video ad was played for at least two continuous seconds with at least 50% of the video in view on the page
Field type metric
Data type int.number.value
video_watched_10_seconds
Display name Video watched 10s
Description The number of times your video ad was viewed for at least ten seconds
Field type metric
Data type int.number.value
video_watched_100_percent
Display name Watches at 100%
Description The number of times the ad was served and a user watched the entire video, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_25_percent
Display name Watches at 25%
Description The number of times the ad was served and at least 25% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_3_seconds
Display name Video watched 3s
Description The number of times your video ad was viewed for at least three seconds
Field type metric
Data type int.number.value
video_watched_5_seconds
Display name Video watched 5s
Description The number of times your video ad was viewed for at least five seconds
Field type metric
Data type int.number.value
video_watched_50_percent
Display name Watches at 50%
Description The number of times the ad was served and at least 50% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_75_percent
Display name Watches at 75%
Description The number of times the ad was served and at least 75% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_95_percent
Display name Watches at 95%
Description The number of times the ad was served and at least 95% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
viewer_comments
Display name Viewer comments
Description The number of times a user saw the post, and also commented on it. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value

Table: PLACEMENT

account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of clicks detected for this report period
Field type metric
Data type int.number.value
comment_downvotes
Display name Comment downvotes
Description The number comment downvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comment_upvotes
Display name Comment upvotes
Description The number of comment upvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comments_page_views
Display name Comments page views
Description The number of times the comments page was viewed for the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
configured_status
Display name Campaign configured status
Description The status that the user has configured this entity to have. Can differ from the effective status depending on the context such as pending billing information
Field type dimension
Data type string.text.value
conversion_add_to_cart_clicks
Display name Click: add to cart
Description Number of add to cart click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_total_items
Display name Cart size: add to cart
Description Total size of the shopping cart
Field type metric
Data type int.number.value
conversion_add_to_cart_total_value
Display name Total value: add to cart
Description Total value of shopping cart
Field type metric
Data type float.currency.value
conversion_add_to_cart_views
Display name View: add to cart
Description Number of add to cart view-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_clicks
Display name Click: add to wishlist
Description Number of add to wishlist click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_items
Display name Cart size: wishlist
Description Total size of wishlist
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_value
Display name Total value: wishlist
Description Total value of wishlist
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_views
Display name View: add to wishlist
Description Number of add to wishlist view-through conversions
Field type metric
Data type int.number.value
conversion_lead_clicks
Display name Click: lead
Description Number of lead click-through conversions
Field type metric
Data type int.number.value
conversion_lead_total_value
Display name Total value: lead
Description Total value of leads
Field type metric
Data type float.currency.value
conversion_lead_views
Display name View: lead
Description Number of lead view-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_clicks
Display name Click: page visit
Description Number of page visit click-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_views
Display name View: page visit
Description Number of page visit view-through conversions
Field type metric
Data type int.number.value
conversion_purchase_clicks
Display name Click: purchase
Description Number of purchase click-through conversions
Field type metric
Data type int.number.value
conversion_purchase_total_items
Display name Cart size: purchase
Description Total number of items purchased
Field type metric
Data type int.number.value
conversion_purchase_total_value
Display name Total value: purchase
Description Total value of purchase
Field type metric
Data type float.currency.value
conversion_purchase_views
Display name View: purchase
Description Number of purchase view-through conversions
Field type metric
Data type int.number.value
conversion_search_clicks
Display name Click: search
Description Number of search click-through conversions
Field type metric
Data type int.number.value
conversion_search_views
Display name View: search
Description Number of search view-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_clicks
Display name Click: sign up
Description Number of sign up click-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_views
Display name View: sign up
Description Number of sign up view-through conversions
Field type metric
Data type int.number.value
conversion_signup_total_value
Display name Total value: sign up
Description Total value of signups
Field type metric
Data type float.currency.value
conversion_view_content_clicks
Display name Click: view content
Description Number of content view click-through conversions
Field type metric
Data type int.number.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
effective_status
Display name Campaign status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of impressions served for this report period
Field type metric
Data type int.number.value
objective
Display name Campaign objective
Description The objective type of a campaign
Field type dimension
Data type string.text.value
placement
Display name Placement
Description Placement of the ad
Field type dimension
Data type string.text.value
spend
Display name Amount spent
Description The amount spent for this report period in the account currency
Field type metric
Data type float.currency.value
video_fully_viewable_impressions
Display name Full video views
Description The number of times your video ad was played for at least three continuous seconds with at least 100% of its pixels visible
Field type metric
Data type int.number.value
video_plays_expanded
Display name Video plays expanded
Description The number of times the video was played while expanded (full-screen) mode
Field type metric
Data type int.number.value
video_plays_with_sound
Display name Plays with sound
Description The number of times the video ad was played with the sound on
Field type metric
Data type int.number.value
video_viewable_impressions
Display name Video views
Description The number of times your video ad was played for at least two continuous seconds with at least 50% of the video in view on the page
Field type metric
Data type int.number.value
video_watched_10_seconds
Display name Video watched 10s
Description The number of times your video ad was viewed for at least ten seconds
Field type metric
Data type int.number.value
video_watched_100_percent
Display name Watches at 100%
Description The number of times the ad was served and a user watched the entire video, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_25_percent
Display name Watches at 25%
Description The number of times the ad was served and at least 25% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_3_seconds
Display name Video watched 3s
Description The number of times your video ad was viewed for at least three seconds
Field type metric
Data type int.number.value
video_watched_5_seconds
Display name Video watched 5s
Description The number of times your video ad was viewed for at least five seconds
Field type metric
Data type int.number.value
video_watched_50_percent
Display name Watches at 50%
Description The number of times the ad was served and at least 50% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_75_percent
Display name Watches at 75%
Description The number of times the ad was served and at least 75% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_95_percent
Display name Watches at 95%
Description The number of times the ad was served and at least 95% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
viewer_comments
Display name Viewer comments
Description The number of times a user saw the post, and also commented on it. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value

Table: COMMUNITY

account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of clicks detected for this report period
Field type metric
Data type int.number.value
comment_downvotes
Display name Comment downvotes
Description The number comment downvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comment_upvotes
Display name Comment upvotes
Description The number of comment upvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comments_page_views
Display name Comments page views
Description The number of times the comments page was viewed for the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
community_name
Display name Community name
Description The ID of the community/subreddit being targeted. Community ID is equivalent to the name
Field type dimension
Data type string.text.value
configured_status
Display name Campaign configured status
Description The status that the user has configured this entity to have. Can differ from the effective status depending on the context such as pending billing information
Field type dimension
Data type string.text.value
conversion_add_to_cart_clicks
Display name Click: add to cart
Description Number of add to cart click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_total_items
Display name Cart size: add to cart
Description Total size of the shopping cart
Field type metric
Data type int.number.value
conversion_add_to_cart_total_value
Display name Total value: add to cart
Description Total value of shopping cart
Field type metric
Data type float.currency.value
conversion_add_to_cart_views
Display name View: add to cart
Description Number of add to cart view-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_clicks
Display name Click: add to wishlist
Description Number of add to wishlist click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_items
Display name Cart size: wishlist
Description Total size of wishlist
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_value
Display name Total value: wishlist
Description Total value of wishlist
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_views
Display name View: add to wishlist
Description Number of add to wishlist view-through conversions
Field type metric
Data type int.number.value
conversion_lead_clicks
Display name Click: lead
Description Number of lead click-through conversions
Field type metric
Data type int.number.value
conversion_lead_total_value
Display name Total value: lead
Description Total value of leads
Field type metric
Data type float.currency.value
conversion_lead_views
Display name View: lead
Description Number of lead view-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_clicks
Display name Click: page visit
Description Number of page visit click-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_views
Display name View: page visit
Description Number of page visit view-through conversions
Field type metric
Data type int.number.value
conversion_purchase_clicks
Display name Click: purchase
Description Number of purchase click-through conversions
Field type metric
Data type int.number.value
conversion_purchase_total_items
Display name Cart size: purchase
Description Total number of items purchased
Field type metric
Data type int.number.value
conversion_purchase_total_value
Display name Total value: purchase
Description Total value of purchase
Field type metric
Data type float.currency.value
conversion_purchase_views
Display name View: purchase
Description Number of purchase view-through conversions
Field type metric
Data type int.number.value
conversion_search_clicks
Display name Click: search
Description Number of search click-through conversions
Field type metric
Data type int.number.value
conversion_search_views
Display name View: search
Description Number of search view-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_clicks
Display name Click: sign up
Description Number of sign up click-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_views
Display name View: sign up
Description Number of sign up view-through conversions
Field type metric
Data type int.number.value
conversion_signup_total_value
Display name Total value: sign up
Description Total value of signups
Field type metric
Data type float.currency.value
conversion_view_content_clicks
Display name Click: view content
Description Number of content view click-through conversions
Field type metric
Data type int.number.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
effective_status
Display name Campaign status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of impressions served for this report period
Field type metric
Data type int.number.value
objective
Display name Campaign objective
Description The objective type of a campaign
Field type dimension
Data type string.text.value
spend
Display name Amount spent
Description The amount spent for this report period in the account currency
Field type metric
Data type float.currency.value
video_fully_viewable_impressions
Display name Full video views
Description The number of times your video ad was played for at least three continuous seconds with at least 100% of its pixels visible
Field type metric
Data type int.number.value
video_plays_expanded
Display name Video plays expanded
Description The number of times the video was played while expanded (full-screen) mode
Field type metric
Data type int.number.value
video_plays_with_sound
Display name Plays with sound
Description The number of times the video ad was played with the sound on
Field type metric
Data type int.number.value
video_viewable_impressions
Display name Video views
Description The number of times your video ad was played for at least two continuous seconds with at least 50% of the video in view on the page
Field type metric
Data type int.number.value
video_watched_10_seconds
Display name Video watched 10s
Description The number of times your video ad was viewed for at least ten seconds
Field type metric
Data type int.number.value
video_watched_100_percent
Display name Watches at 100%
Description The number of times the ad was served and a user watched the entire video, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_25_percent
Display name Watches at 25%
Description The number of times the ad was served and at least 25% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_3_seconds
Display name Video watched 3s
Description The number of times your video ad was viewed for at least three seconds
Field type metric
Data type int.number.value
video_watched_5_seconds
Display name Video watched 5s
Description The number of times your video ad was viewed for at least five seconds
Field type metric
Data type int.number.value
video_watched_50_percent
Display name Watches at 50%
Description The number of times the ad was served and at least 50% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_75_percent
Display name Watches at 75%
Description The number of times the ad was served and at least 75% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_95_percent
Display name Watches at 95%
Description The number of times the ad was served and at least 95% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
viewer_comments
Display name Viewer comments
Description The number of times a user saw the post, and also commented on it. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value

Table: INTEREST

account_id
Display name Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
account_name
Display name Account name
Description The name of the account
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
category
Display name Category
Description Interest category
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The number of clicks detected for this report period
Field type metric
Data type int.number.value
comment_downvotes
Display name Comment downvotes
Description The number comment downvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comment_upvotes
Display name Comment upvotes
Description The number of comment upvotes on the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
comments_page_views
Display name Comments page views
Description The number of times the comments page was viewed for the ad. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value
configured_status
Display name Campaign configured status
Description The status that the user has configured this entity to have. Can differ from the effective status depending on the context such as pending billing information
Field type dimension
Data type string.text.value
conversion_add_to_cart_clicks
Display name Click: add to cart
Description Number of add to cart click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_total_items
Display name Cart size: add to cart
Description Total size of the shopping cart
Field type metric
Data type int.number.value
conversion_add_to_cart_total_value
Display name Total value: add to cart
Description Total value of shopping cart
Field type metric
Data type float.currency.value
conversion_add_to_cart_views
Display name View: add to cart
Description Number of add to cart view-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_clicks
Display name Click: add to wishlist
Description Number of add to wishlist click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_items
Display name Cart size: wishlist
Description Total size of wishlist
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_value
Display name Total value: wishlist
Description Total value of wishlist
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_views
Display name View: add to wishlist
Description Number of add to wishlist view-through conversions
Field type metric
Data type int.number.value
conversion_lead_clicks
Display name Click: lead
Description Number of lead click-through conversions
Field type metric
Data type int.number.value
conversion_lead_total_value
Display name Total value: lead
Description Total value of leads
Field type metric
Data type float.currency.value
conversion_lead_views
Display name View: lead
Description Number of lead view-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_clicks
Display name Click: page visit
Description Number of page visit click-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_views
Display name View: page visit
Description Number of page visit view-through conversions
Field type metric
Data type int.number.value
conversion_purchase_clicks
Display name Click: purchase
Description Number of purchase click-through conversions
Field type metric
Data type int.number.value
conversion_purchase_total_items
Display name Cart size: purchase
Description Total number of items purchased
Field type metric
Data type int.number.value
conversion_purchase_total_value
Display name Total value: purchase
Description Total value of purchase
Field type metric
Data type float.currency.value
conversion_purchase_views
Display name View: purchase
Description Number of purchase view-through conversions
Field type metric
Data type int.number.value
conversion_search_clicks
Display name Click: search
Description Number of search click-through conversions
Field type metric
Data type int.number.value
conversion_search_views
Display name View: search
Description Number of search view-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_clicks
Display name Click: sign up
Description Number of sign up click-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_views
Display name View: sign up
Description Number of sign up view-through conversions
Field type metric
Data type int.number.value
conversion_signup_total_value
Display name Total value: sign up
Description Total value of signups
Field type metric
Data type float.currency.value
conversion_view_content_clicks
Display name Click: view content
Description Number of content view click-through conversions
Field type metric
Data type int.number.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
effective_status
Display name Campaign status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The number of impressions served for this report period
Field type metric
Data type int.number.value
interest_id
Display name Interest ID
Description Interest ID
Field type dimension
Data type string.text.value
interest_name
Display name Interest name
Description Interest name
Field type dimension
Data type string.text.value
objective
Display name Campaign objective
Description The objective type of a campaign
Field type dimension
Data type string.text.value
spend
Display name Amount spent
Description The amount spent for this report period in the account currency
Field type metric
Data type float.currency.value
video_fully_viewable_impressions
Display name Full video views
Description The number of times your video ad was played for at least three continuous seconds with at least 100% of its pixels visible
Field type metric
Data type int.number.value
video_plays_expanded
Display name Video plays expanded
Description The number of times the video was played while expanded (full-screen) mode
Field type metric
Data type int.number.value
video_plays_with_sound
Display name Plays with sound
Description The number of times the video ad was played with the sound on
Field type metric
Data type int.number.value
video_viewable_impressions
Display name Video views
Description The number of times your video ad was played for at least two continuous seconds with at least 50% of the video in view on the page
Field type metric
Data type int.number.value
video_watched_10_seconds
Display name Video watched 10s
Description The number of times your video ad was viewed for at least ten seconds
Field type metric
Data type int.number.value
video_watched_100_percent
Display name Watches at 100%
Description The number of times the ad was served and a user watched the entire video, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_25_percent
Display name Watches at 25%
Description The number of times the ad was served and at least 25% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_3_seconds
Display name Video watched 3s
Description The number of times your video ad was viewed for at least three seconds
Field type metric
Data type int.number.value
video_watched_5_seconds
Display name Video watched 5s
Description The number of times your video ad was viewed for at least five seconds
Field type metric
Data type int.number.value
video_watched_50_percent
Display name Watches at 50%
Description The number of times the ad was served and at least 50% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_75_percent
Display name Watches at 75%
Description The number of times the ad was served and at least 75% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
video_watched_95_percent
Display name Watches at 95%
Description The number of times the ad was served and at least 95% of the video has played, including plays that skipped to this point
Field type metric
Data type int.number.value
viewer_comments
Display name Viewer comments
Description The number of times a user saw the post, and also commented on it. Please note that this field will be removed on 2024-09-22
Field type metric
Data type int.number.value