Reddit Ads fields

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

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

62 metrics68 dimensions

ACCOUNT

account_name
Field label Account name
Description The name of the account
Field type dimension
Data type string.text.value
account_id
Field label Account ID
Description The ID of the account
Field type dimension
Data type string.text.value
timezone
Field label Time zone
Description The time zone ID preference for this account
Field type dimension
Data type string.time.timezone
admin_approval
Field label Admin approval
Description Admin approval
Field type dimension
Data type string.text.value
currency
Field label Currency
Description Currency of the account
Field type dimension
Data type string.currency.code
attribution_type
Field label Attribution type
Description Attribution Type
Field type dimension
Data type string.text.value
click_attribution_window
Field label Click-attribution window
Description Click-attribution window
Field type dimension
Data type string.text.value
view_attribution_window
Field label View-attribution window
Description View-attribution window
Field type dimension
Data type string.text.value
pixel_partner_preferences
Field label Pixel partner preferences
Description Advertiser-set pixel partner preferences
Field type dimension
Data type string.text.value

AD

ad_name
Field label Ad name
Description The name of the ad
Field type dimension
Data type string.text.value
ad_id
Field label Ad ID
Description The ID of the ad
Field type dimension
Data type string.text.value
ad_effective_status
Field label Ad status
Description The effective status for the ad
Field type dimension
Data type string.text.value
ad_configured_status
Field label Ad configured status
Description The status that the user has configured this entity to have
Field type dimension
Data type string.text.value
click_url
Field label Ad click URL
Description The ad's click URL
Field type dimension
Data type string.text.url
post_id
Field label Post ID
Description The ID of the post
Field type dimension
Data type string.text.value
post_url
Field label Post URL
Description The URL of the post
Field type dimension
Data type string.text.url
preview_url
Field label Preview URL
Description The test mode preview URL
Field type dimension
Data type string.text.url
preview_expiry
Field label Preview expiry date
Description The expiration date of test mode
Field type dimension
Data type string.time.date
search_term
Field label Search term
Description The 'Search Term' that is displayed on a promoted trend
Field type dimension
Data type string.text.value
event_trackers
Field label Event trackers
Description The event tracker URLs
Field type dimension
Data type string.text.value

AD GROUP

ad_group_name
Field label Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
ad_group_id
Field label Ad group ID
Description The ID of the ad group
Field type dimension
Data type string.text.value
ad_group_effective_status
Field label Ad group status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
ad_group_configured_status
Field label Configured status
Description The status of the ad group configured by the account owner
Field type dimension
Data type string.text.value
start_datetime
Field label Start datetime
Description Datetime when the ad group will begin to deliver
Field type dimension
Data type string.time.datetime
start_time
Field label Start time
Description Date when the ad group will begin to deliver
Field type dimension
Data type string.time.date
end_datetime
Field label End datetime
Description Datetime when the ad group will stop delivering
Field type dimension
Data type string.time.datetime
end_time
Field label End time
Description Date when the ad group will stop delivering
Field type dimension
Data type string.time.date
bid_type
Field label Bid type
Description The bidding strategy for the ad group
Field type dimension
Data type string.text.value
bid_value
Field label Bid
Description The amount to pay in US dollars per bidding event
Field type dimension
Data type float.currency.value
goal_type
Field label Budget type
Description The type of budget for the ad group
Field type dimension
Data type string.text.value
goal_value
Field label 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

CAMPAIGN

campaign_name
Field label Campaign name
Description The campaign name
Field type dimension
Data type string.text.value
campaign_id
Field label Campaign ID
Description The ID of the campaign
Field type dimension
Data type string.text.value
effective_status
Field label Campaign status
Description The calculated status determining the real status of this entity
Field type dimension
Data type string.text.value
configured_status
Field label 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
objective
Field label Campaign objective
Description The objective type of a campaign
Field type dimension
Data type string.text.value

COMMUNITY

community_name
Field label 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

