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.

Conclusion

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

The team at 94.9 KLTY has served the Dallas/Fort Worth community for over 35 years. In 2020, the need was never greater. Through their local campaigns, Christmas Wish and Speak Love, they were able to assist many families who were impacted by not only the pandemic, but by hard times in general. The Speak Lovecampaign helped first responders, teachers, servers, food service staff, and many more within the community throughout the year. In 2020 94.9 KLTY’s Christmas Wish campaign brought Christmas joy to hundreds of families in the DFW area. They provided vehicles, food, toys, and other forms of relief to families in their community. They could not have reached any of these needs if not for their listeners and their generous donations to 94.9 KLTY’s nonprofit programs. In total, Speak Love and Christmas Wish raised more than $160,000 for those in need in Dallas/Fort Worth. They also recognized those sacrificial front-line workers and first responders who keep our community safe. Each week, 94.9 KLTY honored them, raised funds throughout the summer, and then presented each first responder with a check as a token of their gratitude. With countless families in need because of the pandemic, 94.9 KLTY also helped the Tarrant Area Food Bank distribute food essentials on multiple occasions in September, October, November. It is 94.9 KLTY’s sincere honor to serve our listeners in Dallas/Fort Worth.

×

LIFE 96.5 seeks to empower and serve the Sioux Falls area by reaching out in faith to help make it a better place to live and work. They want to lead their listeners to Jesus and help them grow in their faith through opportunities to love and serve others. In January 2020, LIFE 96.5 listeners donated over 950 brand new baby items during the Sioux Empire’s Largest Baby Shower. The Baby Shower grows every year, demonstrating their community’s love and support of the couples who are choosing life for their unborn children. LIFE 96.5 listeners, in partnership with Dacotah Bank, provided gift cards and cash donations to the Sioux Falls School District social workers to meet the needs of 1,000 homeless students. LIFE 96.5 also invited listeners to participate in a city-wide prayer parade, where they prayed for health care and government officials while driving past hospitals, schools, and city government offices. During the months of September and October 2020, LIFE 96.5 listeners provided over 250 twin sheet sets and 100 mattresses to the Sioux Falls Sleep in Heavenly Peace organization for children who are sleeping on floors. Through LIFE 96.5, listeners also made a difference in the lives of patients spending Christmas at Avera Behavioral Health Hospital. Each patient received a Christmas stocking filled with gifts and a note of encouragement. In addition, each Saturday morning LIFE 96.5 staff host Life Connection, a program featuring community leaders and discussing the needs and concerns of the Sioux Falls Community.

×

89.5 KVNE exists to glorify God by encouraging people, connecting their community, and pointing people to Jesus Christ. When their community was turned upside down by COVID, they knew they had to jump into action and mobilize their listeners to make a difference for Christ. To best serve their local community, KVNE held multiple drives to support local ministry partners and those most impacted by the pandemic. They collected 1,500 gift cards (totaling more than $15,000) to benefit those in need because of shutdowns, gathered over 12,000 diapers for foster families, and collected 150 care packages for senior citizens. They also collected 1,032 fans for the Salvation Army and over 1,000 pairs of shoes for kids heading back to school. Additionally, listeners donated 1,512 care packages for the homeless in East Texas, and KVNE hosted two blood drives to help those fighting the coronavirus. People across East Texas needed connection during the pandemic, so they organized a social media outreach, called Praise Defeats, a coordinated time where listeners shot videos of themselves singing “Raise A Hallelujah.” The videos were shared thousands of times, as they deepened their community’s connection. In addition, KVNE launched a Hispanic Christian music station (Fuzión), started a worship station (Lift Worship), and began a Bible Teaching Station (The Well) – all to help people grow in their faith. God allowed them to impact His Kingdom in profound ways and serve their local community powerfully during an unprecedented time when people needed hope like never before.

×

