Blog

Home / Blog
google trends local seo keyword research tool

google trends local seo keyword research tool

seo
Performing local seo keyword research can seem really tough. You might have a niche field in a place where you wonder if anyone is even looking for your services that you give. You might even have a shop, but you are lost on what to blog about in your area that can attract foot and site traffic. I'm here to show how you should use Google Trends for your research and dominate in local SEO! In this blog post, I am going to show how a local bicycle shop that is located in Massachusetts can use Google Trends for their local SEO keyword research. Let's begin. What is Google Search Trends Google trends is a website that takes social trends from the world and aggregates it based on popularity, search…
Read More
Microsoft Groove Music Guide

Microsoft Groove Music Guide

fun
In an age where music streaming services tend to be the same, you might ask yourself why another service might be worth exploring? This guide will shed light on a relatively unknown music service that might answer your needs compared to another service. This guide will explain what Microsoft Groove music is, what devices it works on, what are the unique advantages and disadvantages this service has, how to get the subscription for free, and if it is ultimately is worth switching too.   What is Groove Music? Microsoft Groove is a music streaming service owned by Microsoft. It has had a long history of name changes like Xbox Music and Zune, but now it has been re branded to be called Groove with the Windows 10 launch.    How…
Read More
Ultimate Guide to Edge Extensions

Ultimate Guide to Edge Extensions

fun
Microsoft Edge is a new browser that can be found on Windows 10 computers. Launched on July 29th, 2015, Edge has seen a pretty low uptick in usage by users. When launched, the browser did not have any extensions and was lacking some other key functions that rivals like Chrome, Safari, Firefox, and others had. With many updates since 2015, Microsoft Edge has some features like extensions and plugins that can help you stay productive while you browse the web. Here is the ultimate guide to finding, downloading, and using Microsoft Edge with extensions.   How to install and Use Extensions for Microsoft Edge Step 1: Launch Edge If you are unfamiliar with where to find this browser, you should see a blue letter "e" at the bottom of your…
Read More
How to Remove Tracking URL’s in Excel

How to Remove Tracking URL’s in Excel

Excel
Tracking URL's are special characters added to paid search campaigns, social media campaigns, email campaigns, and pretty much anything that you want to specifically track for marketing purposes. While great for separating out channels by the source, you will quickly realize the nightmare it creates when you want to check your data. In this blog post, I am going to show how to update your excel formula to remove everything after a special character like a question mark. You want to do this so you are presented with a clean URL (without the tracking), so you can put everything into a Pivot Table and review the data. Here are the steps below.   Excel Steps to Remove Text After a Specific Character Here is an example of exporting the top landing pages with the…
Read More
How to Increase Your Organic Click Through Rate

How to Increase Your Organic Click Through Rate

experiments
In this blog post, I am going to share an experiment that I'm about to run. I want more click activity on my site for my Bing Search Partners post in both Google and Bing. To do this, I am going to change my title tag and meta name description and see if I can get it to be more click enticing and increase its overall click-through rate. My hypothesis is this. If I can make my title and description stand out more, I will receive a higher click-through rate than the 5.9% I have received in the last 90 days according to Google Search Console. To do this, I am going to break down the competition, take historical data from both Google and Bing, push the update to both engines, and…
Read More
How to SEO Analyze and Audit a Web Page

How to SEO Analyze and Audit a Web Page

seo
You've worked for weeks (maybe months) on a guide or a blog post and you are excited to finally push it out and live. Perhaps your guide is so long (like over ten thousand words) that you can't exactly manually check to make sure all the SEO best practices are being used. This is where tools will come in for your SEO Website audit. Tools like Screaming Frog, Google Search Console, Bing Webmaster Tools, and more are free and will get you top analysis for your site. In this guide, you will see how to do a technical SEO audit along with analyzing your webpage for common errors that can be easily fixed and will set you up for great success. Let's get started!   How to Find Broken Links with Screaming Frog…
Read More
How to Clean a Dirty XML Sitemap Using WordPress

How to Clean a Dirty XML Sitemap Using WordPress

seo
A clean sitemap is a key part for having an effective SEO strategy for your website. While Bing has said they have a low tolerance on dirty sitemaps, Google has said they are more lenient. I believe it is still important to have a clear sitemap non the less. A clear sitemap will also cut the amount of unnecessary steps the search bots have to take to crawl your sitemap. Assuming you know how to crawl your sitemap for errors, you are now ready for the next step if you use WordPress.   Screaming Frog Results + WordPress   Here is an example of a screaming frog pull that I did on my site. I sorted the view to show the three 301 redirects in my sitemap. When I look at the URL's, I…
Read More
Understanding Content Drilldown in Google Analytics

Understanding Content Drilldown in Google Analytics

search
The content drilldown section within Google Analytics shows the taxonomy of your site, how it is organized (both good and bad), and where people interact well when visiting your site. Within this report, you can see how many page views a page gets, the bounce rate, the exit rate, and the time spent on the page. This report can help you see if there are sections on your site that are working or not, if you have duplicate content on your site with the title tags, and if your structure on your site is a mess. You can break out the report by medium and source to see how your audience reacts when coming from a different source like email over organic search. This type of report can give you quick SEO technical wins just by doing a little…
Read More
How to Track DuckDuckGo as Organic in Google Analytics

How to Track DuckDuckGo as Organic in Google Analytics

seo
DuckDuckGo has grown search query share ever since it launched in 2008. Within Google Analytics, you will see traffic from this source listed as referral instead of organic. To change this, you will need to update a filter and the organic search sources within Google Analytics. This should take a grand total of 2 minutes to complete. Once this is set up, you will then count these searches as organic moving forward. Let's begin!   How to Add DuckDuckGo as Organic Visits in Google Analytics   The first thing you should do is split out the view of your website. You should have a raw listing which does not have any filters on your site and then have at least another listing that has filters. Custom filters are a great way to…
Read More
Text to Columns in Excel Tutorial

Text to Columns in Excel Tutorial

Excel
Sometimes you will inherit data from a tool or your boss that needs to be separated into each column to make the data easier to sort and process. One example of needing to do this is if you have imported data from the web into excel and the name of the football player, their team, and their place are all put into the same cell. While you can import that data, you now need to split that results to view it easier. Luckily, we can use the text to column section within excel to quickly break this out than manually doing this. Here are the steps on how to use the convert text to columns wizard in Excel. I've also included pictures that help explain these steps in greater detail.…
Read More