• FAQs

          Search engine optimization (SEO) helps businesses drive visits to their website through organic search traffic. Given that the top organic search results receive a third of the clicks, a decline in ranking could be detrimental for your business. Implementing SEO best practices on your website will help to ensure that your web content is seen by as many potential customers as possible. The more visitors you have, the better your chances are of converting those visits into sales!

          Local search engine optimization (SEO) helps local businesses gain visibility by optimizing their local business listings for local search. A business that leverages local SEO will include its address, phone number, local opening times, and exact location in the form of a local citation. The goal is to rank for local searches which are usually performed by people in a specific geographical region looking for a business near them.

          We typically see results within the first 30 to 60 days, but when it comes to SEO, there are many factors at play. It's important to remember that SEO is a long-term strategy and results may not come as fast at you wish.


        • FAQs

          Digital advertising uses the internet to send advertisements to customers who are online through different websites and social media platforms like Google, Bing, LinkedIn and Facebook.

          The price for Google Ads management depends on the monthly ad spend. For accounts with $1,000 in monthly ad spend, the price is $550/month. Between $1,000 and $5,000 a month in ad spend, the price is $950/month. For $5,000 to $10,000 a month in ad spend, the price is $2,000/month. For more than $10,000 a month in ad spend, the price is $4,500/month.

          The price for Social Media Ads management depends on the monthly ad spend. For accounts with $1,000 in monthly ad spend, the price is $550/month. Between $1,000 and $5,000 a month in ad spend, the price is $950/month. For $5,000 to $10,000 a month in ad spend, the price is $2,000/month. For more than $10,000 a month in ad spend, the price is $4,500/month.


        • FAQs

          This depends on the complexity and size of a redesign and if eCommerce is needed. On average, it takes around 14-18 weeks from the web design intensive stage to launch.

          If your website experiences the following issues: it’s not responsive on all devices, has a slow loading speed, the design appears old and tired, users don’t spend long on the site, sales are stagnant, or your business is going through a rebranding - your website needs a redesign to boost your brand awareness and sales.

          Sometimes there’s no need to rebuild a website. Minor edits, refreshing page content and images, or restructuring page layout for SEO best practices can boost traffic and sales.


        • FAQs

          Semantic search launched in 2013 with the release of Google's Hummingbird update. Since then, Google's search engine has become more complex. The integration of machine learning, with RankBrain, and NLP, with BERT, has enabled the search engine to better understand the context of a query and deliver more personalized and targeted results. Semantic SEO is the process of creating machine-readable content using structured data and linked open data to help search engines better understand your content.

          On-page SEO is the practice of optimizing individual web pages in order to rank higher and earn more relevant traffic in search engines. On-page SEO refers to both the content and HTML source code of a page that can be optimized, as opposed to off-page SEO which refers to links and other external signals. From meta tags to page content, website structure, and HTML, on-page optimization services are focused on making your website more visible to search engines.

          Structured data refers to any organized data that conforms to a certain format, such as information in a relational database. When information is highly structured and predictable, search engines can more easily organize and display it in creative ways. Structured data involves using a piece of code that is laid out in a specific format easily understood by search engines. The search engines read the code and use it to display search results in a more dynamic way.


        • FAQs

          An SEO agency has experts in different areas of search engine optimization that may be out of the realm of your marketing team's abilities. SEO can be very complex and time-consuming. Furthermore, as search engine algorithms change it can be difficult to stay current on the latest ranking factors and strategies for improving online visibility. You will likely see a greater return on investment and better results from using a professional SEO agency than you would from tackling this on your own.

          As a digital marketing agency, SMA Marketing provides products and services in four areas: SEO, Local SEO, Digital Advertising, and Web Design

          We focus on building authentic, long-lasting relationships with our clients. We’re goal oriented and results driven and believe in doing good and making a difference in the world.

  • Contact

Using Google Data Studio to Create Marketing Reports [Free Template Included]

Google Data Studio is a perfect solution for creating powerful marketing reports. While there are many business intelligence tools on the market, this free tool from Google is packed with everything marketers need to get their jobs done.

In this video, I’ll share how you can leverage Data Studio to create actionable marketing reports.

Get the  Data Studio Template Here.

Video Transcript: 

In the latest episode of Hack My Growth, we took a look at Google Data Studio and how we can use this tool to create meaningful and actionable marketing reports. And as a bonus, I’m going to give you a free template you can use to get started right away.

Advantages of Using Google Data Studio

There are a number of options when it comes to creating reports in the marketing realm. There are lots of tools out there that you can use to inspect your data, go deeper with your data, build dashboards, & scorecards. The thing is it can often be very confusing, and a lot of these tools have restrictions, things that you can and cannot do. Now, the cool thing about Google Data Studio is there’s a ton of functionality. It links to tons of different connectors and tools. And it helps those who don’t have an advanced understanding of data or databases to create meaningful reports.

The great thing about Google Data Studio is you can build one report that looks the same across every single page. So whether you’re pulling data from Google Analytics or Search Console, or maybe from HubSpot or SEM Rush, it can all be formatted in the same way, giving you a really crisp, clear look when you’re reporting to clients or other members of your team. Let’s take a look at the template that we created and how you can begin to use it today and leverage Data Studio to create actionable reports.

Using an SEO Report Template

What I’m looking at right now is the SEO report template that we’ve built on Data Studio. It’s a two-page report that a client or a user can go through and get some meaningful information from. This was built using Google Data Studio. If you don’t have an account, you just go to datastudio.google.com and sign up or log in with your Google ID, and it will set you up.

Right now, we’re using default information from Google themselves as a sample. But as you can see, we’ve got a couple of things in this report. You can add your logo up top here. We’ve got channels that we can filter through, so social referral, all the different traffic channels.

Looking at Organic Channels

If you only want to look at organic, you can just click this and it will filter all of the data to organic itself. We’ve also got another filter up here with our timeframe. Now, one of the things I really like about Data Studio is it gives you much broader control over your timeframe. There are a lot of tools on the market that don’t allow you to create custom time ranges and that can be frustrating when you want to see the impact over a year or maybe over two years. This will allow you to do that as long as you have that data within your Google Analytics account. As we walk down in this report, I’m going to turn all these on so you can see it all, we’ve got the traffic sources section. So this is breaking down all the different sources, the sessions, the new sessions, bounce rate, and the pages per session.

Organic Vs. Other Channels

We can see how each one of these channels has performed and we can compare organic versus other channels. Now, this is helpful if you’re an SEO, because you can show the impact and the weight that organic has in their overall marketing strategy. When you’re just looking at the gains in organic, it doesn’t really put it into context with all of the other channels that clients may be using. So when you can pull this out and say, “Hey, organic is actually driving you the most traffic. Organic also has a relatively good page per session rate. It’s got a lower bounce rate,” and start to tie some of the story to how organic’s helping the brand overall. This doughnut chart over here just shows the comparative values of each one of these channels in a more visual form. Sometimes this is easier for a client to really see how much more organic is than let’s say social.

Top Performing Content List

Down below this, we have a top performing content list. We’ve got page title, the page URL itself, page views, the average time, and the bounce rate. Now, this is really helpful for content and understanding what type of content is not just driving traffic but is also engaging users as well. The reason I like to have the page title in here is we typically have keywords in our page titles. We can use these to see how these pages are performing in search as well. If we look, we can see the page view. We can also filter this though by average times and say, which pages did people spend the most time on? Well, if there’s only one page view, then it’s not really helpful because that’s one person. We want to look for pages that have a lot of views, but also spend time on the site.

Look at Bounce Rate

We can also filter by bounce rate as well to help give us a better understanding of which pages have a lower bounce rate and why. Sometimes there’ll be a null, and if this is in here, you can create a filter to extract or remove the null so you don’t see that in the report.