Since 1986, The JOY FM has made community service a hallmark of its ministry to listeners – first in Sarasota, and then expanding to Tampa, other Florida markets, and most recently to Atlanta and Middle Georgia. Even with this growth, community outreach remains hands-on, with legacy events like T-Shirts for Turkeys, which helped feed more than 28,700 families in all markets served last year. 2020 created new challenges for serving, so The JOY FM innovated several service projects to accommodate contactless delivery and social distancing. JOY Drop and Restock, a brand-new outreach, collected 30 tons of food to restock local food banks hit hard by the pandemic. Partnering with Natalie Grant and Hope for Justice, Team Freedom approached a grand total of $1,000,000 in 2020 to fight human trafficking. As listeners faced political rhetoric and serious questions about race and justice, as well as practical challenges like hybrid classrooms, The JOY FM programming (on terrestrial signals, as well as its LF Radio and JOY Worship platforms) responded with a recommitment to our mission of “Helping You Find JOY.” Resources for listeners, such as the Off Air with Carmen podcast, was provided to help listeners wrestle with big questions like Christian citizenship. Possibly The JOY FM’s most relevant community service effort for 2020 was prayer. The JOY FM’s Prayer and Crisis Referral service interacted with 620,936 listeners in need of prayer or help. Of those calls and texts, 4,949 listeners reported praying to place their faith in Jesus Christ.

×

“Hope Starts Here” is more than The Light FM’s tagline. It’s their mission. In 2020, they were intentional in regularly offering community-needed resources and hope-filled encouragement. They hosted their 5th annual Make a Difference training to encourage listeners to share God’s hope and saw 14 people begin a personal relationship with Jesus. The Light FM also visited eight local Law Enforcement agencies to share words of encouragement and care baskets. They partnered with East Tennessee Children’s Hospital and artists of Winter Jam for a private concert and time of prayer with families battling pediatric cancer. The Light FM listeners from five different cities donated 258 wheelchairs, 262 crutches, 259 walkers, 71 transport chairs, and 66 canes to Wheels for the World, which brings mobility and the hope of Christ around the world. During stay-at-home orders, The Light FM began offering free monthly virtual events, including: a graduation ceremony, featuring artists and Bible teachers; a conference with Crown Financial on how to manage finances during the pandemic; Girl Talk LIVE, a women’s event with worship and Bible study; God’s Hope in Crisis training with chaplains of the Billy Graham Rapid Response Team; a pastor appreciation event for local churches, featuring Chip Ingram and Matthew West; and a Family Christmas Night with live music, games, and a devotion from The Light FM staff. Even throughout the pandemic, The Light FM also found ways to be out in the public, safely, with six drive-in events featuring movies and live music.

×

2021 Membership Exclusives

January – Your 2021 Radio Goals – Virtual Event
February – SURPRISE BENEFIT 
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

×

Paul Cameron began his career in radio prior to graduating from the University of Wisconsin Oshkosh in 1980, starting his first job in 1979 as part-time on-air talent at WMKC 96.7FM (an adult contemporary station). In 1980 Paul moved to part-time on-air talent for WHBY-AM 1230 (a news/talk station), and while still working there, began working part-time for WEMI 100.1FM. In 1981, he went full-time for WEMI and over the years served as program director, music director, station manager, and director of radio operations. In 2002 he assumed the role of executive director and general manager for Christian Family Radio, now known as The Family Radio Network. Since 2016 Paul has been chief operating officer and afternoon on-air host. He was part of the transition from one full power station to five full power stations and six translators, all in Wisconsin. Paul has given back to his community by serving on several local boards in various capacities, including The Emergency Shelter of Appleton, The Community Clothes Closet of Menasha, and Loaves and Fishes of the Fox Valley. He also serves on the Wisconsin Broadcasters Association Board of Directors and has been a fundraiser host with ShareMedia/Dunham+Company since 2002.

×

