Alli Data Library v2.6
Overview
Alli Data Library v2.6
is now available. Here's what's new:
What to know before upgrading
Breaking changes
There are no Breaking Changes for this release.
Behavior changes
2 New Conversion Metrics for TikTok Ads
ADL2.0 now provides 2 new offline conversion metrics for TikTok Ads at Account, Campaign, Adgroup and Ad level performance models:
offline_complete_payment
, which isTotal Complete Payment (Offline)
from the UIoffline_complete_payment_value
, which isTotal Complete Payment Value (Offline)
from the UI
6 New Conversion Metrics for Snapchat Ads
ADL2.0 now provides 6 new conversion metrics for Snapchat Ads at Account, Campaign, Adgroup and Ad level performance models:
web_purchase_conversions
web_purchase_conversions_value
app_purchase_conversions
app_purchase_conversions_value
offline_purchase_conversions
offline_purchase_conversions_value
New features and enhancements
New DMA-level Geo Reports
DMA-level geo reports are now available for Facebook Ads, Google Ads, Snapchat Ads, and TikTok Ads. Now users can get DMA data within the geo__dma_performance
model, as well as the following platform models:
facebookads__geo_dma_performance
googleads__geo_dma_performance
snapchatads__geo_dma_performance
tiktokads__geo_performance
The field mapping document has been updated here Data Library Field Mapping - Geo DMA Performance
To enable geo reporting, please confirm:
The following datasources have been created for the client
Facebook Ads:
facebookads_insights_geo
facebookads_insights_dma
Google Ads:
googleads_insights_geo_state_campaign
googleads_insights_geo_state
googleads_insights_geo_metro_campaign
googleads_insights_geo_metro
Snapchat Ads:
snapchat_insights_geo_dma
TikTok Ads:
tiktok_insights_ad_dma
Add the following line to the dbt vars JSON file. This is disabled by default.
"data_library_facebookads_geo_reporting_enabled": "True",
"data_library_googleads_geo_reporting_enabled": "True",
"data_library_snapchatads_geo_reporting_enabled": "True",
"data_library_tiktokads_geo_reporting_enabled": "True"
New conversion metrics & conversion reports available for Google Ads
Google Ads has new conversion reports available within ADL2.0. These reports provide conversion metrics at the conversion action name level, allowing users to obtain detailed conversions based on different conversion actions.
googleads__campaign_conversion_performance
googleads__adgroup_conversion_performance
googleads__ad_conversion_performance
Meanwhile, more conversion columns are available for Google Ads performance models, mapped to corresponding conversion action categories:
add_to_cart_conversion
add_to_cart_conversions_value
purchase_conversions
purchase_conversions_value
sign_up_conversions
sign_up_conversions_value
app_install_conversions
app_install_conversions_value
These columns are mapped when the conversion_action_category
for the Ad/Campaign matches one of the actions: ADD_TO_CART
, PURCHASE
, SIGNUP
, APP_INSTALL
The field mapping documents have been updated for Account, Campaign, Adgroup and Ad level here Data Library 2.0 Field Mapping
Added ability to pull in impressions and clicks from programmatic_cost
Data Library 2.0 now enables users to add impressions
and clicks
into programmatic_cost
via the pass-through metric feature.
Google Ads Pmax Report Update
Data Library 2.0 has updated Google Ads Pmax report, utilizing the new calculation logic for display metrics (see Google PMAX Report Refactor - Display Metrics ). The enhancement ensures the alignment of display metrics with the Placement Analysis report used by the SEM team.
The report changes require a new datasource googleads_settings_assetgroup
. Users can use Alli Data Library 2.0 - Onboard Platform
and select Google Ads
as the platform to launch the new datasource if it’s missing for the clients (see Onboarding a platform to Data Library).
Bug fixes
Resolved metric doubling for Facebook Ads
Resolved an issue within ADL2.0 where facebookads__ad_performance
model has doubled metrics for some clients.
Fixed Facebook structure datasource duplicates
Update/Merge failure error impacting clients when building facebookads__ad_performance
report has been resolved by deduplicating Facebook structure datasources regarding to self-refreshed preview_link
.
Resolved an issue with cm_placement_id
extraction for DV360
Resolved an issue with cm_placement_id
extraction logic for DV360 to check the TrueView Ad name if the Ad group name returns null
.
Other changes
Updated URL extraction logic for Facebook Ads
Ad URLs for Facebook Ads performance models have been updated within ADL2.0. Now users can get appropriate URLs and URL tags within facebookads__ad_performance
by querying the following columns:
link_ad_url
url_tags
Updated cm_placement_id
extraction logic for Taboola
The cm_placement_id
extraction logic for Taboola has been enhanced to retrieve it from URLs, resolving join failures with CM360 data.
How to upgrade
Make sure to read through the What to know before upgrading section, and make the necessary updates before upgrading
To upgrade, simply select the appropriate version of the ADL 2.0 Refresh app, save, and run
Resources
🚀 Tutorials
- Onboarding Vistar DSP to Data Library
- Building and refreshing a Data Library report
- Backfilling data for a platform in Data Library
- Onboarding a platform to Data Library
- Getting started with Data Library 2.0
- Querying Data Library 2.0 in Data Explorer
- Onboarding Bidtellect to Data Library
- Onboarding Trade Desk to Data Library
- Onboarding CM360 to Data Library
How-tos
- How to add fields to a datasource without losing historical data
- How to categorize CM360 conversions in Data Library
- How to find which platforms and reports are enabled in Data Library
- How to find your Data Library datasources in Alli Data
- How to add custom Programmatic cost in Data Library
- How to add source of truth data in Data Library
- How to reclassify media channel data in Data Library
🔍 Reference
- Report Migration Guide
- Column Migration Guide
- Tablestakes Migration Guide
- Data Library 2.0 Migration Guide
- Data Library 2.0 Field Mapping
- Data Library 2.0 Report DAGs
- Core Categorizations in Data Library 2.0
- Placement ID methodology in Data Library 2.0
- Data Library Platform dbt Packages
- Data Library 2.0 FAQs