Looker Studio dashboard: build and share interactive reports

Key takeaways

Looker Studio is a free, code-free tool that turns GA4, BigQuery, and Google Sheets data into shareable interactive reports, with a paid Pro tier for teams that need enterprise governance.

Point Details Free to use Looker Studio is free for creators and viewers; costs arise from BigQuery queries or paid connectors. Five-step build sequence Create report → add data source → add date control → add charts → share with correct permissions. Chart choice matters Match chart type to the question: scorecards for KPIs, time series for trends, tables for multi-metric breakdowns. Design for decisions Place KPIs at the top, one question per chart, and test mobile layout before sharing. Project-pixel builds it for you Project-pixel delivers analytics-ready websites with Looker Studio dashboards configured from day one, at a fixed price.

***

How does Looker Studio connect to your data sources?

Looker Studio pulls data through connectors, and the built-in Google connectors are where most people start. GA4, BigQuery, Google Sheets, and Google Ads all connect natively with no extra setup beyond granting access. For everything else, over 1,300 community connectors cover platforms from Shopify to HubSpot to Facebook Ads.

Adding a data source takes five steps:

The official report editor documentation notes that you can also add further data sources later from the toolbar under Resource → Manage added data sources, which is useful when you need to blend two feeds on the same page.

Common connector choices at a glance:

Pro Tip: *Match your sharing settings to your data source permissions. If a viewer cannot access the underlying Google Sheet or GA4 property, they will see a "No data" error. Use a shared data source with a service account to give all viewers consistent access without exposing individual credentials.*

***

• 01Open Looker Studio and click Create → Report.
• 02The "Add data to report" panel opens automatically. Select the Connect to data tab.
• 03Choose your connector (for example, Google Analytics 4).
• 04Sign in and configure credentials, then select the correct property or dataset.
• 05Click Add to report to confirm.
• 06GA4 - sessions, users, conversions, and event data direct from your Google Analytics property.
• 07BigQuery - large-scale or custom datasets; queries run on demand, so watch for usage costs.
• 08Google Sheets - the fastest way to bring in manual data, targets, or offline spend figures.
• 09CSV upload - one-off imports; not live, so refresh manually when data changes.
• 10Community connectors - third-party platforms; some are free, others carry a monthly fee.

Which chart types should you use, and when?

The chart type is not decoration; it is an argument. Pick the wrong one and the data misleads rather than informs.

Chart types and their best use cases:

Metrics vs dimensions is the distinction that trips up most beginners. A *dimension* is a descriptive attribute: Channel, Country, Page Title. A *metric* is a number: Sessions, Conversions, Revenue. Every chart needs at least one of each.

Calculated fields let you create derived metrics the connector does not supply natively. A simple example: divide Conversions by Sessions and format as a percentage to get Conversion Rate. Write it as Conversions / Sessions in the calculated field editor.

A word on data blending: blending joins two data sources on a shared key, such as Date or Campaign Name. The pitfall is double-counting when the join key is not unique across both sources. Before publishing a blended chart, cross-check the totals against each source individually.

Pro Tip: *Add a comparison date range to every scorecard. Set the comparison period to "Previous period" and Looker Studio automatically calculates the delta and colours it green or red. Viewers get context without needing to open a second tab.*

***

• 01Scorecard / KPI card - a single headline number (sessions, revenue, conversion rate). Add a comparison period to show trend direction at a glance.
• 02Time series - how a metric moves over time. The default for sessions, clicks, or revenue trends.
• 03Bar / column chart - comparing discrete categories: channels, campaigns, or landing pages.
• 04Pie / donut chart - proportional breakdowns. Keep slices to five or fewer; beyond that, a table is clearer.
• 05Table - multi-metric comparisons across many rows. Add heatmaps to surface outliers without extra charts.
• 06Geo map - regional performance; useful for local businesses tracking traffic by city or postcode.
• 07Scatter plot - relationship between two metrics (e.g. spend vs. conversions by campaign).

How to build a simple marketing dashboard step by step

