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

Sep

18

blocked url in robots txt file test in google search console

How to Block Dynamic URL’s

Dynamic URL’s can appear on your website in many different ways. If you have an internal search box on your site, you will see that the URL might contain a question mark which stands for a query based action after a search has been performed. You may have an e-commerce site that allows the user to change the page by size and color. When that happens, you might see a dynamic URL that performs those intended actions by the user. Today, I am going to show you how to block these pages from being indexed and shown in the SERPs for Google and Bing.   If you are not familiar with […]

Read More

Sep

10

a bit smaller excel document after removing the formulas

How to Make Excel Smaller and Run Faster

Working with large sets of data with pivot tables, slicers, graphs, macros, formulas, and more can definitely make your excel document larger than it needs to be. The problem with a larger excel document is that it takes up more of your space on your hard drive or cloud, it takes longer to open on both desktop and a mobile device, and it can be very slow in performing simple tasks like filtering out the data or using tools like a slicer. This becomes especially true when you are dealing with hundreds of thousands of rows of data. In this blog post, I am going to show how to change […]

Read More
1 2 3 15