Rob Dempsey has been serving the HIS Radio Network listeners faithfully since 2000, currently working as operations manager and morning show co-host on the HIS Morning Crew with Rob & Lizz. Rob worked as a security guard at television studios for the Home Shopping Network before he was called into the radio ministry. Now, Rob’s personal stories of overcoming obstacles, walking through a long journey to health, and stepping out in faith and selflessness inspire his listeners. Some know him as the guy who lost 140 pounds to overcome obesity, others know him as the 16-year-old kid kicked out of his home to live in the streets, and others know him as being a foster and adoptive parent. Rob and his wife’s kids range from a 34-year-old war hero, 25-year-old social media marketing specialist, 19-year-old honors college student, a 12-year-old they adopted in November 2009, as well as many foster children throughout the last 9 years. Recently, Rob has been on a health journey which included two surgeries, one a major reconstructive surgery. These past two years have been a challenge for Rob, but he continues to show that through God, anyone can become an overcomer.

×

Since 1989, Mike Harper has faithfully impacted East Texas on-the-air at 89.5 KVNE, where he serves as VP Communications and morning show host. He began as a volunteer weekend DJ, driving from 90 miles away. Mike advanced the cause of Christian radio by serving several years on the steering committee for CMB, and he has taken part in every NCRS/CMB since 1999. According to Nielsen, Mike and Carrie in the Morning has been the #1 Morning Show for a decade (#1 Persons 12+) propelling KVNE as high as an 8.3 share and helping KVNE become the #1 rated station in the Tyler/Longview market. During that time, KVNE won 8 Station of the Year Awards (CMB & NRB). Additionally, Mike and his co-host Carrie Parsons have been awarded “Best Morning Show in East Texas” for 9 years in a row. Mike has shaved his head to reach a pledge drive goal, donned white tights and a cape “for the children,” and stood on top of a building during a remote broadcast. He has daily arrived faithfully at 5:00 am and braved ice, snow, hail, and tornados in an effort to keep his listeners safe, encourage them, and point them to Jesus.

×

Bryan O’Neal has spent a lifetime entertaining, encouraging, and spreading God’s love to millions over the airwaves, landing his first radio job in 1972 in mainstream Top 40 radio. In 1978 Bryan hosted and produced Portland’s first CCM’s 30-minute radio show on Top 40 62-KGW. He then teamed up with his good friend Bob Anthony to plan a full-time CCM station in Santa Rosa. Eventually that station became K-LOVE. After K-LOVE moved to Sacramento, Bryan became their full-time employee #13 in 1994. In 1998 Bryan worked as the program director for another CCM station, KPAM/Pamplin Media. In 2001 Bryan teamed up once again with Bob Anthony at EMF’s Air1. Bryan was instrumental in moving Air1’s entire Portland staff to the new building in Rocklin, where he worked as operations director and then program director. In 2005 Bryan worked a short stint at KTSL in Spokane, and then became the music director and afternoon host at 89.7 KSGN in Redlands, California. Bryan O’Neal has worked as the program director at KSGN and co-host with Brandi Lanai for nearly 10 years of Bryan and Brandi in the Morning. Bryan hung up his headphones for retirement in March of 2021.

×

Bill Scott is one of the founders of Vidare Creative, a fundraising consulting company which helps Christian radio stations, through their 365 plan concept, raise the funds they need to grow. Bill has been a part of Christian radio for 39 years. He’s worked at WCIE, The JOY FM, and WAY FM as a production director, on-air talent, program director, and station manager. Bill co-hosted Dawson McCallister Live, which aired on 500 radio stations each weekend. Bill began ZJAM, a syndicated show that aired on 350 stations in the USA, Canada, the UK, and Guatemala each weekend. Bill’s latest show was Xtreme Talk Live, airing each Sunday night on over 200 radio stations. Bill has hosted 700 fundraisers on Christian radio in the UK, USA, Canada, Australia, and New Zealand. Bill also runs Men of Radio, a Facebook group with over 600 men from Christian radio. For the past three years, he has hosted the Men of Radio Winter Retreat in McCall, Idaho, with the focus of getting to know other men on Christian radio so they can walk through life together. Bill Scott believes passionately in Christian radio, and he has dedicated his life to see it grow.

×