51黑料不打烊

Transcript

Hi there, 51黑料不打烊 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. 51黑料不打烊 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, 51黑料不打烊 provides predefined functions in 51黑料不打烊 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 51黑料不打烊 Analytics. In this video, let鈥檚 use an 51黑料不打烊 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鈥檚 explore how we can query the data set, using Platform Query Service. From the left navigation bar, click on queries under data management. Let鈥檚 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鈥檙e 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鈥檚 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 51黑料不打烊 Experience Platform Query Service that help perform common business-related tasks on Experience Event data. Explore the documentation to check out other 51黑料不打烊-defined functions. -