How To Use Amazon’s Search Query Performance Report To Increase Sales! (pro tips)

[@iusmanasif]

Massive thing for Amazonian. Please share the webinar link which you discussed on timeStamp 07:13

[@xkwisitlady]

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!

[@walkchill9920]

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

[@joeyzshopping]

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.

[@sellerfuel]

I have the same question. I downloaded the template for SUPA 2.0 and 4.0 not sure which one is the latest.

[@sulemankamran4326]

@@sellerfuel can you share template with me i didnt get yet

[@muhammaddaniyalahmed8871]

Definitely an amazing sheet for our PPC arsenal 💯🔥

[@sulemankamran4326]

if you have sheet can you share with me

[@DeanChristener]

Great video, could you please send the links on how to use this report as you mention in 07:12. Thanks in advance

[@mansournorouzi4535]

Hi Dean, we will have a webinar on this soon.

[@YushaKhan-c6c]

Please share the Webinar and SUPA V2 Thanks!

[@ClaraFerschen]

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.

[@komkom9828]

Thanks for the details. I am newbie here. How do you use this report to boost impressions, clicks and conversion sales ?

[@dominicwhitehand7360]

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?

[@mansour.norouzi]

Is this the US data? if yes, it should work. Please follow the exact steps. Haven't see this happen for anyone

[@dominicwhitehand7360]

@@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?

[@harchandmeghwar]

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?

[@philipme2073]

Fixed first issue. Now when I reconnect it has two fields that say invalid BA conversion field for 2 fields

[@Maria-mh9jp]

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.

[@andresallsalu5170]

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?

[@MariaMarketera]

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.

[@jurchavezAdvenJur]

Thank you! I think I'm going to use this tool and I would definitely gonna subscribe!

[@winnie_pook]

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?

[@MaxMironov-u8y]

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.

[@MuhammadHamza-g2j]

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.

[@mansournorouzi4535]

I would suggest tracking the top sellers variation/variations instead of all. Since this is manual, not easy to track all

[@AfzaalAltaf-e9r]

Did you found fix of delta sheet?

[@user-xo1ow5to2n]

Super! Quick question - if we have say 50 ASINs, we have to download the ASIN view for each of the 50 PER WEEK?

[@WeezyZZ]

What if i after one/two weeks i want to add another new one week?

[@sml0514]

Great info! I'm struggling to make a copy of the supa document. Can you please help?

[@1gramaticu]

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

[@mansour.norouzi]

Just your ASIN

[@vineetmahajan2231]

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.

[@mansour.norouzi]

Hey, just enter the new report

[@vineetmahajan2231]

​@@mansour.norouzi It worked. Thanks

[@mittalpatel2841]

Can you share the SUPA template?

[@jaione3705]

Hola! Soy de España, ¿como podria ver tu video con subtitulos en español? Gracias de antemano!! Un saludo!

[@VasylKrychkovskyi]

templatet doesn't work - I did everything as before but it doesn't update the data at all - please fix it

[@ShujaRizvi-t6q]

i have tried several times, when making copy of data studio template nothing happens ??

[@oculy-sales3514]

Great job as always Mansour! why didn't you download quarteley data instead weekly? whats the difference?

[@abelhenok1388]

Thanks for sharing this information! Would you mind sending me the webinar for detailed information on how to use this?

[@zhujohnny887]

I use Excel, does the google sheet compatible with EXCEL?

[@riazjaved7307]

Does this work only with gmail accounts?

[@Talhaa27-q4p]

so can in top search term we need to put same of amount of week data as SQP and ASIN View?

[@mansour.norouzi]

You could do for all weeks. Or just one week. Up to you

[@hassamtajamal1775]

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?

[@mansournorouzi4535]

I will update the macro soon to take this into account. regarding US and UK, I would suggest to have 2 separate files

[@RomuloNegrilloJr]

Does it comes with an API for the search query performance?

[@mansour.norouzi]

It is not there. I. hope Amazon adds it soon

[@KimPiosecka]

What should I do if I have over 200 ASINS? I cant download all of this information manually

[@maurineramos7994]

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!

[@mansournorouzi4535]

Oh great catch. Yes that could be an issue since the macro read the headers

[@pythonoptic]

can you run this for us?

[@hughmaffett6771]

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!

[@mansournorouzi4535]

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

[@oculy-sales3514]

Configuration Configuration changed! you might have to update your REPORT sheet

[@TeodorAmzn]

In some of the Pink columns it shows #NUM!. How can I solve this problem?

[@mansournorouzi4535]

It means the previous period had no data

[@Yorlasty]

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?

[@hassamtajamal1775]

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

[@Yorlasty]

@@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 :)

[@mansournorouzi4535]

@@Yorlasty I will come up with a change in macro in next week or so and share it with you

[@marcocasalini1454]

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?

[@mansournorouzi4535]

enter the data one period at a time and then process the data. Let me know if you still see problems

[@marcocasalini1454]

@@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?

[@mansournorouzi4535]

@@marcocasalini1454 can you send the headers of your report? We are transitioning the data based on headers. Maybe they are different

[@lessiwek]

@@mansournorouzi4535 I think the headers in Europe are a bit different and this will not work correctly

[@abhilyarthhandicraftpvtltd9799]

how to use this report for increasing sales

[@kkabc1886]

Amazing

[@joeyzshopping]

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?

[@mansour.norouzi]

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

[@joeyzshopping]

@@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.