Freelance Excel Jobs

Marketing & PR Consultant – B2B Professional Services

We are a high-end, boutique facilities management (FM) business, delivering bespoke, service-led solutions to premium commercial and residential environments. We’re looking for an experienced freelance Marketing & PR Consultant to take ownership of our content, positioning, and visibility, with a strong focus on LinkedIn, website improvements, and authority-building content. We currently don’t have a formal marketing or PR plan, or internal resource, so this role requires someone who can create the direction and deliver the work. Scope of Work LinkedIn content & thought leadership Create and manage regular LinkedIn content Develop a clear thought-leadership narrative around premium FM, service excellence, discretion, and experience-led delivery Mix of insight-led posts, industry commentary, behind-the-scenes expertise, and brand storytelling Content designed to build trust and credibility, not vanity metrics Website improvements Review and improve website copy and structure Refine key pages to clearly communicate our boutique positioning and differentiation Ensure messaging supports authority, reassurance, and conversion Light SEO awareness where appropriate, without diluting tone or quality PR-led content (LinkedIn-first) Apply PR principles to content creation to strengthen trust and legitimacy Position us as a knowledgeable, credible voice in the FM and workplace experience space Identify opportunities for light PR activity (awards, features, trade content, profile building) What We’re Looking For Proven experience in B2B, professional services, property, construction, or FM-adjacent sectors Strong writer with the ability to articulate premium, service-led brands Comfortable working with minimal input and creating structure independently Able to balance strategy and hands-on content creation UK-based or strong understanding of the UK FM / property market preferred Engagement Ongoing freelance role Estimated 5–10 hours per month initially Opportunity to expand scope as the partnership develops We’re looking for someone who can shape the story, create the content, and elevate how we are perceived.

Zkteco Attandance Custom Website Portal

The ZKTeco Attendance Custom Website Portal is a web-based attendance management system designed to integrate with ZKTeco biometric devices. The main purpose of this project is to automate the attendance process and provide an efficient, accurate, and user-friendly solution for managing attendance records. This portal allows attendance data from ZKTeco biometric machines to be automatically synchronized with the website. Through a secure admin login, administrators can manage users, devices, departments, and attendance records with ease. The system provides real-time attendance monitoring, daily and monthly reports, late and absent tracking, and data export options such as Excel and PDF. Being a custom-built web portal, it can be tailored according to the specific needs of an organization. The system helps reduce manual work, minimizes human errors, saves time, and ensures secure storage of attendance data. Overall, this project is a reliable and effective attendance management solution for offices, schools, colleges, and organizations that want to integrate ZKTeco biometric technology with a modern web-based system

Senior Data Engineer

We are seeking a Senior Data Engineer to design, implement, and optimize data pipelines utilizing Scala, Spark, and Java. The ideal candidate will develop and maintain real-time data processing systems essential for business operations. Collaboration with data scientists and analysts is crucial to understand data requirements and deliver high-quality solutions. Responsibilities include ensuring data quality through robust testing, monitoring workflows, and troubleshooting pipelines. Candidates should possess a degree in Computer Science or Engineering, with proven experience in data engineering, real-time processing, and SQL proficiency. Familiarity with cloud platforms and data governance is preferred. We offer a competitive salary, benefits, and opportunities for professional growth in a collaborative environment. Key Responsibilities: - Design, implement, and optimize data pipelines using Scala, Spark, and Java. - Develop and maintain real-time data processing systems to support business-critical operations. - Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver high-quality solutions. - Ensure data quality and reliability through robust testing and validation procedures. - Monitor and troubleshoot data pipelines and workflows to ensure high availability and performance. - Stay current with emerging technologies and industry best practices to continuously improve our data infrastructure. Qualifications: -Bachelor’s or Master’s degree in Computer Science, Engineering, or a related field. - Proven experience with Scala, Spark, and Java in a data engineering or similar role. - Strong understanding of real-time data processing and streaming technologies. - Experience with big data platforms and tools such as Hadoop, Kafka, and Flink is a plus. - Proficiency in SQL and experience with relational databases. - Excellent problem-solving skills and attention to detail. - Strong communication and collaboration skills to work effectively with cross-functional teams. Preferred Skills: - Experience with cloud platforms (AWS, Azure, Google Cloud) and their data services. - Knowledge of data warehousing solutions and ETL processes. - Familiarity with data governance and security best practices.

Animal Talent Scout and website content Uploader

