.jpg)
My Amazon Guy
About My Amazon Guy: 1.2-billion managed on Amazon, My Amazon Guy is A 400+ client full service Amazon Agency in Atlanta, Georgia. We grow market share through traffic and conversion improvements. PPC, SEO, CTR, Design, Catalog Merchandising. My Amazon Guy gives away all their trade secrets with more than 2200 video tutorials on YouTube.
Follow us on LinkedIn: https://linkedin.com/company/my-amazon-guy
Subscribe on our YouTube Channel: https://youtube.com/@myamazonguy
My Amazon Guy
PPC Pivot Table Search Term Hack
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