Affiliate Profit Tracking - Two Philosophies
Having been in the affiliate marketing game for quite some time now, I've had my fair share of freak-out sessions where I think life is over when a campaign fails for a day. Although logic tells me that the market (people, competition, demand, etc.) fluctuates on a daily basis and is even evident if you do a Google Trend on most any keyword, emotion rules over on days when you are in the red $500 and it seems like there's no where to go but down.
Now, if you track your profits at all using Microsoft Excel, Google Spreadsheets or some other contraption, chances are that you like to track your profits and losses on a daily basis. And if that's the case, your charts (if you were to render them) would probably look something like this-
There isn't much wrong with a chart like this except that, if you'll notice, it's pretty uninspiring to look at when you notice your spend overshadowing your revenue. Also, it's hard to accurately gauge where you are in terms of net profits over the course of the month.
That's why I recommend tracking your profits and losses over the span of the month. This way, you can tell how much you are in the green, black or red. It gives you a solid number to base further action on so you don't go shutting your campaigns down because of a hiccup day. If you were to organize your data this way, the chart would look something like this-
You'll notice right away that it's more inspiring to see the dark blue line above the light blue line (you're in profits, baby). What this will allow you to do is see the bigger picture and therefore, make better decisions about whether or not to keep campaigns running or shutting them down. Typically if I chart my profits and losses this way, I will see the overall worth of a campaign and keep it running.
However, I am in no way saying that you shouldn't monitor the daily, weekly and even monthly trends of your campaigns and schedule them accordingly. What I am saying is that you can tell much more easily this way whether you should shut a campaign completely down or keep it going strong.
As obvious as all this might sound, it might help to absorb this philosophy into your own affiliate marketing strategy to add to your overall profit margin. Simple, yet effective.
Good luck,
Scott
Popularity: 12% [?]










January 24th, 2008 at 7:53 pm
What do you think about going a step further. What if you find out that you do really badly on lets say Saturdays, Do you think we should even go as far as to turn off campaigns on a certain day?
January 24th, 2008 at 8:24 pm
@will: If that’s most profitable for you, then most definitely yes. I have some campaigns that I turn off for three out of seven days. You just have to test and look at statistics with Google Trends to see what works best.
January 25th, 2008 at 2:04 am
My light blue line is about 10 time bigger than my dark blue line! How long do you give a campaign like mine before you bin it completely!?
January 25th, 2008 at 6:24 am
why not just graph the 3 (or more) day moving averages? that way you get a smoother line without missing the ability to react quickly to changes.
January 25th, 2008 at 9:03 am
@Chris: Yikes. Well, I guess it depends on what you’re actually spending. If you’re spending $10 and making $1, that’s not as big a deal as spending $100 to make $10, etc. If you’re working with bigger numbers, it’s best to quit sooner.
@Matt: You mean as in percentage increases/decreases?
January 29th, 2008 at 6:26 am
@Scott: It’s a little better than that now - I’ve spent £61 (YSM only) and recouped £21 since I went live 10 days ago. the last few days have been better, and I’m slowly getting close to a poitive ROI. Maybe I should have chosen a less competitive niche to start with (Online Dating) but I’m learning a lot. I want to be at least profitable day-by-day on YSM before I open the adwords taps!
January 29th, 2008 at 9:20 am
@Chris: Yes, online dating can be a bitch but once you’ve got her, you’ll be happy you did.