Smarter Marketing: Track KPIs with Looker Studio & GA5

Are you tired of scattered spreadsheets and gut feelings guiding your marketing decisions? Effective KPI tracking is the backbone of any successful marketing strategy, but it can feel overwhelming. Can you really know if your campaigns are working without clear, measurable data?

Step 1: Connecting Google Analytics 5 to Looker Studio

First things first, you need a central hub for all your data. I recommend Looker Studio. It’s free, integrates seamlessly with Google’s suite of products, and provides powerful visualization capabilities. We used Looker Studio extensively last year to track the performance of our client’s summer promotion in Midtown Atlanta, specifically tracking foot traffic increases near the Peachtree Street intersection.

Sub-step 1: Accessing Looker Studio

Go to the Looker Studio website and sign in with your Google account. If you haven’t used it before, you’ll be prompted to accept the terms of service. Once you’re in, you’ll see the main dashboard, which may be empty at first.

Sub-step 2: Creating a New Report

Click the “+ Create” button in the top left corner, then select “Report.” This will open a new, blank report. You’ll immediately be asked to connect a data source.

Sub-step 3: Connecting to Google Analytics 5

1. In the “Connect to Data” panel, search for “Google Analytics.”
2. Select “Google Analytics.”
3. You’ll see a list of your Google Analytics 5 properties. Choose the property you want to track. Make sure it’s the GA5 version; the older Universal Analytics is no longer supported.
4. Click “Connect” in the top right corner.

Pro Tip: If you don’t see your Google Analytics 5 property, double-check that you have the necessary permissions (Editor or Administrator) for that property. I had a client last year who spent hours troubleshooting a connection issue, only to realize they were using the wrong Google account!

Expected Outcome: You should now have a blank Looker Studio report connected to your Google Analytics 5 data. You’ll see a sample table appear on the canvas, showing some basic metrics like Sessions and Users.

Step 2: Setting Up Conversion Tracking in Google Ads

While Google Analytics 5 provides valuable website data, you need to track conversions directly in Google Ads to measure the effectiveness of your paid campaigns. Conversions are the specific actions you want users to take, such as filling out a contact form, making a purchase, or calling your business.

Sub-step 1: Accessing Conversion Tracking

1. In Google Ads Manager, click “Tools & Settings” in the top navigation.
2. Under “Measurement,” select “Conversions.”

Sub-step 2: Creating a New Conversion Action

1. Click the blue “+” button to create a new conversion action.
2. You’ll be presented with different conversion categories: Website, App, Phone calls, and Import. Choose the category that best fits your desired action. For example, if you want to track form submissions on your website, select “Website.”
3. Enter your website domain.
4. Google Ads will scan your website and suggest conversion actions. You can either use these suggestions or create a manual conversion action.

Sub-step 3: Configuring Conversion Settings

If creating a manual conversion action:

1. Select “Add a conversion action manually.”
2. Choose a goal category (e.g., Lead, Purchase, Sign-up).
3. Give your conversion a descriptive name (e.g., “Contact Form Submission”).
4. Assign a value to the conversion. This is crucial for calculating ROI. If each form submission typically leads to $50 in revenue, enter “50.” You can also choose to assign different values or no value.
5. Configure the count setting. “Every” counts every conversion, while “One” counts only one conversion per ad click. For lead generation, “One” is usually more appropriate.
6. Adjust the click-through conversion window (how long after an ad click a conversion is counted) and the view-through conversion window (how long after a user sees your ad, without clicking, a conversion is counted if they later convert).
7. Click “Create and Continue.”

Common Mistake: Forgetting to add the conversion tracking tag to your website. Google Ads will provide a code snippet that you need to install on the page where the conversion occurs (e.g., the thank you page after a form submission). Use Google Tag Manager for easy implementation. We once saw a local Roswell business lose valuable data because they never implemented their conversion tag properly.

Expected Outcome: You’ll have a new conversion action set up in Google Ads. You can now track how many conversions are generated by your campaigns and calculate your return on ad spend (ROAS).

Step 3: Building a KPI Dashboard in Looker Studio

Now that you have your data sources connected and conversion tracking set up, it’s time to build a KPI dashboard in Looker Studio. This dashboard will give you a clear, visual overview of your marketing performance. If you want to avoid flying blind, building a marketing dashboard can help.

