Features

"ClickEquations has done a terrific job of delivering its service both as a web-based interface but, more importantly, in its ClickEquations Analyst product in Excel. Because Quillion manages our own products/services in performance marketing as well as that of great clients, it is an ideal tool." David Shor – Principal, Quillion, Inc.

ClickEquations Analyst Templates

ClickEquations Analyst, our free Excel plug-in for ClickEquations, lets you build and share dashboards with coworkers and clients.

Analyst Templates Each copy of ClickEquations Analyst ships with a dozen pre-built templates that you can use with your own data, no changes needed:

Dashboards (Trends and Snapshots)

Dashboards provide a quick look at how your campaigns are performing on Google, Yahoo, and MSN over the past 7 days.

You can change the date range to any time frame you want.

Clicks and Conversion Dashboard

CE_analystTemplates-clicks-and-conversions

Clicks and Cost Dashboard

CE_analystTemplates-clicks-and-costs

< Back to top >

Progress (Comparisons)

The progress templates help you answer the question of “What’s Changed?” You can cut through the clutter of thousands of keywords and surface trends you wouldn’t normally find by just reviewing the Top 10 Campaigns, etc.

Month-Over-Month Trend

CE_analystTemplates-clicks-and-conversions

 What’s Changed? (Google)

CE_analystTemplates-clicks-and-costs
   
What’s Changed? (Yahoo)

CE_analystTemplates-clicks-and-conversions

 ROI Distribution Report

CE_analystTemplates-clicks-and-costs

< Back to top >

Potential (Forward Looking)

How much money could you make and where are the biggest areas of opportunity? The Potential reports guide your analysis and optimization.

Google Impression Share (Campaign)

CE_analystTemplates-clicks-and-conversions

 ClickShare Opportunity (Ad Group)

CE_analystTemplates-clicks-and-costs

< Back to top >

Keywords

Our two Keyword templates help you understand

  • How well distributed your keywords are and the impact of Match Type on revenue
    and performance
  • Which keywords are generating clicks on one engine that might be candidates for expansion to another engine
Match Type Distribution

CE_analystTemplates-clicks-and-conversions

 Clicks By Engine

CE_analystTemplates-clicks-and-costs

< Back to top >

Bids

Finding the Minimum First Page Bid in Google AdWords and determining whether it’s even a problem for you is tedious. Our template automatically gathers the Minimum First Page Bid Estimate and compares it to your current bid along side your current position and Quality Score. You can quickly see which words you need to focus on and which can be ignored.

Minimum First Page Bid Estimates

CE_analystTemplates-clicks-and-conversions

< Back to top >

Quality Score

Quality Score is just as important as bid in determining your Ad Rank and what you actually pay for a click. Use our Quality Score template to see the distribution of keywords that have a Quality Score of 1-10 and get a quick list of those below 7 (the typical average, which Google calls “Ok”).

Quality Score Distribution

CE_analystTemplates-clicks-and-conversions

< Back to top >

Learn More

Some of Our Clients

  • Comcast
  • Clix Marketing
  • Beau-coup
  • Uncommon Goods
  • Gyro:HSR
  • Portent Interactive

© 2010 ClickEquations, Inc. All Rights Reserved. | 866-360-0220 | sales@clickequations.com | 555 North Ln, Suite 6040 Conshohocken, PA 19428