Data Library 2.0 FAQs
This Document provides detailed answers to the most frequently asked questions regarding ADL 2.0. This guide aims to offer clarity and assistance to users encountering common issues below.
If troubleshooting steps does not resolve the issue, Please submit an ASD ticket or contact DE team for further assistance.
Q: What dbt_vars
should I enable for onboarding platforms of new clients?
A: Refer to available platform dbt_vars to determine which models would be enabled upon activating the corresponding platform dbt_var
.
Data Flows from all {platform}_{report}_performance models files {report}_permance models in ADL 2.0 (refer ADL 2.0 Available Reports)
Q: Why am I unable to download the dbt_vars
JSON for some clients?
A: Occasionally, due to glitches, you may encounter difficulties downloading the dbt_vars
Json file. To solve this, navigate to App execution and access logs. Below Set Up DBT
, find the fetch DBT Vars
section and copy the contents of the dbt_vars
dictionary to the dbt_vars
JSON file. This will provide you with the details of the enabled platforms for that client.
Access the latest and correctly formatted dbt_vars file here at Generating dbt_vars JSON
![image-20240320-183356.png](../../__attachments/2874606084/image-20240320-183356.png?inst-v=9d2044ed-f5d2-41ad-960f-0e53811769aa)
Q: Why is certain platform data not flowing in {client}_core.ad_performance
?
A: Ensure that the vars of that platform are enabled in the dbt_vars
Json file, and verify that the vars remain consistent across all apps, including the ALL Reports
app and essential
reports across both BigQuery and Redshift.
Q: Are certain report columns available in the platform (e.g., Ad columns in {platform name})?
A: To ensure that the report is available on the platform. Verify the reporting hierarchy to check the report availability on the platform. If the report is N/A
the corresponding columns will not be accessible in platform models of ADL 2.0.
Q: What is the column mapping for this column in UI and its API name?
A: Refer to field mapping documents to obtain API and UI names for validation purposes. This helps for cross-verification of data between the UI and ADL 2.0, ensuring consistency and accuracy.
Q: How to solve data inconsistency between UI and platform-related ADL models?
A: Troubleshooting Steps: Refer to the DAGs to examine the existing ADL data sources fueling the final performance model. Ensure data source configurations match UI settings and query at the data source level to verify data consistency with UI.
If discrepancies persist, attempt backfilling the data source for the relevant date range. Validate data consistency with UI again. If Data matches, trigger the ADL refresh apps.
Ensure correct UI and API names by referring to field mapping docs.
Q: Data inconsistency between Meta Ads Conversion columns in UI and ADL 2.0 Model.
A: If you encounter Data Validation issues with ADL 2.0 Meta standard ad conversion data source, please refer to this document for troubleshooting guidance. (How to Validate Meta Ad Conversion Metrics )
Q: What should I do if I notice ADL Refresh App Errors?
A: If you encounter failures with the ADL refresh app, please refer to this document for troubleshooting guidance. (https://agencypmg.atlassian.net/wiki/spaces/PTD/pages/edit-v2/3272998926?draftShareId=e8488ad2-27ce-4043-9dc5-99454d3dae01 )