PPC campaign intelligence
Friday, July 20th, 2007PPC marketing when done right can be very profitable, I have developed my own PPC reporting tools in Excel that are pretty damn advanced if I may say so myself (that’s what I used to do for a living, develop business intelligence tools that integrate with 3rd party systems) with the help of these tools I can track my PPC campaigns on Google and Yahoo and compare the results over a few pages (lots of graphs and analytics so it takes up about 5 tabs in Excel).
The datasets I create are very informative, for example I not only know my ROI, but I know my ROI based on my GM (ROI – return on investment, GM – gross margin), on top of that I know all my click through rate, my click through to subscribe rate & cost, and my click to sale rate & cost.
The management tools I have are so good I’m able to give clients better data then the advertising companies provide, which enables me to charge a nice management fee of 40% of revenue spent. For e.g. if a client spends $10k, my bill is $4k. Might sound hefty but wait till the end and you’ll know why it’s not all that bad of an investment.
Here’s some data of mine, I’m not going to include all the graphs etc, just the small breakdown that gives an indication of the campaign for this month.
Campaign performance
Here we can see the totals and averages for the month, we have the number of clicks on the ad, subscribers to the site, sales we did, total revenue from the sales, the total gross margin of those sales, the ROI from the gross margin and the gross margin ROI as a percentage. Se were making close to a 300% ROI on our gross margins, and about 700% ROI on sales. I think It’s important to look at your ROI from your gross margins not from your sales, I’ll explain that in a different blog post.
|
SUMMARY |
TOTAL |
|
AVG |
|
||
|
|
|
CLICKS |
29,925 |
965 |
||
|
|
|
SUBSCRIBERS |
858 |
28 |
||
|
|
|
SALES |
766 |
26 |
||
|
|
|
SALES ($) |
$76,129 |
$2,456 |
||
|
|
|
GM ($) |
$34,258 |
$1,105 |
||
|
|
|
GM ROI ($) |
$22,539 |
$727 |
||
|
|
|
GM ROI (%) |
292% |
|||
Conversion Summary
These are the conversion summaries of the clicks, so our click through rate on the ads we use is on average 11.5%, of the 11.5% on average 2.9% subscribe, and 2.6% make a purchase.
|
SUMMARY |
BEST |
|
AVG |
|
|||
|
|
|
|
CTR |
14.5% |
11.5% |
||
|
|
|
|
Click->Subscriber |
4.3% |
2.9% |
||
|
|
|
|
Click->Sale |
4.4% |
2.6% |
||
Cost Summary
This is one of my favourite parts, this is our cost summary, in total in the month we spent over $11k on the campaign, with an average of $0.40 cents per click, and of those clicks we got the most we paid for a subscriber was $67, expensive! But all in all were paying $17 for a subscriber, bear in mind newsletter subscribers are worth lots of money, at times the newsletter itself can make thousands, we push the cost we’re paying for these subscribers into our newsletter reporting so we know our cost of the newsletter and ROI for it etc, those subscribers don’t magically appear at no cost.
We also paid $100 to make one sale; we probably went a couple of days without a sale but that’s not big deal unless your campaign is costing your heaps without any return, the average cost for a sale was $24 and our total money spent for the month as mentioned before was just over $11k.
|
SUMMARY |
MAX |
AVG |
|||
|
|
|
|
$/CLICK |
$ 0.45 |
$ 0.40 |
|
|
|
|
$/SUBSCRIBER |
$ 67.16 |
$ 17.35 |
|
|
|
|
$/SALE |
$ 100.74 |
$ 24.23 |
|
|
|
|
TOTAL $ |
$ 11,719.14 |
|
The results
So after spending $11k in one month on a PPC marketing campaign across Google, and Yahoo we could be pretty scared at the result especially after seeing the most we spent to get a sale was $100 and the average cost of a product sold is $99!
But our stats tell us exactly how we went, we spent $11k, but our gross profits were $34k. The most we paid for a sale was $100, but all in all we sold $76k worth of products, I’m sure when you talk to lots of these PPC marketing companies they’ll tell you that the campaign was awesome and you make a 700% ROI, really your just being lied to and your lying to yourself if you think that, you need to base your facts on what counts and that’s your gross margins, our GM ROI was 300% pretty good still, after costs we made a healthy profit of $22k.
If I was a client of myself, my total costs would have been $15k, with a profit of closer to $18k, slightly less but don’t forget you just moved almost $80k of stock in a month, that’s sure to help your buying power to bring your margins down more and really, you still make $18k profit so why not go again? Oh and not forget you’ve also just increase your customer base and subscribers to your newsletter that also brings in heaps of revenue.




The registrar that picked it up was
recent comments