Looker Studio - Data Source Template Directory

Overview

Start building your own Looker Studio reports using SourceMedium’s out of the box template data sources.

Data Source	Table Name(s)	Description	Present on (templates)
[DEMO] Executive Summary	`sm_transformed_v2.rpt_executive_summary_daily`	Contains daily aggregated metrics across all of the data sources integrated with SourceMedium	SourceMedium v2 Template Executive Summary
[DEMO] Marketing Performance	`sm_transformed_v2.rpt_ad_performance_daily`	Contains daily advertising performance data from all advertising platforms integrated with SourceMedium	SourceMedium v2 Template Paid Marketing Summary Creative Performance
[Demo] Orders	`sm_transformed_v2.obt_orders`	Contains fully joined order facts and order dimensions	SourceMedium v2 Template Sales & Orders
[DEMO] Order lines	`sm_transformed_v2.obt_order_lines`	Contains fully joined order line facts and order line dimensions	SourceMedium v2 Template Product Performance
[DEMO] Customers	`sm_transformed_v2.obt_customers`	Contains customer facts and dimensions from across sales, email, and subscription integrations	SourceMedium v2 Template Data Quality
[DEMO] Customers With First & Last Orders	`sm_views.rpt_customers_first_last`	Contains customer metadata joined to acquisition & latest order performance	SourceMedium v2 Template Customer Data Explorer
[DEMO] Data Quality Test Results	`sm_metadata.rpt_data_quality_test_results`	Test results for the various data quality checks performed on your data	SourceMedium v2 Template Data Quality
[DEMO] Schema Catalog	`sm_metadata.rpt_schema_metric_catalog`	SourceMedium table & field reference	SourceMedium v2 Template Data Catalog