Build a monthly sales report in Looker Studio
- Budget
- You set this
- Timeline
- 2-3 weeks
- Category
- Data & analytics
Scope
Our monthly sales report is built by hand from HubSpot and Shopify exports. We want it rebuilt in Looker Studio with a daily refresh: revenue by channel and product, new versus returning customers, and pipeline by stage, shared with the leadership team.
Deliverables
- Agreed metric definitions
- Looker Studio report with four pages
- Daily refresh from HubSpot and Shopify
- Access set up for the leadership team
- Handover call and notes
Skills
- Looker Studio
- Data modelling
- HubSpot
- Shopify