Closed

Excel Template

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,

Skills: Data Entry, Data Processing, Excel

See more: excel template service, excel template designer, excel template workers money, best excel templates, create excel templates, excel templates for business, excel inventory templates, project management excel templates, excel budget templates, excel database template download, excel spreadsheet templates for tracking, design excel template, excel template price part number configurator, importing xml excel template, excel template price list, bank statement excel template, quick books excel template, list excel template, excel template invoice freelance, quickbooks pro excel template

About the Employer:
( 1 review ) Brierley Hill, United Kingdom

Project ID: #17565585

65 freelancers are bidding on average £105 for this job

jaylancer43

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 More

£250 GBP in 3 days
(595 Reviews)
8.3
schoudhary1553

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 More

£200 GBP in 3 days
(270 Reviews)
7.6
bouslimi1979

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

£100 GBP in 3 days
(234 Reviews)
7.4
hdlong66

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 More

£20 GBP in 1 day
(141 Reviews)
6.9
ksriniravi

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 More

£80 GBP in 3 days
(148 Reviews)
6.6
priyal1997

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 More

£150 GBP in 2 days
(186 Reviews)
6.7
Tanmoy236

"""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 More

£120 GBP in 3 days
(146 Reviews)
6.4
sonarkaushik

ok I have seen all the files and very able to create excel template to cater your requirement. I am ready to start

£156 GBP in 3 days
(100 Reviews)
6.2
MohsanEijaz

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 More

£200 GBP in 3 days
(66 Reviews)
6.0
TechnoGuruu

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 More

£150 GBP in 3 days
(36 Reviews)
5.1
madnanayoub

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 More

£20 GBP in 3 days
(30 Reviews)
4.9
AlexandrUKR

please clarify possible next steps

£250 GBP in 10 days
(16 Reviews)
5.0
imteyazkhan85

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, More

£21 GBP in 3 days
(25 Reviews)
4.2
designer504

**** 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 More

£44 GBP in 0 days
(4 Reviews)
4.0
svsinfopro

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 More

£100 GBP in 3 days
(6 Reviews)
3.6
haleem0786

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]

£150 GBP in 3 days
(14 Reviews)
3.6
Mfaisalshahzad00

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 More

£200 GBP in 3 days
(14 Reviews)
3.5
afenache

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 More

£90 GBP in 1 day
(9 Reviews)
3.7
sdroberts

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 More

£111 GBP in 3 days
(3 Reviews)
3.3
SunniaImran

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 More

£50 GBP in 3 days
(13 Reviews)
3.8