How to enable hourly reporting in ADL

Overview

ADL now supports hourly reporting for the following platforms: Google Ads, Microsoft Ads, Facebook Ads, and TikTok Ads. These hourly reports are as follows:

Google Ads

googleads__adgroup_hourly_performance

Microsoft Ads

microsoftads__adgroup_hourly_performance

Facebook Ads

facebookads__adgroup_hourly_performance
facebookads__ad_hourly_performance

TikTok Ads

tiktokads__adgroup_hourly_performance
tiktokads__ad_hourly_performance

Cross-channel

adgroup_hourly_performance
ad_hourly_performance (Facebook and TikTok Ads only)

Data within these reports will be refreshed hourly with the most up-to-date and recent performance metrics.

Prerequisites

ADL 2.0 - Refresh app exists for your client (Building and refreshing your ADL reports)

Instructions

Hourly Datasources Onboarding

To enable Google Ads hourly reporting for your client, do the following:

1.) In Alli Marketplace, install the ADL 2.0 - Onboard Platform app
(see Onboarding a platform):

2.) Within the app, select the platform you’d like to create hourly datasources for, e.g: TikTok Ads

3.) Click Save and Run. When the app execution completes, you should be able to see the TikTok hourly datasource in Alli Data

4.) Under the Advanced Settings tab in the datasource, ensure that the schedule is set to Real Time

Remember to ensure the datasource schedule is set to Real Time. If its set to the Default schedule, hourly reporting models will not pull in data hourly!

5.) Authenticate the datasource and backfill the datasource as needed

ADL Apps Setup

If you’re enabling hourly reporting for Tiktok Ads, Facebook Ads, or Microsoft Ads, follow the below steps

6.) Once the datasource has pulled in data, navigate to the existing ADL 2.0 - Refresh app

7.) Within the dbt_vars json file, add the following vars and set whatever platform you require hourly reporting for to True, e.g. enabling TikTok Ads:

JSON

"data_library_tiktokads_hourly_reporting_enabled": "True"
"data_library_facebookads_hourly_reporting_enabled": "False"  --modify to True as needed
"data_library_microsoftads_hourly_reporting_enabled": "False" --modify to True as needed

8.) App Setting: PLATFORMS = ALL PLATFORMS

If you’re enabling hourly reporting for Google Ads, follow the below steps.

Based on the current model design of Google Ads hourly reporting, an independent ADL refresh app outside clients' current ADL 2.0 - Refresh - Daily app will be required.

Since Jan. 2025, an independent ADL refresh app for Google Ads hourly report only will not be required. The doc will be updated accordingly then.

6.) Create a new ADL app once the data source has pulled in data. You can complete this step easily by duplicating the current ADL daily apps. The app can be named as ADL 2.0 - Refresh - {Client Name} - {Data warehouse name} - Google Ads - Hourly

7.) Within the dbt_vars JSON file, copy and paste all the vars from All Platforms - Daily APP and add a new var as "data_library_googleads_hourly_reporting_enabled": "True"

JSON

"data_library_googleads_enabled": "True",
"data_library_googleads_searchterm_reporting_enabled": "True",
etc.
--- Please keep all Google Ads and other platform vars same as the daily app

"data_library_googleads_hourly_reporting_enabled": "True" --new added var for hourly reporting

Please ensure to have the same vars from the All Platforms - Daily APP and add additional var "data_library_googleads_hourly_reporting_enabled": "True"

8.) App Setting: PLATFORMS = Google Ads. Schedule it so it doesn’t conflict with the ADL 2.0—Refresh—All Platforms app.

Ex. If the All Platforms app runs on the hour at 7:00, 10:00, and 1:00, schedule the Hourly app to run at the :15 minute mark of the hour (7:15, 8:15, 9:15, etc.)

9.) Within the app, set DEPLOYMENT to True

Tip
If you’re enabling hourly reporting for a single platform only, consider selecting the specific platform within the PLATFORMS_TO_REFRESH drop-down. This will minimize unnecessary refreshes on other platform reports and speed up the deployment of your new hourly report.

Just be sure to set this back to All Platforms and hit Save

10.) Hit Save and Run to execute the deployment app

11.) Set DEPLOYMENT back to False and click Save

12.) Once the app completes successfully, you should be able to query the hourly report(s)

There is currently an issue with the TikTok API. If any metrics outside of clicks, spend and impression are selected, there tends to be a lag in the data. If you notice this lag and determine that the other metrics are not needed, you can deselect them from the datasource tiktok_insights_ad_byhour and then you should get up-to-date hourly data.