Google Spreadsheets Projects

Google Page indexing

I am looking for someone who is an expert (but not too pricey and fair in pricing) to help us with Google Indexing of our news pages on our website. We have 9.58k pages indexed, but 90.8k pages not indexed, due to some errors. I can provide access to our Google console and website. I have had this job done before and it took the previous person around 2-4 hours to fix, so I have based the fix pricing on this time frame. If the job is good, may consider for SEO and long term work.

urgent

Google Analytics help

we need someone to help remove a bad review from our google page by any means necessary and maybe to help with SEO

Google Ads Expert

We are looking for an experienced Google Ads professional to manage and optimize our campaigns to enhance the profitability of our Small business and improve SEO performance. If you're passionate about driving results through paid search and have a proven track record in Google Ads, we'd love to hear from you!

I want my online magazine to be on the first page of google

i have a luxury online lifestyle magazine website and i have a lot of competition, i would like to get my website listed firt on google for certain keywords

Excel spreadsheet entry and other minor admin tasks

This is an opportunity for data entry and administrative support tasks on a contract basis. The primary responsibility will be populating a property analysis Excel spreadsheet with numerical details for several listings. Minor tasks may also include document updating such as legal wills, resumes, or similar typing work. While the initial workload is expected to be light, consisting of a few hours per week, there is potential for additional responsibilities and greater time commitment moving forward depending on client satisfaction and collaboration. The ideal candidate will have intermediate Excel skills, strong attention to detail, and the ability to work independently with minimal supervision on routine office support duties. Communication will be virtual and work can be completed remotely on a flexible schedule.

Google Local Guides Help

Looking for someone to help with google reviews and advise on getting reviews for google maps. Possible 20 reviews from different google local guides. Thanks

opportunitypre-funded

Daily scrape of jobs into Google Sheet from employer websites

This project seeks to streamline daily job posting efforts for a large jobs website. At present, we keep it busy we manually finding and posting jobs to the site daily. It's a lot of effort to maintain and I'm looking to streamline and automate it. The 13 organisations I'd like to start with - including links to their pages where jobs are listed/linked out from - are shown in the attached spreadsheet. We'll likely want to expand this list over time. I'm looking to set up a process to monitor for new jobs each day, and to scrape key information into a Google sheet I already have set up. It needs to be a robust process that can run in the longer term to autopilot. The information we'd need to capture for each new job into the Google sheet is as follows: 1 - Job title 2 - HTML of the role description 3 - Employer name 4 - URL of the role 5 - Country 6 - State (if in the USA) Once in the Google Sheet I can then categorise them and import them to the site in batches. Please outline how you'd approach the task. I hope you can help with this task.

BetAngel - Excel Spreadsheet Required

I require a spreadsheet that halts betting when a specified profit threshold is reached or ceases betting after, for instance, achieving five consecutive wins. All targets would need to be user defined figures.

Freelance Google Ads Specialist

