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,

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Brierley Hill, United Kingdom

Projektin tunnus: #17565585

65 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

£250 GBP 3 päivässä
(595 arvostelua)
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 Lisää

£200 GBP 3 päivässä
(270 arvostelua)
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 3 päivässä
(234 arvostelua)
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 Lisää

£20 GBP 1 päivässä
(141 arvostelua)
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 Lisää

£80 GBP 3 päivässä
(148 arvostelua)
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 Lisää

£150 GBP 2 päivässä
(186 arvostelua)
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 Lisää

£120 GBP 3 päivässä
(146 arvostelua)
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 3 päivässä
(100 arvostelua)
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 Lisää

£200 GBP 3 päivässä
(66 arvostelua)
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 Lisää

£150 GBP 3 päivässä
(36 arvostelua)
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 Lisää

£20 GBP 3 päivässä
(30 arvostelua)
4.9
AlexandrUKR

please clarify possible next steps

£250 GBP 10 päivässä
(16 arvostelua)
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, Lisää

£21 GBP 3 päivässä
(25 arvostelua)
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 Lisää

£44 GBP 0 päivässä
(4 arvostelua)
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 Lisää

£100 GBP 3 päivässä
(6 arvostelua)
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 3 päivässä
(14 arvostelua)
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 Lisää

£200 GBP 3 päivässä
(14 arvostelua)
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 Lisää

£90 GBP 1 päivässä
(9 arvostelua)
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 Lisää

£111 GBP 3 päivässä
(3 arvostelua)
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 Lisää

£50 GBP 3 päivässä
(13 arvostelua)
3.8