One of the things I do a lot of is manage PPC spend. There are a lot of ways to manage PPC, and everyone has their own little tricks and tools they like. But, overall, PPC is a numbers game--trying to find the most efficient use of client dollars to get the most valuable traffic flowing into a website. To do this, we look at a number of different metrics--bounce rates, conversion rates, CPC, total cost, etc. In fact, there are so many different metrics to look at, it can be difficult to know where to start!
Where I like to start is with Tableau and a month's worth of PPC keyword data. First, I export a keyword report from Google. Then I delete some junk in the spreadsheet, and plop it into tableau (well, actually, I point my pre-existing Tableau PPC workbook at the new spreadsheet) and instantly the new data populates the charts and dashboards with the current information.
Now, from here you can create all sorts of different views into the performance of your keywords. When I mean all sorts, I mean ALL SORTS. I've spent days and days creating new and ever more fancy iterations of keyword data only to reformat it all the next month and come up with something else. But over time, I've found that there are a couple of views that really help, and those are the ones I go back to every time. If you are trying to control costs, or look for ways to cut out fat, or are just looking for where to start, a great chart to create is a Click-Cost Scatter Chart. When you apply linear averaging and 95 Percentile reference lines, you get an instant view of which individual keywords are budget hogs and if that spend is justified. This is mostly useful for trimming back on costs by finding trouble spots and increasing efficiency, not for expanding campaigns.
