Turn campaign data into a structured performance review with the AAMA Campaign Performance Report Template. This editable Excel workbook helps marketers, agencies, organizations, consultants, students, and academic teams compare campaign results with objectives, evaluate performance across channels and audiences, identify meaningful findings, and document the decisions that should follow.

The template is designed to support both ongoing campaign reviews and final post-campaign reporting. It combines performance calculations with space for interpretation so the finished report explains not only what happened, but also why the results matter and what should happen next.

Download the Campaign Performance Report Template

The AAMA Campaign Performance Report Template is provided as an editable Microsoft Excel workbook with formulas, conditional formatting, structured reporting tables, and summary charts already built in. Enter campaign results into the appropriate worksheets, then use the executive summary and findings sections to translate those results into conclusions and recommendations.

The workbook uses a neutral professional design that can be adapted to an organization, agency, client, classroom, or campaign. Bracketed instructional text should be replaced or removed before the completed report is distributed.

What the Template Helps You Evaluate

Campaign reporting should do more than reproduce numbers from advertising platforms or analytics dashboards. A useful report should connect those numbers with the campaign objective, explain where performance differed from expectations, identify the factors that may have influenced the result, and establish what the organization should learn from the campaign.

The AAMA template is structured around that process. It combines campaign-level results with channel, creative, audience, and KPI analysis so teams can move from measurement to interpretation.

What’s Included

The workbook includes eight working sheets:

1. Instructions
2. Campaign Overview
3. Executive Summary
4. KPI Summary
5. Channel Performance
6. Creative Performance
7. Audience Performance
8. Findings & Recommendations

Each sheet supports a different level of campaign analysis while remaining connected to the same reporting framework.

Begin With the Campaign Context

The Campaign Overview sheet establishes the information a reader needs before evaluating performance. It includes fields for the campaign name, organization or client, owner, campaign dates, reporting period, primary objective, primary KPI, approved budget, attribution or measurement methodology, data date, and report author.

The sheet also provides space for an executive campaign narrative and measurement limitations. This context can prevent readers from interpreting individual metrics without understanding the business problem, campaign purpose, or limitations of the available data.

Establish the Objective Before Reviewing Results

Campaign performance should be evaluated against the objective established before the campaign began. A campaign designed primarily to increase awareness should not be judged exclusively by immediate conversions, while a direct-response acquisition campaign should not be declared successful simply because it generated a large number of impressions.

The report should clearly state the campaign’s primary objective and KPI before the results are interpreted. Supporting metrics can provide additional context, but they should not replace the original success criteria after the campaign has ended.

Use the Executive Summary

The Executive Summary automatically rolls up key campaign results from the Channel Performance sheet. It includes approved budget, actual spend, budget variance, impressions, clicks, conversions, revenue, CPM, CPC, CTR, CPA, conversion rate, and ROAS.

The sheet also provides working areas for the executive interpretation and primary recommendation. These sections are intended to communicate the most important conclusion to decision-makers who may not review every supporting worksheet.

Compare Targets With Actual Results

The KPI Summary allows teams to document the baseline, target, actual result, variance, progress against target, status, and explanatory notes for important campaign metrics.

This structure helps distinguish campaign performance from raw activity. A conversion count of 5,000 may appear impressive in isolation, but its meaning changes substantially if the target was 2,000 or 10,000.

Status options allow each KPI to be classified as below target, near target, met target, exceeded target, not evaluated, or not applicable.

Evaluate Channel Performance

The Channel Performance sheet compares individual channels, platforms, placements, or major media groups using common campaign metrics.

Teams can enter:

• Spend
• Impressions
• Reach
• Clicks
• Conversions
• Revenue

The workbook automatically calculates:

• CPM
• CPC
• CTR
• CPA
• Conversion Rate
• ROAS

This creates a consistent framework for comparing media performance without rebuilding formulas for each reporting period.

Understand CPM

Cost per thousand impressions measures the cost associated with delivering 1,000 advertising impressions:

