Overview
Start building your own Looker Studio reports using SourceMedium’s out of the box template data sources. Learn how to use our Looker Studio templatesDirectory
| 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 |
| [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 |
| [Demo] Orders | sm_transformed_v2.obt_orders | Contains fully joined order facts and order dimensions | SourceMedium v2 Template |
| [DEMO] Order lines | sm_transformed_v2.obt_order_lines | Contains fully joined order line facts and order line dimensions | SourceMedium v2 Template |
| [DEMO] Customers | sm_transformed_v2.obt_customers | Contains customer facts and dimensions from across sales, email, and subscription integrations | SourceMedium v2 Template |
| [DEMO] Customers With First & Last Orders | sm_views.rpt_customers_first_and_last_order_summary_v1 | Contains customer metadata joined to acquisition & latest order performance | SourceMedium v2 Template |
| [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 |
| [DEMO] Schema Catalog | sm_metadata.rpt_schema_metric_catalog | SourceMedium table & field reference | SourceMedium v2 Template |