Articles on Excel spreadsheets

RSS

Fast SEO Competitive Analysis

seo-progress

Careful keyword research is a time-consuming, often overlooked, but yet foundational aspect of creating a fantastic SEO strategy. Careful keyword research is a time-consuming, often overlooked, but yet foundational aspect of creating a fantastic SEO strategy. 0 Comments

Link Building With Ahrefs: A How-To Guide

step-1-davies

This step-by-step guide to link building with Ahrefs also looks at how the tool helps sort through massive amounts of data so you can make more positive decisions faster. This step-by-step guide to link building with Ahrefs also looks at how the tool helps sort through massive amounts of data so you can make more positive decisions faster. 0 Comments

How Can Good PPC Managers Become Great PPC Managers?

Good to Great

Good PPC managers get results, know their way around the necessary data tools, and can follow the foundations of PPC well. But great PPC managers don’t stop there. These are some characteristics that elevate a PPC manager from good to great. What are the differences between good PPC managers and great PPC managers? These are some characteristics that elevate a PPC manger from good to great. 0 Comments

Google Wants to Woo Enterprise Clients Away From AdWords Management Platforms

AdWords Device Clicks by Day of Week

Two new features add powerful, enterprise-level AdWords management functionality previously available through outside platforms like Kenshoo and Marin. Two other features are unique to Google and will give management solutions a run for their money. Two new features add powerful, enterprise-level AdWords management functionality previously available through outside platforms like Kenshoo and Marin. Two other features are unique to Google and will give management solutions a run for their money. 0 Comments

4 Ways to Avoid Getting Hit by Negative SEO or New Unnatural Links

New Ahrefs Graph

When it comes to unnatural links, companies need to remain vigilant. This post explains four actionable methods for tracking new unnatural links, so businesses can avoid negative SEO attacks, future Penguin hits, and manual actions. When it comes to unnatural links, companies need to remain vigilant. This post explains four actionable methods for tracking new unnatural links, so businesses can avoid negative SEO attacks, future Penguin hits, and manual actions. 0 Comments

PPC Management Operations: The Ultimate Guide

engine-x-ray

Regularly scheduled daily, monthly, quarterly, and semi-annual PPC tasks will ensure that you miss less opportunity to respond to change and increase your return on investment. This guide will help your PPC accounts perform at the optimal level. Regularly scheduled daily, monthly, quarterly, and semi-annual PPC tasks will ensure that you miss less opportunity to respond to change and increase your return on investment. This guide will help your PPC accounts perform at the optimal level. 0 Comments

Claim 2014s Biggest Easy Traffic Opportunity in 3 Easy Steps

The 2014 Traffic Plan

Want to quickly grow traffic from the content you already have or what you already rank for? This guide to auditing your existing content will give you the best possible chance of ranking it to attract as much traffic as humanly possible. Want to quickly grow traffic from the content you already have or what you already rank for? This guide to auditing your existing content will give you the best possible chance of ranking it to attract as much traffic as humanly possible. 0 Comments

Link Building 101: How to Conduct a Backlink Analysis

Link Building 101 Backlink Analysis Guide

Being able to perform a thorough backlink analysis is a fundamental element to any link building campaign. What's more, running backlink analyses can help develop your fundamental knowledge of links, link building strategies, and link quality. Being able to perform a thorough backlink analysis is a fundamental element to any link building campaign. What's more, running backlink analyses can help develop your fundamental knowledge of links, link building strategies, and link quality. 0 Comments

Use AdWords Scripts to Streamline Your PPC Optimization Efforts

adwords-create-new-script

AdWords Scripts allows users to work directly with Google AdWords API and pull data in Google Spreadsheets or other data housing software. Here are a couple of easy ways AdWords Scripts can be used to streamline your optimization process. AdWords Scripts allows users to work directly with Google AdWords API and pull data in Google Spreadsheets or other data housing software. Here are a couple of easy ways AdWords Scripts can be used to streamline your optimization process. 0 Comments

How to Check the Status of Google Penguin Link Removals Using Screaming Frog or Deep Crawl

frog-penguin-check-links

