Much of the day to day activity of digital marketing departments and professionals involves handling large amounts of data. The…
Keyword Research With The Excel Bing Ads Intelligence Add-in
One of the greatest things about working in the Search Industry is the copious amount of data that we get…
Excel Formatting Tips To Rock Your PPC Reports
You might use formatting already, but I am here to make your life a little easier yet. I’m going to show you how to introduce color to your reports.
Why does color matter? Color is much easier to process then black-and-white numbers on an Excel spreadsheet….
How To Do An Index Audit
Combine two powerful tools — SEO Quake and Excel — to perform an index audit, identifying missing pages….
Free Excel Template For Optimal PPC Keyword Organization
There are great posts that discuss keyword research, but what comes next? How do we organize these keywords into for our Adwords campaign? Can we expand on these keywords to include permutations?…
Calculate URL Depth Using Excel
Want to quickly and easily see how “deep” your URL’s are? This excel Formula counts directories and URL query parameters to determine to true depth of a URL….
(Almost) Automatically Reveal A Site’s Directory Structure Using Excel
The larger the site the harder it becomes to figure out how many different levels and permutations there are once you leave the homepage.
Using Excel you can get a clear view in no-time….
How to Check HTTP Redirects with Microsoft Excel
After our previous three SEO spreadsheet articles … How to Automatically Track Your Google Positions in Microsoft Excel A Search…