The “For" clause allows you to limit query rows to users who "did" or "did not do" a selected event before or after performing the initial event. For example, you could use a "For" clause to view users who did "Subscribe" after "Email Clicked".
"For" Clause Basics
Creating a "For" Clause
To use a "For" clause, click and drag an event from the data panel. Drop it into the drop zone at the end of the query row that says “For users who did/not”. By default, the "for" clause will be set to users who did, for example, "Subscribe", and also did "Email Clicked" greater than or equal to 1 time within the prior 7 days. See below for how to modify the "for" clause.
Did vs Did Not Do
After dragging an event into the drop zone, click the drop-down menu to select whether the event should be “did” or “did not.” For example:
- Show users who did "Subscribe" and also did "Email Clicked" at least once within the prior 7 days.
- Show users who did "Subscribe" and did not "Email Clicked" within the prior 7 days.
Adjusting Event Count
After adding an event with the "For" clause you can adjust for the number of times users performed this event, such as “greater than or equal to 1 time”, "less than 5 times", or "greater than 3 times". For example, you can view users who did "Subscribe", and also did "Email Clicked" more than 3 times within the 7 days prior to subscribing.
Adjusting Date Range
You may customize the date range using two drop down menus.
The first menu allows you to select whether the "For" clause event should have occurred prior to the initial event, subsequent to the initial event, or between two selected calendar dates. When using "between", the second menu displays a calendar, allowing you to select a specific date range.
When using "within the prior/subsequent", the second menu allows you to select a preset or custom count based on minutes, hours, days, weeks, or months.
Multiple "For" Clauses
Multiple "For" clauses may be added by dragging additional events into the query builder, then dropping them into the “For users who did/not” drop zone.
As events are added, you can adjust the event count and date range of each additional "For" clause. When using a relative date range, the date range is always relative to the date of the base event in the query and not the other "For" clauses.
For example, you could view how many people did "Subscribe" for users who did "Email Clicked" 2 times or greater within the prior 7 days, and did "Blog View" 3 times or greater within the prior 7 days. This will show users who clicked email links and viewed content within 7 days before subscribing.
Keep In Mind
Note that the "For" clause events could have occurred outside of the main date range in the query builder.
For example, "Subscribe" events in the chart window will have occurred within the Last 7 Days of the current date, as set in the date range menu at the base of the query builder. However, the "Email Clicked" and "Blog View" events will have occurred within the 7 days prior to "Subscribe". If a "Subscribe" event occurred 6 days ago, and "Email Clicked" occurred 6 days prior to that, the "Subscribe" event will be counted even though "Email Clicked" occurred 12 days prior to today.