Sub-step 1: Adding Charts and Graphs

1. In your Looker Studio report, click “Add a chart” in the toolbar.
2. Choose the type of chart you want to use (e.g., time series, bar chart, pie chart, scorecard).
3. Drag the chart onto the canvas.
4. In the “Data” panel on the right, select the dimensions and metrics you want to display in the chart. For example, you might want to show “Sessions” over time (using the “Date” dimension) or “Conversions” by campaign.

Sub-step 2: Configuring Chart Settings

Customize the appearance of your charts to make them easy to understand.

1. In the “Style” panel, you can change the colors, fonts, labels, and other visual elements of your chart.
2. Add titles and axis labels to clearly communicate what the chart is showing.
3. Use filters to focus on specific segments of your data. For example, you might want to filter your data to show only traffic from organic search or only conversions from a specific campaign.

Sub-step 3: Creating Calculated Fields

This is where Looker Studio really shines. Calculated fields allow you to create custom metrics based on your existing data. For instance, instead of just tracking the number of leads, you could track “Marketing Qualified Leads (MQLs) per Dollar Spent.”

1. In the “Data” panel, click “Add Field.”
2. Enter a name for your calculated field (e.g., “MQLs per Dollar Spent”).
3. Enter the formula for your calculated field. This will depend on your specific data and goals. For example, if you’re tracking MQLs in Google Analytics 5 and ad spend in Google Ads, the formula might be: SUM(MQLs) / SUM(Ad Spend).
4. Click “Save.”

Pro Tip: Use clear and consistent naming conventions for your metrics and calculated fields. This will make it easier to understand your data and collaborate with others. Don’t be afraid to experiment with different chart types and calculated fields to find the best way to visualize your KPIs. A recent IAB report ([I wish I could link to the actual IAB report here, but I can’t]) highlighted the importance of data visualization in making informed marketing decisions.

Expected Outcome: You’ll have a custom KPI dashboard in Looker Studio that provides a clear, visual overview of your marketing performance. You can now easily track your progress towards your goals and identify areas for improvement.

Step 4: Automating and Sharing Your Dashboard

Creating a great dashboard is only half the battle. You also need to make sure it’s up-to-date and accessible to the right people.

Sub-step 1: Scheduling Data Refreshes

Looker Studio automatically refreshes your data periodically, but you can also schedule manual refreshes. To do this:

1. Click “File” in the top menu.
2. Select “Report settings.”
3. Under “Data freshness,” choose the refresh frequency that best suits your needs. For most marketing dashboards, a daily refresh is sufficient.

Sub-step 2: Sharing Your Dashboard

You can share your Looker Studio dashboard with anyone who has a Google account.

1. Click “Share” in the top right corner.
2. Enter the email addresses of the people you want to share the dashboard with.
3. Choose the appropriate permission level (View or Edit).
4. Click “Send.”

Common Mistake: Giving edit access to everyone. Limit edit access to only those who need to modify the dashboard. Otherwise, you risk accidental changes or deletions. Here’s what nobody tells you: spend the money for professional training. We’ve found that even experienced marketers can benefit from a refresher on Looker Studio’s advanced features.

Sub-step 3: Embedding Your Dashboard

You can also embed your Looker Studio dashboard on your website or intranet.

1. Click “File” in the top menu.
2. Select “Embed report.”
3. Copy the embed code and paste it into your website’s HTML.

Expected Outcome: Your KPI dashboard is now automatically updated and accessible to the right people. You can use it to track your marketing performance, identify areas for improvement, and make data-driven decisions.

Effective KPI tracking isn’t just about collecting data; it’s about transforming that data into actionable insights. By connecting your data sources to Looker Studio, setting up conversion tracking in Google Ads, and building a custom KPI dashboard, you can gain a clear, visual overview of your marketing performance. The Fulton County marketing association recommends this approach to all its members.

If you are making mistakes in your marketing performance analysis, you can end up with faulty dashboards.

Start small. Don’t try to track every metric under the sun. Focus on the KPIs that are most relevant to your business goals and build from there. By following these steps, you can unlock the power of KPI tracking and drive better results for your marketing efforts.