Adobe Defined Functions

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

Learn how to use Adobe-defined functions in Adobe Experience Platform Query Service to perform common business-related tasks on Experience Event data. For more information, please visit the Query Service documentation.


Hi there, Adobe Experience Platform in just data from a wide variety of sources. A significant challenge for marketers, is making sense of this data to gain insights about their customers. Adobe Experience Platform Query Service facilitates that by allowing you to use standard SQL to query data in platform, using a user interface. On top of the standard SQL capabilities, Adobe provides predefined 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. In this video, let’s use an Adobe defined function, Sessionization, to explore Experience Event Data. From your Experience Platform homepage, navigate to data sets under data management. For this video, we are using a fictional retail brand called Luma. Luma loyalty data set contains information about customers, loyalty details, geographic details, et cetera. Luma web data contains web traffic information about customers interaction on the Luma site, including products viewed by a customer, visited pages, products purchased, et cetera. Now let’s explore how we can query the data set, using Platform Query Service. From the left navigation bar, click on queries under data management. Let’s click on the create query button, and you can see a query editor window opens up. Query editor enables you to write and execute queries without using an external client. When you’re working with experience event data, originating from a website, mobile application, interactive voice-response system, or any other customer interaction channel, it helps if events can be grouped around the related period of activity. Typically, you have a specific indent driving your activity, like researching a product, paying a bill, checking out balance, filling out an application, and so on. This grouping or sessionization of data helps associate the events to uncover more context about the customer experience. Let’s create a query to perform a sessionization for the Luma web data set. In the session timeout function, we provide two parameters, timestamp and expiration in seconds. Expiration in seconds denotes the number of seconds needed between events to qualify the end of the current session and the start of the new session. For the sample query, the results are given in the session column. The session column is made up of the following components, timestamp difference, number, is_new, and depth. Timestamp difference, the difference in time in seconds between the current record and the prior record. Number, a unique session number starting at one, for the key defined in the partition by of the window function. Is_ new a Boolean used to identify whether a record is the first of a session. Depth, the depth of the current record within the session. I hope I was able to give you a quick overview of how to use predefined functions in Adobe Experience Platform Query Service that help perform common business-related tasks on Experience Event data. Explore the documentation to check out other Adobe-defined functions. -

On this page