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

As if serving one community isn’t a privilege, BOOST RADIO served six in 2021. In January, BOOST reintroduced themselves to St. Louis when they moved from a translator to a full-power signal. BOOST hit the cold streets with weekly “Sweet Stops;” the first 95 listeners to show up got free treats. BOOST team members served as the official DJs for two different Polar Plunges with the Special Olympics in February; nearly $200,000 was raised from hundreds of brave swimmers. March was when BOOST grew into Chicago! To celebrate, the station delivered deep dish pizza to listeners in St Louis and Chicago. BOOST RADIO renamed April 1 to April Fuel’s Day and had DJs pop up at random gas stations in both markets to buy gas for strangers. Spring & Summer brought BOOST to Minneapolis, Portland, OR, Pittsburgh, and Fayetteville, NC. The station brought their new friends Pop Up Parties for their backyard BBQ’s and open houses. BOOST supplied food, party favors, and custom mixes for dozens of winners nationwide. During the late summer and early fall, the station partnered with Out of the Darkness for suicide prevention walks. Across all BOOST markets, nearly 10,000 walked together. During the holidays, the station teamed up with rapper Thi’sl & the Salvation Army for the Full Ride Toy Drive. BOOST listeners filled a storage locker & U Haul full of gifts for children in need. 2021 was a year BOOST hit the streets and empowered its audience to bless others in their communities.

×

At Hope Media Group, the passion for Christ and the city of Houston shine in its efforts to mobilize the community to do good works so that more people can experience God’s love. After Hurricane Ida, generous KSBJ and NGEN listeners raised over $276,000 with God’s Pit Crew, sending 684 KSBJ Team Help Crews to Louisiana and sponsoring the distribution of 2,711 Blessing Buckets. KSBJ listeners also provided 20,000 bottles of water for fellow Houstonians after the winter freeze, and over 2,450 KSBJ and NGEN listeners participated in our annual Blood Drive with Gulf Coast Regional Blood Center saving more than 7,000 lives. A ministry committed to prayer, KSBJ formed the Greater Houston Prayer Council (GHPC), unifying 48 prayer groups across the city with an interdenominational, multi-ethnic, and multi-generational focus. KSBJ was also a beacon of joy to the community serving 3,000 cups of Blue Bell ice cream last summer and handing out 4,175 Easter Crosses for listeners to display as a reminder that “He is Risen.” During the holiday season, 91.7 Vida Unida blessed 100 families with Thanksgiving meals, and KSBJ listeners fulfilled the Christmas wishes of 9,315 children under the care of Houston CPS in partnership with Be A Resource. Beyond loving their neighbor, caring KSBJ and NGEN listeners sponsored 1,233 Kenyan children through Compassion International. In a year of unforeseen challenges along with the enduring effects of COVID-19, Hope Media Group listeners served as the hands and feet of Jesus like never before.

×

KCBI shares Jesus’ love and transforming power in Dallas-Fort Worth, inviting listeners to join the station in serving the community. KCBI Outreaches blessed nearly 67,000 individuals in 2021. In February, KCBI listeners provided 25,000 bottles of water to people in DFW whose water supply had been contaminated after an unprecedented winter storm disrupted power for several days. Later that month, nearly 1,300 women gathered for KCBI’s HeartStrong Faith Conference in Dallas to worship, pray and grow. Speakers included bestselling author Margaret Feinberg, podcaster Tara-Leigh Cobble, and theologian Nika Spaulding. Through KCBI’s Summer of Service, listeners donated over 13,000 meals, along with 9,000 Bibles, to community members still struggling with the COVID pandemic. Another 350 KCBI volunteers served at local ministries on our Summer of Service Day. They assembled 1,000 Love Boxes for women facing unplanned pregnancies; prepped backpacks, sorted clothing and distributed food to those in need; and prepped nearly 2,000 shoes for kids whose parents otherwise couldn’t afford them. Thanks to listeners’ generosity, KCBI distributed more than 32,000 Bibles to Texas prisons, human trafficking ministries and humanitarian ministries in 2021. Listeners purchased sonograms for pregnancy centers, which helped save more than 5,500 babies from abortion. They provided 38,000 bottles of water, along with 500 Bibles, to victims of the devastating tornadoes that swept through Kentucky in December. And throughout 2021, listeners offered more than 21,300 prayers for requests through KCBI’s Online Prayer Center. KCBI is grateful to God for the opportunity to impact DFW and beyond with Jesus’ love and transforming power.

