Alli Data Library v2.0
Release Date |
|
---|
ADL v2.0 quick hits
DE-1952 Metric Reach is available in ADL 2.0
DE-1953 Post Saves for Facebook Ads is available in ADL 2.0 within the reports below:
facebookads__ad_peformance
facebookads__adgroup_performance
facebookads__campaign_performance
facebookads__account_performance
DE-2058 - Impression Share Metrics added to
keyword_performance
DE-2057 - Bid Strategy for Google Ads is available in ADL 2.0 within the reports below:
googleads__campaign_performance
googleads__adgroup_performance
googleads__keyword_performance
DE-2055 - Add effective_cpm to the following reports:
creative_performance
ad_performance
DE-2062 - New Categorizations available (
core_display_campaign_type, core_campaign_short_name
)DE-1974 - New Reports available within Alli Data Explorer Certified Datasources
Bug Fixes
DE-2066 - DV360 & CM360 datasources quoting issue on Snowflake
DE-2081 - Add
dv360_insights_ad_trueview
to available reports to backfill in ADL Backfill AppDE-2073 - Metrics not available defaulting to null vs. zero
Resources:
How to enable the latest version:
Select the tag v2.0
in the ADL 2.0 refresh App and execute it to reflect the below listed changes to your client.
![](../../__attachments/3014164539/image-20231031-150221.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
The Why
Reach metric is now available in ADL 2.0 [DE-1952]
This change Adds in the
reach
column available at thead_performance
,adgroup_performance
,campaign_performance
,account_performance
models.To implement this change to a client, make sure to add the
reach
column to social platform datasources. Refer to this field mapping document to fetch theapi_names
forreach
column according to platform, add it and backfill the datasource from required dates. Then refer the refreshing ADL 2.0 report to reflect thereach
column atad_performance
and other models.
This step is optional and only applies IF:
Reach column is missing in the existing social platforms Facebook, TikTok, Pinterest and Snapchat datasources.
Also reach is available only in the above social platforms and they have to be enabled for a client to add this column to your platform datasources
As an example for Snapchat Ads, find reach column in field mapping doc and look for
snapchatads
mapping for reach api_name columnuniques
as below and add that column insnapchat_insights_ad
. Then backfill the datasource for required dates and refresh the app to reflect thereach
column atad_performance
.
![](../../__attachments/3014164539/image-20230926-143259.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
Quick Platform Datasources and API column names for reference:
Platform | ADL 2.0 Datasource | API column name |
---|---|---|
Snapchat | snapchat_insights_ad | uniques |
pinterestads_insights_pins | total_impression_user | |
pinterestads_insights_adgroup | total_impression_user | |
facebookads_insights_ad | reach | |
TikTok | tiktok_insights_ad | reach |
Post Saves is now available for Facebook Ads in ADL 2.0[DE-1953]
This change Adds in the
post_save_conversions_1d_view_7d_click (action_onsite_conversion_post_save)
column available at thefacebookads performance
models.
Bid Strategy is now available for Google Ads in ADL2.0[DE-2057]
This change Adds in the
bid_strategy
column available at thegoogleads__campaign_performance
,googleads__adgroup_performance
, andgoogleads__keyword_performance
models.