Looker Studio - Template Directory - SourceMedium

The SourceMedium v2 Template is the base report you copy during onboarding. It is built from the data sources below; each data source is a Looker Studio view of one SourceMedium table. Copy the whole report, or copy a single data source to build your own report. See how to copy a template.

Data sources

Data source	Table	What it contains	Used on template page
[DEMO] Executive Summary	`sm_transformed_v2.rpt_executive_summary_daily`	Daily aggregated metrics across every data source connected to SourceMedium	Executive Summary
[DEMO] Marketing Performance	`sm_transformed_v2.rpt_ad_performance_daily`	Daily advertising performance from every connected ad platform	Paid Marketing Summary, Creative Performance
[Demo] Orders	`sm_transformed_v2.obt_orders`	Fully joined order facts and order dimensions	Sales & Orders
[DEMO] Order lines (alternate: second copy)	`sm_transformed_v2.obt_order_lines`	Fully joined order line facts and order line dimensions	Product Performance
[DEMO] Customers	`sm_transformed_v2.obt_customers`	Customer facts and dimensions from sales, email, and subscription integrations	Data Quality
[DEMO] Customers With First & Last Orders	`sm_views.rpt_customers_first_and_last_order_summary_v1`	Customer metadata joined to acquisition and latest order performance	Customer Data Explorer
[DEMO] Data Quality Test Results	`sm_metadata.rpt_data_quality_test_results`	Results of the data quality checks run on your data	Data Quality
[DEMO] Schema Catalog	`sm_metadata.rpt_schema_metric_catalog`	SourceMedium table and field reference	Data Catalog