D2C Looker Studio Dashboard

I need our scattered Direct-to-Consumer data pulled together into a single, reliable Google Looker Studio (Data Studio) workspace that my management team can open each morning and instantly understand how the business is performing.

Scope
• Combine four lenses—sales, marketing, inventory and customer behaviour—into one cohesive report.
• Connect live data from Google Analytics, Meta Ads (Facebook/Instagram), Google Ads, our logistics partner’s feed, plus a manual inventory sheet (CSV/Google Sheet). If a community or partner connector is required, build or recommend it.
• Design intuitive pages and filters so senior management can drill from a high-level overview into SKU, campaign or cohort detail without needing analyst support.

Key views I expect
– Daily, weekly and monthly sales with YoY and MoM deltas
– ROAS, cost per acquisition and funnel drop-offs for each paid channel
– Customer cohorts and LTV trends
– Real-time inventory position with low-stock alerts matched to marketing velocity
– Order-to-delivery timeline visualised from the logistics feed

Deliverables
1. Fully-functional Looker Studio report with branded styling and shareable link
2. All data connectors or scheduled uploads configured and documented
3. Custom calculated fields/scripts for metrics such as blended ROAS and inventory cover days
4. One-page hand-off guide (PDF or doc) so the team can update or extend the dashboard later

Acceptance
The dashboard must refresh automatically on the chosen schedule, load in under 10 seconds on a standard laptop, and display correctly on desktop and tablet. Once those boxes are ticked, we’ll sign off.