This walkthrough uses GA4 as the data source and mirrors the approach in this practical industry guide. The Looker Studio Help Centre tutorial covers the same chart-addition steps if you want the official reference alongside.

Numbered build sequence:

Before sharing, run this layout check:

Looker Studio autosaves every change as you work, so there is no risk of losing progress mid-build.

***

• 01Create the report. Click Create → Report in Looker Studio. When prompted, select Google Analytics as your connector and choose your GA4 property. Click Add to report.
• 02Set the layout. In File → Report settings, choose Responsive if the dashboard will be viewed on mobile devices, or Freeform for a pixel-precise desktop layout. The official tutorial explains both options; Freeform is the default.
• 03Add a Date Range Control. From the toolbar, select Add a control → Date range control and place it in the top-right corner. Set the default range to "Last 28 days."
• 04Add KPI scorecards. Insert four scorecards in a row: Sessions, Users, Conversions, and Conversion Rate. For Conversion Rate, use a calculated field (Conversions / Sessions). Set each to compare against the previous period.
• 05Add a time series. Insert a Time series chart below the scorecards. Set the dimension to Date and the metric to Sessions. This gives viewers an instant trend line.
• 06Add a channel breakdown table. Insert a Table chart. Set the dimension to Session default channel group and add metrics: Sessions, Users, Conversions, Conversion Rate. Enable heatmaps on the Sessions column.
• 07Add a second page for campaign detail. Click the + icon next to the page tab at the bottom. On page 2, add a table with Campaign as the dimension and the same four metrics. Add a filter control so viewers can isolate individual campaigns.
• 08Does every chart have a clear title label?
• 09Is the date range control visible on every page?
• 10Do all scorecards show a comparison period?
• 11Have you previewed the report in View mode (not Edit mode)?
• 12On mobile (if using Responsive layout), do charts stack cleanly without overlapping?

How do templates and the report gallery save you time?

The Looker Studio template gallery offers pre-built reports for common use cases: GA4 overviews, Google Ads performance, Search Console summaries, and more. Community-built reports extend this further, covering e-commerce, social media, and SEO dashboards.

Adapting a template takes four steps:

A template is the right starting point when your use case is standard: a GA4 traffic overview, a Google Ads spend summary, or a Search Console ranking report. Start from scratch when your data model is unusual, you are blending three or more sources, or the template's layout actively obscures the story you need to tell. Adapting a badly structured template often takes longer than building clean from the beginning.

***

• 01Open the template and click Use template in the top-right corner.
• 02When prompted, replace the sample data source with your own connector and property.
• 03Update KPI scorecards to reflect your actual goals (replace placeholder metrics with the ones your team tracks).
• 04Adjust the default date range control and remove any charts that do not apply to your reporting needs.

Sharing, embedding, and access controls (UK privacy note)

Once the report is ready, Looker Studio gives you several ways to distribute it.

Share link is the simplest option. Click Share and choose between View and Edit access. Viewers with the link can interact with filters and date controls but cannot modify the underlying report. For team collaboration, add users by email address and assign Editor or Viewer roles individually.

Publish to web makes the report publicly accessible to anyone with the URL, including search engines. Use this only for data you are genuinely comfortable making public.

Embedding lets you place a live, interactive report inside a webpage using an iframe. This works well for client-facing portals or internal intranets. The embed code is available under File → Embed report.

Scheduled email delivery sends a PDF snapshot of the report to a list of recipients on a set schedule: daily, weekly, or monthly. Find it under File → Schedule email delivery. This is useful for stakeholders who want a regular summary without logging into Looker Studio.

For permissions, the least-privilege principle applies: give viewers View access and reserve Edit access for the people actively maintaining the report. Use shared data sources rather than individual credentials so the report does not break when a team member leaves.

UK privacy note: if your datasets contain personal data (names, email addresses, IP-derived location), check that your data processing basis is documented under UK GDPR. Apply row-level security or redact identifiable fields before sharing reports beyond your immediate team, and consult your data protection officer where required.

***

Is Looker Studio free, and where do costs appear?

The core product is free. Google's official product page confirms that Looker Studio is available at no charge for both report creators and viewers. A paid enterprise tier, Looker Studio Pro, adds project-level management, team workspaces, and dedicated support, with pricing listed per project on the same page.

Feature Free tier Looker Studio Pro Report creation Unlimited Unlimited Viewer access Free Free Data source connectors Built-in Google connectors + community connectors Same, plus enterprise governance Team workspaces Not available Available Dedicated support Community forums Google support SLA Pricing £0 Per-project (see Google Cloud pricing page)

Where costs can still appear on the free tier:

For most small businesses running GA4 and Google Sheets, the free tier covers everything. BigQuery costs only become relevant at scale, typically when querying millions of rows or running automated scheduled queries.

***

• 01BigQuery queries - Looker Studio queries BigQuery on demand; large or frequent queries incur BigQuery compute charges.
• 02Paid community connectors - some third-party connectors charge a monthly subscription.
• 03Third-party data transfer tools - ETL services that move data into BigQuery or Sheets before Looker Studio reads it carry their own fees.
• 04Agency or freelance build fees - the tool is free; the expertise to configure it well is not.

Dashboard design best practices from Project-pixel

Good dashboard design is not about aesthetics. It is about whether a viewer can answer a question in under ten seconds.

Layout principles:

Accessibility:

Pro Tip: *Before sharing any report, switch your browser to a mobile viewport and check the Responsive layout version. Charts that look clean on a 27-inch monitor often overlap or truncate on a phone screen. Fix layout issues in Edit mode before the first stakeholder sees them.*

Stakeholder review checklist:

For local service businesses tracking Google Business Profile traffic alongside website sessions, linking your Google Business Profile data into a Looker Studio report gives a more complete picture of how customers find you.

***

• 01Place KPI scorecards at the top of every page so the headline numbers are visible without scrolling.
• 02Fix the date range control in the top-right corner and keep it in the same position on every page.
• 03One question per chart. A chart trying to show three things at once answers none of them clearly.
• 04Use progressive drill-downs: summary on page 1, channel breakdown on page 2, campaign detail on page 3.
• 05Check colour contrast ratios; avoid relying on colour alone to encode meaning (add labels or patterns for colour-blind viewers).
• 06Label every axis and use descriptive chart titles, not generic ones like "Chart 1."
• 07Keep legends concise; if a legend needs more than five entries, reconsider the chart type.
• 08Does each chart answer a specific question?
• 09Who is the primary audience for this page, and what decision does it support?
• 10What action should a viewer take after reading this report?
• 11Are all metrics defined in a text box or tooltip so new viewers are not guessing?

Common Looker Studio issues and how to fix them

Most problems in Looker Studio trace back to three root causes: permissions, mismatched data, or too many queries running at once - Gleanit can provide expert analytics and dashboard support to help your team resolve these issues quickly.

Quick fixes for frequent issues:

Performance checklist before publishing:

When a problem persists after these checks, the Looker Studio Help Centre is the first place to look. For complex multi-source builds or governance issues, escalating to an analytics specialist or requesting a build review from Project-pixel is often faster than debugging alone.

***

• 01Missing fields or "No data" errors - check that the connector has the correct permissions and that the data source is shared with all viewers. Re-authenticate the connector if credentials have expired.
• 02Incorrect date ranges - confirm the chart's dimension is set to Date (not a custom date field) and that the Date Range Control is connected to the chart at report level, not page level only.
• 03Blended data mismatches - verify that the join key exists in both sources and contains matching values. A mismatch in date format (YYYYMMDD vs. YYYY-MM-DD) is a common culprit.
• 04Slow loading dashboards - reduce the number of charts per page, avoid blending more than two sources on a single chart, and consider extracting data to a Google Sheets summary or BigQuery table that Looker Studio reads as a flat file.
• 05Calculated field errors - check for division-by-zero cases (wrap the denominator in NULLIF(metric, 0)) and confirm the field type matches the expected output format.
• 06Fewer than 15 charts per page where possible.
• 07Use aggregated data sources rather than row-level queries for summary dashboards.
• 08Limit custom calculated fields to those you genuinely use; unused fields still run queries.
• 09If BigQuery is the source, use partitioned tables and filter by date to reduce query costs and load time.

