How to enable hourly reporting in Data Library
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 Data Library reports)
Instructions
To enable hourly reporting for your client, do the following:
1.) In Alli Marketplace, install the ADL 2.0 - Onboard Platform
app
(see Onboarding a platform to Data Library):
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
5.) Authenticate the datasource and backfill the datasource as needed
6.) Once the datasource has pulled in data, navigate to the 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
:
"data_library_tiktokads_hourly_reporting_enabled": "True"
"data_library_googleads_hourly_reporting_enabled": "False"
"data_library_facebookads_hourly_reporting_enabled": "False"
"data_library_microsoftads_hourly_reporting_enabled": "False"
8.) 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
9.) Hit Save and Run
to execute the deployment app
10.) Set DEPLOYMENT
back to False
and click Save
11.) Once the app completes successfully, you should be able to query the hourly report(s):
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!
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.
Related articles
- Onboarding Vistar DSP to Data Library
- Building and refreshing your Data Library reports
- Backfilling a platform in Data Library
- Onboarding a platform to Data Library
- Getting started with Data Library
- Onboarding Bidtellect to Data Library
- Onboarding Trade Desk to Data Library
- Onboarding CM360 to Data Library