Here’s a little update on the affiliate marketing.
In short, I’m still sucking. This morning was great and I thought I was actually getting somewhere, when I was at positive 69% ROI, but ever since then, I’ve just been accumulating more and more clicks with no more leads coming in.
So, I finished the day at -47.39% ROI, which, ironically enough, is still the best day I’ve had yet. Here’s the latest screenshot:
Nearly a grand in the hole… that’s bad, right? I haven’t even really been doing much actual work; most of my time spent doing this lately has been just updating my stats in Excel, and checking the stats across the 6 sites I use.
The other day I applied for another limit increase on my credit card, and after checking online yesterday, it appears they’ve approved it already. This will help me in the future if I continue to do this affiliate marketing thing.
Anyhow, I have a few questions for you guys, perhaps one of you out there knows the answer(s)?:
1. In Excel, is there any way to make all positive numbers appear as green text? Right now it just shows black, but it’d be nice to have them show as green. I know you can manually change the background of cells to different colours but I’m wondering about automatically having positive $ output as green.
2. Is there any way to make the dates automatically increment? Right now I just hand update them and this takes time. In relation, sometimes when I copy and paste the total row down to make more room, it will keep the ‘memory’ of what cells to do the math on, and will do so from like 2 rows above it, but sometimes it doesnt, and just keeps it’s old formula, meaning I have to keep updating them each time. How come it sometimes does this but not others, and how can I make it so I can just keep copy/pasting it to make more room and don’t have to keep updating them?
3. This is really bugging me; in MSN AdCenter, am I blind or is there no way to select data from a specific date?!? The reasons I want to do this are obvious, and as you can see from my spreadsheet, I’m forced to just put the total down, which is completely insane. Is there no way to do this? If not… wow.
I talked to my affiliate managers from Copeac and AzoogleAds, and was able to get rate increases on both of my campaigns there, one by $0.50 and the other by $2. This is small, but helps nonetheless. Just goes to show you never know what you’ll get if you don’t ask.
So… yeah. I’m completely sucking with the affiliate marketing thing. One of the issues is it being so time consuming for me. I’m so used to having stuff automatically set up and working by itself, and affiliate marketing requires a lot of constant stat checking, at least when you’re starting out. It also doesn’t help that I was stubborn enough to purposely choose the most competitive niches imaginable.
I’m going to take a little break from affiliate marketing and get some stuff done from my ‘todo’ list. If I stay focused too much on one thing for a long time I get bored, and we can’t have that, can we?