Magento Business Intelligence Help Center

Using the Event Number Calculated Column

This document outlines the purpose and uses of the "Event Number" calculated column available in the "Manage Data -> Data Warehouse" page. Below is an explanation of what it does, followed by an example, and the mechanics of creating it. Please note: This is currently a beta feature. 

Explanation 

The "Event Number" column type identifies the sequence in which events occurred for a particular "event owner", like a customer or user. If you're familiar with SQL, this column type is identical to the "RANK" function. It could be used to observe differences in behavior between first-time events, repeat events, or nth events in your data. 

In case of ties, this column contains the same "rank" for the tied events, and skips the subsequent numbers. For example, if it were ranking the numbers 5,8,10,10,12, the ranks would be 1,2,3,3,5. 

The most common use case of this column is to analyze first time buyers and repeat buyers. First time buyers are identified by adding a filter (to a metric or report) on "Customer's order number" = 1. "Customer's order number" is a column of the type "Event Number". 

Example 

event_id 

owner_id 

timestamp 

Owner's event number 

1 

2015-01-01 00:00:00 

2 

2015-01-01 00:30:00 

3 

2015-01-01 02:00:00 

4 

2015-01-02 13:00:00 

5 

2015-01-03 13:00:00 

In the above example, the column "Owner's event number" is an "Event Number" column. It ranks the owner's events in the order in which they occurred (based on the "timestamp" column). 

For instance, consider all rows where "owner_id" = A. The 1st row in the table is the earliest timestamp for this owner, followed by the 3rd row in the table, followed by the 4th row in the table. 

Mechanics 

Here are some instructions on creating an "Event Number" column: 

  1. Navigate to the "Manage Data -> Data Warehouse" page. 
  2. Navigate to the table on which you want to create this column. 
  3. Click "Create a Column" and choose the "EVENT_NUMBER (…)" column type under the "Same Table" section. 
  4. The first drop-down "Event Owner" specifies the entity for which the rank is to be determined. In the case of "Customer's order number", a customer identifier such as "customer_id" or "customer_email" would be the "Event Owner". 
  5. The second drop-down "Event Rank" specifies the column that enforces the sequence that determines the rank of the row. In the case of "Customer's order number", the "created_at" timestamp would be the "Event Rank". 
  6. Under the "Options" drop-down, filters can be added to exclude rows from being considered. The excluded rows will have a NULL value for this column. 
  7. Provide a name to the column and hit "Save". 
  8. The column will be available to use immediately. 

Screen_Shot_2017-09-07_at_4.02.51_PM.png

For any questions, please feel free to reach out to the support team at support@rjmetrics.com. 

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk