Data Science 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.

Game Layout Artists to visual facelift a card game prototype

I am seeking a Dextrous-proficient designer (or an experienced board game enthusiast with high-end aesthetic taste) to provide a professional visual facelift for a deck of training cards. The deck is aimed to be used as an exercise for process improvement and project management trainings. The project is currently in a "Functional Prototype" stage. All logic, mechanics, images, and text have been finalized within Dextrous. However, the current layout uses basic rectangular text zones, standard borders, and lacks the "premium aesthetic" required to engage training participants. I am NOT looking for image generation, content writing, or game mechanical changes. I need you to take the existing amateurish "raw" content and make it look elegant, sophisticated and professional. Specific Requirements: - Dextrous Expertise: You must be comfortable working within the Dextrous.com layout engine (managing layers, style inheritance, and dynamic text). - The "Board Game" Eye: You don’t need a degree in design, but you must understand what makes a "good-looking" card. You should have experience playing or handling modern, high-quality board games (e.g., Everdell, Scythe, Love Letter, Berserk, Libertalia or high-end TCGs). - Managing Density: These cards are text-heavy by design. The challenge is to make/keep this text readable and inviting without cutting a single word. This is an educational tool, not a commercial product. - Discretion & Confidentiality: The content of these cards represents internal corporate training methodology and specific process "pain points." As a requirement, the successful candidate must exercise absolute discretion. This means the specific text, data, and internal terminology used in the deck must be treated as confidential and may not be shared, reproduced, or featured in public portfolios or case studies without explicit written consent. Key Deliverable: template modernization. Redesign the base Layout of the 2 most common cards in Dextrous. With your skills it shouldn't take more than an hour. Maybe another hour to fully grasp the concept and to do some follow up changes This is a non-commercial, educational project aimed at improving the way professionals learn to solve problems. If you love board game design and have a "minimalist/pro" style, this is a clean, structured project with all content ready to go.

Virtual Assistant (Marketing Admin) — Remote | Healthcare Tech

We’re a growing healthcare tech company looking for a highly reliable, detail-oriented Virtual Assistant / Marketing Admin to support our marketing operations and client coordination. This is a remote, long-term freelance opportunity with consistent weekly hours for the right person. • Minimum: 10 hours/week (guaranteed for the right candidate) • Potential: up to 40 hours/week as you ramp up and prove performance • Rate review: after 2 months, with an increase based on performance Who this is for You’ll be a great fit if you’re a full-time freelancer (or have meaningful weekday availability) who can operate in UK working hours (9am–6pm GMT) and help on-demand when needed. Requirements (must-have) • Native English speaker with clear, concise, professional business writing • Able to adapt to UK working hours (9am–6pm GMT) with some on-demand availability • If you’re already working full-time for other clients during the day, this likely won’t be the right fit • Highly reliable, punctual, trustworthy, and consistently meets deadlines • Previous experience as a VA / project assistant / marketing assistant • Excellent attention to detail Key responsibilities Your regular work may include: • Research-oriented tasks (market, competitors, prospects, content, tools) • Sending outbound messages via LinkedIn Sales Navigator and/or email • Coordinating with team members across design, development, and marketing • Creating marketing banners/videos using Canva and/or Figma • Communicating requirements between clients and our internal team • Organising schedules, deadlines, meetings, and follow-ups • Uploading/scheduling daily content (social media + YouTube) • Copywriting (short-form + longer-form as needed) • Editing video transcripts • Editing blog posts and checking for SEO guideline compliance • Finding relevant images to support content • Writing weekly marketing emails • Extracting data for monthly marketing reports • Liaising with content creators and external collaborators • Bonus: experience with Asana or Trello Hiring process We’ll shortlist several candidates and run a paid test project. If you pass, this can become a strong long-term partnership with increasing hours and responsibilities. How to apply Please include the following in your application: 1. Full name 2. Where you are based (city + confirm you can adapt to UK timezone) 3. Relevant tasks/projects you’ve worked on + your current availability (hours/week + typical working hours) 4. Your favourite non-work activities 5. One work-related problem you solved that you’re proud of (briefly explain the situation + outcome) 6. Links or examples of previous relevant work (if applicable) 7. A 1-minute selfie video introducing yourself and sharing a bit more about you

opportunity

MERN Developer

