This extension collects a variety of information from your customer’s activity in the store.

Here is a list of collected KPI’s and its meaning.


NameDescription
Customer ID
Magento® Customer ID
Email
Magento® Customer Email
Store View
Store View ID
Loyal
If the customer is considered loyal or not, based on the result of the formula you defined in the “Formulas” section.
Number of visits
How many visits did the customer made to your store (max one visit per day)
Days Abandoned Cart
Number of days with an abandoned cart
Abandoned Cart Totals
Total Amount in the abandoned cart
Abandoned Cart N. Products
Number of products in the abandoned cart
Abandoned Cart Qty
Total quantity of products in the abandoned cart
Days until Anniversary
Number of days until the customer birthday
Age
Customer Age
Date of Birth
Customer Date of Birth
Days Order with Pending Payment
Number of days since customer’s last order and that order has the state ‘pending payment.’
Pending Payment Date
The date where the order was made and payment has yet to be made
Days since Last Order
Days since the customer last completed order (state complete or closed).
Last Order Date
Date of customer’s last completed order (state complete or closed).
Days since First Order
Days since the customer first order (state complete or closed).
First Order Date
Date of customer’s first completed order (state complete or closed).
Number of Reviews
Number of reviews made by the customer
Days since the Last Review
Number of days since the customer last review
Last Review Date
Date of customer’s last review
Days since Registration
Number of days since the customer account was registered
Account Registration Date
Date when the customer account was registered
Days Since Last Activity
A number of days since the customer had any activity in the store. Please note that the customer might have been in the store, but not logged in,
Last Activity
Number of days since the customer last activity
Number of Orders
Number of order made by the customer with any state
Number of Completed Orders
A number of orders made by the customer having the sate complete or closed.
% of Completed Orders
The percentage of completed order made by the customer
Total Orders Amount
The sum of the grand total from all orders made by the customer with the state complete or closed
Base Subtotal Orders
The sum of the subtotal (grand total minus shipping minus discounts) from all orders made by the customer with the state complete or closed
Base Total Shipping
The sum of the shipping amount from all orders made by the customer with the state complete or closed
Base Total Discount
The sum of the shipping amount from all orders made by the customer with the state complete or closed
N. Orders W/ Discount
The number of orders with the state complete or closed made by the customer where a discount was applied
Base Profit
The sum of the profit made from the customer
Base Cost
The sum of the cost in order made by the customer
Base Total Taxes
The sum of all taxes in orders made by this customer with the state complete or closed
Orders Average
The order amount average from orders with the state complete or closed made by the customer
% Orders Amount
The order average from the customer in comparison to the customers average. For example: If the order average for the entire store from all customers is $100 and the order average for this customer is $120, the % of the customer will be 120%. If the order average for the customer was $80, the % would be 80%. If this value is over 100%, it means the customer orders above the store average.
Orders Average (last Y)
The same as “Orders Average” but for last year
% Orders Amount (last Y)
The same as “% Orders Amount” but for last year
Orders Average (before the last Y)
The same as “Orders Average” but from the beginning to last year
% Orders Amount (before the last Y)
The same as “% Orders Amount” but from the beginning to last year
Avg. Days Between Orders
The number of days between orders by the customer with the state closed or complete