ID535 - Stack Rank Your Customers (Using Analytics Data) Overview & Sample

This report Stack Ranks your customers using analytics data from your contracts, revenue, cost, clicks. The Columns reported are Revenue,Cost,Margin,CostPerCopy,ActualClicks, BaseAndOverageClicks (billed totals), color & BW clicks (both actual and billed))

The alert is emailed on the 1st of each month as a .txt file that you import into excel as a tab delimited file. See instructions here on importing the file.

Below is a sample of the Column headers, right click on images to enlarge.





You will see each metric represented and labeled with (RY01) & (RY02), rolling year 1 = last complete 12 months rolling, RY02= previous rolling 12 months to that. All of ECIs analytic rollups  ignore the "Current" month you are in because the data in the month is incomplete. You might not have billed a contract for last month so revenue could potentially be missing.

The columns containing "Rank" in their name are the respective rank for the period (RY01/RY02) from greatest to lowest so that you can compare a customers Rank on Revenue over the last 12 months (RY01), to how they Rank on Revenue in the previous 12 months to that (RY02) and see if a customer is slipping or growing.   

Note: With Analytics, all "Clicks" are from billed meters. Actual = the display, actual clicks customer ran. Base And Overage = the total clicks billed on an invoice for that machine.  So your Click metrics will always be lagging based upon the meter billing cycle for each contract. If you bill a lot of contract meters Quarterly, then you are going to be missing the most recent 3 months of meters until you bill that contract (contracts are billed in arrears usually).  If you bill "Annually", then your RY01 is going to be off in regards to the Contract metrics (base & overage revenue, meter clicks). 

EAutomate will "denormalize" the contract invoices and distribute the revenue & clicks for that invoice across the Overage Dates for that invoice evenly, so trying to reconcile to a contract invoice will typically require you have the previous and next invoice so that you can see how DGI prorates the revenue & clicks into the # of days in the cycle and then distributes that per diem into the appropriate Rolling Months so that the clicks/revenue are spread evenly and you have "data" for each month.  But the clicks can't distribute until they are billed, and since they are billed in arrears then your click distributions will only be current thru the most recent meter billing cycle for each contract. 

More details on understanding analytics data here.

You can verify the data by using the Analytic Eviews, Customer Transactions(Distributed) as the source eview and focus in on one customer at a time to see the raw details.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Please sign in to leave a comment.
Powered by Zendesk