Behavioral Parameters Using "For" Clauses

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 "Open Email". 

"For" Clause Basics

Creating a "For" Clause

y6.gif

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, "Newsletter Subscribe", and also did "Email Link 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

y7.gif

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 "Newsletter Subscribe" and also did "Email Link Clicked" at least once within the prior 7 days.
  • Show users who did "Newsletter Subscribe" and did not "Email Link Clicked" within the prior 7 days.

Adjusting Event Count

y8.gif

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 "Newsletter Subscribe", and also did "Open Email" 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.

y9.gif

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. 

m32.gif

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

5af35782c47cf793730655.gif

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.

5af356ea455c8818311545.gif

For example, you could view how many people did "Newsletter Subscribe" for users who did "Email Link Clicked" 2 times or greater within the prior 7 days, and did "View Content" 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 occured outside of the main date range in the query builder.

For example, "Newsletter 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 Link Clicked" and "View Content" events will have occurred within the 7 days prior to "Subscribe".  If a "Subscribe" event occurred 6 days ago, and "Open Email" occurred 6 days prior to that, the "Subscribe" event will be counted even though "Open Email" occurred 12 days prior to today.

0 users found this helpful