Tracking Your Social Media Marketing Impact

Looking for a faster way to visualize and make sense of your marketing metrics? Have you heard of Google Data Studio?

In this article, you’ll learn how to build a reusable report in Google Data Studio.

Why Use Google Data Studio to Simplify Marketing Measurement Analysis

When you’re a small business with a limited marketing budget, it can be difficult to identify which social media marketing efforts are working the best. Sifting through spreadsheets and Google Analytics reports can be daunting—not to mention time-intensive—if you’re not super comfortable with data and math.

This is why setting up a dashboard can be a good solution. It can help you quickly find answers to pertinent questions and make more informed decisions without spending hours crunching numbers in Excel.

Follow the steps below to create your own custom marketing dashboard with Google Data Studio. The best part is that you can do this for free.

Use Google Data Studio, step 1.

#1: Decide What You Want to Measure

When you read tactical articles like this one, it can be tempting to create a Google Data Studio account and immediately start building out a dashboard. However, I strongly encourage you not to do that right away. Instead, think about your marketing goals and define what you want to measure first. After all, if you can’t measure it, you can’t manage it.

One of the biggest mistakes that I see brands make is trying to measure anything and everything. That’s how you wind up with 25+ page weekly or monthly marketing reports that no one reads. Instead, it’s better to focus on three core KPIs and then about a dozen sub-KPIs. Your core KPIs should tie back to a monetary value. You know it’s a core KPI if you can answer these questions:

  • Does it increase revenue (i.e. growth metrics)?
  • Or does it decrease costs (i.e. retention metrics)?

Everything else is a vanity metric. Vanity metrics aren’t necessarily bad; however, they need additional context to be relevant. For example, some common vanity metrics are the number of Instagram followers, net email subscriber growth, and any social media engagement metrics.

Pro Tip: For some insight into what metrics other brands are tracking, check out Google Data Studio’s Report Gallery. It has an entire section devoted to marketing templates.

Use Google Data Studio, step 2.

If you’re a SaaS business with a heavy focus on content marketing, for instance, the core three KPIs you care about might be how your marketing efforts impact monthly recurring revenue (i.e. MRR), customer lifetime value (LTV), and churn or cancellations.

Some important sub-KPIs you may want to pay attention to are customer acquisition cost for each marketing channel (CAC), referral sources, traffic by source/medium/channel, Domain Authority (DA) or Domain Rating (DR), blog sessions, blog unique visitors, time on site, social media shares, backlinks, new inbound leads, percentage of inbound leads that are marketing-qualified (MQLs), etc.

Use Data to Tell a Story

Just like you use words to tell a story, you can do the same with data. The problem is that most of us are trained to think of data more like a Magic 8 Ball. Ask a question, shake the ball a few times, and you automagically get answers.

However, the quality of the questions you ask has a significant impact on what data you look at and the conclusions you draw. Specifically, the more focused the question, the more specific and actionable your findings will be. I like to use the focusing question from Gary Keller’s bestselling book The One Thing: “What’s the one thing you can do such that by doing it everything else will be easier or unnecessary?”

#2: Create an Outline for Your Marketing Measurement Dashboard

To tell a more cohesive and compelling story with your marketing data, you need to create an outline. I can’t stress this enough. The more thought you invest into mapping out and outlining your marketing dashboard, the easier it will be to build it.

Use Google Data Studio, step 3.

You can outline your dashboard digitally using a tool like Figma (free version available), Sketch (30-day free trial; $99/yearly), Balsamiq ($9/per month), or Google Drawings (free for Gmail/Google apps users). Or you can freeform it in a journal or notebook.

I like to do this process digitally; however, it doesn’t matter how you choose to outline your dashboard as long as you actually do it.

For my outline, I like to focus on the “meat” of the dashboard—the metrics or what I’m going to measure. Often, we obsess over the design and layout, because it’s fun to think through that. If you start with the design, though, you’ll end up doing a lot more work. It’s much faster to think through the substance of the dashboard, which will then inform the look and feel.

Below is an example of a basic outline for a blog dashboard. As you can see, it won’t win any design awards, but it does ensure that you know what you’re building.

Use Google Data Studio, step 4.

#3: Connect Google Data Studio With Your Data Source

Once you’ve developed an outline, the next step is to create a Google Data Studio account. All you need to get started is a Gmail or Google apps email address. Here is where you can create your Google Data Studio account. (It’s free!)

Pro Tip: Make sure you use the same email address as the one you use for Google Analytics.

In addition to maximizing what you can do in Google Data Studio, the following actions can help spruce up your analytics account:

  • Make sure you’re using goals.
  • Enable ecommerce tracking and check that it’s working correctly.
  • Set up multi-channel funnels and assisted conversions.

Use Google Data Studio, step 5.

The next step is to connect your data sources in Google Data Studio. Click Data Sources in the left navigation and then click the + button on the right.

Use Google Data Studio, step 6.

You can connect three different types of data sources: Google connectors (i.e. built-in/direct integrations), partner connectors (third-party integrations), and open-source connectors.

You’ll find over 135 partner connectors that let you pull in everything from Facebook and Instagram ad insights to Bing ads, Reddit insights, Quora ads, Amazon Seller stats, and customer support call-tracking metrics.

Use Google Data Studio, step 7.

If you don’t see a data source for the specific metric you need, you can always import it yourself through a CSV file, MySQL query, or custom JSON or XML file.

Use Google Data Studio, step 8.

