Have you ever sat down and thought about the tools that make your job easier? From a laptop, phone and Wi-Fi to search engines, Excel, PowerPoint, SlideShare, Dropbox and Microsoft Word.
The digital strategists and PPC managers at Evolve Digital Labs recently compiled a list of some of our favorite tools that make us more efficient and improve outcomes when it comes to SEO and SEM.
Google Adwords is at the center of most digital marketing campaigns. As a Google partner the Evolve team uses Adwords daily.
Keyword Tool provides search volume for keyword lists, however the values it returns are estimates and can be wildly inaccurate especially for low-mid search volume terms.
A better solution to get the true search volume is to use the Traffic Estimator tool. We do a traffic estimate for sites and keyword lists using the maximum bid ($100) to get the true search volume for those terms.
If your keyword list is large, (>2k) you can still use this method via the Adwords API and a little scripting know-how.
SEO Mofos Search Snippet Tools helps quickly visualize and show examples of what SERPs will look like.
Microsoft SEO Tools are helpful options for improving Bing SEO, as most other tools available are geared to optimize for Google.
Excel sheets are something Evolve’s PPC managers pour over hourly scanning thousands of keywords and search queries for clients like Merck and Charter Spectrum. It helps to have a few easy tricks to make working with Excel and endless data a little easier.
The Pivot Tables function allows users to look at account data for top-level analysis like campaigns, or ad groups. It can also quickly drill down all the way to keyword level to find which KWs are either driving the success of a campaign or holding it back.
The Find/Replace tool helps clean up data, which is one of the most important keys to big data sets and being able to quickly analyze and make accurate cost-effective decisions.
Everyone knows how to use VLOOKUP and what it does, but a free add-in in Excel called Fuzzy Lookup can help by matching up two datasets. Like Vlookup, Fuzzy can compare two unique columns between 2 sets of data. However Fuzzy can match up two columns from each side. So you can match First Names, and Last names that may not be in the same columns without concatenating. Fuzzy is free and takes a little practice to understand how it works. There is a limit on the size of data but for a couple 100,000 rows of data it works great.
All of our clients undergo an audit to identify opportunities for growth. “Found SEO Tool” (UK) is a straightforward audit resource that provides insight into what to fix on a website, like Screaming Frog it’s used more for analysis than an SEO road map.
Webmaster Tools are critical during the audit phase; we use those insights to highlight the next steps. We pay incredibly close attention to impression data, query data and CTR to analyze organic performance and potential.
Those are just a few of our top tools, to learn more about how we can put them to work for you get in touch with us. If you’ve got a unique ‘go to’ SEO/SEM tool that you’d like to share, let us know!