• 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

Data Visualization with Google Sheets

Data Visualization with Google Sheets

Google Analytics is one of the most widely known and used website analytics platforms. BuiltWith, a website that tracks what software is used on websites across the internet, knows of 29.3 million websites using Google Analytics, which comes out to 8.4 percent of the 348 million websites tracked in its database. (Source). Every day, Google Analytic’s (GA) is pulling billions of pieces of data for site owners. 

While many never even log in to see what is going on, the few that do are often overwhelmed by the amount of data and only look at service level metrics, such as overall site traffic. Learning GA takes time and patience. Just like any tool, the more you learn and use it, the more you get out of it. Google has a number of plugins that can help GA users extract their data and build powerful visualizations using Google Sheets. In this post, we will go over how to install the sheets add-on, run a report, and create a visualization that can bring your website data to life. 

Installing the Google Sheets Add-On

  1. The first step is to go to Google Sheets.
  2. In order to use the Google Analytics add-on, you must add it to your spreadsheet. The next few steps will tell you how.
  3. Next, create a new Google Spreadsheet (or open an existing one).
DATA Visualization.png

4. From the menu bar choose: Add-ons > Get Add-ons.

5. Find the Google Analytics Add-on from the add-ons gallery and select it.

6. From the add-on description page, click the “+” in the top right corner to add this add-on to your spreadsheet.

7. A dialog should pop up requesting your permission for the add-on to access your Google Analytics data. Click “Accept”.

8. The add-on is now installed. A “Google Analytics” submenu should now appear in the Add-ons menu.

Google Sheets-1.png

Creating Reports

Now that you have the GA add-on added, you can run reports. Reports can be created manually or by using the add-on’s report creation tool. To build a report with the tool itself, select “Add-ons” > “Google Analytics” > “Create a New Report” from the menu bar.

This will display a sidebar on the right which allows you to look up your Google Analytics account information as well as choose what dimensions and metrics to query. When you’re finished, click the “Create Report” button and your report information will appear in a sheet named “Report Configuration”. If a sheet doesn’t exist in the report, one will be created. 

Google Sheets 2-1.png

Now, it can be tempting to try to pull all of your data at once, but I recommend doing it in chunks. This way you can still make sure you’re getting what you need and not having to sort through a ton of extra data. To create additional reports, simply repeat the steps above. The new reports you create will add a new column of data to the right of the previous report.

If you look at the values the report creation tool enters into the report configuration sheet, you’ll notice that many of the cells are left blank. Don’t worry, this is intentional. The add-on is meant to get you started and provide you with the information you might not know off the top of your head. The rest of the fields will need to be entered by you.

If you are not sure what to enter, review Google’s very helpful configuration parameter reference page. This will help you better understand what to query and help ensure you get the data you want and need.

Running Reports

Once you have all your inputs into the “create a report” form, it’s time to run the report. To do this, you will need to query the data. To run all the reports you’ve created select “Add-ons” > “Google Analytics” > “Run Reports” from the menu bar.

Automating Reports 

In order to make sure you have the up to date data, you can run reports on a schedule. For instance, you may want a report to run once a month and to set the report to run every 30 days. To set up an automated report select “Add-ons” > “Google Analytics” > “Schedule Reports” from the menu bar. 

This opens a report scheduling box where you can turn scheduling on and off and set how frequently your report will run. To turn scheduling on, check the box labeled “Enable reports to run automatically.” Once scheduling is enabled you can use the drop-down bar to control the time and frequency. 

For a great tutorial, check out the video below.

Creating Visualizations 

While you can learn a lot from spreadsheets and the data they hold, adding some visualization can really help. Let’s say you run a report to compare this month’s traffic with last month’s traffic. To build the data source for this example, check out these videos. They will give you a really great walkthrough.   

After you have pulled the data you will see “sheets” tabs at the bottom of the page where each individual page of the data is held. Create a new sheet and label it “Dashboard.” Pull the data you are interested in and click the “insert chart” button in the navigation. Choose the visualization the makes the most sense and customize as needed.

Google Sheets DATA Visualization

As you can see, adding a visualization to the data helps you more easily see trends. There are a number of different chart types available that you can use to dig deeper and find out what is working and what isn’t. Another great feature is if you have your report on a schedule, the visualizations will update when the data updates. This is a very convenient feature in a fast paced business world.

Want to learn more about data visualization with Google Sheets?  Check out the video below.

While these reports aren’t the fanciest, they do help make sense of more of your data. When you can see how your traffic is trending you can explore what could be the cause of it. This is just one simple way of using free tools to dig deeper into your data to help you make more informed decisions. If you are looking for to do even more, sites like Simple Sheets offer dashboards and slicers to help your data come to life.  For a detailed set-by-step process, check out this link and tutorial from the Google Developers site.

On-Page SEO Guide

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