Articles on Excel

RSS

Competitive Analysis for Panda Using SEMrush [Tutorial]

semrush-panda-competitive-analysis

There’s a lot you can learn from analyzing websites in your niche that have been impacted by Panda. This post explains how to use SEMrush to drill into organic and paid search data in order to surface problematic content, keyword targeting issues, usability problems and more. There’s a lot you can learn from analyzing websites in your niche that have been impacted by Panda. This post explains how to use SEMrush to drill into organic and paid search data in order to surface problematic content, keyword targeting issues, usability problems and more. 0 Comments

PPC Budget Forecasting 101

Budget

As pay-per-click professionals, we're often asked to play with our numbers, shift our budgets, and essentially predict the future. A daunting task, for sure. Here's a simple walk-through on how to answer those tough budgeting questions from clients. By recalculating your search account's potential, you can create a rough PPC budget forecast that will help you answer all of your clients' questions. 0 Comments

PPC Click-Through Rate by Position: Does Rank Matter? [Data]

Click-Through Rate by Position

What is the "right" position is for a given keyword? A data set of more than 12,000 data points was analyzed to find out what the click-through rate (CTR) would be at various average positions. Here are three insights from the data. What is the "right" position is for a given keyword? A data set of more than 12,000 data points was analyzed to find out what the click-through rate (CTR) would be at various average positions. Here are three insights from the data. 0 Comments

PPC Management: Your Past, Present & Future

Forward Looking

Don't get stuck in the mire of the present and always putting out fires within your account. PPC managers need to reside in the future, past, and present simultaneously in order to get the full scope of their campaigns and optimize them successfully. Don't get stuck in the mire of the present and always putting out fires within your account. PPC managers need to reside in the future, past, and present simultaneously in order to get the full scope of their campaigns and optimize them successfully. 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

Link Building 101: Competitor Analysis

Link Building 101 Competitor Analysis

Competitor backlink analysis is great – you get the initial research into the industry done, it helps you understand the competition, and it gives you a tidy list of high opportunity links. Let's dive into the how of competitor backlink analysis. Competitor backlink analysis is great – you get the initial research into the industry done, it helps you understand the competition, and it gives you a tidy list of high opportunity links. Let's dive into the how of competitor backlink analysis. 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

14 Tips on How to Become a More Efficient SEO Professional

Begin To-Do List

Most SEO professionals live on the web, where distractions are myriad – from email to social media – and something new crops up almost every minute. These ideas and tactics will help you stop procrastinating, get focused, and be more productive! Most SEO professionals live on the web, where distractions are myriad – from email to social media – and something new crops up almost every minute. These ideas and tactics will help you stop procrastinating, get focused, and be more productive! 0 Comments

3 More Big PPC Mistakes Even Pros Make & How to Fix Them

oops-mistake-sign

Mistakes aren’t bad … if you learn from them. Not even seasoned PPC professionals are perfect. Here’s hoping you can avoid these blunders involving geotargeting, keywords, and conversion and tracking – or fix any errors you’re guilty of. Mistakes aren’t bad … if you learn from them. Not even seasoned PPC professionals are perfect. Here’s hoping you can avoid these blunders involving geotargeting, keywords, and conversion and tracking – or fix any errors you’re guilty of. 0 Comments

Recharge Your PPC Profitability: 5 Ways to Diagnose & Treat a Paid Search Slump

profit-graph

Every so often, after having worked on an account with successful results, there can be a plateauing or declining period. Even if you profits aren't dipping, proactively performing these steps will help your account operate at peak performance. Every so often, after having worked on an account with successful results, there can be a plateauing or declining period. Even if you profits aren't dipping, proactively performing these steps will help your account operate at peak performance. 0 Comments

Competitive Analysis: How to Become an SEO Hero in 4 Steps

organic-search-visibility-growth-by-product-line

Spending time understanding and tracking trends in your competitive landscape will positively impact the metrics you care about. And sharing both the traffic and revenue growth and insights you gain may make you a star in the executive suite. Spending time understanding and tracking trends in your competitive landscape will positively impact the metrics you care about. And sharing both the traffic and revenue growth and insights you gain may make you a star in the executive suite. 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

