My Amazon Guy

PPC Pivot Table Search Term Hack

June 20, 2022
My Amazon Guy
PPC Pivot Table Search Term Hack
Show Notes

How to Consolidate ALL of your Search Term Data into a single Pivot Table

00:00 PPC Pivot Table Search Term Hack
00:42 The Ads dashboard
01:38 All reports should have the same format
02:20 Opening up Excel
04:01 Creating connections
06:08 Get data
06:16 Combine craze and append
06:57 Power Query editor
08:13 Creating a pivot table
08:55 Selecting match type
09:26 Customer search terms
11:30 Average ACOS
12:30 Combining search terms together

🏫 mag-school.com - PPC, SEO, Design, Catalog courses for $10-20

âť“ Do you want to grow your Amazon sales or solve a problem? Go to www.myamazonguy.com and get help

My Amazon Guy Podcast and Videos: 
Podcast.MyAmazonGuy.com
YouTube.com/MyAmazonGuy

Website: MyAmazonGuy.com

Other Social Media links:
https://www.facebook.com/myamazonguys/
https://www.linkedin.com/company/my-amazon-guy
https://twitter.com/myamazonguy

âś…Get 50% off First Month with Helium 10 
https://bit.ly/3z1sijm

âś… Order a Trademark from My Amazon Guy for $825 and get your brand registry on Amazon in under 7 days. Order here: https://myamazonguy.com/trademark-services/

âś… A+ Enhanced Brand Content https://myamazonguy.com/amazon-enhanced-brand-a-plus-content/

âś… Beginner Tutorial Playlist: https://www.youtube.com/playlist?list=PLDkvNlz8yl_bC5ERcdJm9mu_MLSTyl3e_

âś… Coaching on Demand (Same day Appointments Available): https://myamazonguy.com/book-a-coaching-call/

#amazonselling #amazonseller #amazonfba #myamazonguy

🎤My Podcast Setup:
Rode NT1KIT Cardioid Condenser Microphone https://amzn.to/39aCRWb
Rode Swivel Mount: https://amzn.to/31daD8T
RODECaster Pro Podcast Production Studio https://amzn.to/3cghWCM
Sony Alpha a6400 Camera https://amzn.to/31bTFYi
Sigma 16mm Sony E Lens https://amzn.to/3lQxAZ0

Support the show