Excel Template

Đã Đóng Đã đăng vào 5 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

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,

Nhập liệu Xử lí dữ liệu Excel

ID dự án: #17565585

Về dự án

60 đề xuất Dự án từ xa 5 năm trước đang mở

60 freelancer chào giá trung bình£102 cho công việc này

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 Thêm

£200 GBP trong 3 ngày
(377 Nhận xét)
8.1
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 trong 3 ngày
(307 Nhận xét)
7.8
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 Thêm

£120 GBP trong 3 ngày
(273 Nhận xét)
7.1
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 Thêm

£80 GBP trong 3 ngày
(211 Nhận xét)
6.9
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 Thêm

£20 GBP trong 1 ngày
(162 Nhận xét)
6.9
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 Thêm

£150 GBP trong 2 ngày
(196 Nhận xét)
6.8
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 Thêm

£200 GBP trong 3 ngày
(90 Nhận xét)
6.4
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 Thêm

£150 GBP trong 3 ngày
(95 Nhận xét)
6.2
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, Thêm

£21 GBP trong 3 ngày
(54 Nhận xét)
5.9
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 trong 3 ngày
(102 Nhận xét)
6.2
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 Thêm

£90 GBP trong 1 ngày
(22 Nhận xét)
5.3
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 Thêm

£20 GBP trong 3 ngày
(35 Nhận xét)
5.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 Thêm

£100 GBP trong 3 ngày
(8 Nhận xét)
4.8
GopalJp

Hi, This is Gopal. I am a book-keeper and accountant. I have gone through your project description and understood. Kindly note that I have been working in Accounting, Tax, Audit and Finance function for more than Thêm

£55 GBP trong 3 ngày
(16 Nhận xét)
4.6
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 Thêm

£44 GBP trong 0 ngày
(9 Nhận xét)
4.4
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 Thêm

£200 GBP trong 3 ngày
(18 Nhận xét)
3.9
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 Thêm

£111 GBP trong 3 ngày
(8 Nhận xét)
4.0
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 Thêm

£50 GBP trong 3 ngày
(14 Nhận xét)
3.9
engrtan

Hi ! I would like to offer you a possible solution that would not use VBA programming. If it were up to me, I would be setting up formulas on the relevant cells (as shown in your PNG file), using conditional averag Thêm

£30 GBP trong 3 ngày
(5 Nhận xét)
3.1
Navitalreja

Hello there, I am Very much good at excel, I will do this job perfectly and i will make sure that all the requirements are satisfied.

£20 GBP trong 2 ngày
(3 Nhận xét)
2.5