Looker Studio Tutorial: Build Marketing Dashboards That Drive Decisions

If you are still copying numbers from Google Analytics into spreadsheets every Monday morning, it is time to stop. Google Looker Studio (formerly Data Studio) lets you build live, interactive dashboards that pull data automatically from dozens of sources, giving your Singapore marketing team a single place to track performance across every channel.

For businesses in Singapore, where marketing budgets are scrutinised closely and stakeholders expect real-time visibility, Looker Studio is an indispensable tool. Whether you manage Kempen Google Ads for an e-commerce brand in Orchard or oversee social media marketing for a chain of F&B outlets, a well-built dashboard saves hours of manual reporting each week.

This looker studio tutorial walks you through every step, from connecting your first data source to sharing polished, branded reports with clients or management. By the end, you will have the skills to build dashboards that make your marketing data actionable.

What Is Looker Studio and Why Use It

Google Looker Studio is a free data visualisation platform that transforms raw marketing data into interactive dashboards and reports. Unlike static spreadsheet charts, Looker Studio reports update automatically whenever the underlying data changes, meaning your dashboard always shows the latest numbers without any manual effort.

The platform connects natively to Google products such as Google Analytics 4, Google Ads, Google Search Console, Google Sheets, and BigQuery. Through partner connectors and community connectors, you can also pull data from Facebook Ads, LinkedIn, HubSpot, Shopify, and hundreds of other platforms that Singapore marketers rely on daily.

Key benefits for marketing teams include the ability to combine multiple data sources into a single view, create branded reports that match your agency or company identity, and share live dashboards with stakeholders who can explore the data themselves. For agencies offering digital marketing services in Singapore, Looker Studio dashboards are an excellent way to demonstrate value and maintain transparency with clients.

Connecting Data Sources

Every Looker Studio report begins with at least one data source. Here is how to connect the most common marketing platforms step by step.

Step 1: Open Looker Studio. Navigate to lookerstudio.google.com and sign in with the Google account that has access to your marketing platforms. If you manage multiple client accounts, ensure you are logged into the correct Google account before proceeding.

Step 2: Create a new data source. Click the Create button in the top left corner and select Data source. You will see a list of available connectors. Google’s own connectors appear first, followed by partner and community connectors.

Step 3: Select your connector. For Google Analytics 4, click the GA4 connector, then choose the appropriate account, property, and data stream. For Google Ads, select the Google Ads connector and pick the account or MCC you want to report on. For Google Search Console, choose the Search Console connector and select your verified property.

Step 4: Configure fields. Once connected, Looker Studio displays all available dimensions and metrics. You can rename fields, change data types, add descriptions, and set default aggregation methods. For example, rename sessionSource to Traffic Source for clearer reporting.

Step 5: Click Connect. Your data source is now ready to use in any report. You can reuse the same data source across multiple reports, which keeps your field configurations consistent.

For platforms without native Google connectors, such as Facebook Ads or TikTok Ads, you can use third-party connectors from providers like Supermetrics, Funnel, or Windsor.ai. These typically require a separate subscription but are well worth the investment for agencies managing multi-channel campaigns.

Creating Your First Report

With your data sources connected, it is time to build your first marketing dashboard. Follow these steps to create a clean, functional report.

Step 1: Start a new report. From the Looker Studio homepage, click Create and select Report. You will be prompted to add a data source. Select an existing data source or create a new one.

Step 2: Set up the canvas. Looker Studio starts you with a blank page. Go to Page > Current page settings to adjust the canvas size. For dashboards viewed primarily on desktop, a 1200 x 900 pixel canvas works well. For reports designed for presentation, use a 16:9 ratio at 1920 x 1080 pixels.

Step 3: Add a header. Insert a text box at the top with your report title, such as “Monthly Marketing Dashboard — [Client Name]”. Add your company logo using Insert > Image. Use a coloured rectangle behind the header to create a branded banner. Singapore agencies often use this space to include the reporting period and a brief summary of key outcomes.

Step 4: Plan your layout. Before adding charts, sketch out what information each section should contain. A typical marketing dashboard includes a top row of scorecards showing headline KPIs, a middle section with trend charts and breakdowns, and a bottom section with detailed tables. This hierarchy ensures stakeholders see the most important numbers first.

Step 5: Add your first chart. Click Insert in the toolbar and choose from the available chart types. Start with a scorecard to display a key metric like total sessions, conversions, or revenue. Drag it onto the canvas and configure the metric and date range in the properties panel on the right.

