Query Types
All engagement queries begin with you deciding which type of query you want to create. The query type determines the scope of the query.
MXO provides the following query types:
| Statement | Scope | Summary | Notes |
|---|---|---|---|
| discover journeys | Return results for all identifiable journeys. | Discover data for all customer journeys, based on the specified filters. | |
| discover nth | Return results for one identified journey. | Discover data for one journey where n is the _n_th matching journey, from the start or end of the full customer journey path. | |
| export all customer data for date () | Return results for all customers. | Discover data for all customer activity, for a specified date range. | Replaces existing Data Export 7.5 functionality. |
Simple queries to get you started
Below are three very simple engagement queries, designed to get you started with thinking about and using EQL.
Use Case 1: Show me all customer journeys in the last 90 days
QuestionI want a general overview of how customers interacted with our brand over the last 90 days.
Querydiscover journeys having events limited in date(#CURRENT_DAY - 90 days, #CURRENT_DAY)Use Case 2: Show me the first successful application journey for each customer
QuestionI want to look at the first journey where a customer was approved for an account with our brand.
Querydiscover nth(1) journey through(interaction(activity="Application Approved"))Use Case 3: Retrieve data for all customer activity in the last week
QuestionI want to retrieve data for all customer activity in the last week and download that data for further analysis in our BI tool.
Queryexport all customer data for date(#CURRENT_WEEK - 1 week, #CURRENT_WEEK)