When should you build in-house versus hire an expert?

Most people can build a functional Looker Studio dashboard in an afternoon. The question is whether "functional" is enough for what you actually need.

DIY works well for straightforward, single-source reports: a GA4 traffic overview, a Google Ads spend summary, or a weekly Sheets-based KPI tracker. If you can follow the walkthrough above and the data is already in a Google product, there is no strong reason to pay someone else to do it.

Hire an expert when:

Project-pixel approaches dashboard projects the same way it approaches website builds: fixed scope, clear deliverables, and no ambiguity about what you are getting. That structure matters when a dashboard is a client-facing asset rather than an internal experiment.

***

• 01You are blending three or more data sources and the join logic is non-trivial.
• 02The dashboard feeds a board-level or client-facing decision and errors carry real consequences.
• 03You need row-level security, custom connectors, or a bespoke data pipeline that feeds Looker Studio from a proprietary system.
• 04Performance is critical and you are hitting BigQuery query limits or slow load times you cannot diagnose.
• 05Governance matters: you need version control, documented data definitions, and a handover process.

Analytics and dashboards, built into your website

Project-pixel builds analytics-ready websites for established service businesses across the UK, with Looker Studio reporting set up as part of the package rather than bolted on afterwards. You get GA4 connected, key KPIs defined, and a working dashboard integrated into your site from day one, without the back-and-forth of briefing a separate analytics agency.

For businesses that want industry-specific reporting, Project-pixel's industry website packages include analytics configuration tailored to your sector, whether that is tracking appointment bookings, local search traffic, or lead form conversions. Fixed price, clear timeline, no hidden costs.

Get in touch with Project-pixel to discuss what a production-ready dashboard looks like for your business.

***

Sources

The resources below cover official documentation, step-by-step tutorials, and the template gallery for deeper reference.

***

• 01Data Studio: Business Insights Visualizations | Google Cloud
• 02Tutorial: Create a new report - Looker Studio Help
• 03Tutorial: Create a new report | Data Studio | Google Cloud Documentation
• 04Building Your First Looker Studio Dashboard: A Step-by-Step Guide | Adnan Agic

FAQ

What is a Looker Studio dashboard?

A Looker Studio dashboard is an interactive, shareable report built in Google's free Looker Studio tool (formerly Data Studio). It connects to data sources such as GA4, BigQuery, or Google Sheets and displays metrics through charts, scorecards, and tables that viewers can filter in real time.

Is Google Looker Studio free?

Yes. Looker Studio is free for both report creators and viewers. A paid enterprise tier, Looker Studio Pro, adds project-level workspaces and dedicated support, with pricing listed per project on Google Cloud.

Does Looker Studio still exist?

Looker Studio is the current name for what was previously called Google Data Studio. Google rebranded the product as part of its broader Looker platform, and it remains an active, supported tool available at looker.google.com and through Google Cloud.

Why can Looker Studio feel slow or expensive to run?

The tool itself is free, but dashboards that query BigQuery directly incur compute charges based on data scanned. Slow load times usually stem from too many charts per page, blended queries across multiple sources, or unpartitioned BigQuery tables. Reducing chart count, using aggregated data sources, and partitioning BigQuery tables by date resolves most performance issues.

When should I hire someone to build my Looker Studio report?

DIY works for single-source reports using GA4 or Google Sheets. Hire an expert when you are blending multiple data sources, need row-level security, or the dashboard supports a client-facing or board-level decision where errors carry real consequences. Project-pixel offers fixed-price analytics builds as part of its website packages.

Recommended

• 01Bright Lane Clinic - Concept case study - Project Pixel
• 02Vector Architects - Concept case study - Project Pixel
• 03Forge Capital - Concept case study - Project Pixel
• 04Northgate Chambers - Concept case study - Project Pixel