Amazon PPC Product Launch Conversion rates using Product Opportunity Explorer

hi guys and welcome to another video on Amazonia YouTube channel so in one of my previous videos I've shared how to estimate the budget for your PPC product launch or for a relaunch for certain keywords there was a part in this fancy calculator calculator sorry where you had to estimate your conversion rate in the past now that has changed because now we can use product opportunity Explorer but you can see exactly your conversion rate per search term and I'm going to show you step by step how to do just that so let's navigate to product opportunity Explorer and for this example I use the keyword weighted jump rope just make sure to uh call sorry to select proper Marketplace here so because you cannot go back and change your Marketplace once you start to to dig into the into the data so I've choose United States or whatever your Marketplace is so once you type that and hit search you will be presented with Niche details with a lot of useful information but I'm going to stick just to the topic right now and feel free to explore the product opportunity explore on your own so down there you will notice the tabs on the top so product search terms Insight strands customer review insights returns really really useful information go there and and explore how you're standing against your competition so when you when you find your top click products for your Niche what you want to do is go go ahead and hit download button and have that Excel sheet uh somewhere you're going to see something like this just the basic Excel sheet we're going to get to that later next step is go to the Search terms and do the same download to your Excel file so you can find it later on just a little bit about what you're going to see here these are the main top uh 20 something products yeah I think top 25 five products but the point is not uh top 20 products but top 20 products for this Niche that are getting most of the clicks that's why the data is so relevant so there are bunch of other competition but these are the products that are getting majority of Clicks in sales for this Niche same goes for the Search terms there are only 17 shown but these 17 are grabbing majority of sales so as you can imagine there are a bunch of other Search terms over there but they are having like all the others are 50% and these guys over here are the majority um so once you downloaded the product app and search sorry for my voice I'm I'm a little bit under the the the weather so products and Search terms so for when you download the first one from from the product what what you want to do you want to go let's zoom in a bit you want to go into the niche click count for the past year this is data for the whole year past 360 days and what you want to do you want to summarize uh this number and remember it so it's not remember let's copy it so and then let's copy that to another tab in um the other sheet that you downloaded so what we want to do here is calculate how many clicks each of these Search terms got in the last 360 days we can do that because we have Click Share from the report uh we downloaded you can find that uh you can learn more about each of these columns by clicking here on theand it's it's going to open a new tab and search volume and get to to familiar familiarize yourself with what you're seeing here so to discover the exact uh where was it yeah so to find the exact uh clicks for each search term you want to do the equation so remember we have total clicks and this is the in percentages when you download uh the file it automatically converts the percentages to the decimal number so what you want to do here is this is going to let's call it um total clicks per search term for example let's let's bold it and you want to calculate that like total number of clicks that happen in an N times the percentage so immediately you see that this weighted jump probe search term got 93,000 of clicks so majority as you can see by the by the percentage here and then we want to apply the formula all the way through the end just we want to make sure that this number D2 is fixed so you do that by adding dollar sign here so we don't mess up our formulas okay now this is correct and let's round it up to a nice looking number so now we have total clicks per search term what we want to uh do next is that we have search volume in the past 360 days and we have search conversion rate please not that's not the actual conversion r that we're F trying to find but that's the actual how many of those search volumes out of the search volume how many of those ended up having a conversion so so let's call that a p purchases yeah I spelled that correctly per search term and we want to calculate that search volume times the percentage and then we want to apply that range all the way down down and also let's round it up a bit yeah now we have purchases per Search terms now we have clicks we have purchases so the only thing left is that we calculate the conversion rate so that's going to be number of purchases divided by the total number of clicks let's present that as a percentage with a few decimal parts and there you go conversion rates per search term then see that so now in the past we had this calculator that I share with you I'm going to link link it in the comments below so in the past uh sorry this is we don't need that so in the past we had to estimate the conversion rate in order to calculate the CPA so there are few things a few points where you can gather that but now we have even better results with this calculation from product opportunity Explorer now what I would do normally to estimate the budget for a product launch I would go to these um search terms and for example I typically what we do is that if you want to be an aggressive on a product launch you want to select um three or four or five keywords that you want to rank for organically as as as high as you can so being an aggressive product launch and because these are the most important keyword it's going to be very expensive but you can also decide to go a mildly mildly aggressive like select only the mid ones or lower ones depending on your budget or you can maybe just select these and do not create several um sorry choose more keywords but beit less aggressively on those so I don't want to go through all the steps in that file because you can go back to my previous video but the only difference here is now this part so conversion rates you can now have the correct conversion uh conversion rate so these are on the average what uh the search term is for each of the so what the conversion rate is for each of the Search terms so it averages around what's the average 10.91 so we can call that 11 so you can see that once you have your Amazon suggested bits let's say whatever they are then you can see that that average CPC is going to be for the Amazon suggested bit 2.38 and the average conversion 8 is 11% which means you on on average you will need nine clicks to land the sale and you will have a cost per acquisition cost per sale roughly $21 that brings you to exact number how many sales you need per day in order to rank on top half of the page now for the top half the page I've referenced that in my previous video but for for for uh helium 10 number you will get top half of the page but if you use data R numbers you will have exact numbers for top three product top three places data R is useful but unfortunately it's only for for US market unless they change it okay now they they updated they added German and and the UK one in beta so check that out so here what we want to do for example I have selected only the top four now from hel 10 weighted jump rope weighted jump rope for men jump Pro for women and jump Pro weighted so once you have that keyword those keywords I go to the this comma separator to very useful tool and I select here select the delimer and I have the all the keywords ready for data R by default it's it's sorted by related but for this specific tax uh task you want to go to the exact match paste your keyword and hit get keywords please not that day TOA data is updated only monthly so now we are mid January but still we have only December data in February 1st you will get the January data so please know that for December numbers can be a little bit inflated because of the shopping season but nevertheless this is the process you will have to follow whenever you search for keywords in dataa you will have additional information here and this is the number that we are interested so daily sales to rank as they say it shows the estimated number of daily sales that need to be sold for an Asin after a search for the keyword is made for it to rank in the top three for that keyword so this number is much higher than what you're going to see in helium 10 it doesn't mean that helium 10 is not precise it really is but helium 10 is giving you the number of of how many sales over the period of 8 days to get in top 15 or uh sorry top 16 positions while here the data Rover gives you the numbers for top three so 10 8 three and one so just we need to make sure that the the order is correct here yeah so 10 8 3 and 1 so here you can immediately see the the difference uh okay sorry why I haven't added for the from helon 10 data um bits Max suggested bit from Helium 10 would be here and helium 10 CPR numbers be will be these guys okay now we have the cor all the data for helium 10 if you use helium 10 for this task or you if you use dataa immediately you can see that it's almost a double from what you see helium 10 to what you see in data R so only for these four keywords that we selected you will have we can paste them here okay so for these key four keywords you will have to spend on the daily basis 535 to get to that top positions only if you have your listings s out your conversion rate optimize your listing for conversion rate um so there you here you go in the past it was about estimation but now you can easily see the expected conversion rate for search term and plan your budget according this is very important for you guys who are do it yourself first uh for PPC and for you guys who are managing other accounts this is very useful for example when uh a brand owner approaches you and says hey I want to rank for this for these keywords and and this is the budget you can immediately run your calculation here through this file and see that for example if their monthly budget is to spend $5,000 on all the campaigns and you see that in order to accomplish that task that they're asking you you need like 300 500 a day so immediately you can provide meaningful reply to them and say hey this is what I've calculated and this is the budget that you can expect to uh get that those results are you ready to invest that money to get that to those positions or is it too much and if if it's too much then you can adjust strategy together because it's a it's it's meaningful data so they they they can make an informed decision about it um I'm going to link the file I'm going to ask you to test it out I think I Sol there there were a few issues over there but I think I saw them also let me know if that works for you and see you in the next video guys bye-bye