CONVERSION (AVERAGE VALUE)

conversion_purchase_avg_value
Field label Average value: purchase
Description Average value of purchase
Field type metric
Data type float.currency.value
add_to_cart_avg_value
Field label Average value: add to cart
Description Average value of shopping cart
Field type metric
Data type float.number.value
conversion_add_to_wishlist_avg_value
Field label Average value: wishlist
Description Average value of wishlist
Field type metric
Data type float.currency.value
conversion_lead_avg_value
Field label Average value: lead
Description Average value of lead
Field type metric
Data type float.currency.value

CONVERSION (CART SIZE)

conversion_purchase_total_items
Field label Cart size: purchase
Description Total number of items purchased
Field type metric
Data type int.number.value
conversion_add_to_cart_total_items
Field label Cart size: add to cart
Description Total size of the shopping cart
Field type metric
Data type int.number.value
conversion_add_to_wishlist_total_items
Field label Cart size: wishlist
Description Total size of wishlist
Field type metric
Data type int.number.value

CONVERSION (CLICKS)

conversion_purchase_clicks
Field label Click: purchase
Description Number of purchase click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_clicks
Field label Click: add to cart
Description Number of add to cart click-through conversions
Field type metric
Data type int.number.value
conversion_add_to_wishlist_clicks
Field label Click: add to wishlist
Description Number of add to wishlist click-through conversions
Field type metric
Data type int.number.value
conversion_lead_clicks
Field label Click: lead
Description Number of lead click-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_clicks
Field label Click: sign up
Description Number of sign up click-through conversions
Field type metric
Data type int.number.value
conversion_search_clicks
Field label Click: search
Description Number of search click-through conversions
Field type metric
Data type int.number.value
conversion_view_content_clicks
Field label Click: view content
Description Number of content view click-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_clicks
Field label Click: page visit
Description Number of page visit click-through conversions
Field type metric
Data type int.number.value

CONVERSION (CPA)

conversion_purchase_ecpa
Field label eCPA: purchase
Description Effective cost per action. Calculated as total spend divided by total number of purchase conversions. (Amount spent / purchase clicks)
Field type metric
Data type float.currency.value
conversion_add_to_cart_ecpa
Field label eCPA: add to cart
Description Effective cost per action. Calculated as total spend divided by total number of add to cart conversions. (Amount spent / add to cart clicks)
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_ecpa
Field label eCPA: add to wishlist
Description Effective cost per action. Calculated as total spend divided by total number of add to wishlist conversions. (Amount spent / add to wishlist clicks)
Field type metric
Data type float.currency.value
conversion_lead_ecpa
Field label eCPA: lead
Description Effective cost per action. Calculated as total spend divided by total number of lead conversions. (Amount spent / lead clicks)
Field type metric
Data type float.currency.value
conversion_sign_up_ecpa
Field label eCPA: sign up
Description Effective cost per action. Calculated as total spend divided by total number of sign up conversions. (Amount spent / sign up clicks)
Field type metric
Data type float.currency.value
conversion_search_ecpa
Field label eCPA: search
Description Effective cost per action. Calculated as total spend divided by total number of search conversions. (Amount spent / search clicks)
Field type metric
Data type float.currency.value
conversion_view_content_ecpa
Field label eCPA: view content
Description Effective cost per action. Calculated as total spend divided by total number of content view conversions. (Amount spent / content view clicks)
Field type metric
Data type float.currency.value
conversion_page_visit_ecpa
Field label eCPA: page visit
Description Effective cost per action. Calculated as total spend divided by total number of page visit conversions. (Amount spent / page visit clicks)
Field type metric
Data type float.currency.value

CONVERSION (TOTAL VALUE)

