How To Use Amazon’s Search Query Performance Report To Increase Sales! (pro tips)
Вставка
- Опубліковано 28 вер 2024
- Download the SUPA template here: incrementumdig...
Mansour Norouzi director of Amazon Advertising at Incrementum Digital shares a step by step walkthrough of how to best utilize Amazon's Search Query Performance Analyzer report to improve your PPC advertising for your Amazon FBA products. Search Query Performance is one of Amazon's best features recently released. It has many use cases for brands, Amazon sellers and marketers. SUPA template can help you speed up the process of extracting and analyzing Search Query Performance data.
➤ ➤ SUBSCRIBE FOR MORE AMAZON CONTENT
bit.ly/Increme...
Watch these other videos about SUPA template:
• How to Use SUPA V3.0 (...
• How to Use SUPA V4.0 (...
// GET IN TOUCH
bit.ly/Increme...
// JOIN US ON LINKEDIN
bit.ly/IDLinkedin
// SUBSCRIBE TO OUR NEWSLETTER
bit.ly/Increme...
// SUBSCRIBE TO LIRAN’S PODCAST
apple.co/3Nixo1r
0:00 intro
Incrementum Digital is the growth engine to your brand on Amazon. We drive better business outcomes for your Amazon brand with a proven approach to digital marketing, PPC management, creative services, and customer experience, powered by technology and the smartest marketing minds around the globe.
Partnering with our team is like growing an entire e-commerce business overnight. Focus on important areas of your organization by having a certified team of over 100 dedicated Amazon experts leveraging the best strategies, latest data, and technologies to surge your business to new heights.
Here are some of our growth engine solutions:
➤ Amazon Advertising Management (Amazon PPC, DSP, Google)
➤ Account Management, Seller Central Operations
➤ Amazon Account Auditing (Listing Monitoring, Reimbursements, etc.)
➤ Creative Services (Video, Images, Copywriting, etc.)
➤ Influencer Campaign Management
GET STARTED NOW: bit.ly/Increme...
This is an amazing tool - thanks for sharing! Are the seminars you mentioned (about the 7 min mark) about use cases for the SQP data still available? Thanks!
Definitely an amazing sheet for our PPC arsenal 💯🔥
Massive thing for Amazonian. Please share the webinar link which you discussed on timeStamp 07:13
Hi, first of all. Thank you so much for a very helpful video. You earned a subscriber. I just have an issue though, during the Top Search Terms Processing, I am getting an error of "Exceeding Maximum Execution Time". Please help on how to fix this.
Thanks for the details. I am newbie here. How do you use this report to boost impressions, clicks and conversion sales ?
Can you share the SUPA template?
templatet doesn't work - I did everything as before but it doesn't update the data at all - please fix it
Hello. Since there have been some changes to the Brand Analytics Report (for example it now says "basket" instead of "cart". Would it be possible for you to update this tool? This would be very much appreciated! Thank you.
Hi Mansour, this looks great. My Brand import processes fine but when I try to import/process the ASIN I get an error of "Exception: Range not found"? The range data looks exactly the same as the Brand data, so I am not sure why it is not accepting it from my ASIN Weekly Simple Reports?
Is this the US data? if yes, it should work. Please follow the exact steps. Haven't see this happen for anyone
@@mansour.norouzi Hi Mansour - yes, it's US data. I followed the steps exactly and even repeated them, and for the ASIN reports it still comes up with the same error?
Super! Quick question - if we have say 50 ASINs, we have to download the ASIN view for each of the 50 PER WEEK?
Great job as always Mansour! why didn't you download quarteley data instead weekly? whats the difference?
Does this work only with gmail accounts?
Hello. Could please advice me on how to upload a new week to this? You didn't explain it. I tried to do the same thing with the docs again but the new week didn't show up. Thank you for very much.
i have tried several times, when making copy of data studio template nothing happens ??
Thanks for sharing this information! Would you mind sending me the webinar for detailed information on how to use this?
Great info! I'm struggling to make a copy of the supa document. Can you please help?
Do we have to enter "Top Search Terms Input" every time we add new data or is this suppose to be one time thing in the beginning?
I use Excel, does the google sheet compatible with EXCEL?
Did you found fix of delta sheet?
HI Mansour, thanks for the amazing report. I had a question regarding updating the report on a weekly basis? Do you need to create a new report or just enter new week data and refresh data? I have done so, but it does not update.
Hey, just enter the new report
@@mansour.norouzi It worked. Thanks
Hola! Soy de España, ¿como podria ver tu video con subtitulos en español? Gracias de antemano!! Un saludo!
Configuration
Configuration changed! you might have to update your REPORT sheet
Thanks for providing this template! Is there a maximum number of uploads I can add? I tried to upload weekly reports for the year to date and had an error after about 13 brand uploads. Thanks!
The upload limit would be as long as Sheets lets you upload. How did you download the data before Sep 2022? Amazon doesn't provide download before that
This is cool stuff, thanks as always! I have an issue importing brand and ASIN data in the Google Sheet. When I import them and process through the script as you showed, in Brand and ASIN Processed Tab it shows only the Brand Name and the ASIN (respectively) but not all the other data. Am I doing something wrong?
enter the data one period at a time and then process the data. Let me know if you still see problems
@@mansournorouzi4535 Yeah I've done the same as you did, import one and process one, but it gives me this issue... my reports are in Italian, is language something that can mess up the processing of the data?
@@marcocasalini1454 can you send the headers of your report? We are transitioning the data based on headers. Maybe they are different
@@mansournorouzi4535 I think the headers in Europe are a bit different and this will not work correctly
Great Video, thanks. When I import Data to the Tab Top Searchterms-Input, and try to process it, I receive this error message: "TypeError: Cannot read properties of undefined (reading 'toString')Details"
How can I solve this?
thanks
I see videos for SUPA 2.0, 3.0, 4.0, which is the latest? Also where can we see how to use and leverage this data? It looks nice in these charts but I am unsure how to apply these data points.
I have the same question. I downloaded the template for SUPA 2.0 and 4.0 not sure which one is the latest.
when I run the script, the system does not process it and the browser asks me "close the page or wait" 20 minutes of waiting did not bring anything, what should I do?
can you run this for us?
Great Tool.
I'm curious how you track and get data for variation listings because SQP doesn't pull data for Parent ASIN, so what's the best approach to keep track of and obtain data for variations in SQP and Top Search Terms (Brand Analytics)? I'd appreciate your thoughts.
I would suggest tracking the top sellers variation/variations instead of all. Since this is manual, not easy to track all
Hi Mansour, thanks for creating this. Can you please tell me in the ASIN section in seller central, do I have to enter all my ASINs from the brand or can I enter competitors ASINs aswell? Thank you
Just your ASIN
Great video, could you please send the links on how to use this report as you mention in 07:12. Thanks in advance
Hi Dean, we will have a webinar on this soon.
Thank you! I think I'm going to use this tool and I would definitely gonna subscribe!
What happens is I dont upload them in order / if I want to add more (older) dates after already uploading the more recent ones? Thank you so much for this gold btw.
Thank you for sharing. I want to ask if can we add an option for a custom filter on Delta - Latest Period to Previous and Max to sort by brand purchase?
What should I do if I have over 200 ASINS? I cant download all of this information manually
Fixed first issue. Now when I reconnect it has two fields that say invalid BA conversion field for 2 fields
What if i after one/two weeks i want to add another new one week?
how to use this report for increasing sales
Hi Mansour, thanks for this! Just wanted to ask about a possible workaround when the Top Search terms input can't be mapped with the ASIN and Brand Processed? It keeps on returning empty fields despite ensuring that we have the same date range on the reports. Thanks!
Edited: Just tried changing the Top Search Term headers from "No. 1" to "# 1" and it now works perfectly. Hope this helps!
Oh great catch. Yes that could be an issue since the macro read the headers
Thanks for this. I have a couple of questions:
1) The headers in EU are different how do we manage that?
2) I have same ASINs under same brand name in US and UK using global selling. How do we incorporate that because brand name and asin is same. How do i differentiate the UK and US data?
I will update the macro soon to take this into account.
regarding US and UK, I would suggest to have 2 separate files
Amazing
so can in top search term we need to put same of amount of week data as SQP and ASIN View?
You could do for all weeks. Or just one week.
Up to you
In some of the Pink columns it shows #NUM!. How can I solve this problem?
It means the previous period had no data
Does it comes with an API for the search query performance?
It is not there. I. hope Amazon adds it soon
Great job as always Mansour! There is an issue with European SQP - Cart is called Basket so it doesn't pick up Cart data. Any quick fixed apart from renaming the headers on each SQP file?
I just did a quick fix. Just copy the headers from a US version SQP file and paste it in the EU version SQP file. :D
@@hassamtajamal1775 Yeah that's what we did (renaming heads on the files) but doing that across 30 odd files was wasted time so hoping Mansour can fix the issue for others :)
@@Yorlasty I will come up with a change in macro in next week or so and share it with you
So After adding like 12 - 24 weeks the sheet slows down where when I try running a script, the sheet freezes. The data gets processed, but the "Brand Input" tab doesn't clear. Anyone else? @incrementumdigital any insight?
Unfortunately the Google Sheet has some limitations and could get slow with so much data. What error do you see when it doesn't clear? Also you could clear it manually
@@mansour.norouzi I'm not getting an error. it just freezes up for about 15 minutes. Then the script runs about 50% of the time it freezes up.