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

🏫 - PPC, SEO, Design, Catalog courses for $10-20

❓ Do you want to grow your Amazon sales or solve a problem? Go to and get help

My Amazon Guy Podcast and Videos:


Other Social Media links:

✅Get 50% off First Month with Helium 10

✅ Order a Trademark from My Amazon Guy for $825 and get your brand registry on Amazon in under 7 days. Order here:

✅ A+ Enhanced Brand Content

✅ Beginner Tutorial Playlist:

✅ Coaching on Demand (Same day Appointments Available):

#amazonselling #amazonseller #amazonfba #myamazonguy

🎤My Podcast Setup:
Rode NT1KIT Cardioid Condenser Microphone
Rode Swivel Mount:
RODECaster Pro Podcast Production Studio
Sony Alpha a6400 Camera
Sigma 16mm Sony E Lens

Support the show