For websites hit by Penguin, some webmasters need to analyze thousands of links (or more). This step-by-step tutorial walks you through the process of using Screaming Frog and Deep Crawl to check a list of unnatural links to be removed. For websites hit by Penguin, some webmasters need to analyze thousands of links (or more). This step-by-step tutorial walks you through the process of using Screaming Frog and Deep Crawl to check a list of unnatural links to be removed. 0 Comments

What is Mobile App Attribution & Why is it Important?

mobile-app-attribution

Mobile app attribution is vital for measuring the effectiveness of your marketing campaigns. While there isn't a standard method of tracking iOS apps, two methodologies are most used: unique identifier matching and device fingerprinting. Mobile app attribution is vital for measuring the effectiveness of your marketing campaigns. While there isn't a standard method of tracking iOS apps, two methodologies are most used: unique identifier matching and device fingerprinting. 0 Comments

PPC Bid Management: Are You Managing Bids Efficiently?

change-bids-increase-bid-by-this-percent

Every PPC manager should be aware of the range of features and methods for managing bids efficiently and effectively. Here is a basic breakdown of the different ways you can manage your bids and the pros and cons of each. Every PPC manager should be aware of the range of features and methods for managing bids efficiently and effectively. Here is a basic breakdown of the different ways you can manage your bids and the pros and cons of each. 0 Comments

1 PPC Resolution You Must Make: Fix Your Quality Scores

bing-ads-webpage-keywords

It’s time to fix your quality scores. Many advertisers have hundreds, if not thousands, of keywords, so prioritizing optimization efforts is a must. Here’s how Bing Ads Intelligence can help improve your quality scores and landing page relevancy. It’s time to fix your quality scores. Many advertisers have hundreds, if not thousands, of keywords, so prioritizing optimization efforts is a must. Here’s how Bing Ads Intelligence can help improve your quality scores and landing page relevancy. 0 Comments

5 Advanced (But Simple) SEO Analyses You Should Perform With Visitor Intelligence

company-size-leads-share

Collecting the right data and attributing it to the right sources will help you understand how SEO impacts your business. Learn how to structure your data to enable analysis and reporting and SEO analyses you can perform with visitor intelligence. Collecting the right data and attributing it to the right sources will help you understand how SEO impacts your business. Learn how to structure your data to enable analysis and reporting and SEO analyses you can perform with visitor intelligence. 0 Comments

50+ Tools to Automate Your Link Building

These backlink analysis and link prospecting tools can help link builders shift their workload to computers as much as humanly possible. These backlink analysis and link prospecting tools can help link builders shift their workload to computers as much as humanly possible. 0 Comments

What's the Value of a Paid Search Impression?

Tie conversion metrics to paid search impressions with this incredibly useful tool for determining the true value of your paid search campaigns. Tie conversion metrics to paid search impressions with this incredibly useful tool for determining the true value of your paid search campaigns. 0 Comments

Last-Minute Gifts for Online Marketers

Make your marketing priority wish list for SEO Santa, and check it twice. These three "gifts" could make all search marketers happy this holiday season. Make your marketing priority wish list for SEO Santa, and check it twice. These three "gifts" could make all search marketers happy this holiday season. 0 Comments

Google Unveils More of the Invisible Web

Google has quietly extended its index of the web, for the first time making searchable a number of file formats that are all but ignored by other search engines. Google has quietly extended its index of the web, for the first time making searchable a number of file formats that are all but ignored by other search engines. 0 Comments

Google Unveils More of the Invisible Web

Google has quietly extended its index of the web, for the first time making searchable a number of file formats that are all but ignored by other search engines. Google has quietly extended its index of the web, for the first time making searchable a number of file formats that are all but ignored by other search engines. 0 Comments

AltaVista Launches Trusted Feed Program

AltaVista's new Trusted Feed program offers unprecedented control to webmasters, allowing submission of 500 or more URLs directly to the search engine via an XML feed. AltaVista's new Trusted Feed program offers unprecedented control to webmasters, allowing submission of 500 or more URLs directly to the search engine via an XML feed. 0 Comments