×

Life 102.5 has a heart for Madison! For the 4th year in a row, during Valentine’s season, Life 102.5 invited listeners to share the love of Jesus with children and families receiving care at the Children’s Hospital. Listeners generously provided 2,234 Lego kits for the children. Afternoon host Summer Shepherd interviewed Dr. Melissa Mork on her award-winning podcast, “No Seriously, How Do I Do This?” Their conversation inspired the station’s “Embrace Play” giveaway, supporting families’ mental health during the pandemic. Life 102.5 provided a week’s worth of experiences for listeners, including art classes, game nights, and more. Morning Show host Dave Conour joined Team World Vision and rang two full marathons to bring attention to World Vision’s efforts of providing clean water to children and families around the world, Dave’s many miles provided 260 families with clean water for life! Life 102.5’s 21st annual Shoebox Gifts for Kids drive collected more than 1500 Christmas boxes of school supplies, hygiene items, toys, and winter clothing for children in Dane County. It was the station’s largest year yet. Amanda Brooks, Morning Show co-host and host of the weekly program “Faith & Life Today” focused on giving voice to women’s health, family and children’s issues in Madison including, education, marriage and divorce, immigration, and social justice. Life 102.5 had a wonderful year of reaching families, through children, with the love of Jesus. That’s why in 2022, Life 102.5’s outreach goal is focused on helping the most vulnerable children and their families in Madison and Southern Wisconsin.

×

Spirit 92.9 continued its commitment of blessing the central Minnesota community through intentional service projects. As the pandemic affected another year, station listeners rose to the challenge of uplifting and encouraging those feeling loss, loneliness, or burnout. Thanks to the help of generous listeners and business partners, Spirit 92.9 raised more than $8,000 in an online tip jar that blessed the staff at 19 local restaurants returning to work full time with huge tips during the Big Tip promotion. The restaurant workers were grateful for the visibility and appreciation. Numerous area teachers nominated by their students and families received special honor at the end of the school year with flowers and $500 VISA gift cards as part of “Thank A Teacher” organized by Spirit 92.9. In the fall, Spirit 92.9 partnered with two local ministries and provided free holiday meals to the community. During the ‘More Than A Meal’ event, the station worked with community members who donated enough to provide 6,000 meals and give help to people in need. Station team members also prepared and served meals together at the local homeless mission. At Christmastime, 11 community members wrote Spirit 92.9 and shared the story of someone they believed deserved some extra joy due to personal hardships. The individuals received $1000 to bless that person during Spirit 92.9’s Share The Joy promotion. Phone calls were made to hundreds of listeners to offer prayer and encouragement. Prayer support and a personal response is offered all year long.

×

2022 Membership Exclusives

January – 2022 Calendar
February – Social Series for Holy Week
March – Virtual Radio Station Field Trip
April – Book
May – Mediabase Webinar
June – Surprise at Momentum
July – Exclusive Momentum Content
August – Virtual Peer Networking Gathering
September – Fall Fun Box
October – Techsurvey Webinar
November – Noisemaker Promotions Vol 2 Book
December – Christmas Surprise 

*subject to change

×

Jim Campbell, Founder & Network President of Radio Training Network, Inc. began his radio career in commercial radio in Tennessee in 1964.  In 1966 he moved his family to Lakeland, Florida to attend college, and upon graduation he joined the staff at First Assembly of God Church where he and the church launched in the mid 1970s the first Contemporary Christian Radio Station in the nation, WCIE-FM. The station grew in both market impression and influence not just in Lakeland, but around the country inspiring others to follow Jim’s lead. In 1989 Jim left the church and founded Radio Training Network, Inc. (RTN) and over the next 30+ years, he oversaw the acquisition and development of 40+ stations plus translators. With 130 team members, RTN stations serve the Carolinas, Georgia, Alabama, Florida, and Missouri. These stations are well recognized in their respective markets thanks to the servant leadership of the staff, aggressive marketing, and a commitment to a strong emphasis on Jesus first. At present RTN has some two million listeners each week on air and approximately the same number online.

