Google Looker Studio tutorial (2025): automate your marketing dashboards

Video Description

Learn to automate your marketing dashboards with Google Looker Studio. Find all our tutorials and templates: https://portermetrics.com/en/tutorial/looker-studio/ Highlights: 1) Connect data 00:53 Connect GA4 03:06 Connect Meta Ads 04:40 Managing Data Sources 2) Charts 10:20 Metrics and Dimensions 12:26 Scorecards 14:35 Time Series Charts 15:45 Cumulative Time Series 17:02 Tables 19:42 Area Charts 22:24 Scatter Plots - Correlations 24:08 Scatter Plots - Clusters 28:15 Funnel Charts 30:12 Funnels with Tables 31:20 Funnels with Bar Charts 32:42 Community Visualization in Funnels 34:05 Funnel with Images 34:44 Line Charts 37:00 Geo Charts 40:33 Heat Maps with Pivot Tables 41:37 Pivot Tables 42:09 Pie Charts 43:04 Bar Charts 44:39 Gauge & Bullet Charts 46:18 Treemaps 3) Interactive dashboards 47:23 Date Range Controls 49:30 Data Controls 50:08 Drilldowns 51:30 Optional Metrics 52:22 Chart Sliders 53:20 Cross-Filtering 54:00 Export to Google Sheets 55:40 Dropdowns 56:18 Input Boxes 57:12 Buttons 58:34 Filters 4) Data transformation 01:00:36 Data Transformation examples 01:03:00 Date Formats 01:04:10 Currency Data Formats 01:05:53 Text, URLs, and Images 01:06:54 Count and Count Unique Formats 01:08:05 Engagement Rate 01:08:59 Conversion Rate 01:11:55 Data Source-Level Custom Fields 01:14:30 Web Page Title Length Checker 01:15:45 Meta Ad Headline Length Checker 01:16:30 Date Difference Calculation 01:17:57 Conditionals 01:19:25 Regular Expressions 01:22:10 RFM Analysis 01:25:36 Currency Conversion with Parameters 01:28:22 Multi-Account Selection 5) Data Blending 01:30:28 Data Blending examples 01:33:49 PPC Data Blending 01:38:22 Fix Null Values in Blended Data 01:43:06 Fix Missing Dates in Blended Data 01:46:00 Custom Formulas for Data Blending 01:48:10 Cross-Channel Reports for Shopify 01:55:45 Goal Tracking with Data Blending 01:56:52 Currency Conversion in Blended Reports 01:59:02 Calculate Cost and Profit 02:02:18 Join Types or Operators 6) Design and White-Label 02:06:50 Design Elements 02:09:52 Text and Images 02:11:20 Pages and Navigation 02:14:00 Report-Level and Page-Level Style 02:15:40 Conditional Formatting 02:18:09 Copy-Pasting Styles 02:18:30 Shapes and Lines 02:19:38 Themes 02:21:50 Layouts 02:24:09 Aligning Horizontally and Vertically 02:24:25 Modern Charts 7) Sharing Reports 02:24:58 Sharing Reports 02:26:00 Share a Link 02:26:17 Schedule Email Delivery 02:27:35 Download PDF 02:28:20 Embed Reports 02:29:29 Draft Mode 02:30:19 Changelog Course instructor: Juan Bello, founder at Porter, a leading Looker Studio connector startup.