Job Title: Animal Talent Scout (Remote) Company: The Animal Talent Ltd Location: Fully Remote Website: www.theanimaltalent.agency ABOUT US The Animal Talent Ltd is a specialist animal talent agency representing exceptional animals for film, television, advertising, fashion and commercial campaigns. We work closely with animal owners across the UK and internationally, curating professional talent profiles that meet the high standards required by global brands and production companies. As our agency continues to grow, we are looking for a highly organised, detail-driven Animal Talent Scout to join our team. THE ROLE: This role sits at the heart of our talent pipeline. You will be responsible for sourcing owners of skilled cats and dogs based in the UK, reviewing the new animal submissions, assessing the quality and suitability of photographs and information submitted, guiding owners through improvements where needed and uploading all data to our databases and website to ensure all approved talent is professionally presented within our systems. This is not a generic admin role - it requires excellent written communication, strong judgement, confidence in giving polite but clear feedback, experiencing uploading data to website website and exceptional organisational and database skills. KEY RESPONSIBILITIES ▪️Sourcing skilled cats and dogs in the UK interested and available in animal modelling work; ▪️Reviewing and assessing new animal talent submissions for suitability and presentation quality; ▪️Evaluating photographs and videos for technical quality (focus, lighting, composition) and suitability for professional casting; ▪️Communicating clearly and diplomatically with animal owners via email to request improvements, missing information, or revised images where required; ▪️Uploading and accurately organising approved talent profiles, images and videos within our database and to the website; ▪️Maintaining detailed, well-structured records using Google Docs, Sheets and Drive; ▪️Ensuring all talent profiles are consistent, accurate and meet agency presentation standards; and ▪️Working closely with the internal team to ensure submissions move smoothly from enquiry to live online representation. ESSENTIAL SKILLS AND EXPERIENCE ▪️Exceptional written English, with the ability to communicate professionally, clearly, and politely at all times; ▪️Strong organisational skills and a meticulous eye for detail; ▪️High proficiency in Google Docs, Google Sheets, Google Drive, website data uploads including adding alt text; ▪️Confidence assessing image quality and providing constructive, tactful feedback; ▪️Ability to manage multiple submissions simultaneously and prioritise effectively; ▪️Comfortable working independently in a remote environment; and ▪️Calm, professional communication style when dealing with the public DESIRABLE (but not essential) ▪️Experience working with talent agencies, casting, modelling, or submissions-based roles; and ▪️An interest in animals, photography or creative industries WHAT WE OFFER: ▪️Twenty hours per week at £11.50 - £920/month ▪️Fully remote, flexible working; ▪️A key role within a respected and growing specialist agency; ▪️The opportunity to work closely with unique animal talent and high-profile creative projects; and ▪️A professional, supportive and detail-focused working environment. If you are highly organised, an excellent written communicator m, experienced in data uploads and take pride in precision and presentation, we would love to hear from you.

Live Score Reporter (In-Stadium)

About Us We are a new sports technology startup focused on making live football match updates faster and more reliable than ever before. Our mission is to reduce delays in live match information by sourcing updates directly from the stadium, ensuring that goals, key events, and match progress are shared as they happen — not seconds later. Currently, we are in the testing and evaluation phase, exploring how real-time, in-person reporting can improve the speed and accuracy of live football updates. This stage allows us to validate our concept, refine our processes, and measure the true impact of faster live data delivery. We believe that speed matters in live football. By combining human presence at matches with efficient communication systems, we aim to build a solution that sets a new standard for real-time match updates. As we grow, our focus remains on accuracy, transparency, and continuous improvement as we work toward creating a dependable live football update platform. Job Overview We are seeking reliable live update reporters who attend matches in person and can send real-time score updates instantly from inside the stadium. Speed, accuracy, and consistency are critical. Key Responsibilities Attend matches physically at the stadium Send live score updates immediately (goals, halftime, full time, red cards, penalties, etc.) Ensure 100% accuracy and minimal delay Stay focused on the game throughout the match Follow reporting instructions and timing rules strictly Required Skills & Qualifications Ability to attend stadium matches regularly Fast and reliable mobile texting / messaging skills Strong internet connection (mobile data backup preferred) Excellent attention to detail Punctual, trustworthy, and responsive Basic understanding of football (or the specific sport involved) Preferred (Nice to Have) Prior experience in live sports reporting Access to multiple stadiums or leagues Dual SIM phone or backup device Familiarity with WhatsApp, Telegram, or custom reporting app Payment Structure As we are a new startup currently in the testing and evaluation phase, compensation is structured on a per-match basis. Base Payment: €25 per completed match Performance Bonuses: Additional bonuses may be awarded based on the speed and accuracy of live updates Payments are issued after successful completion and review of each match Consistent performance during the testing phase may lead to increased rates and long-term opportunities This structure allows us to fairly compensate contributors while assessing the effectiveness and scalability of our live reporting model.

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

