Business Projects

Advanced Webinar KPI, Revenue & Lead Attribution Dashboard

Advanced Webinar KPI, Revenue & Lead Attribution Dashboard (Google Sheets Only) Project Overview I am looking for an experienced Google Sheets data analyst / dashboard specialist to build a comprehensive, advanced KPI dashboard that tracks the full performance of my webinars — from traffic and registrations through to sales attribution by lead source and lead temperature. This is not a basic spreadsheet.
It is a multi-layer Google Sheets dashboard designed to analyse, optimise, and scale webinars profitably. This dashboard will be used by senior leadership to make decisions around: * Scaling paid traffic * Understanding where sales actually come from (warm vs cold) * Optimising webinar content, offers, and follow-up * Forecasting revenue with confidence Platform Requirement (Non-Negotiable) ✅ Google Sheets ONLY
❌ No Looker Studio
❌ No Excel-only builds
❌ No basic reporting templates The solution must use: * Structured tabs * Clear formulas (no hard-coded numbers) * Pivot tables / QUERY formulas where appropriate * Easy duplication for future webinars Dashboard Requirements 1. Traffic & Acquisition Metrics * Traffic by source (email, ads, social, affiliates, partners) * Cost per click (CPC) * Cost per registration (CPR) * Registrations by source * Revenue by traffic source * ROI by traffic source 2. Lead Source & Lead Temperature Attribution (Critical) The dashboard must clearly show where sales came from, segmented by both lead source and lead temperature. Lead Source Examples * Warm database (existing email/CRM list) * Cold paid ads * Retargeting ads * Organic social * Affiliate / partner traffic * Direct outreach / DMs Required metrics: * Registrations by lead source * Attendance rate by lead source * Conversion rate by lead source * Revenue by lead source * Revenue per registrant by lead source Lead Temperature Segmentation Leads must be categorised into: * Warm leads (existing database) * Lukewarm leads (previously engaged, non-buyers) * Cold leads (first-touch via ads) Required metrics: * Buyers by lead temperature * Conversion rate by lead temperature * Revenue by lead temperature * Average order value by lead temperature * Time-to-purchase by lead temperature This section must clearly answer: “Are webinar sales coming primarily from warm audiences, cold traffic, or a mix?” 3. Registration & Pre-Webinar Behaviour * Registration conversion rate * Registrations over time * Warm vs cold registrant split * Pre-event engagement indicators * Attendance prediction indicators (based on engagement) 4. Live Webinar Engagement * Live attendance rate * Replay views * Average watch time * Watch-time segmentation (25%, 50%, 70%, 90%) * Drop-off analysis * Engagement scoring (attendance, watch time, CTA clicks) 5. Offer & Sales Performance * Total revenue * Buyers (live vs replay) * Offer conversion rate * Average order value (AOV) * Revenue per attendee * Revenue per registrant * Time-to-purchase analysis 6. Follow-Up & Delayed Conversion * Sales from follow-up sequences * Conversion window tracking (24h / 48h / 7 days) * Revenue split: live vs post-webinar * Email-to-sale efficiency 7. Sales Call & Backend Metrics (If Applicable) * Calls booked from webinar * Call show-up rate * Close rate * Revenue per call * Webinar → Call → Sale conversion flow * Revenue by sales rep (if applicable) Executive Summary (Top of Sheet) A high-level summary tab showing: * Total revenue * Net profit * ROI * Revenue per registrant * Cost per acquisition * Revenue split: warm vs cold leads * Scale readiness indicator (Green / Amber / Red) What I Will Provide * Clear KPI definitions and formulas * Definitions for lead source and lead temperature * Sample data structure * Explanation of how data flows * Ongoing clarification during the build This project is clearly scoped and well thought through. Who I’m Looking For * Advanced Google Sheets experience * Strong understanding of funnels, attribution, and revenue analytics * Comfortable working with large datasets and complex formulas * Commercially minded (not just technical) * Clear communicator Please include: * Examples of complex Google Sheets dashboards you’ve built * How you would handle lead source and lead temperature attribution in Sheets * Estimated timeline to first working version Budget & Future Work This is an initial build, with potential for: * Automation improvements * Ongoing optimisation * Additional dashboards I am happy to pay for quality work. Question: Briefly explain how you would structure a Google Sheets dashboard to show revenue from warm vs cold webinar leads.

Remote Admin & Accounts Assistant – Part-Time/Paid Training

