Autoplay
Autocomplete
Previous Lesson
Complete and Continue
[EN] Looker Studio Mastery for Marketers & Analysts
Welcome & Course Introduction
1. Meet Your Instructor - Trần Nhật Hải (3:57)
2. How to Get the Most From This Course (1:18)
3. Money-back Guarantee Policy (1:49)
4. Copyright Notice: Unauthorized Reproduction and Use Prohibited Without Author's Consent
Contact Us
MODULE 1: The Importance of Data Analytics for Marketers & Business Owners
1. Why Data Analytics Is No Longer Optional (3:00)
2. The Role of DA (3:24)
3. Benefits of Using Data in Ad Strategy (1:58)
4. Common Mistakes When Ignoring Data (1:43)
5. Tools That Empower Data-Driven Marketing (1:35)
Conclusion: Data is Your Competitive Advantage (1:06)
Quiz
MODULE 2: Using Looker Studio for Ad Data Visualization
1. Why Use Looker Studio for Ad Analysis? (5:50)
2. Connecting Google Sheets to Looker Studio (4:42)
3. Navigating the Looker Studio Interface (7:27)
4. Creating Dimensions and Metrics in Looker Studio (4:24)
5. Setting Up Theme & Layout (10:26)
6. Customize Chart Style (9:29)
7. How to Add and Configure: Table, Scorecard, Time Series, Bar (13:26)
8. How to Add and Configure: Pie, Geo Chart, Line, Area (7:02)
9. How to Add and Configure: Scatter, Pivot Table, Bullet, Treemap, Sankey (7:40)
10. How to Add and Configure: Gauge, Waterfall, Timeline, Funnel (5:15)
11. Adding Interactive Controls: Date Range & Filters (19:22)
12. Creating Basic Metrics & Custom Calculations (6:20)
13. Filter in chart (3:49)
14. Page Management & Responsive Design Tips (4:39)
15. Sharing & Publishing Your Report (5:15)
Quiz
MODULE 3: Advanced Techniques in Looker Studio
1. Advanced Calculations: GROUP, BIN (10:41)
2. Advanced Calculations: CASE WHEN, REGEXP,... (16:16)
3. Conditional Formatting (4:51)
4. Add a Field & Create Parameters for Dynamic Input (9:23)
5. Blend Data from Multiple Sources (14:18)
6. Automating Refresh Data in Looker Studio (2:02)
7. Common Issues & How to Troubleshoot Them (9:28)
Quiz
MODULE 4: Practice – Building an Ad Spend Management Dashboard
1. Objective of This Practice (2:03)
2. Visualizing Ad Spend with Time Series, Bar Chart, and Line Chart (8:46)
3. Ad Spend Scorecard by Platform: Facebook, Google, TikTok (6:14)
4. Advertising Budget Insights by Country, Objective, and Account Status (7:32)
5. Ad Spend Details by Marketer, Product, and Platform (12:32)
MODULE 5: Practice – Facebook Ads Analytics
1. Objective of This Practice (3:44)
2. Prepare Your Facebook Ads Data (5:27)
3. Ad Performance Scorecard Overview (9:13)
4. Cost, Conversion, and ROAS Scorecard Overview (5:43)
5. Ad Spend Trends and Distribution: Line Charts & Pie Charts (5:26)
6. Ad Performance Metrics Table (5:42)
7. Ad Performance Breakdown by Gender and Age: Table & Pie Charts (2:26)
8. Ad Spend Analysis by Hour and Placement (4:44)
9. Ad Performance by Region: Table & Heatmap Visualization (5:59)
Referral Program – Earn by Sharing the Course
1. Referral Program – Earn by Sharing the Course (1:07)
Final Words – Thank You & What’s Next
1. Thank You for Joining This Learning Journey (2:21)
1. Meet Your Instructor - Trần Nhật Hải
You can download the
Teachable
app to study on your phone.
Complete and Continue
Discussion
0
comments
Load more
0 comments