Ecommerce Reports and Forecasting Specialist (Google Sheets & Automations)

GOOGLE SHEETS AUTOMATIONS & DATA VISUALISATION SPECIALIST ABOUT US We are a fast-growing UK-based e-commerce brand selling 41 individual SKUs plus several bundled “alias” SKUs. A large share of revenue comes from subscriptions, so retention and churn data are critical. EXISTING SET-UP • Google Sheets forecasting model fed by: – Shopify order data (Matrixify export) – Paid-media spend (Supermetrics “2-Minute Reports”) • Feeds are fragile, churn logic incomplete (Recharge issues) and dashboards could be sharper. THE PROJECT HARDEN & EXTEND DATA FEEDS • Automate or stabilise imports from Shopify, paid-media sources and Recharge. • Build any missing integrations so data lands in Google Sheets cleanly, on schedule and without manual fixes. REFACTOR FORECAST WORKBOOK • Replace hard-coded figures with dynamic formulae. • Ensure all 41 SKUs (plus bundles) forecast units and revenue accurately over a 24-month horizon. • Layer in SKU-level churn and repurchase logic for subscriptions and one-time purchases. ADD BUSINESS-DRIVING METRICS • Rolling 4- and 12-week churn by product. • Auto-calculated future marketing spend required to hit unit targets, based on target CAC and projected new-customer needs. • LTV vs CAC projections (revenue and margin). • Repurchase rates, cohort analyses, product-variant mix, subscription vs one-time trends and other key insights. DELIVER DASHBOARDS • Preferred: Looker Studio. Acceptable: advanced Google Sheets charts. • Visuals must update automatically with refreshed data. PROVIDE ONGOING SUPPORT • Ad-hoc tweaks, new requirements and additional data sources. MUST-HAVE SKILLS • Expert-level Google Sheets (ARRAYFORMULA, QUERY, INDEX-MATCH, Apps Script, etc.). • Experience automating data imports and integrations (API calls, Supermetrics, Zapier/Make, Google Cloud Functions or similar). • Solid understanding of e-commerce data (orders, SKUs, bundles, subscriptions, churn). • Strong analytical mindset; able to turn raw data into reliable forecasts. • Clear written English and ability to document work for non-technical stakeholders. NICE-TO-HAVES • Shopify, Recharge and paid-media platform experience. • Looker Studio dashboard design. • Familiarity with subscription metrics (MRR, churn cohorts, retention curves). BUDGET Open to proposals. Please quote a total for Phases 1-3 and your hourly or retainer rate for ongoing work. Value for money beats headline price. HOW TO APPLY • Short note describing relevant experience and why you’re a good fit. • Links or screenshots of comparable Sheets or Looker Studio dashboards (redacted is fine). • Confirmation you can start within the next fortnight and hit the timeline above. We’ll review applications on a rolling basis and aim to hire by within 7 days of posting, please start your proposal with the word forecast so we know you read this. Questions welcome—just drop them in your proposal.