We are seeking to hire a Remote Admin & Accounts Assistant who is organized, customer-focused and confident working independently. You will assist with admin,accounts and customer service tasks to keep our day-to-day operations running smoothly.No prior experience is needed as we provide full paid training. Responsibilities: Keep databases and records accurate and up to date Track purchase orders and supplier deliveries Research products and sales data to support decisions Provide helpful,professional customer service to the team and partners Assist with basic HR admin tasks Join supplier calls and product demos Support other admin duties as needed Incentives: Paid training and ongoing support Flexible part-time hours (remote) Supportive international team Career growth potential and long-term work Secure payments through pph.com Submit a short cover letter and CV via peopleperhour.com explaining why you’d be a great fit for this role.

Freeagent Landlord MTD Book keeping and Setup

I have the Freeagent Landlord Edition MTD software I have linked my bank acocunt - need someone to do the booking keeping and setup

Register a company in UK

Hi, I would like to register a company in UK using a UK Based registered office address and Virtual business address. Please provide your price including Companies House fees and yearly cost for Registered office address and virtual business address. I am looking to do this early this week.

Recruitment Specialist Wanted Now

We are seeking a highly skilled Recruitment Specialist to enhance our talent acquisition efforts. The ideal candidate will possess extensive knowledge of recruitment strategies, possess exceptional communication skills, and have a proven track record in sourcing and attracting top-tier candidates across various industries. Responsibilities will include developing job descriptions, conducting interviews, and implementing effective onboarding processes. The successful freelancer will demonstrate an ability to work independently, manage multiple roles simultaneously, and adapt to our dynamic work environment. Join us in building a diverse and talented workforce.

Bar and pie charts

Hi team. Hope you are well. Do you offer bar graphs / bar charts design as one of your services please? I might need about 10-15 of them done please? Thanks, Darren

Ongoing Site Identification Support (UK Planning)

Hi I’m looking for ongoing support one day per week to help identify potential UK sites suitable for planning, using Searchlands (licence provided). I’ll provide: A clear summary of the site characteristics and constraints I’m targeting A simple template to complete for each site identified The role will involve: Using Searchlands to research and shortlist sites Applying the criteria consistently Completing the template for each viable site The target output is around 20–30 sites per week. Based on your experience, this feels like it could be a good fit, so I’d be keen to discuss further if this is of interest.

opportunity

Non Profit Attorney and Financial Services lawyer - UK based

Hi, We have a mobile app which will facilitate donations to non charitable organisations (temples) in the UK. User can select any organization and choose to pay any preferred temple. We want someone to: Review the business plan and make sure it complies with non-charitable donations Review our Temple onboarding process to make sure we fully check the organizations and their status Review our payment gateway integration so make sure we fully comply with online payments. Please do NOT bid if you are not UK based.

Need a freelancer in Amsterdam, Netherlands

We are looking for reliable individuals to perform Primary Source Verification tasks in Amsterdam, Netherlands. The work involves visiting designated institutions/organisations to take few geotagged photos of the signboard to confirm the location, printing the document and getting it signed and stamped by the concerned authority for authenticity, collecting the verifier’s name, designation and contact number, and sending a scanned copy of the signed and stamped document back to us.

Need a freelancer for on site verification in Veles, Macedonia

We are looking for reliable individuals to perform Primary Source Verification tasks in Veles, Macedonia. The work involves visiting designated institutions/organisations to take few geotagged photos of the signboard to confirm the location, printing the document and getting it signed and stamped by the concerned authority for authenticity, collecting the verifier’s name, designation and contact number, and sending a scanned copy of the signed and stamped document back to us.

Interest and other income from overseas savings on my tax return

I have Interest and other income from overseas savings to complete on my tax return and am struggling to complete this section. I also have a simple question about how much I need to pay on account for next year as my calculation says I dont need to pay anything >>> this is very strange.

IT Project Manger - Service Transition experience Required

I’m currently managing the transition from project delivery to support for a SharePoint NHS project, and I’m looking for guidance on the required project templates and the information needed for a smooth handover. If you know where I can purchase the templates or provide guidance/coaching, I’d be interested in learning more. As a Project Manager, I’m specifically looking for support from a senior PM who can assist with this transition. This is the list of handover documents that has been suggested : Source Code repository Access & pemission document Third party tools and integration Issues log Project Clousre document Service D&A Acceptance criteria Configuration & Asset

Urgent UK accountant to file LLP accounts (already done)

Hi, I need a UK account who knows how to submit LLP accounts and have the accurate software to do so. All prepared and ready to file. Thanks for your offers!

urgent

UK SOLICITORS FIRM TO REVIEW AND ISSUE LEGAL NOTICES AND DEMANDS

Hello, I am a legal consultant and I require for a solicitor from a legal firm to review and issue legal notices for me on their legal firms letter head (not consultancy company) through email/post so the notices are taken more seriousley as I do not have a company myself, I will do the hard work in providing the content of the letters and I will pay a reasonable fee for every letter/response or email issued on a long term basis. Each letter will not take more than 30mins. I look forward to your proposals. Adam