Company Overview: We are a forward-thinking digital marketing agency committed to delivering measurable results for our clients across a variety of industries, including professional services, healthcare, home improvement, and hospitality. Our focus is on driving relevant, high-quality leads and conversions through strategic online advertising. If you’re passionate about creating profitable campaigns that help businesses thrive, we’d love to have you on board. Role Overview: We’re looking for a Freelance Google Ads Specialist to help manage and optimize pay-per-click (PPC) campaigns for a diverse range of clients. You’ll play a key role in crafting, executing, and refining campaigns that maximize ROI, leveraging your expertise in keyword research, ad creation, audience targeting, and ongoing optimization. Key Responsibilities: Campaign Strategy & Setup: Develop tailored PPC strategies based on client goals. Set up campaigns, ad groups, and keywords in Google Ads, ensuring alignment with business objectives and branding guidelines. Keyword Research & Optimization: Identify profitable, industry-specific keywords. Continuously analyze keyword performance and make data-driven adjustments to improve quality scores and reduce costs. Ad Creation & Testing: Write compelling ad copy, experiment with multiple ad variations, and conduct A/B tests to improve CTR, CVR, and overall campaign performance. Bidding & Budget Management: Employ bid strategies that balance target ROAS, CPA goals, and client budgets. Monitor spending closely to ensure efficiency and profitability. Landing Page Optimization: Collaborate with our design and development team to refine landing pages, improve user experience, and boost conversion rates. Reporting & Analysis: Track KPIs, analyze performance metrics, and produce clear, concise reports for clients. Offer strategic recommendations based on data insights to continuously enhance campaign outcomes. Platform & Industry Expertise: Stay updated on the latest Google Ads features, industry best practices, and emerging trends. Apply new techniques to keep campaigns fresh and competitive. Qualifications & Skills: Experience: Minimum 2+ years of hands-on experience managing successful Google Ads campaigns. Proven track record with a variety of client types and budgets is a plus. Technical Proficiency: Strong understanding of Google Ads interface, Google Analytics, conversion tracking setup, and key performance metrics. Analytical Mindset: Excellent data analysis skills; able to interpret results and translate insights into actionable strategies. Creative Approach: Skillful at crafting engaging ad copy and experimenting with new ideas to capture audience attention. Communication: Clear and professional communication, including the ability to explain complex insights to non-technical stakeholders. Organization & Self-Motivation: Adept at managing multiple campaigns simultaneously, meeting deadlines, and maintaining impeccable attention to detail. Freelance Flexibility: Able to work remotely on a project-by-project basis, accommodating varying workloads and timelines. Why Work With Us: Diverse Clientele: Work on a wide range of campaigns spanning various industries, broadening your skill set and portfolio. Flexible Collaboration: Enjoy the freedom to set your own schedule and work environment as a freelancer. Long-Term Partnerships: Grow with us. We value building ongoing relationships, offering a steady flow of projects if you consistently deliver results. Team Support: Collaborate closely with a team of digital marketers, designers, and SEO experts who respect and value your expertise. If you’re driven by data, enjoy testing new strategies, and are committed to helping businesses achieve measurable growth, we want to hear from you. Submit your portfolio, past campaign results, and examples of your achievements in Google Ads today.

Ranking my website on Google

I am looking for an SEO to rank my business on Google to get leads.

Global Export Sales Expansion Excel Spreadsheet

