How To Use Pivot Tables For PPC Marketing (Google Ads/AdWords)

EXCEL FOR PPC ONLINE COURSE

This video will show you how to use pivot tables for PPC, specifically Google Ads (AdWords).

Pivot tables can be a great way to analyse large sets of PPC data and make sense out of it. When you download raw data from Google Ads, then a pivot table and by extension, a pivot chart will allow you to visualize the data and spot trends.

Many marketers think pivot tables are scary, but they don't have to be. Get started and have fun playing with datasets to visualize the data you need.

It can be great to use pivot tables for client and stakeholder engagement to pull stats for campaign performance over time.

Pivot tables for PPC aren't scary, just get started!

If you liked this video, don’t forget to subscribe and follow me on Twitter & LinkedIn via the below.

[HimanshuShankaran]

Hey Darren, Thanks for the insight's on how excel can be used for google ads, i think there should be more tutorials such as this where we can learn more about how excel can be used for google ads.

[ALEXZILBER]

can you please create a lesson where you use the v-lookup function for the PPC routine? or analyze data with v-lookup

[komalvishwakarma]

Hey man, this was impressive....can you create one just like this for social media analytics...It would be a great help!!

[aaronortiz]

great tutorial! thank you for this info!

[birana]

WOW! So informative and clear. Deserves more views.

[NbaLiveever]

Thank you so much for this explanation and tutorial Darren! It def helped me understand how to use pivot tables for PPC.

[AndyBlackJnr]

Nice video. The Average CPC part doesn't seem right though. What happens if Campaign A has 1, 000 clicks and an average CPC of £1, and Campaign B has 1 click and an average CPC of £10? The average of those two CPCs is £5.50, but the average CPC across both campaigns is £1.01. I use a formula in the pivot-table that is something like =if(clicks<>0, cost/clicks, 0)

[ProgrammingNewbie]

Hey thanks for this, never used pivot tables before! But that was tops mate!

[angusmace]

Excellent tutorial, thanks mate. Would be really interested to hear some of your 'go-to' pivot tables reports that you pull monthly/quarterly for analysis or for showing clients during meetings.

[kuntamukkalapallavi]

Thank you so much Darren Taylor your videos are very helpful ❤️

[florinadicu]

This was really helpful thank you - can i ask if i want to update the raw data on a weekly or monthly basis, how would i import the updated raw data without messing the pivot tables up?

[puabible]

I think it could be returning a wrong answer when we sum up individual cpcs and directly take average?

A right way to do it should be sum of cost/ sum of clicks?

[anjabrox]

amazing.... I was looking for that thanks :)