4 Ways to use Excel for AdWords Insights
?Download as PPTX, PDF?
6 likes?1,728 views
The document discusses various techniques for organizing and analyzing Google Ads data using pivot tables, counts, and the IF function. It provides step-by-step explanations for consolidating search term lists, identifying top performing keywords, and insights on costs and efforts. The techniques allow advertisers to better understand their account performance and make strategic optimizations.
4 Ways to use Excel for AdWords Insights
- 1. Susan Wenograd Twitter: @SusanEDub @SusanEDub #HeroConf 1
- 3. Heroic Act: Using Pivot Tables @SusanEDub #HeroConf 3
- 4. Here¡¯s where you find out @SusanEDub #HeroConf 4 Search term and total spend Search term and total spend Search term and total spend Search term and total spend Ad Groups term appeared in + spend Ad Groups term appeared in + spend Ad Groups term appeared in + spend Ad Groups term appeared in + spend
- 5. Here¡¯s how you get it @SusanEDub #HeroConf 5
- 6. We¡¯re on our way¡ @SusanEDub #HeroConf 6
- 7. Whoa. Lots of stuff. @SusanEDub #HeroConf 7
- 8. Look at you, all organized. @SusanEDub #HeroConf 8
- 9. Heroic Act: Using ¡°Count¡± @SusanEDub #HeroConf 9
- 10. Ad quantity by Ad Group @SusanEDub #HeroConf 10
- 11. Oops. Time to write some ads. @SusanEDub #HeroConf 11
- 12. Keyword volume by Ad Group @SusanEDub #HeroConf 12 (The agency was terminated.)
- 13. Heroic Act: Using ¡°If¡± @SusanEDub #HeroConf 13
- 14. Paid & Organic Report @SusanEDub #HeroConf 14
- 15. What it looks like @SusanEDub #HeroConf 15
- 16. Time to do some replacing @SusanEDub #HeroConf 16 Delete ¡°Ad Shown Only¡± instances Add a new column: ¡°Organic Stronger¡±
- 17. Using the ¡°If¡± Function Admission: Horrible memory for formatting formulas correctly @SusanEDub #HeroConf 17
- 18. Now it looks like this @SusanEDub #HeroConf 18
- 19. Insights: Cost Comfort @SusanEDub #HeroConf 19
- 20. Insights: Effort Focus @SusanEDub #HeroConf 20
- 21. You¡¯re a hero to clients & SEOs alike @SusanEDub #HeroConf 21
- 22. Heroic Act: Using Text to Columns & Removing Duplicates @SusanEDub #HeroConf 22
- 23. Sweep the leg(s), Johnny. @SusanEDub #HeroConf 23 1. Negative keyword patterns 1. Content cues
- 24. Text-to-wha? Export search terms. @SusanEDub #HeroConf 24
- 25. Go through the prompts ¡°Delimited¡± @SusanEDub #HeroConf 25 ¡°Space¡±
- 26. It looks worse before it looks better¡ @SusanEDub #HeroConf 26
- 27. Consolidate terms to one column ? ¡°Remove Duplicates¡± on each column ? Copy keywords in each column to bottom of Column A. @SusanEDub #HeroConf 27
- 28. You¡¯ll have one list of Keywords now @SusanEDub #HeroConf 28
- 29. One list, many insights @SusanEDub #HeroConf 29 Negative keyword Hmm. Consumers care about the material¡ad copy & keyword additions! Ad Group idea & on-site content idea win! Ad Group for B2C Campaign, negative keyword for this Ad Group
- 30. Closing Advice @SusanEDub #HeroConf 30 Thank You!