Clicky

X

Subscribe to our newsletter

Get the State of Digital Newsletter
Join an elite group of marketers receiving the best content in their mailbox
* = required field
Daily Updates

An Introduction to Pivot Tables for PPC Analysis

12 March 2014 BY

80 Flares Twitter 45 Facebook 3 Google+ 14 LinkedIn 15 Buffer 3 Email -- StumbleUpon 0 Pin It Share 0 Filament.io 80 Flares ×

pivot-dataAs a recent convert to pivot tables for analysis of your PPC Account and the fact that it has been the most requested guide after the training course at Biddable World, I thought I’d write a post to explain what they are, how they work and how to use them to analyse your PPC Data.

I will happily admit that when things get a bit ‘too maths’ I run to the hills (or start crying), but stick with me and I assure you that you’ll get the hang of pivot tables in no time!

What are Pivot Tables?

According to Wikipedia,  a Pivot Table is as follows:

what-is-a-pivot-table

Still with me? Great!

Take a deep breath, and let’s extract some data from our Adwords account and manipulate it in excel to help us optimise our spend.

What you’ll need?

  • Data from your PPC Account
  • A copy of Excel
  • This post open next to your excel spreadsheet :-)

Pivot Table to Analyse Quality Score

There is no point in re-making something that is already a great resource so if you haven’t already done so, check out this fantastic Brad Geddes video showing you how to look at ‘pockets of opportunity’, how to segment out relevant data, download, and manipulate data to help you gain insights using columns, filters and pivot tables.

The ‘Sweet Spot’ – finding the most profitable position

You don’t have to be in the top slot to get a decent return on investment. In some cases, being at the top can cause too many impressions and still not enough clicks so could also damage your CTR and your overall quality score.

So if you want to save some money or make a case for spending more – the ‘Gerald B Watson Memorial Guide to finding the sweet spot’ video from Sean Quadlin at PPC Hero is a good place to start.

Other Great Pivot Table Resources

The most comprehensive guides to pivot tables that I have found are as follows:

Takeaways

There are unlimited amounts of data to crunch so start downloading and practise pivot tables every chance you get. Not only will it impress your boss (or your potential new boss!), it will help you get the most out of your PPC data with minimal effort. It certainly beats trawling through screens and screens at a glance, and the great news is, you do not have to re-make the pivot table each time – just replace the data and re run!

When you are using pivot table data – remember:

  • This is an analysis of data so keep things simple
  • Use different Segments of data to see the overall picture (eg weekly vs monthly)
  • Use filters in the Adwords Data download to get more precise analysis
  • Practice – it took me several goes before I could do it off by heart
  • Re-use the table – exchange data and re-run – so set up a table for every type of data you want to run in advance

If you don’t have any data but would like to figure out the tables - contact me and I will pass you a copy of dummy data that you can use to try crunching

AUTHORED BY:
h

Jackie Hole is an Award Winning Search Marketing consultant specialising in Paid Search, Conversion Improvement and Organic Search / SEO for the USA, Canada and European markets. Starting out in Multimedia & Interface Design, Jackie has over 15 years experience in online marketing and was recently awarded European Search Personality of the Year. Jackie is Company Director of 22M
  • http://www.clickminded.com/ Jennifer

    Thank you for your article! It’s a great explanation of pivot tables. I hope others who have just completed an seo training will also find it useful.

  • Steve

    One of the best kinds of PPC ads available today are Google’s remarketing display ads. What’s great about them is that you can segment them by behavior, so if people have been to your home page but not your sales page, you can direct them there. If people land on your shopping cart but don’t buy, you can run ads to send them back to the shopping cart and complete checkout. The power to segment is one of the most powerful advancements in marketing technology in the past century. I didn’t know this when I started but I called Simon (302-401-4478) and I got help. Now I make 22.37% more on my display advertising than I did before and I’ve been selling a lot more product.

80 Flares Twitter 45 Facebook 3 Google+ 14 LinkedIn 15 Buffer 3 Email -- StumbleUpon 0 Pin It Share 0 Filament.io 80 Flares ×

Nice job, you found it!

Now, go try out the 12th one:

Use Google Translate to bypass a paywall...

Ran into a page you can't read because it is blocked or paywalled? Here's a quick trick (doesn't always work, but often does!):

Type the page into Google translate (replace the example with the page you want):

http://translate.google.com/translate?sl=ja&tl=en&u=http://example.com/

How about that!?

Like this 12th trick? Tell others they need to look for this trick on our page: http://www.stateofdigital.com/search-hacks-marketers/

Or Tweet: Found the secret 12th one!