CPM = Advertising Cost ÷ Impressions × 1,000

CPM can help evaluate media cost efficiency, but a lower CPM does not automatically mean a channel is more valuable. Audience quality, placement, viewability, creative performance, and campaign objective also matter.

Understand CPC

Cost per click measures the average advertising cost associated with each click:

CPC = Advertising Cost ÷ Clicks

CPC can be useful for traffic-focused campaigns, but inexpensive clicks are not necessarily valuable clicks. Conversion quality and downstream performance should also be reviewed.

Understand CTR

Click-through rate compares clicks with impressions:

CTR = Clicks ÷ Impressions × 100

CTR can provide information about creative response, audience relevance, placement, and offer strength. It should not be treated as a universal measure of campaign success because many campaign objectives do not depend primarily on clicking behavior.

Understand CPA

Cost per acquisition measures the average advertising cost associated with a defined acquisition or conversion:

CPA = Advertising Cost ÷ Acquisitions

The acquisition definition should remain consistent across the report. A lead, registration, purchase, membership, appointment, and new customer may represent substantially different business outcomes.

Understand Conversion Rate

Conversion rate measures the percentage of eligible interactions that produce a defined conversion:

Conversion Rate = Conversions ÷ Eligible Opportunities × 100

The denominator should be documented when it is not obvious. Depending on the analysis, the calculation may use clicks, visits, leads, users, or another defined opportunity.

Understand ROAS

Return on ad spend compares attributed advertising revenue with advertising cost:

ROAS = Advertising Revenue ÷ Advertising Cost

ROAS can help evaluate revenue efficiency, but it is not the same as profit. Margin, fulfillment, overhead, customer acquisition economics, refunds, retention, and other business costs may materially change the financial interpretation.

Compare Creative Performance

The Creative Performance sheet allows teams to compare individual advertisements, messages, concepts, formats, or assets using spend, impressions, clicks, conversions, revenue, CTR, CPA, and ROAS.

Creative comparisons can help identify which messages or executions appear to produce stronger audience response. Teams should still consider differences in targeting, media placement, spend, delivery, and sample size before attributing performance differences exclusively to the creative itself.

Evaluate Audience Segments

The Audience Performance sheet allows campaign results to be compared across defined audience groups when reliable segment-level reporting is available.

Teams can evaluate spend, impressions, reach, clicks, conversions, revenue, CTR, CPA, and ROAS for different audiences. This may reveal that campaign averages are hiding important differences among customer types, geographic markets, prospect groups, behavioral segments, or other strategically relevant audiences.

Audience analysis should be based on meaningful segmentation rather than unsupported demographic assumptions.

Separate Performance From Explanation

A metric tells the team what happened. It does not automatically explain why it happened.

For example, a high CPA might result from weak creative, an expensive audience, poor conversion experience, a limited offer, low-quality traffic, technical problems, inaccurate targeting, competitive pressure, or another factor.

The report should distinguish observed results from interpretations about their causes. Where evidence is uncertain, conclusions should be labeled accordingly.

Document Measurement Limitations

Marketing data often contains limitations that affect interpretation.

These may include:

• Attribution assumptions
• Modeled conversions
• Cross-device identity gaps
• Cookie or privacy restrictions
• Platform reporting differences
• Delayed conversions
• Offline activity
• Duplicate audiences
• Missing revenue data
• Incomplete CRM integration

Documenting these limitations does not weaken the report. It makes the analysis more credible by clarifying what the data can and cannot establish.

Review Budget Performance

The Executive Summary compares approved budget with actual campaign spend.

A campaign that spends less than budget is not automatically successful, and a campaign that exceeds the original budget is not automatically unsuccessful. The reason for the variance and the value produced by the spending should be considered together.

Under-spending may reflect efficiency, but it can also indicate delayed execution, limited inventory, operational constraints, or missed opportunity.

Look Beyond Aggregate Results

