ADL v2.6 (June 2024)

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 is Total Complete Payment (Offline) from the UI

• offline_complete_payment_value, which is Total 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:

1. 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

2. 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 Report Field Mappings

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).

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

How-tos

🔍 Reference