DTC Analytics Expert for Custom Revenue Modeling Dashboard

---

---

We’re a fast-growing DTC brand seeking a data analytics expert to build a custom dashboard that models marketing spend and revenue by channel. The goal is to get real clarity on what’s working (and what’s not), optimize spend, and enable scenario planning for growth. Scope of Work: Ingest & automate data from Shopify, Meta, Google Ads, and other platforms (APIs, CSVs, or automated connectors—your call). Build a dashboard (Google Sheets or excel that: Tracks spend, revenue, and efficiency (MER, ROAS, incremental revenue per channel) by week/month Models incremental revenue per $1 spent, and forecasts the impact of shifting spend between channels Supports basic marketing mix modeling (MMM) or scenario testing (“What happens if I increase spend on Meta 20%?”) Data hygiene: Clean, transform, and validate data for accuracy and easy updating. Visualization: Clear charts and tables that make trends and outliers obvious. Documentation: Instructions for ongoing use by a non-technical team. Requirements: Proven experience in DTC/e-commerce analytics (Shopify data preferred) Hands-on experience building channel attribution, MMM, or cohort models Fluent in Google Sheets/Excel Strong communicator—can explain what the data means for decision-making Bonus: Experience with SQL or Python for data wrangling To Apply: Share 1–2 examples of similar dashboards you’ve built (screenshots or Loom demo preferred) Briefly outline how you’d approach the project, tools you’d recommend, and estimated timeline

Keyword: Data Analysis

Price: $15.0

Data Analysis Data Visualization Microsoft Excel Google Analytics Analytics