Microsoft Dynamics 365 Finance Setup and Config

We are seeking a Finance Data Migration Consultant with a strong understanding of core accounting principles and bookkeeping to set up our Microsoft Dynamics 365 Finance environment. The project involves migrating 18 months of historical data from Sage 50 and configuring specific workflows for Accounts Payable and Employee Expenses. All current historical data relates to our UK entity but we will in due course be operating accounts for UAE and Global as well which needs to be factored into the setup of Dynamics setup. Key Responsibilities 1. Historical Data Migration - Scope: Import approximately 18 months of historical records, primarily focusing on transactional data and payroll journal summaries. - Source Data: We will provide the historical data in 3 Excel files (already exported from Sage 50). You will aid in loading this data into Dynamics 365 Finance, ensuring proper dating and categorization of all opening balances and transactions. - Reconciliation: Perform comprehensive, auditable reconciliation checks between the final Sage 50 reports and the imported Dynamics 365 balances to guarantee zero data loss and absolute accuracy post-migration. 2. Functional Setup Context: We are a largely remote business and therefore require automation of entries into the ledgers in the first instance, and the ability to track invoices or expenses through an approval process – confirming the expense as a valid business expense for services received or goods received, from the correct counterparty and for the correct amount.  This needs to be done within the “system” with approvals “signatures” noted electronically within approval limits. - Accounts Payable (Invoice Management): We require a simple, lightweight approach to handle invoices for services subscribed to or products purchased. - Email Ingestion: Setup must include a workflow where invoices sent to a specific company email address are ingested/handled within Dynamics 365. - Employee Approval & Audit: We need a way for employees to either enter items (for expected invoices) or approve invoices that have come in. This must include a simple audit process to track exactly who entered or approved the expense. - Employee Expenses: Configure the Expense Management module (or appropriate workflow) to allow team members to easily upload and submit expense claims for approval Each of these categories can be served by an add-in or configuration of the stand Prerequisites - Proven experience with Microsoft Dynamics 365 Finance implementation and data migration. - Strong knowledge of Sage 50 structures to understand the source data. - Ability to configure email-to-invoice workflows (via standard D365 features, OCR, or Power Automate). Timeline - We are able to have a call to go over the requirements/deliverables if required. - Please provide an outline of your proposal to fulfil the requirements outlined above and an estimated timeline for the full process (Migration + AP/Expense Setup). e.g., 1-4 Days, 1 week.

Senior Full-Stack Developer

Full Job Description Overview: This position will work directly with Technology project teams, business users, and development teams to apply technical solutions in support of identified business challenges. You will be responsible for monitoring systems, interfacing with business owners, triaging issues, and developing solutions. This role requires working with limited supervision and providing after-hours system support as needed for a range of applications including Java, .NET, Visual Basic, and Oracle. Responsibilities: Design, develop, execute, deliver, and maintain Software Development and Maintenance projects. Participate in an Agile Software Development team with remote onshore and offshore development members. Attend project and client meetings, representing the team. Provide technical advice on solutions, performance issues, and project objectives. Contribute to Agile processes while maintaining efficient delivery. Deliver high-quality, secure, scalable, and maintainable production software. Adhere to coding standards. Maintain and create documentation (technical, functional, troubleshooting). Interact with Business Owners to understand business requirements and communicate technical decisions to non-technical users. Collaborate with other IT teams, including Enterprise Architecture, Security, DevOps, and Infrastructure to remove blockers and follow industry best practices. Foster effective, ongoing team interaction and communication. Qualifications: Bachelor’s Degree in Computer Science or equivalent experience required. Minimum of 5+ years’ experience designing, developing, and maintaining large-scale enterprise systems. Experience working on Agile software development teams with both onsite and remote members. Knowledge of the full software development lifecycle, including design, architecture, development, testing, deployment, and maintenance. Understanding of web services and APIs. Strong Oracle database knowledge. Forward-thinking with the ability to anticipate project, technology, and team solutions. Strong problem-solving skills and the ability to drive technological issues to resolution with minimal guidance. Self-motivated and able to thrive in a fast-paced, remote or onsite environment. Required experience with Spring Boot, REST APIs, and database connectivity. What We Offer: Pay Range: $40000 – $50000 / year, plus corporate bonus incentives. Benefits: Comprehensive medical, dental, and vision coverage, 401(k) with company match, HSA contributions, Paid Time Off, Personal/Sick Time, Paid Parental Leave, and more. Award-winning culture: We prioritize our company values: We Care; We Do the Right Thing; We Strive for Excellence; We Think BIG; We Take our Work Seriously, Not Ourselves.

