As well as generating key data insights for your ecommerce store for metrics like customer lifetime value or average time between orders, RFM Calc can produce even deeper insights into a particular order characteristic using our custom column reporting. Simply select that column as a custom column (for example, payment method or Google source channel) when scheduling a report, and we'll do the rest. For a complete overview of how our custom column reports work, please see our in depth video guide below:
For all custom columns, we'll show you a monthly breakdown of revenue, orders and also an overall split for your order data:
As well as showing overall revenue and orders, we'll produce data tables showing the customer lifetime value and average time between orders based on the custom column value used on a first customer order:
Remember, RFM Calc can generate advanced custom column reports for any data you can supply to us. For example, the chart below shows orders per month based on the Google source channel for that order. This was achieved by combining the source channel (exported from Google Analytics) with the original Magento order CSV via the Microsoft Excel vlookup function:
Not only do we show monthly revenue and orders, but of course we'll also show the customer lifetime value and average time between orders for the custom column in a clean sortable data table, in this case the Google source channel:
This incredibly powerful data can then provide key insights into lifetime value and average time between orders across whatever custom column data you submit.