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