Reddit Ads Prebuilt Reports
We include prebuilt reports by default. You can enable or disable prebuilt report tables on the Schema tab to avoid syncing data you don't need.
Fivetran supports the following Reddit Ads prebuilt reports:
| Report | Primary keys | Fields |
|---|---|---|
| ACCOUNT_REPORT | account_id 🔑, date 🔑 | COMMON_FIELDS |
| CAMPAIGN_REPORT | account_id 🔑, campaign_id 🔑, date 🔑 | COMMON_FIELDS |
| AD_GROUP_REPORT | account_id 🔑, ad_group_id 🔑, date 🔑 | COMMON_FIELDS |
| AD_REPORT | account_id 🔑, ad_id 🔑, date 🔑 | COMMON_FIELDS |
| POST_REPORT | account_id 🔑, post_id 🔑, date 🔑 | COMMON_FIELDS |
| CAMPAIGN_COUNTRY_REPORT | account_id 🔑, campaign_id 🔑, country 🔑, date 🔑 | COMMON_FIELDS |
Note that COMMON_FIELDS comprise the following fields:
app_install_metrics_add_payment_infoapp_install_metrics_add_to_cartapp_install_metrics_app_launchapp_install_metrics_completed_tutorialapp_install_metrics_installapp_install_metrics_level_achievedapp_install_metrics_purchaseapp_install_metrics_searchapp_install_metrics_sign_upapp_install_metrics_spendapp_install_metrics_spend_creditsapp_install_metrics_view_contentclickscomment_downvotescomment_upvotescomments_page_viewsconversion_roascpcctrecpmgallery_item_captiongallery_item_idimpressionslegacy_click_conversions_attribution_window_daylegacy_click_conversions_attribution_window_monthlegacy_click_conversions_attribution_window_weeklegacy_view_conversions_attribution_window_daylegacy_view_conversions_attribution_window_monthlegacy_view_conversions_attribution_window_weekpriorityregionspendvideo_fully_viewable_impressionsvideo_plays_expandedvideo_plays_with_soundvideo_startedvideo_viewable_impressionsvideo_watched_10_secondsvideo_watched_100_percentvideo_watched_25_percentvideo_watched_3_secondsvideo_watched_5_secondsvideo_watched_50_percentvideo_watched_75_percentvideo_watched_95_percentviewable_impressionsviewer_comments