Quote:
Originally Posted by mikeylikesit
if you have any tips, tricks, or hints as to how to track down/spot what looks like a missing spender please drop suggestions in here, tryna track stuff down with the CSV transactions in excel has me seeing nothing but a jumble of letters and numbers
|
I take the revshare transaction files and bring them into a database. Then I do several different queries and end up with a table that I dump into excel for looking at and sorting various ways.
Here is what the spreadsheet ends up looking like:
From there I can sort it various ways and see who has been buying but has stopped buying. Then I make a list of those that have been gone at least 6 months that were reguular buyers and had significant income and that is what I send if I need to.
I also keep track of who I have sent so I don't send them again.
I have not had to send any ids since last January. Haven't seen anything that looks fishy that hasn't already been sent.