opportunity

Graphic Charter

Brand Guidelines Development Brief The Landlord About The Landlord The Landlord is a high-end hospitality brand rooted in a refined lifestyle and a strong attention to detail. The brand operates at the intersection of hospitality, service excellence, and contemporary living. We are now entering a new phase of expansion through a franchise model, which makes visual consistency and brand clarity critical across all markets. Each franchise operates locally while carrying the same brand promise. To support this growth, we are looking to develop a complete, structured, and replicable brand guideline that can be deployed consistently across all physical and digital touchpoints. Objective of the assignment The objective is to create a comprehensive and operational brand guideline that will serve as a reference document for all current and future franchisees. This guideline must allow each The Landlord entity to express the brand with coherence, elegance, and precision, while preserving the emotional and aesthetic codes that define our brand DNA. The guideline should be practical, clear, and easy to use, enabling independent teams to apply it correctly without external supervision. Scope of work The selected agency will be responsible for designing and delivering a complete brand guideline, covering the following areas: Visual identity system Define clear rules for logo usage and placement across all supports, including: Brand extensions (TLL Franchises, TLL Manager, TLL Loyalty Program, TLL Platinum) Bedding and linen (pillowcases, sheets, duvets) Bath towels and spa linen Staff uniforms (shirts, aprons, jackets) Stationery (business cards, menus, envelopes, letterheads) Signage (storefronts, plaques, pictograms, vehicle branding) Packaging (bags, labels, boxes) Color palette Definition of primary and secondary colors Authorized shades and variations Color references (Pantone, CMYK, RGB) Recommended color combinations and contrasts Typography Primary and secondary typefaces Typographic hierarchy (titles, subtitles, body text, captions) Practical usage examples across print and digital formats Iconography and illustrations Definition of a consistent illustration style (minimal, linear, pictogram-based) Creation of an icon system covering hospitality services (reception, breakfast, spa, amenities, services) Guidelines for image and illustration treatment (line weight, spacing, visual tone) Photography direction Artistic direction (lighting, mood, subjects, composition) Storytelling approach aligned with a luxury hospitality universe Visual moodboard Image treatment recommendations (retouching, filters, grain, saturation) Examples of visuals adapted for social media, website, and printed materials Tone of voice and brand language Definition of the brand tone (warm, refined, intimate, elegant) Key vocabulary and preferred lexical fields Do’s and don’ts for brand expression Message examples for social media, email signatures, and printed materials Digital applications Design templates for: Instagram feed and stories Facebook publications LinkedIn posts and banners Layout grids and composition rules Logo, typography, and color integration guidelines Examples of carousels, stories, and short-form videos Printed materials and physical applications Complete stationery system (business cards, menus, envelopes, notebooks, labels) Uniform design guidelines and logo placement Linen and bedding specifications (materials, embroidery, positioning) Branded objects and promotional items Deliverables A complete brand guideline document (digital format) Fully structured, clear, and ready for franchise deployment Visual examples and practical use cases for each section Expected timeline and proposal We kindly ask interested agencies to provide: A detailed proposal outlining their methodology and approach A production timeline with milestones A cost estimate for the full scope of work Relevant references, ideally within hospitality, luxury, or franchise networks

Outbound Sales Development Representative (B2B) Part-Time Remote

