1. Template 6 page Looker Studio cho Google Ads
- Overview: scorecard (spend, conv, CPA, ROAS), trend line 90 ngày.
- Campaigns: table top campaign + heatmap day-of-week.
- Keywords: search term report + Quality Score distribution.
- Audiences: demographic breakdown + audience performance.
- Landing Pages: CR per URL + bounce rate + Core Web Vitals.
- Goals & Conversions: funnel + conversion path.
2. Blended data Google Ads + GA4 + CRM
Join key chuẩn cho blend:
- Google Ads → GA4: join trên date + campaign_name.
- GA4 → CRM: join trên user_id (Client ID GA4).
- Google Ads → CRM: join trên gclid (cần Enhanced Conversions for Leads).
3. Calculated fields hữu ích 2026
- Real CPA = Spend / Qualified_Leads (từ CRM)
- Real ROAS = CRM_Revenue / Spend
- LP CR = Form_Submit / LP_View
- Profit = Revenue - Spend - Product_Cost
- DOW = WEEKDAY(Date) cho heatmap
