Google Sheets E-commerce Data Analyst
Budget: £10 – £15 GBP
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.
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.
Related categories:
PHP
JavaScript
Data Entry
Excel
Shopify
Data Visualization
Data Analysis
Google Sheets
API Integration
Google Data Studio