Review SEO and Adwords performance together
About the SEM Gap Analysis Spreadsheet
- Author: Dave Chaffey
- Last updated: May 2011
- Format: Excel 2003 (.xls) template for use in later versions
How will this template help me?
Often paid and natural search are managed separately, but they are most powerful when managed together. This spreadsheet enables you to rapidly import data exported from Google Analytics to compare paid and natural search together. Use it to work with an agency to identify keyphrases to prioritise to maximise traffic.
We’ve used this on many search consultancy projects in financial services, retail and travel sectors and it’s a great way to review where you’re search is broken and needs improving.
This template gives you
- A master worksheet comparing your performance for paid and natural keyphrases side-by-side
- A separate worksheet for Google Adwords Keyword tool data to enable you to compare paid and natural search together
- Separate worksheets for paid and natural search performance
- Home page outlining how to use the spreadsheet.
What does the template include?
The template includes these features:
- Designed to compare paid and natural search performance
- Uses the standard export format from Google Analytics
- Colour-coding of poor performance highlights where action needed
- Can be used just to review and improve SEO
Download Template
You access this advice if a Smart Insights Expert-level member.
Smart Insights Expert Members get “at your desk access” to in-depth advice to improve their online marketing skills and capabilities:
- In-depth Ebooks
- Online training
- How to videos
- Marketing templates
- Audit Online Capabilities
Locked
About Smart Insights Templates
What make's our templates different?
The Smart Insights system for digital marketing improvement includes many templates to help you plan and manage your marketing. The templates are Word or Excel checklists to help you review a company's approach to digital marketing or Excel calculators and models to enable you to better plan digital marketing. All our templates are:- Focused on improvement – Each template will support you to review current ways of working and recommend improvements.
- Available in Word or Excel – Supplied in the most commonly used apps, they can be imported into other programmes.
- Provided as an unbranded template – Unlike our guides, these templates are plain, so you can easily modify to add your own company logo
- Field-tested – Dave Chaffey and the authoring team have years of experience in online marketing, we know the questions that need answering, so that's we include
How will the templates help me?
Our templates are designed to be used as "live documents" to help you and your team when planning or managing digital marketing. This is how our guides help:- Company owners and marketing managers - many of templates cover planning and strategy.
- Digital marketing and Ecommerce managers - as well as planning and strategy you can audit specific digital channels like search or social media marketing with our templates.
- Digital marketing specialists - templates are available for each of the main digital channels, so whether you work on Social media marketing, SEO, PPC, email marketing or conversion rate optimisation for the website there is a template to help. If there isn't, get in touch and we can develop one .
- Consultants and agency specialists - review your own techniques and process against the best practice templates to help you provide structured insights and recommendations for clients.
