Query Service overview

Adobe Experience Platform ingests data from a wide variety of sources. A major challenge for marketers is to make sense of this data to gain insights about their customers. To query data in Platform, you can use standard SQL and Adobe Experience Platform Query Service. You can use Query Service to join any dataset in the data lake and capture the query results as a new dataset for use in reporting, machine learning, or for ingestion into Real-Time Customer Profile. This document provides an overview of the role of Query Service within Experience Platform.

You can use Query Service to connect the online-to-offline customer journey and understand omni-channel attribution for your brand. The following video shows how an experience business can use Query Service to address key use cases and how Query Service works.

Using Query Service usage

To analyze your data, create and execute SQL queries with either the Query Service user interface or the RESTful API.
With the Query Service UI you can write, execute, and schedule queries, view previously executed queries, and access queries saved by users within your organization. You can also test out your queries before executing them on your wider dataset with the Query Editor. See the Query Service UI guide for an overview of the UI functionality.

The RESTful API provides a similar experience. You can use the Query Service API to programmatically write and execute queries, create and save templates for queries that you wish to adapt, or schedule queries for automated execution. See the Query Service developer guide for more information on using the Query Service API.

To quickly get started using Query Service features, you are recommended to read the following documents:

Query Service and Experience Platform services experience-platform-services

Query Service interacts and can be used with multiple Experience Platform services. To make the most out of Query Service’s capabilities, you should become familiar with these services and how they interact with Query Service. The Experience Platform documentation landing page provides summaries and links to the platform’s capabilities.

Data Science Workspace data-science-workspace

Adobe Experience Platform Data Science Workspace uses machine learning and artificial intelligence to gain insights from data stored within Experience Platform. Data scientists can use the Data Science Workspace to build recipes based on record and time-series data about customers and their activities. These recipes facilitate predictions such as buying propensity and recommended offers that the individual is likely to appreciate and use. You can use SQL within Data Science Workspace by integrating Query Service into JupyterLab to explore, transform, and analyze Adobe Analytics data. Read the Data Science Workspace overview and the Jupyter Notebook connection guide for more information about how Data Science Workspace interacts with Query Service.

Segmentation Service segmentation

Use the Adobe Experience Platform Segmentation Service to divide your customers into smaller groups that share similar traits. These audiences can then be evaluated to provide better analysis on your Real-Time Customer Profile data. You can use Query Service to run queries on this audience data within the data lake and provide the analysis. Read the Segmentation Service overview and the Profile Query Language (PQL) guide for more information on how to analyze audiences.

Use cases use-cases

Query Service provides a flexible approach to your data processing that serves many purposes. Among others, it can ease the burden of segmentation from marketers, and help generate actionable audiences and meaningful business insights. The following use cases offer more in-depth examples of the power of Query Service.

Adobe Analytics browse abandonment abandon-browse

This browse abandonment example centers on using Adobe Analytics data to create a particular actionable audience. Query Service accommodates complex logic for segmentation to calculate various personalized attributes for use downstream, or to greatly simplify how you build out your audiences.

Generate insights with custom dashboards custom-dashboards

With Adobe Experience Platform, you can ingest, store, structure, and pull all stored datasets — including behavioral, CRM, and point-of-sale data. Using Experience Platform’s Query Service, you can query on these datasets and answer specific questions about the business and then start generating impactful insights. Learn how to build and manage custom dashboards where you can create, add, and edit bespoke widgets to visualize key metrics with user-defined dashbaords. You can even customize your own Real-Time CDP reports for your marketing and KPI use cases by using SQL queries with the Real-Time Customer Data Platform Insights Data Models.

Next steps and additional resources

By reading this document, you have been introduced to Query Service and how it functions within the greater scope of Experience Platform. To continue learning about Query Service features, you are recommended to rad the following documents:

To better prepare yourself to run queries, watch the following video. This video shares tips and best practices for running queries in the query editor interface, PSQL clients, business intelligence (BI) solutions, and the HTTP API.

recommendation-more-help
ccf2b369-4031-483f-af63-a93b5ae5e3fb