Industry: Industrial & Consumer Gases (Helium & CO₂) Products: Disposable helium cylinders for balloon inflation + CO₂ cylinders for soda systems Markets: UK, Germany, France, Spain, USA Deal Size: €2,000 – €20,000 per order Schedule: 3 days per week (part-time, long-term) ⸻ About the Role We are looking for an experienced Outbound Sales Development Representative (SDR) to support our Sales Director and sales team by identifying, contacting, and qualifying new B2B prospects. This is a high-quality, relationship-focused outbound role, not high-volume spam. You will use LinkedIn Sales Navigator and selective follow-ups via WhatsApp and telephone to initiate conversations and pass qualified, interested leads to our English-speaking sales team (Jade & Ali). ⸻ Your Responsibilities Prospecting & Targeting • Build targeted prospect lists using LinkedIn Sales Navigator • Identify decision-makers in relevant B2B segments (events, retail, wholesale, hospitality, distributors, etc.) • Focus on quality and relevance over volume Outbound Outreach • Send personalised LinkedIn connection requests and first messages • Conduct structured follow-ups (LinkedIn → WhatsApp → phone where appropriate) • Communicate professionally and in line with brand guidelines Lead Qualification & Handover • Engage prospects and identify genuine interest • Capture context, needs, and next steps • Pass warm conversations to the Sales Director / Sales Team in English • Maintain clear tracking of outreach and responses ⸻ Ideal Candidate Profile Required • Proven experience as a B2B SDR / Lead Generation Specialist • Hands-on experience with LinkedIn Sales Navigator • Excellent written English • Comfortable with cold outreach (LinkedIn, WhatsApp, calls) • Organised, process-driven, and reliable • Understands professional outreach vs spam Nice to Have • Ability to message in German, French, or Spanish • Experience in industrial, consumer goods, gas, or technical products • Familiarity with multi-channel outbound strategies ⸻ What This Role Is NOT • Not social media management • Not mass automation or scraping • Not high-volume copy-paste outreach • Not closing sales (handover to Sales Team) ⸻ Tools Provided • LinkedIn Sales Navigator • Approved messaging templates & outreach framework • Shared CRM / tracking sheet • WhatsApp Business (web access) ⸻ KPIs (Weekly – 3 Days) • Quality connections sent & accepted • Meaningful replies • Qualified conversations handed to Sales Team ⸻ Compensation • Hourly or fixed monthly retainer (based on experience) • Long-term opportunity for the right person • Performance-based increases possible ⸻ How to Apply Please include: 1. Brief summary of relevant SDR / lead generation experience 2. Confirmation of Sales Navigator experience 3. Languages you can outreach in 4. One short example of a LinkedIn opening message you would use

Build or configure a online bookstore template Nextjs + React

MUST HAVE EXPERIENCE WITH ONIX 3.2 AND HIGH VOLUME BOOKSTORE ============================================================ Looking for an experience web designer to build or configure ready made template super quick within 7 days. You will also connect the database with supplier using FTP ONIX 3.2 for both physical and digital book sales. current website is www.avenuebookstore.com built on magento 2 need it to have a sleek design and arrangement as waterstones.com Scope of Work ============ ONIX 3.1.2 FTP Integration • Establish FTP connection to receive ONIX 3.1.2 XML feeds (physical + digital books). • Parse ONIX metadata (title, ISBN, format, author, categories, price, availability, etc.). • Automate mapping of ONIX fields to Magento product attributes. • Handle media links (e.g., cover images) and ensure correct association. • Set up scheduled data refresh and error reporting (e.g., nightly or on FTP update). Magento Product Sync & Categorisation • Automatically create or update products in Magento based on ONIX data. • Assign products to correct categories, tags, and custom filters for user navigation. • Validate products with missing data and create logic to flag for manual review. • Ensure full compatibility with simple and downloadable product types. Front-End Setup & UX Flow • Create elegant, responsive product listings and detail pages. • Filter systems for format (eBook, paperback, hardcover), genre, publisher, and price range. • Implement breadcrumb navigation and clean SEO-friendly URLs. Full Site Completion • Customise theme for your brand (colors, fonts, layout). • Build all pages: Home, Shop, About, Contact, Terms, Privacy, etc. • Set up customer account area, checkout flow, newsletter signup, search bar, and footer menus. For a site like Waterstones.com, I'd recommend: **Next.js + TypeScript + PostgreSQL + Stripe** ### **Frontend Layer:** ```plaintext Languages: TypeScript, HTML5, CSS3 Framework: Next.js 14 UI Library: React 18 Styling: Tailwind CSS or Styled Components State Management: Zustand or Redux Toolkit Forms: React Hook Form Validation: Zod or Yup ``` ### **Backend Layer:** ```plaintext Runtime: Node.js 18+ Framework: Next.js API Routes Language: TypeScript Authentication: NextAuth.js or Auth0 API Style: REST or GraphQL (with Apollo) Validation: Zod File Upload: Uploadthing or AWS S3 ``` This stack provides: - Excellent performance and SEO - Type safety with TypeScript - Scalable architecture - Modern development experience - Strong community support - Easy integration with payment systems Only apply if you have necessary experience

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.