Search Visibility

On page two, it’s the search visibility. Here, we’re pulling in Search Console, both the site and the URL data. Now, you’ll see when we go to connect this to our own data, and I’ll walk you through that, you’ll have to use two different types of Search Console connectors. But again, we have the filter up here for the date. We don’t have the channel filter because this is Search Console, so we’re only looking at searches. We’ve got a graph here that shows impressions and clicks. And then we have a scorecard that pulls in site CTR and average positions with the rest over here.

If you look at the landing pages section, right here we’re pulling out your top pages or the top pages in search. We’ll look at the impressions and then the change over that time period, the URL clicks and the change over that time period, the URL CTR and the change over the time period. It helps us to analyze which pages are performing well. What type of traffic are they getting? Are they generating clicks and visits to our site? We want to see that here. Now, if we scroll down below a little bit further, we’ll see the queries that we’re pulling out. And we can look at their average position, the amount of impressions, the clicks and the CTR that they’re getting. And we can also see down here a graph of our overall average position over time. This is helpful to track to see are you trending in the right direction?

Are you increasing your average position? Are you decreasing and you’re starting to earn more visibility for those terms in positions one through 10? Now that we’ve walked through a little bit of what this report looks like, how would we use this report? So we would go up here, and we would hit this button right here that says, “Make a copy.” Now, when we make a copy, we’re going to need to hook up our own data sources. As you can see, it’s going to tell you the data sources that are being used in this report. And if you go ahead and connect yours in this stage, it will actually allow you to pool all of that in directly without having to connect it to the report. You’ll do it here and it’ll make it look awesome for you right away.

Create a New Data Source

To create a new data source, we just hit this drop down button. As you can see, I have some obviously populated in here because I’ve done this a couple of times, but I’m going to show you how it works.

We’re going to hit create new data source. And in this case, it needs to be Google Analytics. I need to find my account. They’ve got a great search bar up here. I can find an account here. Select the properties, select the view that you want, and then you hit connect. Google now is connecting this data source. One thing that I recommend you do, up here at the top, it will always say whatever your view is. So I like to describe this a little bit better because you can go back and see all your different data sources in Data Studio as well. I like to use the site title and then what the data source is.

Another thing I like a lot about Data Studio is you can see it’s pulling in all of the Google Analytics dimensions. When you’re using a third-party tool, sometimes you are limited to the amount of dimensions and metrics you can pull in. Like Tableau, depending on the combination, you’re limited. Power BI, you’re limited. Some of the other sources, you have to pull them into different buckets. When you use Data Studio, you can pull them all right in and begin to work with those reports. Click the add to report button, and now that is connected. The next thing we have to do is we want to do Search Console data. As you see, this one says site and this one says URL. We need both of these connections in order to make this work. We’ll follow the exact same process as we did before.

We’ll create a new data source. We’ll now find Search Console. You search your site, click the right one, and hit connect. Again, you’ll want to do Search Console. Search Console will give you the domain, but I think you should also add something like site so you know which type of connection it is. And once again, we want to do Search Console. This time we want to select the URL property. URL impressions, and hit connect. Again, update this so we know exactly which one we’re talking about, and hit add to report. Now we can hit copy this report, and Google Data Studio will create a copy, but it will create a copy using our datasets only, the datasets we have available. So up here, you can re-title your report to the brand you’re working with.

Final Touches

Then make sure everything looks good. I always like to go through and make sure that everything is working and working the way that it should on both pages. Up here is the other page. And it looks good. As you see, it’s a new site, so there’s not a lot going on with this one right now. One thing that we want to be able to do is share this with our client or share internally.

Data Studio has ramped up their permissions. When you go to share a view here, and you share this with a client, you have to make sure that you give them access to this report. Otherwise, they won’t be able to see it. You can’t just share the link. You have to add the people who you want to be able to view, or you can change the manage access here.

