Excel For SEO
Follow
Find
7.7K views | +8 today
Your new post is loading...
Your new post is loading...
Scooped by Jacob Jarnvall
Scoop.it!

Excellent Analytics Pro » Ampliofy

Excellent Analytics Pro » Ampliofy | Excel For SEO | Scoop.it

Excellent Analytics Pro is a plug-in that brings all the power of Google Analytics right into Microsoft Excel. You don’t have to log into the Google Analytics interface to export data; you can import data from within Microsoft Excel instead. When using Excellent Analytics Pro, you use an interface that you’re already familiar with—Excel.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Microsoft Advertising Intelligence

Microsoft Advertising Intelligence is a powerful keyword research tool that allows you to build and expand on your keyword list in a familiar excel interface. This enables you to easily gauge the performance of relevant keywords on the Yahoo Search! and Bing networks. Apply these insights to improve your keyword selection and campaign performance.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Extract Your Competitor Keyword Strategy [Excel Skills]

Extract Your Competitor Keyword Strategy [Excel Skills] | Excel For SEO | Scoop.it

At the recent SEOmoz / Distilled Pro Seminar in London, I gave a presentation on advanced keyword research. Today I’d like to share one of the tips I gave on how to extract your competitors target keyword list, with relative ease using tools we all have at our disposal.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

SEO: Using Excel for Keyword Analysis

SEO: Using Excel for Keyword Analysis | Excel For SEO | Scoop.it
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Export Search Results or Scrape SERPs to Excel CSV - Northside SEO

Export Search Results or Scrape SERPs to Excel CSV - Northside SEO | Excel For SEO | Scoop.it
Export the top 100 google search results to excel in two easy steps. Essential data for keyword research and link building.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Export VBA code from Excel files using Perl - Rob Hammond - SEO, Perl, etc

Export VBA code from Excel files using Perl - Rob Hammond - SEO, Perl, etc | Excel For SEO | Scoop.it
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel Hints for PPC | SEOptimise

Excel Hints for PPC | SEOptimise | Excel For SEO | Scoop.it
Excel is one of the best tools for PPC.Downloading your data into Excel gives much more scope for analysis and complex change than using a browser interface or...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excellent Analytics for Google Analytics – data grabber

Excellent Analytics for Google Analytics – data grabber | Excel For SEO | Scoop.it

The original and 100% free Google Analytics addin for Microsoft Excel. Automate your analytics!

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Swedish - Gör EXCEL till ett SEO-verktyg på nolltid

Swedish - Gör EXCEL till ett SEO-verktyg på nolltid | Excel For SEO | Scoop.it
Idag kommer ett tips till er som använder excel när ni arbetar med SEO och för er som inte gör det än. Nämligen ett plugin skapat utav Niels Bosma – och det är ett måste plugin för er som använder excel.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Useful Excel Tips for SEO & Website Auditing

Kill me if these Excel Sheet Tips don’t help you in SEO Ketan Raval ketan@letsnurture.com...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Using Excel for SEO – the Grand Collection of Tips

Using Excel for SEO – the Grand Collection of Tips | Excel For SEO | Scoop.it
You probably know that I am a big Excel fanatic (though not an expert). To me, Excel has always been the ultimate SEO, guest...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Tips on Using Excel for SEO and Link Building

Tips on Using Excel for SEO and Link Building | Excel For SEO | Scoop.it
There's some amazing SEO tools around but nothing can do everything and sometimes Excel can be very useful as it gives you so much freedom to manipulate your data.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Link Prospecting with Twitter Tools and APIs | The Beginner SEO

Link Prospecting with Twitter Tools and APIs | The Beginner SEO | Excel For SEO | Scoop.it

Use Twitter for linkbuilding by using some free tools and Google Docs. Here you can find a Google and Excel spreadsheet to copy and use for your needs!

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

PPC Reports: How to Highlight Meaningful Metrics Using Data Visualization