Hello there, pI am seeking an experienced Excel and data modelling expert to create a comprehensive global export sales template for our premium spirits brand. This project is crucial to our international expansion strategy and requires expertise in advanced Excel formulas, market-specific cost analysis, and a deep understanding of COGS (Cost of Goods Sold) and pricing structures across multiple territories. Key Deliverables: 1. Global Template Framework: • A functional and dynamic Excel template tailored for global export sales, including editable fields and automated calculations. • Consolidated summary tab providing a dynamic overview of all markets. 2. Market-Specific Tabs: • Include dedicated tabs for Australia, China (Hong Kong and Beijing), the US, and South America. • Market research data integrated into the model to calculate COGS, duties, shipping costs, and RRP (Recommended Retail Price) per SKU. 3. Product SKU Calculations: • Accurately calculate excise and duties for spirits with 40% ABV (applying Australian regulations as an example). • Incorporate formulas to reflect costs for London Dry Gin, Pink Gin, Barrel-Aged Gin, Botanical Rum, Aged Rum, and Vodka. 4. Automated Features: • Dynamic fields and formulas for profit margins and other key metrics. • Editable fields for local tax rates, shipping, and market-specific costs. Step-by-Step Guide: Global Expansion Pricing Spreadsheet 1. Structure of the Spreadsheet The spreadsheet includes: • Tabs for each market: Australia, China, US, South America. • A Global Summary Tab: Consolidated view of costs, margins, and profitability across markets. 2. Columns in Each Market Tab Each market tab includes the following columns: 1. SKU: Product name (e.g., London Dry Gin, Pink Gin, etc.). 2. Base COGS (GBP): Fixed production costs in GBP. 3. Shipping (Local Currency): Editable field for shipping costs in the market’s currency. 4. Freight (Local Currency): Editable field for freight costs in the market’s currency. 5. Duty (Local Currency, per bottle): Editable field for excise or duty costs, based on the market’s regulations. 6. Total COGS (GBP): • Formula: = [Base COGS] + ([Shipping] × Exchange Rate) + ([Freight] × Exchange Rate) + ([Duty] × Exchange Rate) 7. UK RRP (GBP): Fixed recommended retail price in GBP. 8. Adjusted RRP (Local Currency): Editable field for suggested RRP in the market. 9. Margin (%): • Formula: = ((Adjusted RRP - Total COGS) / Adjusted RRP) × 100 10. Profit (100 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 100 11. Profit (1000 Cases GBP): • Formula: = (Adjusted RRP - Total COGS) × 1000 3. Market-Specific Adjustments 1. Australia: • Excise duty per bottle based on 40% ABV (current rate: AUD 28.52, converted to GBP). • Exchange rate: 1 AUD = 0.54 GBP. 2. China (Hong Kong & Beijing): • Unique excise and duty rates for each region, editable fields. • Exchange rate: 1 CNY = 0.11 GBP. 3. US: • Include local taxes and tariffs. • Exchange rate: 1 USD = 0.74 GBP. 4. South America: • Account for import tariffs and duties (e.g., Brazil-specific rates). • Exchange rate: 1 BRL = 0.18 GBP. 4. Global Summary Tab 1. Pulls data dynamically from all market tabs: • Total COGS by SKU. • Average margins across markets. • Consolidated profit projections for 100 and 1,000 cases. 2. Formulas reference each market tab using =SUM(Australia!Cell, China!Cell, US!Cell, SouthAmerica!Cell). 5. Editable Fields • Ensure all shipping, freight, and duty costs are editable for flexibility. • Adjust exchange rates dynamically for real-time updates. 6. Tools for Collaboration • Conditional Formatting: • Highlight margins below 30% in red for easy visibility. • Data Validation: • Add dropdown menus for currency selection or pre-set SKUs. Candidate Requirements: • Proven expertise in creating complex Excel templates. • Strong understanding of international trade costs and pricing strategies. • Ability to incorporate multiple data points into clear and concise spreadsheets. • Experience working in FMCG, particularly in spirits or beverages, is a plus. If you are passionate about crafting game-changing tools and have the expertise to deliver on this high-stakes project, I’d love to hear from you! Please include examples of similar work or projects when applying. Looking forward to your proposals!

Google Analytics Setup & Tags Manager

I require assistance in properly configuring my website for analytics tracking and reporting. The selected freelancer will be tasked with installing the Google Analytics tracking code on my website pages, setting up event and ecommerce tracking tags as needed, and testing the implementation to ensure data is being collected accurately. Examples of goals include tracking outbound links, file downloads, video plays and online purchases. The analytics account needs customized views, segments and goals structured to suit my specific reporting needs. Configuring GA properly from the outset will allow me to glean valuable insights into user behavior and conversion funnels. Applicants should demonstrate expertise with GA tag manager, solid understanding of event tracking and affiliation with online analytics best practices. Only candidates fluent in tag configuration, interface customization and analytics strategy will be considered for this project. Please provide samples of past analytics implementation work in your proposal.

I want to mail merge a PDF form to many people at the same time

I have a PDF form that I want to mail merge out to various people at the same time. I also have a sample data spreadsheet with the data on that I need mail merging into the document, and then the PDF form being emailed out to each person. The idea was to convert the PDF to word, then from word mail merge this out (so each person got a PDF with their own details on), each month the data will change, so I need someone to set this up and I can do mail merge each month going forward, the same data spreadsheet details which sections of the form I want to mail merge information into. I have attached the PDF and also a sample spreadsheet - I tried converting to word and doing a mail merge from there, but I was struggling to get the information I needed into the relevant boxes Please have a look at the form and see if this can be done before bidding as it isn't a quick 5 minute job to do this! Thanks!

opportunity

Adwords account issues

An AdWords consultant is needed to optimize two Google Ads accounts across two websites. One account promotes cocktails and stag events in the UK and has seen declining impressions and conversions over the past few months. The other account based in Australia recently suffered from restricted impressions that need resolution. The consultant will review monthly performance reports, ad campaigns, and landing pages to identify issues limiting visibility and recommend improved strategies. They will submit a proposal outlining fixes for restrictions, underperforming ads and campaigns, and ways to boost future clicks and conversions. Access to the advertising spreadsheets and website will be provided upon project hiring through the freelancing platform.

opportunity

Excel Lead tracking Managment

Hello, I am looking for a Excel spreadsheet that will track incoming leads, allocate the lead to a sales person on a seperate google sheets/shares spreadsheet, for them to update with status of lead. All controlled by central spreadsheet 1 Sheet - Lead Entry, Name, Address, Tel, e-mail 2nd Sheet, central spreadsheet for all leads - Data from above with the date entered. Plus a drop down of sales person, when drop down activated, it is then auto entered to the spreadsheet of the sales person, Lead status, (which can be updated from Sales persons Spreadshet when lead is actioned and date updated and a 2 notes column (one for notes on main spreadsheet only, another for notes on Salespersons spreadsheet Sheet 3-12 - 9 Spreadsheets for the sales person with, Date of lead, Name, Phone and E-mail, all not editable on this spreadsheet. The lead status (selected from a drop down) and Notes Final sheet, a reporting sheet, Date Range selection Total leads, Lead per status, % of leads in the lead stats, lead per salesperson, etc Want to start straight away Thanks

A4 FLYER (AMENDABLE) AND SMALL EXCEL SPREADSHEET TIDY UP

I require the design of a professional looking A4 flyer that allows for easy editing of logos and details before saving as a PDF. The initial flyer design has already been created, however it needs refinement and formatting to allow for flexible updates. In addition, an Excel checklist needs organization and styling to appear polished. For the flyer component, the ideal file format would be a PowerPoint or Word document to permit adjustment of branding elements and specifics prior to finalizing the PDF version. Clean and customizable layouts are essential. Regarding the spreadsheet, the current checklist lacks a coherent structure and formatting. It necessitates rearrangement and standardization of cells, rows, columns as well as consistent styling like font, alignment, borders to advance its professional look and usability. Both projects involve creatively enhancing provided initial drafts to build out polished and user-friendly end products. The flyer requires a dynamic template while the spreadsheet needs thorough organizing and beautifying. Strong attention to detail and design-minded solutions will be important to effectively meet these dual presentation and organization objectives. Collaboration is welcomed to clarify any aspect of the brief. Concise, high quality work delivered within the agreed upon timeframe will be appreciated. Please provide relevant experience and examples of similar projects in your response if interested. I look forward to reviewing proposals from qualified designers.

Seo and test google ads for my site

Hi! Here is my site http://aiminds.services Its single page simple website. I want seo of this site. Secondly, I want to test google ads compaign for 1-2 weeks. My budget is $10 which is fixed. Thanks!

I need to improve my google ranking/review for my gym

How do I improve my local gym google review and profile?

opportunity

Google and linkedin ads

I’m looking for a Google and LinkedIn Ads specialist to market my fully automated recruitment app. The focus is on targeting individuals specifically seeking work in the education sector. I’m offering up to £600 for this, which must include the ad credits. You may retain 8–10% of the budget as your fee, with the remainder allocated to the ads. Please only accept this proposal if: You allow the full payment, including the ad costs, to be made through this platform. You can manage the campaign effectively, as we plan to spend £600 every two weeks.

Google ad expert

Google ad expert needed for a campaign set up