Campaign totals can hide important performance patterns.

A campaign may achieve its overall conversion target while one channel performs poorly and another compensates for the weakness. Similarly, total ROAS may appear strong while a particular audience, creative execution, or placement consumes substantial budget without producing proportional value.

Channel, audience, and creative analysis can reveal opportunities that are invisible in the campaign-level totals.

Compare Like With Like

Metrics are most useful when the underlying conditions are reasonably comparable.

A retargeting campaign should not automatically be compared with broad prospecting on CPA alone. A six-second video and a long-form landing page serve different communication functions, while branded search and awareness media may occupy different positions in the customer journey.

Interpret performance within the role each channel, audience, or creative asset was expected to perform.

Avoid Declaring Winners Too Quickly

A small amount of data can produce large percentage differences that may not persist as the campaign scales.

Before declaring one creative, audience, or channel the winner, consider sample size, campaign duration, conversion lag, budget allocation, testing methodology, audience overlap, and whether the compared groups received similar opportunities.

Where stronger causal evidence is required, controlled testing may be more appropriate than observational comparison.

Translate Findings Into Decisions

The Findings & Recommendations sheet is designed to connect campaign evidence with action.

Each entry includes:

• Finding
• Supporting evidence
• Interpretation or implication
• Recommendation
• Owner
• Priority
• Status
• Next review date

A useful recommendation should be specific enough that someone can act on it. “Improve performance” is not a meaningful recommendation, while “shift 15% of prospecting media from Placement A to Placement B and retest CPA for two weeks” creates a decision that can be implemented and evaluated.

Separate Finding From Recommendation

A finding describes something supported by evidence. A recommendation describes what should happen because of that finding.

For example:

Finding: Creative B produced a 35% lower CPA than Creative A within the same audience and placement.

Recommendation: Increase delivery of Creative B while developing two new variants based on the same message strategy.

Keeping these concepts separate makes campaign reports easier to review and challenge.

Identify What Should Be Repeated

Post-campaign analysis should not focus only on what failed.

Strong campaigns also create information about what should be preserved or expanded. This may include an audience that responded particularly well, a creative message that consistently performed, a channel that delivered incremental reach, a landing-page improvement, or an operational practice that made execution more efficient.

Document these successes so future campaigns do not have to rediscover the same lessons.

Identify What Should Change

When results fall short of expectations, the objective is not to assign blame. The objective is to identify what can be learned and what can be changed.

Recommendations may involve:

• Media allocation
• Targeting
• Frequency
• Creative
• Messaging
• Offer
• Landing pages
• Conversion experience
• Budget
• Measurement
• Customer journey
• Sales follow-up
• Additional research

Some findings may indicate that the original strategy itself needs revision rather than simple campaign optimization.

Create Institutional Knowledge

Campaign reports become more valuable when they inform future planning.

The final recommendations should be reviewed when the organization develops the next campaign, marketing plan, media strategy, creative brief, or budget. This turns reporting from a backward-looking requirement into a source of organizational learning.

A campaign that produces mediocre business results can still create valuable information when the organization analyzes it rigorously and applies the lessons.

Customize the Workbook

The workbook is intentionally flexible. KPI rows, channels, audience segments, creative assets, reporting periods, status categories, and findings can be expanded or modified to match the organization and campaign.

Bracketed instructional text should be replaced or removed before the completed report is shared. Metric definitions and attribution methods should also be documented whenever they differ from the standard formulas or reporting conventions used in the template.

Use It With the AAMA Planning & Measurement Resources

Use the template alongside the Campaign Planning Framework, AAMA Campaign Planning Workbook, Marketing Metrics & KPI Reference, Common Marketing Formulas, Media Planning Fundamentals, A/B Testing Guide for Marketers, and the AAMA Marketing & Advertising Calculator Hub.

Together, these resources provide a connected system for planning a campaign, establishing success criteria, executing the work, evaluating results, and applying what was learned to the next decision.