Looker Studio: Build a Marketing Dashboard in 15 Min

Understanding your marketing performance isn’t just about collecting numbers; it’s about making those numbers tell a compelling story. Effective data visualization transforms raw data into actionable insights, allowing marketers to spot trends, identify opportunities, and prove ROI with undeniable clarity. But how do you move beyond static charts to truly dynamic, insightful dashboards?

For me, the tool that consistently delivers on this promise for marketing teams in 2026 is Looker Studio (formerly Google Data Studio). It’s free, integrates seamlessly with Google’s ecosystem, and offers unparalleled flexibility once you master its quirks. I’ve used it for years, building dashboards for everything from local Atlanta businesses tracking foot traffic from digital ads to national e-commerce brands analyzing multi-channel attribution. This tutorial will walk you through building a powerful, interactive marketing performance dashboard that will make your data sing.

Step 1: Connecting Your Core Marketing Data Sources

The first hurdle in any data visualization project is getting your data in one place. Looker Studio excels here, offering direct connectors to most major marketing platforms. We’ll focus on the essential trio: Google Ads, Google Analytics 4 (GA4), and a CRM like Salesforce or HubSpot. This combination provides a holistic view from ad spend to closed deals.

1.1. Adding Google Ads Data

1. On the Looker Studio homepage, click “Create” in the top left corner, then select “Data Source.”
2. In the “Connect to data” panel, search for “Google Ads” and select it.
3. You’ll be prompted to authorize your Google Account. If you manage multiple Google Ads accounts, choose the specific “Manager account (MCC)” or individual account you wish to connect.
4. Select the specific “Google Ads Account” from the dropdown menu.
5. Click “Connect” in the top right. Looker Studio will then load a default set of fields. Don’t worry about customizing them now; we’ll do that in the dashboard.
6. Rename your data source to something descriptive, like “Google Ads – [Client Name]” by clicking the pencil icon next to the default name. This is a small but mighty organizational tip that saves headaches later.

Pro Tip: Always connect at the MCC level if you manage multiple accounts. This allows you to easily switch between clients or even blend data across them for aggregate reporting.

Common Mistake: Connecting individual Google Ads accounts when you have an MCC. This forces you to create separate data sources for each, making cross-account reporting a nightmare.

Expected Outcome: A new data source named “Google Ads – [Client Name]” visible in your data source list, ready to be added to a report.

1.2. Integrating Google Analytics 4 (GA4)

1. From your Looker Studio report (or by creating a new data source), click “Add data” from the toolbar.
2. Search for “Google Analytics” and select the connector.
3. Choose your Google Account if prompted.
4. Under “Account,” select the relevant “Google Analytics Account.”
5. Under “Property,” select your “GA4 Property” (it will usually be labeled with “GA4” in parentheses).
6. Click “Connect.”
7. Rename the data source, e.g., “GA4 – [Client Website].”

Pro Tip: Ensure your GA4 property has sufficient data collection enabled for the metrics you care about. If you’re missing e-commerce events, your Looker Studio dashboard will reflect that gap.

Common Mistake: Accidentally connecting a Universal Analytics (UA) property instead of GA4. While Looker Studio can connect to both, their data models are significantly different, and blending them directly can lead to misinterpretations.

Expected Outcome: A new data source “GA4 – [Client Website]” linked and ready for use.

1.3. Connecting Your CRM (e.g., HubSpot)

This is where many marketing teams falter. Getting CRM data into Looker Studio is critical for true full-funnel analysis. While Google Ads and GA4 tell you about traffic and initial conversions, your CRM tells you about qualified leads and closed-won revenue.

1. Click “Add data” from your report.
2. Search for “HubSpot” (or Salesforce, Pipedrive, etc.). There are official connectors for popular CRMs, and many third-party connectors for others. Let’s assume HubSpot for this example.
3. Select the “HubSpot” connector.
4. You’ll be prompted to authorize your HubSpot account. Click “Authorize” and log in to HubSpot if necessary.
5. Select the specific “HubSpot Account” you want to connect.
6. Choose the data type you want to pull. For marketing dashboards, I typically start with “Deals” and “Contacts.”
7. Click “Connect.”
8. Rename the data source, e.g., “HubSpot CRM – Deals.”

