Skip to main content

Dashboards your team can use on day one, and build on later.

Start with copyable, editable Looker Studio templates built on SourceMedium's governed schema. Fork them, customize them, or connect another BI tool.

Production-grade
Fully editable
Bring your own data
Portable

Three dashboard workflows

Monitor, diagnose, and explore.

Start with an executive view for recurring decisions, move into focused diagnostic views when a metric changes, and inspect the underlying customer, order, and product detail when you need to go deeper.

7 reporting modules with 20 documented views.

Explore template

Executive Pace Board

Align weekly decisions around one KPI, trend, and variance view.

Executive Summary
Executive Summary view with KPI cards for revenue, AOV, CAC, and new customers
KPI snapshot cards.

Weekly KPI pacing and variance signals for faster leadership calls.

  • Which KPI cards are off weekly plan, and by how much?
  • Are daily trend lines signaling a real shift or short-term noise?
  • Which rows in the exportable table explain variance fastest?

Reporting backed by the maintained data foundation

SourceMedium
delivers
BI Layer
Looker Studio
+
Data Layer
BigQuery
on
Google Cloud Platform

A reporting layer you can adapt.

SourceMedium uses Looker Studio to deliver copyable dashboards on top of the same governed BigQuery data used across the platform.

Built on governed data

Every module uses the same maintained commerce definitions as direct SQL and the AI Analyst.

Copyable and editable

Start with SourceMedium modules, then copy and adapt them to your own operating cadence.

Share without per-viewer BI fees

Give stakeholders access to the reporting they need without adding a separate seat for every viewer.

Modules for recurring decisions

Executive, growth, customer, product, retention, finance, and operations views stay grounded in one model.

Compatible with your workflow

Reporting is backed by BigQuery, so your team can also use other compatible tools when the workflow calls for it.

Maintained underneath

SourceMedium manages the integrations, models, checks, and schema changes that keep reporting dependable.

FAQ

Answers to the most common questions about the templates, implementation, and how teams adapt them.

Can I edit these dashboards?
Yes. You fork a copy into your own Google account and open Edit Mode in Looker Studio: add charts, rearrange layouts, create calculated fields, and build custom formulas like AOV or YoY growth. It's a real BI tool, not a locked view.
Can we bring in additional data?
Yes. Data sources are additive: connect any BigQuery-compatible source, Google Sheets, or GA4 alongside your existing modules. Your current dashboards keep working while you layer in new sources.
Will numbers match Shopify and ad platforms exactly?
Not always. Source APIs, time zones, attribution settings, and definitions can differ. SourceMedium reconciles those differences and documents why a number does or does not match.
What happens if we ever leave?
Modeled data already delivered to BigQuery, copied dashboard reports, customer-built SQL, and delivered documentation remain usable. SourceMedium-managed refreshes stop after offboarding. To keep receiving fresh data, move the retained assets to a customer-managed BigQuery instance.
How is this faster than building from scratch?
You start with maintained modules running on stable definitions, not a blank BigQuery project. Teams begin with a working foundation instead of assembling tools before anyone trusts the numbers.
Can my whole team access the dashboards?
Dashboards use a centrally managed data-source credential, so approved viewers can filter reports without individual BigQuery setup. Edit access is granted separately to approved editors.

Dashboard customers

What dashboard customers say

“The open-source dashboard templates provided by SourceMedium are simply the best in the business. The ability to fully customize and edit these dashboards internally has given our teams the flexibility and agility they need to make informed decisions quickly on behalf of our clients.”

“SourceMedium is our command center; it helps us identify problems before they get bigger. It's easy enough for everyone on the team to use, and it empowers all people.”

“Thanks to SourceMedium, our team no longer wastes time debating metric definitions in meetings. Instead, we can focus on what really matters: making informed, data-driven decisions that drive results.”

Ready to stop debating the numbers?

Book a platform walkthrough

In a 30-minute walkthrough, we'll review your current data stack, show how SourceMedium would replace or complement it, and demonstrate workflows relevant to your business.