We are looking for a senior developer to help us finalise and consolidate a number of projects which are 75% complete. We expect this to be an ongoing, monthly paid role and so the budget is on that basis. We have a legacy system that, whilst functional, is outdated and needs the functionality migrating/replicating in our new environment. The work will include refactoring, adding routes and connecting multiple interfaces to complete the job. You will need to have an understanding of complex data structures to ensure that migration and CRUD functionality is accurate to serve various interactions of the project. Lastly, the platform has a companion application that is built and compiled in EXPO. This will need attaching to the new migration, rebuilding and deploying to the stores appropriately. Therefore the following experience is necessary **Key Responsibilities:** - Develop new features and enhance existing functionality for our directory website using the MERN stack (MongoDB, Express.js, React.js, Node.js, Next.js). - Utilise trunk-based development practices to ensure smooth and timely integration of code into the main branch. - Work collaboratively with other developers to resolve conflicts and merge changes efficiently. - Perform regular performance and bug-fixing tasks to ensure optimal website performance. - Write clean, maintainable, and efficient code, following best practices and industry standards. - Participate in code reviews to maintain code quality and provide constructive feedback. - Continuously improve and upgrade the software to keep up with the latest advancements in technology. **Required Skills and Experience:** - Proven experience as a MERN Stack Developer. - Strong understanding of trunk-based development and its best practices. - Prior experience working in an agile environment with regular sprints. - Proficiency in MongoDB, Express.js, React.js, and Node.js. - MUST MUST be proficient with Docker and build architectures. - Familiarity with version control systems, particularly Github and Github Actions. - Excellent problem-solving skills and attention to detail. - Strong communication skills and the ability to work collaboratively in a team environment. - Ability to manage multiple tasks and deadlines effectively. **Nice to Have:** - Experience with DevOps practices and tools. - Knowledge of serverless architecture and cloud platforms. - Familiarity with continuous integration and continuous deployment (CI/CD) pipelines. - Typescript experience. If you're after a easy going developer role where there's more work then we can get through then please let me know. No agencies and please only apply if you're used to throwing code out from ticket reference branches - we want to be pushing/building multiple times a day in some situations. Please please please do not apply if you're a junior or mid dev - this requires an individual to undergo a steep learning curve and drive the migration to finalisation. Also - the individual needs to work on the project full time until complete - this is not something that can be done in an hour a day.

opportunity

Magento 2 – Fix Ryft Payment Webhooks (Lightweight PHP)

I am running a Magento 2 multi-store environment with a Ryft payment gateway already integrated. The majority of the system is in place, but I need an experienced Magento 2 / payment gateway developer to audit, verify, and correctly finalise the Ryft webhook implementation. This is a senior-level technical task focused on correctness, performance, and reliability. Critical requirement (please read carefully) The Ryft webhook must be handled using a lightweight standalone PHP endpoint. ❌ NOT using Magento bootstrap (app/bootstrap.php) ❌ NOT loading the Magento framework just to receive webhooks ❌ NOT relying on heavy Apache or Magento routing The webhook should be received in plain PHP, validated, deduplicated, and only then pass confirmed data into Magento in a controlled way. The goal is minimal server load, high reliability, and zero duplicate processing. Current situation Magento 2 multi-store setup (many stores, shared codebase) Ryft payments are mostly working Webhooks are unreliable or not firing consistently Some order duplication and inconsistent order state updates Current implementation may be too heavy and loading Magento unnecessarily What I need you to do Review the existing Ryft payment and webhook configuration Verify webhook events are correctly received (eg captured, failed, refunded) Implement or correct a lightweight PHP webhook endpoint Validate webhook signatures securely Ensure idempotent processing (no duplicate order updates if Ryft retries) Ensure correct Magento order state updates once events are confirmed Confirm the final setup is production-safe and correctly architected What I am NOT looking for A full Magento rewrite Magento observers handling webhook ingestion Any solution that loads the Magento framework to receive webhooks Required experience Magento 2 (checkout flow, order states, payment modules) Payment gateway integrations Webhooks, retries, signatures, and idempotency Clean, efficient, production-grade PHP Budget This is a senior task. Fixed budget up to £750, depending on approach and experience. To apply, please answer BOTH questions below: Why is it bad practice to load Magento’s bootstrap when receiving payment webhooks, and what impact does this have on PHP-FPM and server load? How would you design webhook processing to prevent duplicate order updates if Ryft sends the same event more than once? Applications that do not answer both questions will not be considered.