Reddit Ads Prebuilt Reports
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