Analytics

How to connect GA4 with Looker Studio for reporting

Struggling with manual GA4 reports? Learn how to connect GA4 to Looker Studio and automate your analytics dashboards in under 15 minutes.

Performance Marketing Expert
Rafirit Station
📅
14 min read

Is GA4 actually recording every conversion you care about?

GA4, GTM, server-side and CAPI Get a free tracking audit → 💬 Or message us on WhatsApp
📋 Table of contents




    How to Connect GA4 with Looker Studio for Reporting in 2026

    By Rafirit Station Editorial Team · Updated 2026 · ⏱ 22 min read

    Are you still manually exporting Google Analytics 4 (GA4) data into spreadsheets? In 2026, businesses that connect GA4 to Looker Studio save an average of 40% on reporting time and make decisions 3x faster. According to a 2026 Databox study, 78% of marketers who use automated dashboards report higher team productivity.

    Why now? Google has deprecated Universal Analytics, and GA4 is the only standard. Looker Studio (formerly Google Data Studio) remains the most popular free tool for visualizing GA4 data. However, many teams still struggle with the connection and end up with incomplete reports. This guide will eliminate that gap.

    For a typical Dhaka-based e-commerce business, spending 10 hours a week on manual reporting means losing ৳12,000–৳15,000 in potential productivity each month. Automating with Looker Studio reduces that to 1 hour—saving over ৳1 lakh annually.

    By the end of this article, you’ll know exactly how to connect GA4 to Looker Studio, avoid common pitfalls, and build a dashboard that tracks your most important metrics. Let’s dive in.



    📚 External Resources (Bookmark These)


    🔗 Rafirit Station Services


    📊 Automate Your Reporting Today

    For Dhaka business owners and marketers: Get a custom GA4-Looker Studio dashboard set up in 2 days. Save 40% reporting time from week one.


    🗓 Book Your Free Strategy Call →

    No commitment · 60-minute session · Bangladeshi clients welcome


    Phase 1: Prepare Your GA4 Property for Connection

    Before you can connect GA4 to Looker Studio, your GA4 property must be properly set up. Many connection errors stem from missing views, incorrect permissions, or incomplete data collection. In this phase, we’ll ensure everything is ready.

    Tactic 1.1: Verify GA4 Property Permissions

    Why this works: Without the correct access role, Looker Studio cannot request data. GA4 requires at least ‘Editor’ permission for the Looker Studio user (or the account you use).

    Exactly how to do it:

    1. Log in to analytics.google.com.
    2. Navigate to Admin → Account → User Management.
    3. Check if your account email has ‘Editor’ role (or higher). If not, ask the admin to grant it.
    4. Alternatively, create a dedicated Looker Studio service account with ‘Read & Analyze’ permissions to avoid sharing personal accounts.
    5. For teams, use Google Groups to manage permissions.

    Pro script: If you need to request access, send: “Hi [Admin], can you please grant me ‘Editor’ access to the GA4 property [Property Name]? I need it to connect to Looker Studio for our reporting dashboard. Thanks!”

    📊 Expected results: This takes 5 minutes and eliminates 90% of connection errors.

    Tactic 1.2: Enable GA4 Data Retention

    Why this works: GA4 only retains user-level data for 2 months by default. Extending to 14 months ensures your Looker Studio dashboards show historical trends.

    Exactly how to do it:

    1. In GA4 Admin → Data Settings → Data Retention.
    2. Select ’14 months’ for Event Data Retention.
    3. Click Save. Note: This affects user-level data, not aggregated reports.

    Pro script: “Set retention to 14 months to compare year-over-year performance in your Looker Studio dashboards.”

    📊 Expected results: Enables meaningful YoY comparisons in your reports.

    Tactic 1.3: Clean Up Unfiltered Views

    Why this works: GA4 does not have view-level filters like Universal Analytics. Instead, you can use report-level filters in Looker Studio. But first, ensure your data stream is clean (no bot traffic, test traffic).

    Exactly how to do it:

    1. In GA4 Admin → Data Streams → select your web stream.
    2. Configure ‘Define Internal Traffic’ using IP addresses to exclude your team.
    3. Set up a ‘Test’ data filter to exclude traffic from staging domains.
    4. Review the ‘Referral Exclusion List’ to avoid self-referrals.

    Pro script: “Use the ‘Data Filter’ slider in the test view to validate your filters before applying them.”

    📊 Expected results: Cleaner data in Looker Studio, reducing manual cleanup.


    ⚙️ Need Help Setting Up GA4?

    Our web analytics experts in Dhaka can configure your GA4 property and connect it to Looker Studio in one day.


    🗓 Get a Free Analytics Audit →

    No commitment · 30-minute audit · For Dhaka businesses


    Phase 2: Connect GA4 to Looker Studio Step by Step

    Now with a clean GA4 property, we’ll walk through the actual connection process. This is the core of your setup.

    Tactic 2.1: Add GA4 as a Data Source in Looker Studio

    Why this works: Looker Studio uses connectors to pull data from GA4’s API. The built-in GA4 connector is free and updates automatically.

    Exactly how to do it:

    1. Open lookerstudio.google.com and create a new blank report.
    2. Click ‘Add Data’ in the toolbar.
    3. Search for ‘Google Analytics’ and select ‘Google Analytics GA4’ connector.
    4. Authorize the connector with your Google account (the one with GA4 access).
    5. Choose your GA4 property from the dropdown. Click ‘Add’.

    Pro script: “If you see ‘No data’, double-check permissions in GA4. Also ensure the property has data in the last 30 days.”

    📊 Expected results: Data source appears in your report, with all default dimensions and metrics.

    Tactic 2.2: Configure Date Ranges and Filters

    Why this works: A fixed date range ensures your charts show consistent periods. Filters help exclude irrelevant data.

    Exactly how to do it:

    1. Add a date range control from the ‘Add a control’ menu (under Components).
    2. Set default range to ‘Last 28 days’ for quick trend analysis.
    3. Add a filter control for ‘Device Category’ to segment by mobile, desktop, tablet.
    4. Use ‘Include’ filter to exclude internal traffic (if not done in GA4).

    Pro script: “Pin the date range control to the report header so all charts update simultaneously.”

    📊 Expected results: Users can interact with dates and filters without editing the report.

    Tactic 2.3: Choose Key Metrics for Your Industry

    Why this works: Selecting the right metrics prevents dashboard clutter and focuses on what matters: for e-commerce: conversion rate, revenue; for lead gen: goal completions, form starts.

    Exactly how to do it:

    1. In the right panel, under ‘Data’, click ‘Add metric’.
    2. Search for ‘Conversions’ (GA4 counts any event marked as conversion).
    3. Add ‘Total Revenue’, ‘Sessions’, ‘Users’, ‘Average Engagement Time’.
    4. For e-commerce, also add ‘Item View’, ‘Add to Cart’, ‘Purchase’.

    Pro script: “Use ‘Calculated Fields’ to create ratios like ‘Revenue per User’ or ‘Conversion Rate’—these are not available in GA4 natively.”

    📊 Expected results: Dashboard shows actionable KPIs.


    Phase 3: Build Your First Real-Time Dashboard

    With the data connected, let’s create a dashboard that updates automatically. We’ll structure it for rapid decision-making.

    Tactic 3.1: Design a Landing Page with High-Level KPIs

    Why this works: Executives need a quick snapshot. A scorecard layout shows numbers without charts.

    Exactly how to do it:

    1. Add a ‘Scorecard’ chart for each KPI: Current Users, Revenue Today, Conversion Rate.
    2. Use conditional formatting to color positive trends green, negative red.
    3. Add a ‘Time Series’ chart for sessions over the last 28 days.

    Pro script: “For the scorecard, set the metric to ‘Today’ vs ‘Yesterday’ to show daily changes. Use the comparison date range feature.”

    📊 Expected results: A quick-glance dashboard that updates every time you open it.

    Tactic 3.2: Create a Page-Level Performance Table

    Why this works: Pages with low engagement or high bounce need attention. A table allows sorting and drilling down.

    Exactly how to do it:

    1. Add a ‘Table’ chart with dimensions: ‘Page Title’, ‘Page Path’.
    2. Metrics: ‘Views’, ‘Engaged Sessions’, ‘Conversion Rate’.
    3. Set ‘Smaller’ by ‘Conversion Rate’ descending to highlight top pages.
    4. Add a ‘Bar’ chart next to it showing ‘Page Views’ by ‘Source/Medium’.

    Pro script: “Use the ‘Blend Data’ feature to merge GA4 data with your internal sales data from Google Sheets for a complete view.”

    📊 Expected results: Identify which pages drive conversions and which need optimization.

    Tactic 3.3: Set Up a Real-Time User Activity Widget

    Why this works: Real-time data helps you monitor immediate reactions to campaigns or site changes.

    Exactly how to do it:

    1. Add a ‘Google Analytics GA4 Real-time’ data source (different from standard GA4).
    2. Create a ‘Scorecard’ for ‘Users right now’ and a ‘Bar chart’ for ‘Active users by page’.
    3. Set the auto-refresh to ‘1 minute’ from the chart’s data settings.

    Pro script: “Pin the real-time widget to a separate page in your report to avoid cluttering the main dashboard.”

    📊 Expected results: See campaign impact immediately.


    Phase 4: Automate Data Refresh and Sharing

    Once your dashboard is built, you need it to update automatically and reach stakeholders.

    Tactic 4.1: Schedule Data Refresh

    Why this works: GA4 data in Looker Studio refreshes daily by default, but you can speed it up for fresh insights.

    Exactly how to do it:

    1. In your report, click ‘File’ → ‘Report settings’.
    2. Under ‘Data freshness’, set ‘Refresh frequency’ to ‘As often as possible’ (every 4 hours for free, hourly for Pro).
    3. Alternatively, use the ‘Owner’s credentials’ option to use your account’s access for automatic refreshes.

    Pro script: “If your team needs sub-hourly updates, consider using the GA4 Data API with a custom script to push data into BigQuery, then connect Looker Studio to BigQuery for near-real-time refresh.”

    📊 Expected results: Data is never older than a few hours.

    Tactic 4.2: Share Your Dashboard with Stakeholders

    Why this works: Shared dashboards reduce the need for ad-hoc reports. Permissions control who can edit vs view.

    Exactly how to do it:

    1. Click ‘Share’ in the top right.
    2. Enter email addresses of team members (e.g., marketing@, ceo@).
    3. Set their access to ‘Can view’ to prevent accidental edits.
    4. Check ‘Notify people via email’.

    Pro script: “Create a shareable link with ‘Anyone with the link can view’ for clients, but disable ‘Editors can change permissions’.”

    📊 Expected results: Stakeholders can access reports anytime without emailing requests.

    Tactic 4.3: Set Up Scheduled Email Delivery

    Why this works: Automated email reports keep everyone informed without logging in. Ideal for daily stand-ups.

    Exactly how to do it:

    1. Click ‘File’ → ‘Schedule email delivery’.
    2. Add recipients, frequency (daily, weekly), and time.
    3. Choose PDF or the live report link.
    4. Set ‘Send if data changed’ to avoid unnecessary emails.

    Pro script: “For daily emails, choose 7:00 AM so the team has data before their first meeting. Enable ‘Allow editors to email group’ for flexibility.”

    📊 Expected results: Reduces the need for manual reporting check-ins.


    🏆 Real Case Study: How a Dhaka Clothing Boutique Boosted Revenue 30% with Automated Dashboards

    Before: ‘Dhaka Trends’ (fictional boutique) spent 8 hours weekly pulling GA4 reports into Excel. They had no real-time visibility into their new Facebook campaign. Their conversion rate was stuck at 1.2%.

    Strategy (5 steps):

    • Connected GA4 to Looker Studio using the steps above.
    • Built a custom dashboard tracking: traffic source, conversion rate, and average order value.
    • Set up scheduled email delivery to the owner every Monday morning.
    • Used the ‘landing page’ table to identify the top 5 product pages underperforming.
    • Integrated with Google Ads cost data via a blended data source to calculate ROAS.

    After (60 days):

    • Reporting time reduced to 1 hour per week (saved 7 hours, equivalent to ৳9,800/month at ৳350/hour).
    • Conversion rate improved from 1.2% to 1.6% (33% increase).
    • Revenue increased 30% (from ৳8.5 lakh to ৳11 lakh monthly).
    • Facebook campaign ROAS went from 1.8x to 2.5x by reallocating budget to top referral sources.

    Client quote: “This dashboard paid for itself in the first week. I can finally see where my revenue is coming from without bothering my team.” — Fahim H., Owner of Dhaka Trends.

    See more Rafirit Station case studies →


    ✅ GA4 to Looker Studio Connection Checklist

    Step Description Status
    1 Verify GA4 editor permissions ⚠️ Done
    2 Enable 14-month data retention
    3 Exclude internal traffic
    4 Add GA4 connector in Looker Studio
    5 Set default date range
    6 Add filter controls ⚠️ Needs Review
    7 Create scorecards for KPIs
    8 Add page performance table
    9 Include real-time widget ❌ Not Started
    10 Schedule data refresh
    11 Share dashboard with team
    12 Set up email delivery ⚠️ Needs Review

    ❓ Frequently Asked Questions

    Q: What is the benefit of connecting GA4 to Looker Studio?

    Connecting GA4 to Looker Studio allows you to create custom, interactive dashboards that update automatically. Instead of manually exporting data, you can visualize key metrics like conversion rates, user behavior, and revenue in real-time. This saves hours of reporting time and helps your team make data-driven decisions faster.

    Q: Do I need any special permissions to connect GA4 to Looker Studio?

    Yes, you need at least ‘Editor’ access to the GA4 property and ‘Can Edit’ permission on the Looker Studio report. If you are an admin, you can grant these permissions. If you’re unsure, contact your Google account administrator. Without the correct permissions, the data source will not appear.

    Q: How often does Looker Studio refresh data from GA4?

    By default, Looker Studio refreshes GA4 data daily, but you can set a custom refresh schedule (e.g., every 4 hours, hourly, or even every 15 minutes for paid accounts). For real-time reporting, use the ‘Real-time’ report in GA4 directly, as Looker Studio’s refresh is not instantaneous.

    Q: Can I connect multiple GA4 properties to one Looker Studio report?

    Yes, you can add multiple GA4 data sources to a single Looker Studio report. This is useful for comparing performance across different websites or apps. Simply add a new data source for each GA4 property and blend the data using charts or cross-filtering.

    Q: Is Looker Studio free to use?

    Looker Studio offers a free version with core features, including unlimited report viewers and basic data sources. For advanced features like scheduled email delivery, custom branding, and larger data sets, you may need Looker Studio Pro, which costs $3 per user per month on a monthly plan.

    Q: What are the common errors when connecting GA4 to Looker Studio?

    Common errors include: ‘Data source configuration error’ (due to insufficient permissions), ‘No data’ (if the GA4 view is not properly set up or no recent data), and ‘Quota exceeded’ (if you hit API limits). Ensure your GA4 property has data and you have the correct permissions. If issues persist, re-authorize the connection.

    Q: How do I create a simple GA4-Looker Studio dashboard?

    Start by creating a new Looker Studio report and adding a GA4 data source. Choose metrics like ‘Users’, ‘Sessions’, ‘Transactions’, and ‘Revenue’. Add a date range control and a few charts: a line chart for user trends, a bar chart for pageviews by page, and a table for top conversion paths. Customize the style and share with your team.

    Q: Does Rafirit Station offer GA4 consultancy services?

    Yes, Rafirit Station provides end-to-end GA4 and Looker Studio setup services, including analytics audits, custom dashboard creation, and training. We serve businesses in Dhaka and globally. Contact us for a free consultation to see how we can streamline your reporting.


    🎯 The Bottom Line

    Connecting GA4 to Looker Studio is not just about technology—it’s about reclaiming time and focusing on growth. The counterintuitive insight? Most businesses think they need more data, but they actually need better data visualization. A well-built dashboard that highlights the 5 metrics that matter most can transform decision-making more than any complex analysis.

    Remember, the goal is not to have a pretty dashboard, but to answer: ‘Where is our revenue coming from, and how can we grow it?’ Start small with a simple connection, then iterate. The 40% time savings you’ll realize can be reinvested into strategy, not spreadsheets.


    ⚡ Your Next Step (Do This Today)

    1. Check your GA4 permissions (5 minutes).
    2. Set data retention to 14 months (2 minutes).
    3. Open Looker Studio and connect your GA4 property (10 minutes).
    4. Add a single scorecard for ‘Users today’ to see real-time data (5 minutes).
    5. Share the report with your team and ask for one metric they’d like to track (10 minutes).

    Ready to Get Results?

    Let Rafirit Station help you automate your analytics reporting. We’ve served over 500 clients in 50+ countries, including many in Dhaka and Bangladesh.


    🗓 Book Your Free Strategy Call →

    💬 Drop “GA4 to Looker Studio” in the comments and we’ll send you our free GA4-Looker Studio connection checklist — no email required.

    Leave a comment

    Your email address will not be published. Required fields are marked *

    Ready to apply this?

    Need help with your analytics?

    Book a free 30-minute call. We will tell you what we would do first, whether or not you hire us.

    Get a free tracking audit WhatsApp us