• 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

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

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

SMA Marketing Digital Marketing Agency Giving Back to Kiva Making Loans