You can actually allow this for people who have the link so anybody with the link can view it. Or you can make it open on the web if you need to as well. That’s a really important thing to make sure that your data comes across and people can actually view it, and they’re not just getting a blank page. Any of this stuff is editable though, just so you know, in Data Studio. Like up here, if you want to change the logo, you can just click on the logo and delete this image file and upload a new one. If you want to change the filter or the default ranges, you can do that here. It’s very flexible and allows you to do a number of things. Like I said before, you can add all different types of data. There’s a ton of different data.

If I go to this add data button, you can see just the native connectors from Google. You’ve got Analytics and Ads, and Sheets, BigQuery, quite a bit of stuff here that you can attach to. Then there’s a number of partner connections. Like I said, there’s one for SEMRush. There are ones for all different types, Super Metrics if you’re using them, Twitter, and Facebook. So this tool is very diverse and very large. There’s a ton of different options. There’s a huge amount of people in the partner community who are building different visualizations as well, that are not stock or standard within the Google Data Studio setup. This report will help you get started, but don’t let it be the only place that you go. Push yourself, try things, break stuff, and see how it works. That’s the best way to learn how to use these programs and get more out of them.

And I really like this idea from Austin Kleon, where we steal like an artist. See what other people are doing and leverage that information and create something new of your own based on what you’ve learned from them. So, hope you found this video helpful. If you have any issues with the template or you have any questions about data studio, we would love to continue that conversation with you. Please comment below. And until next time, Happy Marketing.

New call-to-action

