If you open the excel document attached, you'll notice there are 5 columns: queries, clicks, impressions, CTR (click through rate) and position for a fictional bike company called "example".
This is example data downloaded from Google Search Console about a fictional bike company called "Example". Google Search Console allows us to download data about our website to see how we are ranking for given search terms.
To explain the columns if you are not familiar; queries are the actual search term that has been typed into google, clicks are the amount of clicks we rank for for that search term, impressions are the amount of times we show up on Google for that search term, CTR stands for click through rate and is a percentage of clicks to impressions and position is the average position we rank for the query on Google.
I'd like to be be able to upload any list with the same 5 columns and have it automatically tell me the following:
Average click through rate for positions 1-20 for branded and non-branded queries. See image attached for table to make it more obvious.
In essence, a "branded" query is any query with the brand name in - so in this example any query with the term "example....." in.
A "non-branded" query would be anything else, like "mountain bike" for example.
At the moment when I have my list I do the following:
1) Apply a filter on the "position" to filter the range I want. In the first instance this would be filtering the positions to only show those from 1 to 1.9. I would then apply an additional filter on the queries to exclude the brand name, in this example the brand name is "example". I then average the CTR with these filters on. I then repeat this process for "branded queries" in positions 1 to 1.9 (so queries where "example" is written in the query).
2) I then repeat this for positions 2 to 2.9
3) I then repeat this for positions 3 to 3.9
etc etc all the way to 20.
As a bonus point, sometimes there are a few misspellings of the brand name. I'd like the sheet to cross reference a list of branded terms I've typed in and it lumps all of them together. For example, our brand "Example" might show up for "eaxmple", "exmple", etc. I'd like to scan down the list, see which are commonly misspelled but which are clearly intended to be a brand search term and also exclude these on the non-branded queries report.
Any questions let me know,
65 freelance font une offre moyenne de £105 pour ce travail
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (go Plus
Hello, I have the good knowledge of Excel Template. I have more than 5 years of experience in Data Entry, Data Processing, Excel. I have reviewed your job and can deliver you the job with 100% satisfaction. Please Plus
Hi, the idea is globally clear, but we need to discuss few point specially how you want to display thee filters and so on.. Can we have a short discussion please ? Thanks
Hello, You need a calculation of average click through rate for positions 1-20 for branded and non-branded queries. I've done it already. Please reply to my proposal so I could send a file. Thank you and Best regards Plus
Greetings! I have reviewed your requirements and can develop a macro to import the file with raw data, process the same as per specifications and calculate the Average click through rate. I can set up a table to spe Plus
Dear Sir/Madam I just went trough the project description and two attachments, and I'm happy to develop a perfect dynamic model for this purpose. Please refer my profile to see my qualifications, experience and relia Plus
"""I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed m Plus
ok I have seen all the files and very able to create excel template to cater your requirement. I am ready to start
I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Thousands of different tasks has been fulfilled from a simple daily routines with formulas Plus
Hi, I have checked the project details and attached file and I will develop this VBA macro button for you which will do all the listed tasks for you. It will also deal in importing new CSV file or any addition if re Plus
Available Right now to start | Quick turn around | Excel Expert (VBA Macros) Hi, I am computer science graduate with more than 3 years of experience in Excel VBA Programming. I have understood your task that you do ma Plus
ame 5 columns and have it automatically tell me the following: Average click through rate for positions 1-20 for branded and non-branded queries. See image attached for table to make it more obvious. In essence, Plus
**** TOP RATED PERSON. GIVE ME 1 CHANCE TO AMAZE YOU **** I am SANJAY to Turn your Dreams into Reality. I have a Good command on English which gives me better option to understand your work easily. I am expert Plus
Hi there, Data entry is not always as simple as it seems, it requires attention to details and quality which I guarantee. I have 5+ year of experience of IT industry & have lots of knowledge experience about Data E Plus
i have good command over Ms excel especially pivot table, charts, advance formulas, formatting, macro and analysis as well, Please contact with me for more [login to view URL]
Hi, Price and duration is negotiable. I am expert in Excel having 12 Yrs Professional experience. I’ll complete task with 100% Accuracy and in least possible time. I assure you, you will be another 100% satis Plus
Hi, I can create a template file where you can upload any csv file in the format that you provided by pressing one button and with automatic calculation of your results. I will be glad to help you with your project Plus
Hello I would be able to help with your issue. I have over 10 years experience with excel and vba so I am very comfortable with the formulae required for this task. My thoughts are to make a macro to deal with the mis Plus
Hello I am ready right now for data entry. When I go through details of your project I thought that here is the right person to serve you by doing your project well in time with cent percent accuracy. As a loyal p Plus