For the purpose of this article, we’ll stick with Google Analytics, because it’s the easiest data source to start with as well as one of the most versatile. As you get more comfortable, I encourage you to check out many of the other data sources.

Use Google Data Studio, step 9.

After you select the Google Analytics data source, click Authorize to add your account to Google Data Studio.

Use Google Data Studio, step 10.

You’re then prompted to log into your Google Analytics account. When you’re done, click Connect.

Use Google Data Studio, step 11.

Google Data Studio now generates all of the data fields. You have the option to search these fields as well as add new fields to the list. When you’re done, click Create Report in the upper-right corner of the page.

Use Google Data Studio, step 12.

When you see the pop-up window below, click Add to Report to pull your data into your new dashboard so you can start working with it.

Use Google Data Studio, step 13.

Note: To add more data sources (such as Google Search Console, Google Ads, etc.), repeat the same steps as above.

#4: How to Build Your Google Data Studio Dashboard

Google Data Studio has many default templates that you can work from. However, I recommend building a dashboard from scratch because you already know what you’re measuring and have an outline. Starting with a blank report is less work than trying to revise and rebuild an existing template.

Use Google Data Studio, step 14.

There are many different types of charts, tables, graphs and scorecards that you can add to your dashboard in Google Data Studio. You can also upload your own images, embed HTML, and add dynamic filters and segments.

If you have used a WYSIWYG web builder or CMS, you’ll find that the process for adding and customizing charts in your dashboard works similar to customizing a DIY website or template.

The first thing to do is to choose a theme and layout using the Style Settings.

Use Google Data Studio, step 15.

Next, click the Date Range toolbar button to add a date filter. I recommend setting the default date range for 30 or 90 days depending on the account, site traffic, and marketing goals. For accounts with less than 10,000 monthly visitors, stick with 90 days as your default.

Note: You’ll be able to filter and adjust the date dynamically after you’ve built the dashboard.

Use Google Data Studio, step 16.

Now, it’s time to start adding your charts. The easiest chart to add is the scorecard.

Use Google Data Studio, step 17.

You’ll want to customize the metric, which is a certain KPI indicator such as sessions, unique pageviews, conversions, etc. In this example, the metric is Average Time on Page.

Use Google Data Studio, step 18.

With scorecards, I like to add a background rectangle behind the text to make it stand out on the page. To do this, you need to group the text together and make sure it’s sent to the front. The process is similar to using graphic design software like Canva or Photoshop.

Use Google Data Studio, step 19.

Another common chart to add to your dashboard is the pie chart. For instance, you might use a pie chart to see the percentage of users who view your site from different web browsers (i.e. Chrome, Safari, Firefox, etc.).

In this case, you’d add both the dimension and metric. The metric is Sessions, and the dimension is Browser (the browser that visitors used to view your site).

Use Google Data Studio, step 20.

You also might use a pie chart to see what devices people are using to browse your site. Here the dimension is Device Category, and the metric is Sessions.

Use Google Data Studio, step 21.

You can also add bar and line charts to your dashboard. For both, you can add multiple dimensions and metrics (such as Unique Pageviews and Sessions) to view trends over time.

Use Google Data Studio, step 22.

Tables work particularly well when mapping out and tracking paid advertising account data from within Google Analytics. Here’s how to set this up:

  • Add two dimensions: Campaign and Ad Content. This allows you to segment your ads by the overall campaign and individual ad creatives.
  • Add a minimum of three metrics, such as Transactions, ROAS, and CPC.

Use Google Data Studio, step 23.

Pro Tip: To set up a table like the one above, you need to use UTM codes for all of your ad campaigns.

It’s a good idea to also add at least one or two filters in addition to a date filter. I like to filter by either source or medium. This lets you see how people interact with your site when they come from different sources, such as Google, Facebook, LinkedIn, etc.

Use Google Data Studio, step 24.

Here’s what a basic dashboard with one source filter looks like.

Use Google Data Studio, step 25.

Once you’ve created your marketing dashboard, you can share it the same way that you share Google sheets and docs.

Use Google Data Studio, step 26.

You can even save it as a template, which will save you a lot of time in the future.

Use Google Data Studio, step 27.


The steps above show you how to connect Google Data Studio with Google Analytics data and set up a custom marketing dashboard. As you get more comfortable with this tool, you’ll likely end up connecting more data sources.

There are many more Google Data Studio features you can use to refine your dashboard. Click the Resource menu at the top of the page to connect additional data sources, blend data, and add segments.

Use Google Data Studio, step 28.

Link to Original Source


Related posts

2021 Membership Exclusives

January – Your 2021 Radio Goals – Virtual Event
March – Radio Station Field Trip
April – A Webinar for YOUR Board
May – Virtual Mentoring Event
June – SURPRISE BENEFIT at Momentum
July – Salary Survey Webinar
August – Fundraising Webinar
September – Creative Images
October – Techsurvey Webinar
November – Radio Station Field Trip
December – Virtual Christmas Party

*subject to change


Wise, Weird & Welcome: Learning and Leading with the Lepers and the Locust Eaters

We’ve all read the same books about teamwork, leadership, communication, and culture that everybody reads. We’ve mastered Maxwell, studied Sanborn, Sinek, and Sun Tzu, and liberally cribbed Collins in aborted attempts to go from good to great, but…

How’s that working out for you? 

What if you left St. Louis with an entirely new lens through which to view and act upon improvements in:

Let’s examine how this all connects together, but approach it from an entirely different angle. Don’t just think outside the box. Kick the box to the curb and start at zero.