Building Charts, Tables, and Scorecards

Looker Studio offers a wide range of visualisation options. Choosing the right chart type for each data story is critical for creating dashboards that people actually use.

Scorecards are ideal for headline numbers. Use them to display total conversions, revenue, cost per acquisition, or return on ad spend. Enable the Comparison date range option to show percentage change versus the previous period, giving stakeholders instant context on whether performance is improving.

Time series charts show trends over days, weeks, or months. Use line charts for metrics like daily sessions or weekly leads, and area charts when you want to emphasise volume. For SEO performance tracking, a time series showing organic clicks and impressions from Search Console is particularly useful.

Bar charts and column charts work well for comparisons. Use a horizontal bar chart to compare traffic by channel (organic, paid, social, referral, direct) or a column chart to compare monthly revenue across quarters. Stacked bar charts can show the composition of conversions by campaign or ad group.

Pie and donut charts should be used sparingly and only when showing parts of a whole with no more than five or six segments. They work for visualising traffic source distribution or device category breakdown but become unreadable with too many slices.

Jadual are essential for detailed data. Create a table showing your top 20 landing pages with sessions, bounce rate, and conversions. Add conditional formatting by clicking Style > Conditional formatting to highlight rows where bounce rate exceeds 70% in red or conversion rate exceeds 5% in green. Tables with heatmap formatting are excellent for keyword performance reports.

Geo maps visualise geographic data. For Singapore businesses targeting local and regional markets, a geo map showing sessions or conversions by country across Southeast Asia provides valuable insight into where your audience is located.

Adding Filters and Interactive Controls

Filters and controls transform a static report into an interactive dashboard that stakeholders can explore on their own. This is one of Looker Studio’s most powerful features.

Date range control: Go to Insert > Date range control and place it prominently at the top of your dashboard. This allows viewers to change the reporting period without editing the report. Set a sensible default date range, such as the last 30 days or the current month, under the control’s properties.

Drop-down list control: Gunakan Insert > Drop-down list to let viewers filter by specific dimensions. Common filters for marketing dashboards include campaign name, traffic source, device category, and country. For a Singapore e-commerce client, you might add a product category filter so they can view performance for specific product lines.

Advanced filter control: The Advanced filter control lets viewers type search terms to filter data. This is useful for dashboards with hundreds of keywords or landing pages where a drop-down list would be impractical.

Checkbox filter: For dimensions with a small number of values (such as device type: desktop, mobile, tablet), a checkbox filter lets viewers select multiple options simultaneously.

To apply a filter to specific charts rather than the entire page, select the charts you want to filter, right-click, and choose Group. Then apply the filter control to that group only. This technique lets you create a dashboard where the paid media section filters independently from the organic section.

Using Calculated Fields for Custom Metrics

Calculated fields let you create custom metrics and dimensions that do not exist in your raw data. They are essential for building dashboards that show the KPIs your Singapore business actually cares about.

Creating a calculated field: In the data source editor or within a chart’s metric configuration, click Add a field and then Add calculated field. Enter a name and formula using Looker Studio’s formula syntax.

Here are practical calculated field examples for marketing dashboards:

Conversion rate: If your data source provides conversions and sessions but not conversion rate, create it with the formula Conversions / Sessions. Set the output type to Percent.

Cost per lead: For paid campaigns, calculate cost per lead with Cost / Conversions. This is invaluable for Google Ads reporting where you want a single metric that combines spend and results.

Return on ad spend (ROAS): Gunakan Revenue / Cost to calculate ROAS. For Singapore e-commerce businesses, this is often the primary metric that determines whether campaigns scale up or down.

Content grouping: Use CASE statements to group pages into categories. For example, CASE WHEN REGEXP_MATCH(Page path, ".*blog.*") THEN "Blog" WHEN REGEXP_MATCH(Page path, ".*product.*") THEN "Product Pages" ELSE "Other" END. This is especially useful for content marketing analysis where you want to compare blog performance against product pages.

Custom date dimensions: Create a Day of week field to analyse which days generate the most traffic or conversions. The formula WEEKDAY(Date) returns a number you can map to day names using a CASE statement.

Once your dashboard is built, you need to share it with the right people and potentially scale your reporting across multiple clients or brands.

