I run a marketing agency managing paid social (Meta Ads) and organic social for multi-location brands (currently scaling to 100–175+ locations). I’m looking for an experienced Looker Studio + Supermetrics expert to build a clean, scalable reporting system that I can duplicate across all client accounts. Scope of Work: Build a master Looker Studio template for client reporting Connect and structure data using Supermetrics (Meta Ads, Instagram, Google if needed) Create a system that allows easy duplication per client/location Set up dashboards for: Ad performance (Meta) Social media growth (IG/FB) Top creatives (ads + posts) Ensure fast load times and clean data blending Optional: create a summary dashboard for corporate-level reporting across all locations Key Requirements: Strong experience with Looker Studio (Google Data Studio) MUST have experience using Supermetrics Experience with Meta Ads reporting dashboards Experience building templates for agencies or multi-location brands Ability to simplify complex data into clean, client-friendly dashboards Nice to Have: Experience with franchises or multi-location reporting GA4 / Google Ads dashboard experience Ability to advise on best reporting structure Deliverables: 1 master template dashboard Instructions on how to duplicate and connect new client accounts (Optional) Loom walkthrough video Budget: Open to hourly or fixed (please include estimate) To Apply: Please include: Examples of dashboards you’ve built (especially with Supermetrics) Brief explanation of how you’d structure reporting for 100+ client accounts Your availability this week