Getting started
The Data Distiller SKU is required to build a custom data model for your reporting insights and to extend the Real-Time CDP data models that hold enriched Experience Platform data. See the packaging, guardrails, and licensing documentation that relates to the Data Distiller SKU. If you do not have the Data Distiller SKU, contact your Adobe customer service representative for more information.
SQL Insights use cases
Below are common use cases that can be effectively addressed through SQL Insights in Data Distiller.
Profile and audience usage transparency
Challenge: How to break down Key Performance Indicators (KPIs) by specific criteria like business units, loyalty status, or Customer Lifetime Value (CLTV).
SQL Insights Solution: Data Distiller enables the extension of reporting data models in Adobe Experience Platform, facilitating the addition of custom profile attributes such as CLTV or loyalty status.
Consent anomaly tracking
Challenge: How to apply audience overlap and size trendline reports to customized consent attributes for channels like email, SMS, and phone.
SQL Insights Solution: The reporting data model can be extended to track changes in consent preferences over time. This involves building additional fact and dimension tables to trend consent preferences and scheduling incremental data refresh.
Optimize audience segmentation strategy
Challenge: How to integrate Machine Learning (ML) model-generated propensity scores into their audience KPI reports.
SQL Insights Solution: Data Distiller allows the inclusion of propensity scores from custom ML models, facilitating the calculation of aggregate scores at the audience level. This data can then be reported alongside standard KPIs.
Audience expansion
Challenge: How to acquire more than just profile counts in audience overlap reports and attain additional demographic data or preferences to guide audience expansion strategies.
SQL Insights Solution: By extending the reporting data model, users can incorporate additional profile attributes, enriching the audience overlap report with relevant demographic data and preferences.
Key capabilities for generating SQL Insights
The illustration below highlights several essential capabilities for generating SQL Insights. These capabilities include:
- Data visualizations: Incorporating visual elements such as trends and bar charts for a comprehensive view of data trends.
- Dashboard authoring: Enabling the creation of custom dashboards tailored to specific use cases, providing a more personalized and targeted analytics experience.
- Flexible SQL data modeling: Use a versatile SQL data modeling approach that allows users to seamlessly combine and manipulate different datasets, enhancing adaptability, and analytical depth.
- Accelerated store: Implementing an accelerated store mechanism to efficiently serve aggregated insights through SQL, ensuring streamlined and rapid access to valuable information.
- BI connectivity: Facilitating seamless integration with popular Business Intelligence (BI) tools, including Power BI, Tableau, Looker, and Apache Superset. This connectivity ensures compatibility with diverse BI environments, offering users the flexibility to use their tool of choice for in-depth analysis and reporting.
