Looker Studio (Google Data Studio) + Supermetrics Expert for Multi-Location Client Reporting

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