Pro Tip: For CRMs, focus on the objects that contain your key performance indicators (KPIs) like “Deals” (for revenue) or “Contacts” (for lead status). Avoid pulling unnecessary data, as it can slow down your reports.

Common Mistake: Not mapping your CRM’s “Source” or “Original Source” field correctly. Without this, you can’t attribute closed deals back to specific marketing channels, which defeats the purpose of full-funnel reporting. I had a client last year, a local real estate brokerage in Buckhead, who spent weeks trying to figure out why their HubSpot deals weren’t showing up by channel in Looker Studio. Turns out, their “Original Source” property wasn’t being pulled by the connector, and we had to manually add it as a custom field.

Expected Outcome: Your CRM data source connected, allowing you to pull metrics like “Deal Stage,” “Amount,” and “Create Date.”

Step 2: Designing Your Core Marketing Dashboard Layout

A good dashboard isn’t just a collection of charts; it’s a narrative. It should guide the viewer through your marketing performance, highlighting successes and areas needing attention. I always start with a clear, logical flow, typically from high-level performance to granular channel-specific data.

2.1. Setting Up the Canvas and Theme

1. In Looker Studio, click “Create” > “Report.”
2. You’ll be presented with a blank canvas. Go to the “Theme and Layout” panel on the right (if not visible, click the “Theme and Layout” icon in the top toolbar, usually represented by a paint palette).
3. Under “Theme,” choose a pre-defined theme or customize your own. I usually start with “Simple” and adjust colors to match brand guidelines. Click “Customize” to change font styles, primary colors, and background.
4. Under “Layout,” set the “Canvas size.” For most dashboards viewed on desktops, “16:9” or a custom size like “1920×1080” works well. Avoid overly long canvases that require excessive scrolling.

Pro Tip: Consistency is key. Use a consistent color palette across all your dashboards for a professional look. For instance, always use green for positive growth and red for negative trends. It builds visual muscle memory for your stakeholders.

Common Mistake: Overcrowding the dashboard. Less is more. Focus on 5-7 key metrics per page. If you need more detail, create additional pages within the report.

Expected Outcome: A clean, branded canvas ready for your data visualizations.

2.2. Adding Essential Scorecard Metrics

Scorecards are your immediate pulse check. These are the big numbers everyone wants to see first: total spend, total conversions, CPA, and ROI. They should be prominently displayed at the top of your dashboard.

1. Click “Add a chart” from the toolbar and select “Scorecard.”
2. Drag and drop the scorecard to the top left of your report.
3. In the “Setup” panel on the right, for “Data source,” select your “Google Ads – [Client Name]” source.
4. For “Metric,” search for and select “Cost.”
5. Repeat this process for other key metrics:
   • Google Ads: “Conversions,” “Cost per conversion,” “Clicks,” “Impressions.”
   • GA4: “Total users,” “Sessions,” “Engaged sessions,” “Conversion rate.”
   • HubSpot CRM: “Deal Amount” (sum), “Number of Deals.”
6. Arrange these scorecards horizontally across the top of your report.

Pro Tip: Use the “Comparison date range” feature (found under “Date range properties” in the “Setup” panel) to show percentage changes month-over-month or year-over-year. This immediately adds context to your numbers.

Common Mistake: Not clearly labeling scorecards. Ensure each scorecard has a descriptive title (e.g., “Total Ad Spend” not just “Cost”). Use the “Style” tab > “Chart header” to set this.

Expected Outcome: A row of prominent scorecards displaying your top-level marketing KPIs.

Step 3: Visualizing Performance with Interactive Charts

Now for the fun part: turning those raw numbers into engaging visuals. We’ll create charts that demonstrate trends, compare channels, and highlight performance variations.

3.1. Campaign Performance Over Time (Time Series Chart)

