Competitive PR and Advertising Analysis

Resource Overview

A template to track PR & advertising programs to determine Ad Spend/Ad Value Equivalency ratios.


Related Resources

Your Problem

You need to demonstrate that you effectively leverage PR to get exposure and reduce ad spending.

Our Solution

A Microsoft Excel template to track your PR and advertising programs, and those of your top competitors, to determine Ad Spend/Ad Value Equivalency ratios. For background info, read our Executive Summary: Analyzing Competitive Ad vs. PR Spending. Download our free Public Relations Plan Methodology, which uses this tool to help you implement a PR program that gets results.

Key Benefits

  • provides visibility into competitor advertising/PR
  • more accountability for the PR team
  • automatically calculates ratios
  • save 4 hours on formatting
  • generates summary charts


Microsoft Excel Spreadsheet

Estimated Time Required: 4 Hours

Skills Required: Competitive Analysis