🔧 Implementation Steps

1. Data Connection
   • Connected Google Analytics 4 property to a new Looker Studio report.
   • Verified data source by confirming traffic metrics (Users, Sessions) populated.
2. Base Table Setup
   • Added a Table chart with:
     • Dimension: Event name
     • Metric: Event count
   • Displayed all GA4 events (system + custom).
3. Filter Creation
   • Created a new filter named Key Events Only.
   • Filter logic:
     • Include Event name = cta_click
     • OR Event name = subscribe_click
     • OR Event name = form_submission.
4. Filtered Table Setup
   • Duplicated the base table and applied the Key Events Only filter.
   • Resulting table displayed only portfolio-specific events.
5. Validation
   • Confirmed counts in Looker Studio matched GA4 DebugView and Events reports.
   • Ensured other system events (e.g., page_view) were excluded.
6. Funnel Reporting
   • Added three Scorecards to the Engagement Funnel dashboard.
   • Metrics: Total Users, Total Events, and custom Scroll-to-Page View Ratio.
   • Created a calculated field using COUNT(CASE WHEN…) formula to compute the conversion rate.

✅ Results

• Built a clean, stakeholder-ready table showing only business-critical conversion events.
• Isolated cta_click, subscribe_click, and form_submission for clear reporting.
• Enabled easier tracking of conversion funnel activity without noise from irrelevant GA4 system events.

📸Screenshots