Understanding trends is fundamental. A time series chart helps you visualize fluctuations in spend, conversions, or revenue over a chosen period.

1. Click “Add a chart” and select “Time series chart.”
2. Place it below your scorecards.
3. In the “Setup” panel:
   • Data source: “Google Ads – [Client Name]”
   • Dimension: “Date”
   • Metric: Add “Cost” and “Conversions.”
4. Go to the “Style” tab. You can customize line colors, add data points, and even enable “Missing data” interpolation (useful for weekend dips).

Pro Tip: Add a “Date range control” (from the “Add a control” menu) to your report. This allows users to dynamically select the time period for all charts on the page, making your dashboard truly interactive.

Common Mistake: Using too many metrics on a single time series chart, making it visually cluttered and hard to interpret. Stick to 2-3 related metrics.

Expected Outcome: A clear line chart showing how your Google Ads spend and conversions have trended over time.

3.2. Channel Performance Breakdown (Bar Chart)

Which channels are driving the most results? A bar chart is perfect for comparing performance across different marketing sources.

1. Click “Add a chart” and select “Bar chart” (specifically, the “Column chart” variation for vertical bars).
2. In the “Setup” panel:
   • Data source: “GA4 – [Client Website]” (this is where channel data lives best).
   • Dimension: “Session default channel group” (this is GA4’s improved grouping).
   • Metric: Add “Total users” and “Conversions.”
3. Go to the “Style” tab. You might want to sort by “Total users” descending to see the biggest channels first.

Pro Tip: Use a “Filter control” (from “Add a control”) for “Session default channel group.” This lets stakeholders quickly drill down into specific channels, like “Organic Search” or “Paid Search.”

Common Mistake: Using a pie chart for more than 4-5 categories. Bar charts are far superior for comparing quantities across multiple segments, especially when you have long channel names.

Expected Outcome: A bar chart illustrating user acquisition and conversion volume per marketing channel.

Step 4: Advanced Analysis with Blended Data and Custom Fields

This is where Looker Studio truly shines, allowing you to combine disparate data sources and create custom metrics that align with your specific business goals. This is often what separates a good dashboard from a great one.

4.1. Blending Google Ads and CRM Data for Full-Funnel ROI

To calculate true ROI, you need to link your ad spend to your closed-won revenue. This requires blending data.

1. In your report, go to “Resource” > “Manage added data sources.”
2. Click “Add a Data Source” and select your “Google Ads – [Client Name]” source.
3. Click “Add a Data Source” again and select your “HubSpot CRM – Deals” source.
4. Click “Blend Data.”
5. In the blending configuration:
   • Left table (Google Ads): Set the “Join Key” to “Date.”
   • Right table (HubSpot CRM): Set the “Join Key” to “Deal Create Date.”
   • Choose “Left Outer Join” to include all Google Ads data even if there’s no corresponding CRM data for a given day.
   • For the “Dimensions & Metrics” section, pull in “Date,” “Cost,” “Conversions” from Google Ads. From HubSpot, pull “Deal Amount,” “Deal Stage,” and “Original Source.”
   • Click “Save.”
6. Now, when you add a scorecard or table, select this new “Blended Data” source. You can create a custom field (see next step) for ROI: (SUM(Deal Amount) - SUM(Cost)) / SUM(Cost).

Pro Tip: Blending is powerful, but be mindful of your join keys. Mismatched keys will result in empty or incorrect data. Date is often the most reliable common denominator for marketing data.

Common Mistake: Using an “Inner Join” when blending. This will only show data where both sources have a match, potentially excluding valuable information. A “Left Outer Join” is generally safer for marketing performance dashboards.

Expected Outcome: A new blended data source that allows you to analyze ad spend directly against CRM revenue, enabling true ROI calculations.

4.2. Creating Custom Calculated Fields (e.g., MQL by Channel)

Sometimes, the raw metrics aren’t enough. You need to define your own. For instance, “Marketing Qualified Leads” (MQLs) might be defined differently across channels or even within your CRM.