×

Andrea Kleid is a 24-year veteran of radio and records. She began her career working in Christian radio at WNLT in Cincinnati, and then moved onto WAY-FM in West Palm Beach working in programming and promotions. Her next stop took her to JOY-FM in Tampa where she served as the Promotions Director. In 2004, Andrea moved to Nashville to begin her music industry career in radio promotion under Grant Hubbard at Capitol CMG. In 2008, Andrea became the Vice President of Promotion at Word Label Group where she led one of the most successful and influential radio promotion teams in the Christian music industry. Through her signature brand of honesty, passion for Christian music, and focus on relationships, Andrea developed a reputation for successfully launching new artists’ careers including for KING and COUNTRY, NEEDTOBREATHE and Francesca Battistelli. This year, Andrea celebrates her fifth year as the President of her own company, Boxer Poet. An advocate for both radio and artists, Andrea continues to zealously host conversations around further representation for women and people of color on Christian radio.

×

Jason Sharp has a rich history with CCM radio and leadership. His early years at WONU/Chicagoland and The Bridge/Delaware gave flight to his passion for great programming and innovative promotions. As Program Director of WCQR/Johnson City and eventually the network PD for Positive Alternative Radio, Jason’s influence grew across the industry. In 2007, Jason joined the team at Northwestern Media as Program Director and then Station Manager of KTIS, Minneapolis/St Paul. In 2015, Jason furthered his formal education and earned his master’s degree in organizational leadership. Applying his leadership knowledge and skills to work, he now serves as Senior Vice President of Broadcasting at Northwestern Media’s 23 stations in 14 markets across ten states that service 1.5 million listeners each week. Jason also served Christian Music Broadcasters, first as a charter member and eventually as the lead of CMB’s educational track at Momentum for more than ten years. He then served as the organization’s board chairman from 2017-2020. Jason continues to inspire others within Christian media toward excellence and compassion through a Christ-centered attitude, education, and practical application.

×

In 1972, while serving in the U.S. Air Force in Orlando, Johnny Stone dreamt of a second kind of “air force,” that of radio. He took an overnight position at WDIZ-FM, the station where Z88.3 now stands. In the past 50 years of his career, Johnny’s work and personality raised the bar for other programmers in markets ranging from New York City, Chicago, Dallas/Fort Worth, San Diego, Tampa, Atlanta, Tucson, and Minneapolis/St. Paul. During his stint as Program Director and Morning Show host at Star 99.1 New York, his team won the NAB Crystal Radio Award and CMB Station of the Year. Presently, Johnny serves as afternoon host with his wife, Stacey, at 91.9 WGTS in Washington D.C. winner of the 2021 NAB Marconi Award for Religious Station of the Year. Owner of StoneStudios, LLC. and as a 22-year veteran in Christian media, Johnny mentored several on-air talents. Today, along with his on-air role at WGTS, he mentors college students at CMBU, teaching and modeling the belief that “you have to win in the hallways to win on the airwaves.”

×

Lisa Williams was called to Christian radio while praying in 1990. She walked into KCVO in Camdenton, Missouri and started on the air that same week. Over the past 32 years, Lisa served in various roles in on-air, programming, fundraising, and station management at radio stations and networks including K-LOVE, Z88.3, Star 99.1, KCVO, and KCWN. As an on-air personality, Lisa earned several number one ratings in several markets and was the recipient of three industry awards. Lisa now serves as the Network Talent Coach for Northwestern Media, owner of 23 stations in 14 markets across ten states that service 1.5 million listeners each week. While at Northwestern, Lisa hosted the nationally syndicated show Life with Lisa Williams from 2016-2021. She stepped away from the show to focus on coaching more than 90 on-air talents, encouraging and nurturing them to shine the light of Christ through excellent radio. When she’s not coaching talent, Lisa helps stations raise money for their operations. She also hosts a Facebook group for women on-air in Christian radio called GodsRadioGirls and helps facilitate their annual retreat.

×