ClickEquations Analyst Templates

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

cq-dashboard2Each 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

Clicks and conversion dashboard

Clicks and Cost Dashboard

Clicks and cost dashboard

.

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
.
Month Over Month Engine Performance dashboard
What’s Changed? (Google)
.
What's Changed delta dashboard
.

.

What’s Changed? (Yahoo)
.
What's Changed yahoo delta dashboard
ROI Distribution Report
.

ROI Distribution Report dashboard

(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)
.

Impression Share Report dashboard

ClickShare Opportunity (Ad Group)
.

ClickShare Opportunity Report dashboard

(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.
.

Match Type Distribution dashboard

Clicks By Engine.
.

Clicks by Engine dashboard

(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

minimum First page bid estimate report

(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

Quality Score Distribution dashboard

(top)

.

Learn More

SOME OF OUR Clients