Reddit Ads predefined reports
The Reddit Ads data source in Data Integration includes following predefined reports. Each report contains a short description of it, a list of customizable fields (if any), and the schema mapping.
These reports follow a standardized format, so specific fields are locked, and you can only access them through the Custom reports feature.
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 geo locations.
| 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 want to work with their own account, but if they have 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 |
