With just a few Excel techniques you can master in an hour or two, you can save literally hundreds of hours in AdWords. Watch the free videos below to see how 
(You should also Download the Excel Sheet from the Videos Here so you have the formulas and examples to work with on your own computer, and a higher quality screen to look at!)
PART 1
PART 2
PART 3
PART 4
PART 5
{ 8 comments… read them below or add one }
Wow! Thanks so much for the awesome tips on using excel for your adwords campains. Thanks you Rob for your clear explanations, and Glenn for allowing us to watch them. You guys are great.
Tracy
Going to check this out. Thanks for the great information.
thanks Glenn and Rob
I\’ve always wanted to learn about Vlookup Tables, but never did, till now!
thanks
This is truly a unique way of developing targeted keyword phrases Glenn.
Thanks for showing this and offering the excel file to better follow the video AND see the formula coding first hand.
This matrix really opens the door to possibilities, thanks for your knowledge.
David
Very nice, slick, and handy tool with applications beyond adwords. Glen, many thanks for making it available… and Rob, thanks for sharing it. And even better having the videos to refer back to. Cool!
Great Tips Glenn. I learnt about using concatenate for adwords from a fortune 500. I also use the LEN query to dynamically create the ad copy for hundreds of ad groups. (e.g. so if the length of the actual general keyword or ad group is under 25 characters, or whatever, I use that in the dynamic keyword insertion, or remove keyword insertion altogether. If it’s longer, I’d use a more generic keyword.)
I had never used VLOOKUP before, and that’s a very cool feature. The idea of using it to filter out analytics seo keywords that were already in adwords was also pretty cool. Way to go!
Hey Glenn,
I know this is an older post, but wanted to thank you for keeping it.
Your content is always valuable, and I’m glad you provide it for us.
I actually landed a contract to do some PPC and they wanted to cover
multiple areas, and because I knew about this method, I impressed them
enough to get it, and Im sure will continue with them from methods
Im also learning from your Hyper Responsive Club.
So thanks to you Im building up my skills.
Thanks Doc.
Great info guys. Excel really is a great AdWords tool, but I had not used the Vlookup query before so thank you!