Simple Use-Case Query Examples

Below is a list of simple use-case queries that you can use as the starting point for creating your own.

Use Case 1: All Journeys FROM a Channel

Business Use Case: I want to know which customers are coming to our products and services from social media.

Question: How many customers are starting their journey on the Social Channel. With this question only, Dynamic Audiences can obtain considerable knowledge of customer behavior, including where customers go after they leave the social channel.

discover journeys from interaction(channel="Social")

Explanation: The FROM filter asks about the first Interaction Context of interest. It reveals the first-touch attribution and allows you to compare the effectiveness of the different interactions that follow.

Use Case 2: All journeys FROM a Stage TO a Stage

Business Use Case: I want to know how many customers move from awareness of our products to using them.

Question: How many customers on our Touchpoints move from finding out about our products to actually using them.


Discover journeys FROM (stage="Awareness") TO (stage="Use")

Explanation: The FROM filter asks about the first event of interest and the TO statement asks about the last event of interest. It reveals Campaign/Channel/Asset cost-effectiveness. Whereas a query with only a FROM or a TO filter is in some sense "open-ended", this query is more focused, and uses stage-to-stage analysis.

Use Case 3: All Journeys excluding (NOT THROUGH) a specified Stage

Business Use Case: I want to find customers who do not purchase our products and services immediately but are still potential customers.

Questions: How many customers show an interest in our products and services but do not buy them immediately? Are they still potential customers I should think about targeting?

discover journeys from interaction(stage="Awareness") through(not(interaction(stage="Purchase"))) to interaction(stage="Consideration")

Explanation: The FROM filter asks about the first Interaction Context. The TO statement asks about the last Interaction Context. The special syntax of THROUGH(NOT) excludes the Purchase Stage.

Use Case 4: All journeys FROM FIRST Action

Business Use Cases: I want to determine whether introducing marketing content about our Money Market Saving Account is an effective strategy at the beginning of journeys of new customers.

Question: How effective is our strategy of introducing customers to a Money Market Savings Account during their first interaction.

discover journeys from first action(id="Money Market Savings Account")

Explanation: The FROM FIRST filter reveals the first Interaction Context associated with the specified Action that follows and enables you to see where customers go from there.

Use Case 5: All customer DROP OFFs

Business Use Case: I want to know which customers are dropping off at the Physical Channel.

Question: Which of my customers are dropping off the journey after visiting, for example, physical store locations).

discover journeys for customers with drop offs at interaction(channel="Physical")

Explanation: The FOR CUSTOMERS WITH filter reveals customer-specific behavior about their last interaction on the physical channel before dropping off the journey.

Use Case 6: All journeys THROUGH two Channels

Business Use Case: I want to know which customers go through the Mobile and Assisted Channels.

Question: How many of my customers use the Mobile and Assisted Channels to interact with my brand. It does not ask about the first or last Interaction Contexts.

discover journeys through(interaction(channel="Mobile") and interaction(channel="Assisted"))

Explanation The use of THROUGH with AND requires customers to use both Channels. If you substitute OR, customers need only use one channel.

Use Case 7: Analyze All Customer Activity for the last 90 days

Business Use Case: I want to retrieve data about all customer activity for the last 90 days, so that I can analyze that data in my BI tool.

export all customer data for date(#CURRENT_DAY - 90 days, #CURRENT_DAY)