Search by Topic

  • All Resources
  • SEO
  • Digital Advertising
  • Content Marketing
  • Web Development
  • Major Structure Data Updates From Google

    Major Structured Data Updates From Google

    As technology advances, so do the algorithms and updates from search engines like Google. A major update that has caught the attention of website owners and SEO professionals is the…

    How and When to Claim Your Google Business Profile Blog Image (1)

    How and When To Claim Your Business on Google 

    One of the first things we do at SMA Marketing when working with a local SEO client is look for the company’s Google Business Profile. Occasionally, we work with a…

    The 4 Fastest Ways To Contact Google Support

    The 4 Fastest Ways To Contact Google My Business Support

    Your Google Business Profile (GBP), formerly called a Google My Business profile, is an invaluable free tool for local businesses. That said, what can help your business visibility can also…

    Small Business SEO Tips from 10+ Years of Experience

    Small Business SEO: Tips from 10+ Years of Experience

    SMA Marketing has a long history of helping small businesses attract customers through effective search engine optimization. SEO is the foundation of our marketing strategy, enabling us to create a…

    6 Local SEO Tips to Improve Your Local Rankings

    6 Local SEO Tips To Improve Your Local Rankings [Infographic]

    From small businesses to larger enterprises, you need local SEO if you own a brick-and-mortar or online local business. Though local SEO (search engine optimization) is a long-term strategy that…

    What Is an SEO Agency?

    What is an SEO agency and what do they do? Learn how hiring an SEO agency will effectively drive traffic to your site and grow your business.

    What Is an SEO Agency?

    What is an SEO agency and what do they do? Learn how hiring an SEO agency will effectively drive traffic to your site and grow your business.

    What is SEO

    What Is SEO?

    The term SEO has a variety of meanings and is often understood. Learn what SEO is and how SEO works to improve a website’s visibility in search results.

    5 Ways To Convert SEO Leads Using Web Design

    5 Ways To Convert SEO Leads Using Web Design

    Learn how your web design impacts the conversion rate of you SEO leads and how a great design can grow your business online.

    SMART SEO & Content Marketing How Your Message Impacts Rankings [Infographic]

    SMART SEO & Content Marketing: How Your Message Impacts Rankings [Infographic]

    A SMART SEO strategy begins and ends with the development and marketing of awesome content. See how content marketing and SEO are connected.

    Why Design a New Website

    Why Design a New Website

    There are a few different ways to refresh your website. Learn the benefits of designing a new website as a part of your digital marketing strategy.

    Web Design and Development Services How To Find the Right Agency for Your Business

    Web Design and Development Services: How to Find the Right Agency for Your Business

    Learn the tips & importance of working with a digital marketing agency to find the right web design and development services for your business.

    • 6 Proven Methods To Improve Your Customer Experience Strategy

      Extend your relationships with customers beyond their initial purchase and create loyal fans with these methods for improving your customer experience strategy.

      Differentiating SEO vs. SEM

      SEM and SEO are digital marketing strategies that align to accomplish the same goals but consist of different execution. Learn more about SEM and SEO.

      What is Content Marketing?

      Excellent content marketing cuts through the noise of unhelpful information to attract the right customers. Read more from SMA Marketing.

      What Is Internet Marketing?

      Internet marketing is a powerful tool for businesses! Learn about digital platforms, tools, and content delivery systems to reach new customers.

      Guide to Search Engine Marketing

      Looking to expand your digital marketing portfolio? It may be time to explore search engine marketing. Learn more from SMA Marketing.

      7 Content Marketing Strategies You Can’t Ignore

      We’re highlighting 7 content marketing strategies you can’t ignore. A well-rounded content strategy helps you connect with your ideal buyer.

    • The Ultimate Guide to Optimizing Your Google Business Profile

      Ultimate Guide to Optimizing Your Google Business Profile

      Developing a diverse Local SEO strategy for companies with brick-and-mortar addresses or clearly defined service areas includes establishing and optimizing a Google Business Profile (abbreviated GBP for this article).

      Does Blogging Still Work

      Does Blogging Still Work?

      In the latest episode of Hack My Growth we’re going to look at blogging and what role it plays in marketing in the year 2021 and beyond.

      YouTube SEO Best Practices

      YouTube SEO Best Practices

      Did you know that YouTube receives 14.3 billion visits per month? That’s more than Facebook, Wikipedia, Amazon, and Instagram. Businesses and brands all over the globe are creating YouTube videos…

        6 Proven Methods To Improve Your Customer Experience Strategy

        Extend your relationships with customers beyond their initial purchase and create loyal fans with these methods for improving your customer experience strategy.

        What is Content Marketing?

        Excellent content marketing cuts through the noise of unhelpful information to attract the right customers. Read more from SMA Marketing.

        7 Content Marketing Strategies You Can’t Ignore

        We’re highlighting 7 content marketing strategies you can’t ignore. A well-rounded content strategy helps you connect with your ideal buyer.

      • 5 Ways To Convert SEO Leads Using Web Design

        5 Ways To Convert SEO Leads Using Web Design

        Learn how your web design impacts the conversion rate of you SEO leads and how a great design can grow your business online.

        Why Is User Experience Important in Web Design

        Why is User Experience Important in Web Design?

        Learn more about user experience (UX), why it is important for your website to have a good UX, and the benefits of having a good UX on your website.

        Why Design a New Website

        Why Design a New Website

        There are a few different ways to refresh your website. Learn the benefits of designing a new website as a part of your digital marketing strategy.

        Web Design and Development Services How To Find the Right Agency for Your Business

        Web Design and Development Services: How to Find the Right Agency for Your Business

        Learn the tips & importance of working with a digital marketing agency to find the right web design and development services for your business.

        Looking for a Web Designer? 10 Things to Keep In Mind

        Looking for a web designer but not sure where to start? Your website is your digital front door. Here are 10 things you need to look for in a designer.

        The History of Website Design: 30 Years of Building the Web [2022 Update]

        The History of Website Design. We’ve come a long way in 30 years of building the world wide web. Take a look at web design’s past, present and future.

      Get Up-To-Date Digital Marketing Tips Delivered Straight to Your Inbox!

      SMA Marketing Digital Marketing Agency Giving Back to Kiva Making Loans