PPC Reports: How to Highlight Meaningful Metrics Using Data Visualization | Excel For SEO | Scoop.it
Good reporting is a key to proving the value of PPC and the job you’re doing managing PPC. Reports with poorly-crafted charts and rows of numbers suck. Use the right charts to effectively visualize your data, and combine them with solid analysis.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Example PPC Dashboard in Excel | By Data Be Driven

Example PPC Dashboard in Excel | By Data Be Driven | Excel For SEO | Scoop.it
If you're working in an environment where you have to do weekly reporting on your AdWords performance, and the reports in AdWords aren't cutting it, you may...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Excel for SEO Masterclass – Our Next Webinar

Excel for SEO Masterclass – Our Next Webinar | Excel For SEO | Scoop.it

Following on from the success of our first webinar, we’re happy to announce that we have the next one planned for Tuesday 28th August at 4.30pm. This time round, Richard’s going to be running through a Masterclass in Excel for SEO focusing on using API’s to build reports and tools within Excel. If you’ve never really used API’s with Excel before then fear not, we’ll cover everything from the basics right through to advanced link analysis.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Easy And Advanced Uses of Cell Formatting in Excel

Easy And Advanced Uses of Cell Formatting in Excel | Excel For SEO | Scoop.it
In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that post and then come back.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Competitor Backlink Analysis in Excel | SEER Interactive

Competitor Backlink Analysis in Excel | SEER Interactive | Excel For SEO | Scoop.it
When you're trying to rank for a particular term or piecing together a competitor landscape, you might be looking at tens of thousands of backlinks when you...
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

PPC Hints for Excel 2: The Array Formula and Negative Keyword Checking | SEOptimise

PPC Hints for Excel 2: The Array Formula and Negative Keyword Checking | SEOptimise | Excel For SEO | Scoop.it
Last February I gave you some handy Excel tips – here’s some more! Today I’m talking about array formulae. What’s an Array Formula?
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Easy And Advanced Uses of Cell Formatting in Excel

Easy And Advanced Uses of Cell Formatting in Excel | Excel For SEO | Scoop.it
In my post on table formatting, I demonstrated how to transform your static data into a simple yet sexy database in a matter of seconds. If you don’t know how to use table formatting, go read that post and then come back.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

GA Data Grabber — Works in Excel

GA Data Grabber — Works in Excel | Excel For SEO | Scoop.it

GA Data Grabber: Easy-to-use report automation tool for Google Analytics, AdWords, Facebook & Microsoft adCenter. It's the only analytics tool that makes it easy to combine metrics for lots of sites into a single view. Works in Excel.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Some Simple Excel Functions & Macros To Help SEO Productivity

Some Simple Excel Functions & Macros To Help SEO Productivity | Excel For SEO | Scoop.it
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

3 Essential Excel Plugins for SEO

3 Essential Excel Plugins for SEO | Excel For SEO | Scoop.it
Here I am going got talk through some of the Excel plugins I have found very useful for SEO tasks. Best thing I can advise is to get them installed and give them a go for yourself.
more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Microsoft Excel for SEO Spreadsheet Templates | John Doherty

Microsoft Excel for SEO Spreadsheet Templates | John Doherty | Excel For SEO | Scoop.it

Excel is one of the sharpest knives in the SEO’s drawer, or at least it should be. I’ve developed these Excel templates to help you expedite your work. Everything from visualizing backlink profiles to segmenting link prospects by domain authority, you’ll find it here.

more...
No comment yet.
Scooped by Jacob Jarnvall
Scoop.it!

Work with SEO in Excel - The ultimate Excel plugin | Niels Bosma

Work with SEO in Excel - The ultimate Excel plugin | Niels Bosma | Excel For SEO | Scoop.it
SeoTools is an Excel plugin that adds a bunch of useful functions for working with SEO and other web metrics.
more...
No comment yet.