Home > Technical & Creative Skills > Tracking Campaigns

---

Spreadsheet for Ad Performance: Help Me Make it Better (12)

---

This is the spreadsheet I use to track each ad I am currently running and see how well it is performing. It's a good way to check in and see your CTRs, CRs, but most importantly your net earnings, EPCs, and ROIs. This is how I make the call on if I kill ads, ad more, and to not lose track of them. When you are running a lot of ads on Facebook this could be a difficult process, but that's not my style.

How I use this: I take data directly from Prosper and Facebook and manually input. Each day I copy the sheet from the previous day and make changes.

When do I do this: As soon as I wake up, and four to five more times throughout the day.

The status column represents a category for performance. Under 25% red, under 50% ROI it's yellow, over 50% it's green.

Any suggestions to make it better would be great.

Here is the file :

https://docs.google.com/file/d/0Bwoc...it?usp=sharing

I'm sure I missed things. Questions?

---

A worksheet on tracking image performance as well as age.

Another for headlines and another for body copy.

---

I was using a spreadsheet like this for a while on POF, so I have a bit of experience with the ups and downs.

First thought - how much time does it take you to update the spreadsheet? Sounds like you have it pretty nicely streamlined already, but there may be more time savings to be made.

Excel can do quite a lot of automated data input for you, and if you need more power you can always move to doing some Actual Programming.

---

Seems like a serious waste of time.

When it's time to cut ads I'll have the traffic source in one screen, and my tracker (CPVlabs in the other). See how much each ad spent, cut the ones that aren't profitable. There are better uses of your time like creating more ads, campaigns, landers, testing more traffic sources, etc.

---

Serious waste of time? So you keep anything that is profitable or above breakeven? Do you have an unlimited budget and not worried about efficiency at all? And if you are only looking at what is profitable, you are spending your time creating new campaigns and ads but how do you know exactly how profitable your ads are? The sheet gives me an exact number how profitable my ads are and have been in the past. I can look at past days performance to compare trending CPC CTRs.

I can take high EPC / ROI ads and use that information on new ads or for other campaigns. And it doesn't really take that much time. Most of the important info is filled in automatically.

The thread wasn't about if you thought it was valuable or not it was asking for help in making it better

---

Wow calm down. Not going to waste anymore energy trying to help someone with this kind of attitude.

---

^^^
That was a douchy thing for me to say, I apologize dr_ngo.

Sometimes I just slave away over a hot kitchen to whip up a tasty spreadsheet and feel under appreciated. That's all.

And you are definitely right about spending more time on finding other offers, traffic sources, etc.

---

No worries man. I just believe more in spending new resources conquering new things, than spending too much time on the current stuff.

Anyways I look over your spreadsheet and made some changes. I think they are pretty self-explanatory. Take what you like, remove what you don't. I think you should just make a daily spreadsheet. It's better to look at trends and data over a few days, than make changes throughout the day. It's about statistical significance.

https://docs.google.com/spreadsheet/...kE&usp=sharing

---

Bro. He's the Doctor for a reason. When he says med time, it's med time. When he says waste of time?? OPEN your ears and listen to his explanations. But i agree i really can't stand his bad asian attitude...... grr

I asked him this question too, earlier, actually a few other ballers.. Summary?

Cut your losing ads EVERYDAY, even if it's making money the OTHER day, goal is to find a CONSTANT winner. But if you're spending only 2 bucks a day per ad, this won't work - start spending MORE.

Joe

---

Thanks @joejoechen, I think that is a great "golden nugget". How much "MORE" do you recommend? is it a certain amount x offer payout you use to decide (e.g. offr x 3)?

---

I cut losing ads immediately, I try to never even let them get to negative, this is difficult of course if they start out negative. If an ad isn't positive or at least showing a very high CTR in the first $5-$10 of ad spend I cut it. I evaluate several times throughout the day, if an ad drops below a 25% ROI it also gets cut. The goal for me is profit and even above that is capital preservation.

---

Nice one, I admit I am not as strict as you, but maybe that is something I should try, I'm also interested in how @joejoechen or @dr_ngo decide if they have spent "enough" to justify cutting the ads daily?

---

Home > Technical & Creative Skills > Tracking Campaigns