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.
| Name | Description |
|---|---|
| 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 |