ID535 - StackRank Customers from Analytics Database instructions

The attached file is a tab delimited file containing the stack ranking columns for you Customers for RY01 & RY02. (that is Rolling Year 1 and Rolling Year 2..which represent the last 12 months and the previous 12 months to that respectively). More details on understanding analytics data here.

To use this file,

1) save it to a folder you can access from Excel

2) Open Excel and select "File...Open" from the menu

Set the "Files of type" to All Files(*.*)..and then select the CustomerStackRank.ttx file from the folder you saved it in from the email

3) Excel will recognize that it is a delimted file and present you with the text import wizard as below:

Select "Delimited" and click on the "Finish" button


4) Your data should appear in rows and columns, with Column A being the "ParentCustomer"...Column B the LocationCustomer...Column C indicates if you selected only customers that have a currently active contract at the time the report ran..then the remaining columns are your metrics. 

You will see each metric represented and labled with (RY01) or (RY02), which are the Rolling Years from the "last" month (all of DGI's analytic rollups  ignore the "Current" month you are in because the data in the month is incomplete (you might not have billed the contract for t his month so revenue might be missing..etc).

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 customer in what their Rank is on Revenue for example the last 12 months compared to how the ranked for revenue in the previous 12 months to that and see if a customer is slipping or growing.    We provide a ranking number for:

Revenue | Cost | ActualTotalClicks | ActualBWClicks | ActualColorClicks | BaseAndOverageTotalClicks (what Billed) | BaseAndOverageBWClicks |

BaseAndOverageColorClicks | Margin % | Margin $ | CPCTotal | SupplyRevenue

One thing you mus remember with Analytics..all "Clicks" are from billed meters (Actual = the display...actual clicks customer ran..BaseAndOverage = 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 your 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 totally 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. 

You can verify the data by using the Analytic Eviews..selecting the 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