ClickEquations Blog

Suppose you had to quickly reduce your PPC spend. Where would you cut?

One very helpful analysis is rank your campaigns (or better yet AdGroups) by ROI. This tells you where you’re getting more return-per-dollar, and where you’re getting less.

To simplify this analysis we built a ClickEquations Analyst Report, which runs in Microsoft Excel. To use it you define three thresholds – a high ROI that you desire, a low ROI that you detest, and a medium ROI that is minimally acceptable.

With a single mouse click you can then find out what number of your campaigns and what percentage of your spend and revenue fall into each of these bands. On the next tab in the worksheet you can find out exactly which campaigns fell into each group.

In the example above, we look at how ROI falls into four clusters and two charts visualize the spend and difference between spend and revenue.

Armed with this visual, most people are encouraged to look inside the campaigns – probably first by running the Ad-Group version of this report – and find ways to fix the losers or kill the problematic groups or keywords.

But you can’t drive to those actions and decisions without information. This report is a good example of how ClickEquations Analyst can help you to understand the performance of your accounts, and make good decisions about how to prioritize your PPC efforts.

You can begin your use of ClickEquations with a 30-day free trial. Sign up here.

Related posts:

1. Paid Search Data Sources Data drives paid search. We pay for...
2. Need Help Shopping for a Paid Search Platform? A lot of people who come to...
3. Rethinking Paid Search Two years ago we took a deep...
4. Paid Search Clarity – Part I Yesterday I noted that paid search managers...
5. Paid Search Pros Video: Avinash’s Favorite PPC Analytics Tips It’s a sad truth, but “most dashboards...
6. ClickEquations Paid Search Platform – The Feb ’09 Release A few months ago when we first...
7. The First Step To Better Paid Search Campaigns What one piece of advice would I...