conversion_purchase_total_value
Field label Total value: purchase
Description Total value of purchase
Field type metric
Data type float.currency.value
conversion_add_to_cart_total_value
Field label Total value: add to cart
Description Total value of shopping cart
Field type metric
Data type float.currency.value
conversion_add_to_wishlist_total_value
Field label Total value: wishlist
Description Total value of wishlist
Field type metric
Data type float.currency.value
conversion_lead_total_value
Field label Total value: lead
Description Total value of leads
Field type metric
Data type float.currency.value
conversion_signup_total_value
Field label Total value: sign up
Description Total value of signups
Field type metric
Data type float.currency.value

CONVERSION (VIEWS)

conversion_purchase_views
Field label View: purchase
Description Number of purchase view-through conversions
Field type metric
Data type int.number.value
conversion_add_to_cart_views
Field label 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_views
Field label View: add to wishlist
Description Number of add to wishlist view-through conversions
Field type metric
Data type int.number.value
conversion_lead_views
Field label View: lead
Description Number of lead view-through conversions
Field type metric
Data type int.number.value
conversion_sign_up_views
Field label View: sign up
Description Number of sign up view-through conversions
Field type metric
Data type int.number.value
conversion_search_views
Field label View: search
Description Number of search view-through conversions
Field type metric
Data type int.number.value
conversion_page_visit_views
Field label View: page visit
Description Number of page visit view-through conversions
Field type metric
Data type int.number.value

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DEPRECATED

comments_page_views
Field label Comments page views
Description The number of times the comments page was viewed for the ad.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2024-09-22
viewer_comments
Field label Viewer comments
Description The number of times a user saw the post, and also commented on it.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2024-09-22
comment_downvotes
Field label Comment downvotes
Description The number comment downvotes on the ad.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2024-09-22
comment_upvotes
Field label Comment upvotes
Description The number of comment upvotes on the ad.
Field type metric
Data type int.number.value
🚫 Deprecated Deprecated on 2024-09-22

INTERESTS

interest_id
Field label Interest ID
Description Interest ID
Field type dimension
Data type string.text.value
interest_name
Field label Interest name
Description Interest name
Field type dimension
Data type string.text.value
category
Field label Category
Description Interest category
Field type dimension
Data type string.text.value

PERFORMANCE

impressions
Field label Impressions
Description The number of impressions served for this report period
Field type metric
Data type int.number.value
clicks
Field label Clicks
Description The number of clicks detected for this report period
Field type metric
Data type int.number.value
spend
Field label Amount spent
Description The amount spent for this report period in the account currency
Field type metric
Data type float.currency.value
spend_usd
Field label Amount spent (USD)
Description The amount spent (converted to USD) for this report period
Field type metric
Data type float.currency.value
Services Currency conversion
spend_eur
Field label Amount spent (EUR)
Description The amount spent (converted to EUR) for this report period
Field type metric
Data type float.currency.value
Services Currency conversion
spend_gbp
Field label Amount spent (GBP)
Description The amount spent (converted to GBP) for this report period
Field type metric
Data type float.currency.value
Services Currency conversion
ecpm
Field label eCPM
Description The effective CPM for this period. (Total spend / impressions)
Field type metric
Data type float.currency.value
ctr
Field label CTR
Description The click-through-rate for this period. (clicks / impressions)
Field type metric
Data type float.number.ratio
cpc
Field label CPC
Description The cost-per-click for this period. (Total spend / clicks)
Field type metric
Data type float.currency.value

PLACEMENT

placement
Field label Placement
Description Placement of the ad
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime

VIDEO

video_viewable_impressions
Field label 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_fully_viewable_impressions
Field label 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_with_sound
Field label 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_plays_expanded
Field label 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_watched_25_percent
Field label 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_50_percent
Field label 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
Field label 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
Field label 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
video_watched_100_percent
Field label 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_3_seconds
Field label 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
Field label 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_10_seconds
Field label 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
cpv
Field label CPV
Description The cost-per-video-view for this period. (Total spend / video views)
Field type metric
Data type float.currency.value
video_completion_rate
Field label Video completion rate
Description Watched at 100% divided by video views. {Video watched 100% / Video views}
Field type metric
Data type float.number.ratio