Sharing options: Click the Share button in the top right corner to manage access. You can share with specific email addresses, set permissions to Viewer atau Editor, and control whether viewers can download the report data. For client reporting, Viewer access is usually appropriate since it lets clients interact with filters and date ranges without accidentally modifying the dashboard layout.

Scheduling email delivery: Go to Share > Schedule email delivery to send automated PDF snapshots of the dashboard on a recurring schedule. Set it to send every Monday morning so your Singapore team starts the week with fresh performance data. You can customise the pages included and the email subject line.

Embedding reports: If you want to embed a dashboard on your company intranet or client portal, click File > Embed report to generate an iframe code. Adjust the embed dimensions to fit your website layout.

Creating templates: To turn a report into a reusable template, go to File > Make a copy. When copying, Looker Studio prompts you to swap out data sources, making it easy to duplicate a dashboard structure for a new client while pointing it at their data. Save your best-performing dashboard layouts as templates to standardise reporting across your agency.

Using the template gallery: Looker Studio’s template gallery contains dozens of pre-built dashboards for common use cases. Search for marketing, e-commerce, or SEO templates to get a head start rather than building from scratch. Customise the template’s branding, metrics, and layout to match your specific requirements.

Dashboard Best Practices for Singapore Teams

Building a dashboard is easy. Building a dashboard that people actually use every week requires thoughtful design and ongoing maintenance.

Start with the business question. Before adding any chart, ask what decision this dashboard should help someone make. A dashboard for a Singapore property developer might focus on lead volume and cost per lead by channel, while a dashboard for an e-commerce fashion brand might prioritise revenue, ROAS, and top-selling products.

Limit each page to one theme. Rather than cramming everything onto a single page, use multiple pages within the same report. Create separate pages for SEO performance, paid media, social media, and email marketing. Use the page navigation menu to let stakeholders jump directly to the section they care about.

Use consistent formatting. Align charts to a grid, use consistent colour coding (green for positive metrics, red for negative), and apply the same font throughout. Match your brand design guidelines to create professional-looking reports.

Include context, not just data. Add text boxes with brief annotations explaining significant changes. If organic traffic spiked in March due to a viral blog post, note that on the dashboard so viewers understand the data rather than just seeing a spike. This contextual layer transforms a data dump into a useful reporting tool.

Optimise for speed. Dashboards that take 30 seconds to load will not get used. Limit the number of charts per page, avoid pulling unnecessarily large date ranges by default, and use data extracts for data sources with millions of rows. If your GA4 property has heavy traffic, consider using BigQuery exports with scheduled queries to improve dashboard performance.

Review and iterate. Schedule a quarterly review of your dashboards. Remove charts nobody looks at, add new metrics that have become important, and update calculated fields as business goals evolve. The best dashboards in 2026 are living documents, not static templates.

Soalan Lazim

Is Google Looker Studio free to use?

Yes, Looker Studio is completely free. You can create unlimited reports and data sources at no cost. The only potential expense comes from third-party connectors like Supermetrics, which charge a subscription fee to connect non-Google data sources such as Facebook Ads or LinkedIn.

Can I connect multiple data sources to a single Looker Studio report?

Absolutely. A single report can use multiple data sources, and you can even blend data from different sources within the same chart. For example, you can blend Google Ads cost data with Google Analytics conversion data to create a unified performance view.

How often does Looker Studio refresh data?

By default, Looker Studio caches data and refreshes it every 12 hours for most connectors. You can manually refresh by clicking the refresh button in the report header. For connectors like Google Sheets, data updates whenever the underlying spreadsheet changes and the cache expires.

What is the difference between Looker Studio and Looker Studio Pro?

Looker Studio Pro is a paid version that adds enterprise features such as team workspaces, admin controls, service level agreements, and Google Cloud support. For most Singapore SMEs and agencies, the free version provides everything needed for comprehensive marketing reporting.

Can I use Looker Studio to report on SEO performance?

Yes. Connect Google Search Console as a data source to report on organic impressions, clicks, average position, and click-through rate. Combine this with Google Analytics 4 data to track organic traffic, engagement, and conversions. This setup is standard for agencies providing SEO services in Singapore.

How do I create a multi-page report in Looker Studio?

Click Page > New page in the menu bar to add additional pages. You can rename pages, reorder them, and duplicate existing pages to maintain consistent formatting. Use the page navigation panel on the left side of the editor to manage your report structure.

Looker Studio Tutorial: Build Marketing Dashboards That Drive Decisions