Mar

23

Full 90 Day Data from Search Console Before Test

How to Increase Your Organic Click Through Rate

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 […]

Read More

Mar

14

SEO Technical Analysis

How to SEO Analyze and Audit a Web Page

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 […]

Read More

Jan

19

301 Redirects Screaming Frog

How to Clean a Dirty XML Sitemap Using WordPress

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 […]

Read More

Jan

02

301 Redirect Opportunities

Understanding Content Drilldown in Google Analytics

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 […]

Read More

Dec

29

DuckDuckGo Logo

How to Track DuckDuckGo as Organic in Google Analytics

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 […]

Read More

Dec

27

Comma and Spaces in Text to Columns in Excel

Text to Columns in Excel Tutorial

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 […]

Read More

Dec

10

How to import data from the web into excel

How to Import Web Data into Excel

Importing data from the web into Microsoft Excel can be used for a range of reasons. One of the reasons why I personally do this is for Fantasy Football data analysis. I can create a connection from a website that updates player stats every week and create a connection into my excel document. By doing that, I can update the data into a pivot table and start to project out players weekly. By having this connection, I will save time in the long run as I will have the data already updated once I go into the spreadsheet. This is the website I will use in this tutorial below. Let’s get started.   Create the […]

Read More

Nov

06

how to forecast in excel

How to Forecast Data in Excel 2016

Within the data tab in Excel,  there is a forecast sheet button where you can select a time series and forecast out what the projection will look like. This is perfect if you are looking to make a quick forecast for your team, or you are curious about how you are trending with your own goals. The best part of this button is that the calculations are automatically done for you, so you don’t have to do any math or calculations that are normally associated to a task like this. Excel will give the projected numbers by the day, month, or year depending on the given data that you present. Just like any […]

Read More

Oct

16

screaming frog pull of sitemap

How to Fix XML Sitemap 404, 301 Errors

Screaming Frog offers the ability to upload your sitemap file and check for 200, 301, 302, 404, and 500 status codes that may be present in your file.  This blog post will go over how to upload your sitemap as a list and crawl to find 404 errors easily. This blog post will go over the importance of having a clean sitemap for SEO success too. Let’s get started.   Save Your Sitemap as a File   The first step is to find your sitemap and save it as a file. If you are unsure where your sitemap is, you can check out Search Console or Bing Webmaster Tools and look for the sitemap section […]

Read More

Oct

16

heat map in excel finding oppportunities

How to Show Values as Percentages in a Pivot Table

Did you know that you can visualize a pivot table’s sum or count as a percentage for the column? The benefits of using this is that you can switch back and forth at anytime, so you can visualize trends, act on opportunities, and truly compare like metrics against each other much faster. In this blog post, I will show how to do this at the most elementary level, but will expand upon this practice for other ways to slice and dice data. In this example below, I took 350k rows of data and quickly found what states drove high conversion rates and the lowest cost per acquisition. I can take this results […]

Read More
1 2 3 16