Create bespoke reporting data models to extract deeper insights, optimize strategies, and adapt analytics to meet specific business needs with Data Distiller’s SQL Insights. Use the SQL Insights capability to enhance transparency and gain operational insights from your Adobe Experience Platform data across dimensions such as profiles, audiences, campaigns, journeys, entitlements, and consent. This capability provides a versatile, adaptive solution to tailor your organization’s reporting data models to align with your specific business needs.
To visualize your SQL Insights you can use query pro mode to conduct complex analysis with custom SQL queries and transform your data into easily interpretable charts. Use query pro mode to create bespoke insights and visulaizations on your dashboards and cater to both technical and non-technical audiences by downloading your insights as CSV files.
This document covers the use cases, essential capabilities, and required steps to develop an SQL insights dashboard with Data Distiller.
This tutorial uses user-defined dashboards to visualize data from your custom data model within the Platform UI. See the user-defined dashboards documentation to learn more about this feature.
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 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.
Below are common use cases that can be effectively addressed through SQL Insights in Data Distiller.
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.
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.
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.
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.
The illustration below highlights several essential capabilities for generating SQL Insights. These capabilities include:
To develop a SQL Insights dashboard within Data Distiller, follow the step-by-step instructions below.
SELECT
queries to explore raw data on the data lake. This allows for on-the-fly, exploratory data analysis to experiment, and validates data where the results of the queries are not stored in the data lake.INSERT TABLE AS SELECT
and CREATE TABLE AS SELECT
queries to clean, shape, manipulate, and enrich data. The results of these queries are stored on the data lake.By reading this document, you now have a better understanding of the use cases, essential capabilities, and necessary steps to develop an SQL insights dashboard with Data Distiller. To continue learning about creating bespoke reporting data models, see the reporting insights data model guide.