Query Service overview

Last update: 2023-09-25
  • Topics:
  • Queries
    View more on this topic
  • Created for:
  • Beginner
    Developer

Learn how Query Service in Adobe Experience Platform can help you Understand customer behavior and generate impactful insights. For more information, please visit the Query Service documentation.

 Transcript

Hi there. Adobe Experience Platform ingest data from a wide variety of sources. And major challenge for marketers is making sense of this data to gain insights about the customers. In this video, let’s get a quick overview of how Query Service helps brands to connect the online to offline customer journey, and understand Omni-channel Attribution. We will also cover some of the common use cases for Query Service in Adobe Experience Platform. Today, we are in a place where experiences are everything we do, across physical and digital channels. Take an example, such as going on a holiday. Now, the experience begins when you first start planning for a vacation. Choosing the right location, right offers for travel, getting the best deal for your dream resort, to finding the right tours. All of that is now part of the experience. Experience has evolved from making a discreet, even delightful to making an entire journey engaging and compelling. For brands, the big question is around, “How do you deliver that level of experiences?” But what is the secret sauce to deliver a customer experiences that exceed their expectations during every point of the journey? There are three steps to create relevant, satisfying, and valued experiences. First, it starts with measuring customer engagement. Measuring, understanding and analyzing customer journeys allows you to gain a holistic view of your customers and the context behind their every action. Second, discover unique high value audiences. You cannot duplicate your best customers, but you can find more like them. You need to uncover these audiences before your competitors do. The key lies in using your current customer data to locate others with similar attributes. Lastly, we need to deliver seamless one-to-one personalized experiences across touchpoints. What you need is an experienced architecture that makes the right insights available at the right time to make the right decisions. So what are the issues with Generic Cloud Data Platforms? When we talk about experienced architecture, there are two systems. The Operational or the left-brain, and the Analytical or the right brain. In order to shape customer experiences in Real-Time, or near Real-Time, brands need access to Unified Customer View. This Unified Customer View resides in the operational system and supports low latency access patterns. For example, mobile applications or kiosks need quick access to Unified Customer View data to make personalization decision in milliseconds. Analytical systems, on the other hand, it is totally a different kind of data scale scenario. The objective is to analyze large amounts of data to perform Advanced Analytics and to train Machine Learning Models. Trying to use an Operational Scale System that is designed for low latency against an ML workload would not scale because you cannot get access to large amounts of data in a reasonable time. Instead, analytics workloads require a different access pattern. They are typically housed in a Data Lake or a Data Warehouse. But having two separate system creates a lot of challenges. Adobe Experience Platform is built from ground up to be an operational and analytical system. Whether you want to access and use data for Operational or Analytical use cases, it is just a matter of configuration. That being said, Experience Platform is not here to replace your Data Warehouse, unless you want to. We are creating a fast symbiotic complimentary relationship between Operational and Analytical use cases. From a packaging standpoint, there are three flavors of Adobe Experience Platform that you can buy. Collection. Trusted, robust, and most complete streaming data infrastructure that helps simplify Customer Experience data collection and streamline its delivery. Intelligence. Adobe Experience Platform ingest data from a wide variety of sources. Adobe Experience Platform Query Service allows you to use standard SQL to query data in platform, helping marketers better understand their customers. Activation allows brands to create a complete customer profile using both Behavioral and Attribute data from any data source to be used across each organization within the enterprise. At a high level, there are four capability groups under the Experience Platform Intelligence Umbrella. The first is SQL exploration and procreation, which captures the ability provided to bring Customer Experience Data into one place for analysis, exploration, and experimentation using ANSI SQL and for persisting the derived data set into Data Lake. The second capability group captures the capabilities we provide to seamlessly create and visualize key customer metrics within Experience Platform and share these insights with key business decision-makers. Adobe Experience Platform supports third-party integration that allows access to data stored in Experience Platform for dashboarding and reporting. Third capability is, bring or build, and operationalize your own model which captures the AI or machine learning tools, assets, pre-built templates, and frameworks that support the rapid development, training, and tuning of Machine Learning Models with the very key functionality for customers to be able to bring their existing Machine Learning Models. And operationalize those models on top of the rich Omni-channel data in platform. The fourth is, AI or Machine Learning driven insights for personalization via profile enrichment, which are capabilities for applying insights derived from the operationalized Machine Learning workflows to include activation workflows in Adobe and non-Adobe destinations. Here are some of the high-level use cases where a customer will start to use Adobe Experience Platform Intelligence. With SQL Explorer, we can run ad hoc SQL queries against raw customer data as soon as it lands in Adobe Experience Platform for Omni-channel analysis. It is typically used for verification, exploration and experimentation of experience events, leveraging the native SQL Query Editor or third-party SQL tool of choice. Adobe-defined Functions are prebuilt functions in Adobe Experience Platform Query Service that help perform common business related tasks on Experience Event data. These include functions for Sessionization and Attribution like those found in Adobe Analytics. Adobe Experience Platform Query Service provides several built-in Spark SQL functions to extend SQL functionality. Check out the documentation for Spark SQL functions that are supported by Query Service. PostgreSQL is a command-line interface that comes installed when you install PostgreSQL on your machine. You can use any PostgreSQL compliant tool to access Experience Platform data sets and perform data exploration. You are ultimately able to experiment and validate data quickly before operationalizing that data in Customer Journey Analytics or in a dashboard available in Adobe Experience Platform. With the SQL preparation, you can quickly prepare Experience Data for downstream analytical consumption in Adobe Customer Journey Analytics, Data Science Workspace and BI dashboards, with the ability to schedule, manage and monitor SQL preparation jobs on large petabyte scale data sets using UI or API. Adobe Experience Platform allows third party applications that uses PostgreSQL protocol to connect to Query Service. This integration helps marketers to create and view a visualize representation of customer data in their favorite business intelligence tool to make useful decisions based off it. Adobe Experience Platform Query Service facilitates that by allowing you to use standard SQL to create data in platform. Adobe Experience Platform Query Service facilitates that by allowing you to use standard SQL to query data in platform. -

On this page