View Single Post
Old 09-21-2020, 05:33 PM  
kjs
Confirmed User
 
Industry Role:
Join Date: Jan 2014
Location: West Coast
Posts: 167
Most of you do not have enough users signed up to get a reliable signal as to what's going on. Focus on a better indicator.

Try this one:

Grab your last 100 values on the CSV download.
Open it in a spreadsheet
countdistinct([ user id column is here ])

This is simply the unique spenders in the last 100 transactions. It doesn't matter what the time period is. For low traffic affiliates this could be a month, for high it could be a few hours. That is the point.

When that number goes up, great job. Keep at it.
When revenue goes down and that number does not = chill out. People spent less.

Keep in mind it's an average. If it jumps around too much use the last 200, 500, etc. values in the CSV to observe a slower moving average.
__________________
Skype: live:1794c463efa7cc23
kjs is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote