Reddit Ads Predefined Reports

Predefined Reports

The Reddit Ads datasource in Rivery comes with the below predefined reports. Each report will have a short description of it, a list of customizable fields (if any), and the schema mapping. Due to the standardized nature of these reports, there are a number of locked fields that will only be accessible through the custom reporting functionality.

Campaigns

Get a list of campaigns by user.

Field	Data Type	Dimension/Metric
id	String	Dimension
account_id	String	Dimension
configured_status	String	Dimension
effective_status	String	Dimension
funding_instrument_id	String	Dimension
is_processing	Boolean	Dimension
name	String	Dimension
objective	String	Dimension

Communitites

Fetch a list of available communities

Field	Data Type	Dimension/Metric
id	String	Dimension
daily_impressions	Integer	Metric

Geo Locations

Get a list of all the geolocations.

Field	Data Type	Dimension/Metric
id	String	Dimension
country	String	Dimension
dma	Integer	Metric
name	String	Dimension
region	String	Dimension

Interests

Fetch a list of available interests

Field	Data Type	Dimension/Metric
id	String	Dimension
category	String	Dimension
name	String	Dimension

Reports

Obtain reports based on the start date.

Field	Data Type	Dimension/Metric
placement	String	Dimension
request_start_date	String	Dimension
request_end_date	String	Dimension
post_id	String	Dimension
metro	Integer	Dimension
interest	String	Dimension
date	String	Dimension
country	String	Dimension
account_id	String	Dimension
comment_downvotes	Integer	Metric
comments_page_views	Integer	Metric
community	String	Dimension
conversion_add_to_cart_avg_value	Float	Metric
conversion_add_to_cart_total_items	Integer	Metric
conversion_add_to_cart_total_value	Integer	Metric
conversion_add_to_wishlist_avg_value	Float	Metric
conversion_add_to_wishlist_total_items	Integer	Metric
conversion_add_to_wishlist_total_value	Integer	Metric
conversion_lead_avg_value	Float	Metric
conversion_lead_total_value	Integer	Metric
conversion_purchase_avg_value	Float	Metric
conversion_purchase_total_items	Integer	Metric
conversion_purchase_total_value	Integer	Metric
conversion_roas	Float	Metric
conversion_signup_avg_value	Float	Metric
comment_upvotes	Integer	Metric
clicks	Integer	Metric
cpc	Float	Metric
ctr	Float	Metric
custom	Record	Dimension
campaign_id	String	Dimension
ecpm	Float	Metric
gallery_item_caption	String	Dimension
conversion_signup_total_value	Integer	Metric
impressions	Integer	Metric
app_install_metrics	Record	Metric
lead	Record	Dimension
legacy_click_conversions	Record	Dimension
legacy_view_conversions	Record	Dimension
add_to_wishlist	Record	Dimension
page_visit	Record	Dimension
gallery_item_id	String	Dimension
add_to_cart	Record	Dimension
priority	String	Dimension
purchase	Record	Dimension
region	String	Dimension
ad_id	String	Dimension
ad_group_id	String	Dimension
search	Record	Dimension
sign_up	Record	Dimension
spend	Integer	Metric
video_fully_viewable_impressions	Integer	Metric
video_plays_expanded	Integer	Metric
video_plays_with_sound	Integer	Metric
video_started	Integer	Metric
video_viewable_impressions	Integer	Metric
video_watched_100_percent	Integer	Metric
video_watched_10_seconds	Integer	Metric
video_watched_25_percent	Integer	Metric
video_watched_3_seconds	Integer	Metric
video_watched_50_percent	Integer	Metric
video_watched_5_seconds	Integer	Metric
video_watched_75_percent	Integer	Metric
video_watched_95_percent	Integer	Metric
view_content	Record	Dimension
viewable_impressions	Integer	Metric
viewer_comments	Integer	Metric

Accounts

Obtain information about a certain account. Most API users will actually want to work with their own account, but if they have been authorized access, they can access other accounts as well.

Field	Data Type	Dimension/Metric
id	String	Dimension
attribution_type	String	Dimension
click_attribution_window	String	Dimension
created_at	String	Dimension
currency	String	Dimension
pixel_partner_preferences	String	Dimension
status	String	Dimension
time_zone_id	String	Dimension
view_attribution_window	String	Dimension

Ad Groups

Get all ad groups belonging to an advertiser.

Field	Data Type	Dimension/Metric
id	String	Dimension
account_id	String	Dimension
bid_type	String	Dimension
bid_value	Integer	Metric
campaign_id	String	Dimension
configured_status	String	Dimension
effective_status	String	Dimension
end_time	String	Dimension
goal_type	String	Dimension
goal_value	Integer	Metric
bid_strategy	String	Dimension
is_processing	Boolean	Dimension
name	String	Dimension
optimization_strategy_type	String	Dimension
schedule	Record	Dimension
start_time	String	Dimension
targeting	Record	Dimension

Ads

Get a list of ads by for an account ID.

Field	Data Type	Dimension/Metric
id	String	Dimension
account_id	String	Dimension
campaign_id	String	Dimension
click_trackers	String	Dimension
click_url	String	Dimension
configured_status	String	Dimension
effective_status	String	Dimension
ad_group_id	String	Dimension
is_processing	Boolean	Dimension
name	String	Dimension
post_id	String	Dimension
post_url	String	Dimension
preview_expiry	String	Dimension
preview_url	String	Dimension
rejection_reason	String	Dimension
search_term	String	Dimension
third_party_trackers	String	Dimension