3 Holiday PPC Tips for Ecommerce Advertisers With Thousands of Products

christmas-santa

When you have (tens of) thousands of products, each with a different price and margin, and multiple categories, PPC life can get complicated indeed. Here are three opportunities for e-tailers. Act quick to implement these to ride the holiday wave. When you have (tens of) thousands of products, each with a different price and margin, and multiple categories, PPC life can get complicated indeed. Here are three opportunities for e-tailers. Act quick to implement these to ride the holiday wave. 0 Comments

How to do Awesome SEO Keyword Research for a Large, Templated Site

keyword-research-diagram

Looking for keywords to help a formulaic, themed site rank ? Learn how to work out which modifying terms (or “modifiers”) are the most popular in terms of search volume, so you can realize a base level of optimization at the page template level. Looking for keywords to help a formulaic, themed site rank ? Learn how to work out which modifying terms (or “modifiers”) are the most popular in terms of search volume, so you can realize a base level of optimization at the page template level. 0 Comments

How to Create a Content Calendar to Correlate SEO Results

example-seo-content-calendar

You want to create content that is relevant and interesting. Once all that hard work starts to show improved results, don’t let others take all the credit for traffic uplifts across non-brand terms and ranking improvements for target keywords. You want to create content that is relevant and interesting. Once all that hard work starts to show improved results, don’t let others take all the credit for traffic uplifts across non-brand terms and ranking improvements for target keywords. 0 Comments

How to Identify a Link Profile Susceptible to Google Penguin

links-by-anchor-text-link-detective

Google’s Penguin update targeted sites with an unnatural link profile – those with a majority of their links coming from low quality sites along with overly-optimized anchor text. Here’s how site owners can diagnose if they were hit and why. Google’s Penguin update targeted sites with an unnatural link profile – those with a majority of their links coming from low quality sites along with overly-optimized anchor text. Here’s how site owners can diagnose if they were hit and why. 0 Comments

Downloads & Pivot Tables for AdWords Analysis

pivot-chart-mobile-visits

You spend time extracting data about AdWords campaigns to send to your clients, your boss, and other stakeholders. But more important is the data you extract for yourself, to really analyze issues. Here’s what you should take into consideration. You spend time extracting data about AdWords campaigns to send to your clients, your boss, and other stakeholders. But more important is the data you extract for yourself, to really analyze issues. Here’s what you should take into consideration. 0 Comments

Negative Keyword Functionality Now Available in adCenter

adcenter-exact-match-negetive-keywords

Exact match negative keywords are now live in adCenter. This release is expected to help simplify account management, performance, and work much like how AdWords handles negative keywords. Here's a quick overview and some early results. Exact match negative keywords are now live in adCenter. This release is expected to help simplify account management, performance, and work much like how AdWords handles negative keywords. Here's a quick overview and some early results. 0 Comments

Ensure Your Success When Porting Campaigns from Google AdWords to Microsoft adCenter

Import Campaign from Google to adCenter

The four biggest areas of concern when porting campaigns from AdWords to adCenter are bids, keyword status, modified broad match, and tracking tags. Use this guide to save time and money to finding and fixing potential PPC headaches. The four biggest areas of concern when porting campaigns from AdWords to adCenter are bids, keyword status, modified broad match, and tracking tags. Use this guide to save time and money to finding and fixing potential PPC headaches. 0 Comments

Easier Negative Keyword Management in AdWords

Google introduced a useful addition to AdWords that potentially makes managing negative keywords across multiple campaigns a lot easier. Here's how to get the most out of them. Google introduced a useful addition to AdWords that potentially makes managing negative keywords across multiple campaigns a lot easier. Here's how to get the most out of them. 0 Comments

The Big "O" -- Offshoring

Offshoring is a simple word, but one that elicits strong responses. In a down economy, the case for offshoring is simple. But there are issues to address to know when and how to offshore part of your search marketing program. Offshoring is a simple word, but one that elicits strong responses. In a down economy, the case for offshoring is simple. But there are issues to address to know when and how to offshore part of your search marketing program. 0 Comments