1. Select your “Blended Data” source in the right-hand panel (if you’re on a chart using it, or go to “Resource” > “Manage added data sources” and edit it).
2. Click “Add a Field” at the top.
3. Name the field “MQL by Channel.”
4. Enter a formula. For example, if your CRM’s “Deal Stage” has “Qualified Lead” and you want to classify specific GA4 “Session default channel group” as MQL sources:

   CASE
     WHEN (Deal Stage = "Qualified Lead" AND Original Source = "Paid Search") THEN "Paid Search MQL"
     WHEN (Deal Stage = "Qualified Lead" AND Original Source = "Organic Search") THEN "Organic Search MQL"
     WHEN (Deal Stage = "Qualified Lead" AND Original Source = "Social") THEN "Social MQL"
     ELSE "Other"
   END

5. Click “Apply.”
6. Now you can use this “MQL by Channel” as a dimension in charts or tables.

Pro Tip: Use REGEXP_MATCH for more complex string matching in your CASE statements, especially when dealing with inconsistent naming conventions in your source data. We ran into this exact issue at my previous firm, a digital agency in Midtown Atlanta, where a client’s CRM had “Google PPC,” “Google Ads,” and “Paid Google” all referring to the same channel. A regex statement saved us a ton of manual cleanup.

Common Mistake: Incorrect syntax in your formulas. Looker Studio will usually flag errors, but double-check your parentheses and commas. Start with simple formulas and build up complexity.

Expected Outcome: A new, custom metric that categorizes and counts MQLs based on your specific business rules, providing more granular insights into lead quality.

Step 5: Adding Interactivity and Automation

A static dashboard is just a pretty picture. An interactive, automated dashboard is a powerful decision-making tool. This step focuses on making your report dynamic and ensuring it reaches the right people.

5.1. Implementing Filters and Controls

Filters allow users to slice and dice the data to answer specific questions.

1. Click “Add a control” from the toolbar.
2. Select “Drop-down list.”
3. Place it at the top of your report, next to your date range control.
4. In the “Setup” panel:
   • Control field: “Campaign” (from your Google Ads data source).
   • Metric: “Conversions” (to show how many conversions each campaign has).
5. Repeat this for other useful dimensions like “Device,” “Audience,” or your custom “MQL by Channel” field.

Pro Tip: Group related controls together visually. For example, put all “Campaign” related filters on one side and “Audience” filters on another. This makes the dashboard feel intuitive.

Common Mistake: Adding too many controls, which can overwhelm users. Focus on the dimensions that stakeholders most frequently ask to filter by. Sometimes, a simpler dashboard with fewer choices is better.

Expected Outcome: Dynamic filters that allow users to interact with your data, drilling down into specific campaigns, devices, or marketing channels.

5.2. Setting Up Automated Email Delivery

The best dashboard in the world is useless if no one sees it. Automate its delivery.

1. In the top right corner of your Looker Studio report, click the “Share” button.
2. Select “Schedule email delivery.”
3. Click “Schedule delivery.”
4. Under “Recipients,” enter the email addresses of your stakeholders (e.g., marketing director, sales manager).
5. Set the “Start date,” “Repeat frequency” (e.g., “Daily,” “Weekly”), and “Time.”
6. You can choose to “Attach report as PDF” or “Link to report.” I always recommend both.
7. Add a custom “Subject” and “Message” to provide context.
8. Click “Save.”

Pro Tip: Include a brief, insightful summary in the email message, highlighting the most important trends or action items from the dashboard. This adds immediate value and ensures recipients engage with the report.

Common Mistake: Sending reports without context. A dashboard is a tool, not a conclusion. Always provide a brief human analysis to guide interpretation.

Expected Outcome: Your marketing performance dashboard automatically delivered to key stakeholders at a regular interval, fostering data-driven decision-making.

Mastering data visualization for marketing in Looker Studio isn’t just about technical skill; it’s about storytelling. By connecting diverse data sources, building intuitive visuals, and automating delivery, you transform raw numbers into a clear, compelling narrative that drives strategic action and proves your marketing impact.