Find Jobs
Hire Freelancers

Excel Template

£20-250 GBP

Avslutat
Publicerad över fem år sedan

£20-250 GBP

Betalning vid leverans
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,
Project ID: 17565585

Om projektet

60 anbud
Distansprojekt
Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
60 frilansar lägger i genomsnitt anbud på £102 GBP för detta uppdrag
Använd avatar
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 ping me for more discussion.
£200 GBP Om 3 dagar
4,9 (377 omdömen)
8,1
8,1
Använd avatar
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 Om 3 dagar
4,9 (307 omdömen)
7,8
7,8
Använd avatar
"""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 more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
£120 GBP Om 3 dagar
4,9 (273 omdömen)
7,1
7,1
Använd avatar
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 specify all the different combinations that the brand name could be misspelt. This table would subsequently be used while processing the data for branded and non branded queries report. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 25 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Have a Great Day! Srinivasan Krishnamoorthi
£80 GBP Om 3 dagar
5,0 (211 omdömen)
6,9
6,9
Använd avatar
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, Hoang
£20 GBP Om 1 dag
5,0 (162 omdömen)
6,9
6,9
Använd avatar
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 reliability, and if you are comfortable with those, lets discuss the project. I assure you that I will go beyond your expectations, and look forward to hearing from you. Best regards Priyal
£150 GBP Om 2 dagar
5,0 (196 omdömen)
6,8
6,8
Använd avatar
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 and VBA to the complicated VBA projects in microbiology. I am looking for the projects on: - Excel - Excel VBA - Google SpreadSheet - Outlook VBA - Visual Basic - Data processing - Web scraping Mohsan
£200 GBP Om 3 dagar
5,0 (90 omdömen)
6,4
6,4
Använd avatar
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 required. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
£150 GBP Om 3 dagar
5,0 (95 omdömen)
6,2
6,2
Använd avatar
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, 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 ques
£21 GBP Om 3 dagar
5,0 (54 omdömen)
5,9
5,9
Använd avatar
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 Om 3 dagar
4,7 (102 omdömen)
6,2
6,2
Använd avatar
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 and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
£90 GBP Om 1 dag
5,0 (22 omdömen)
5,3
5,3
Använd avatar
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 manual steps. I can automate this task by creation of VBA code in Macro that can be easily triggered using short keys or there a button can be provide that will be run on click. Then it will provide you a spread sheet with statistics, and result in perfectly formatted as you like. Further to that it will search the csv file with names, and then automatically correct your products names as instructed. Moreover, i like to propose a software that will ready both file and out a result and a Excel file will correct product data and a results in your desired format to be printed. I am bidding the lowest as i really want to work for you, so we can mutually decide about the budget, I like to be get paid as you like.
£20 GBP Om 3 dagar
4,9 (35 omdömen)
5,0
5,0
Använd avatar
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 Entry, Internet Research, Lead Generation, LinkedIn and Web Scraping / Data Mining, Excel Utilities & Formulas(Merging, V&H lookups), Data Filtering project and have worked on numerous data entry and research jobs. So please give us a chance to serve you the best. Before start the project i can give you the sample leads for your satisfaction as per your requirements. Thanks!
£100 GBP Om 3 dagar
5,0 (8 omdömen)
4,8
4,8
Använd avatar
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 5 years. Hence, I have expertise on SAP, Tally ERP9, Quick Books, MYOB, ZOHOBOOKS, XERO, MS Access, MS Word, PowerPoint and MS Excel. Recording daily transaction or Book-keeping, Maintaining Books of Accounts, Reconciliation and finalisation of accounts are major areas of my job profile. I would like to draw your kind attention on few of my excel skills:- Maintaining and organizing data, Data Management, Data Entry. Formula development, VLOOKUP, HLOOKUP, LOOKUP, IF, INDEX, SUM. Pivot Table Development and Management Process Improvement Develop and implemented standard operating procedures to bridge data gaps and resolve related issues. Imported and exported data from text files, saved queries, or databases; used automatic outlining, inserted subtotals, created advanced filters, and used database functions. Designed, recorded, and executed macros to automate data entry inputs. Formatted spreadsheets and workbooks for print, document reproduction, and presentations. Hence, I request you to grant me an opportunity to serve you by executing and finishing the project giving my level best and so that I could establish myself on this platform though I am new at freelancer. Looking forward for your positive response. Thanks
£55 GBP Om 3 dagar
5,0 (16 omdömen)
4,6
4,6
Använd avatar
**** 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 in : POWERPOINT / PREZI, LOGO, VECTOR, PDF / EBOOKS, FULL CORPORATE IDENTITY, BROCHURE, POSTER / FLYERS / BOOK COVERS, INFOGRAPHICS, BUSINESS CARD, BANNERS, T-SHIRTS, PACKAGING / LABELS DESIGN, Animation / Video Project Every Single thing in terms of graphic designing can be handled by me Softwares I have Good Command on Illustrator, Indesign, Photoshop (Adobe software suite) Word, PDF, Powerpoint (Microsoft office) CorelDraw, 2d animation, Video Projectc Why To Select Us : 1. Unlimited Revisions till you are Happy 2. Multiple Options to choose from 3. Understand Project to ensure Best Output 4. Regular Updates 5. 24 x 7 Available
£44 GBP Om 0 dag
5,0 (9 omdömen)
4,4
4,4
Använd avatar
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% satisfied client. I am regularly doing following kind of tasks: 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". Thanks. Faisal S.
£200 GBP Om 3 dagar
5,0 (18 omdömen)
3,9
3,9
Använd avatar
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 misspellings issue but I would create a button so this is easy for you to query. Please let me know if you would like me to proceed. I hope to hear back from you soon. Kind regards Steve
£111 GBP Om 3 dagar
5,0 (8 omdömen)
4,0
4,0
Använd avatar
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 professional with rock-hard skills, I am well positioned to exceed your expectations in this position. My background demonstrates a great record of speedily entering sky-scraping volumes of error-free information into a variety of databases. I do extremely well at compiling and verifying data accuracy and integrity. My proven success in independent environments prepares me to make a noteworthy impact on you. Thank you for your consideration. Regards
£50 GBP Om 3 dagar
4,4 (14 omdömen)
3,9
3,9
Använd avatar
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 averages (AVERAGEIFS) with the condition set as either to look for or "*ex*le" and "*ea*le*" or "*e*le*" to stand for "example" (as in your sample spreadsheet), and the particular position bin. The search condition is based on the assumption that the middle letters starting from the second are commonly typed erroneously but as one proceeds through the length of the word, the last two letter would be typed correctly. And that the brand might occur at any point in the search query. I am suggesting a non-VBA based solution to allow the end-user to make on-the-spot fixes as may be required in the future. I hope you would consider my bid. Please drop me line to discuss my proposal further, if you are interested. Thank you in advance ! Best regards, Tristan
£30 GBP Om 3 dagar
5,0 (5 omdömen)
3,1
3,1
Använd avatar
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 Om 2 dagar
5,0 (3 omdömen)
2,5
2,5

Om kunden

Flagga för UNITED KINGDOM
Brierley Hill, United Kingdom
5,0
1
Verifierad betalningsmetod
Medlem sedan juli 11, 2018

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.