September 09, 2018 | in Agency & Digital News, Paid Search & Media Buying

Free Tools From ESV Digital!

Save Some Time in Your Workflow

By Steve Plimmer - Director of Account Management US

One thing that is certain, apart from the proverbial Death and Taxes, is that if you run a digital marketing account, you’re going to need to use Excel. In addition, you’re going to need to deal with a bunch of data.

ESV Digital has come to the rescue with a couple of free Excel tools that focus on keyword analysis (the content of keywords)
and forecasting.

Forecasting

The first tool can help you forecast a year’s worth of monthly spend and revenue performance based on 24 months of previous history. It uses a couple of forecasting to techniques to give the most realistic outcome month to month.

Some notes:

  • It has to have monthly data covering a full 24 months to work; no more, no less.
  • Include only the columns indicated in the instructions.
  • The tool lets you set spend increase and Average Order Value increase estimates to see how the trends may be affected. The settings of the latter on the ROI tab forces the same in the other KPI tabs.

DOWNLOAD HERE

Scan Keywords for Themes

The second tool performs two functions. One tab will let you paste a set of keywords (or search queries) and tell you if there seems to be at least one of the UK or US city, town, state, country, a day or a month.

If a keyword has more than one, like a city and month, it’ll say so.

Another tab lets you paste your keyword list, and then paste or type in a custom list of terms you want to find – the examples here are often qualifying terms – so you can gather the most common themes of keywords to help you decide on an account structure (ad group themes etc.). As a bonus, you get a count of the number of words in each keyword phrase.

excel tools

It is built for 1,000 keywords at a time right now but you can extend this by copying the formula down to the number of keywords you have. You can search for up to 6 terms.

One great scenario for this tool is to find irrelevant searches from search queries so you can exclude them – e.g. “second hand” and “used” if you sell only new items. But there are quite a few uses to which this tool can be put.

DOWNLOAD HERE

 

We hope these tools are of value to you and give you some of your precious time back!

Check out our downloads page for more and don’t forget to follow us on Facebook and Twitter to stay in the loop.

LATEST BLOG POSTS

When it comes to online branding, don’t forget the ‘branding’

By Ashley Hurst - Head of Strategy...

Find Out More

How to solve Facebook under-delivery

A guide with the most common reasons...

Find Out More

Scroll Depth Tracking And Bounce Rate In Google Analytics

By Ben Johnston - Head of SEO...

Find Out More

Paid Search Is Fishing, Not Fish Farming

Where Paid Search Fits in the Marketing...

Find Out More

Want to know more?
Start a conversation