SayPro Performance Tracking Sheet Template

A document to track campaign performance across different platforms, including metrics like CTR, conversion rates, impressions, and spending.

Campaign Overview

• Campaign Name:
  [Enter the campaign name]
• Campaign Manager:
  [Enter the name of the campaign manager]
• Campaign Start Date:
  [Enter the campaign start date]
• Campaign End Date:
  [Enter the campaign end date]

---

2. Platform Performance Summary

Platform	Ad Type	Impressions	Clicks	CTR (%)	Conversions	Conversion Rate (%)	Cost	CPC (Cost per Click)	CPA (Cost per Acquisition)	ROAS (Return on Ad Spend)
Facebook	Carousel Ad	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
Instagram	Story Ad	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
Google Ads	Search Ad	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
LinkedIn	Sponsored Post	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
TikTok	Video Ad	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]

---

3. Key Metrics Definitions

• Impressions:
  The total number of times the ad was displayed across platforms.
• Clicks:
  The total number of clicks the ad received.
• CTR (Click-Through Rate):
  Calculated as (Clicks ÷ Impressions) × 100. This metric shows the percentage of people who clicked the ad after seeing it.
• Conversions:
  The total number of desired actions (e.g., purchases, sign-ups, downloads, etc.) generated from the ad clicks.
• Conversion Rate:
  Calculated as (Conversions ÷ Clicks) × 100. This shows the percentage of clicks that resulted in a conversion.
• Cost:
  The total spend for the ad on each platform.
• CPC (Cost per Click):
  Calculated as (Cost ÷ Clicks). This metric tells you how much you are paying for each click on your ad.
• CPA (Cost per Acquisition):
  Calculated as (Cost ÷ Conversions). This shows the cost of acquiring a customer or lead.
• ROAS (Return on Ad Spend):
  Calculated as (Revenue ÷ Cost). This shows how much revenue is generated for every dollar spent on ads.

---

4. Daily/Weekly Performance Tracking

Date	Platform	Impressions	Clicks	CTR (%)	Conversions	Conversion Rate (%)	Cost	CPC	CPA	ROAS
[Date 1]	[Platform]	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
[Date 2]	[Platform]	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
[Date 3]	[Platform]	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]

---

5. Monthly/Weekly Performance Summary

This section is for summarizing the key metrics after a specific period of tracking, like weekly or monthly.

Platform	Total Impressions	Total Clicks	Avg. CTR (%)	Total Conversions	Avg. Conversion Rate (%)	Total Cost	Avg. CPC	Avg. CPA	Avg. ROAS
Facebook	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
Instagram	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
Google Ads	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
LinkedIn	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]
TikTok	[Enter #]	[Enter #]	[Enter %]	[Enter #]	[Enter %]	[Enter $]	[Enter $]	[Enter $]	[Enter #]

---

6. Insights and Recommendations

Use this section to provide insights based on the tracked performance metrics and recommend any changes or optimizations to improve future campaign performance.

• Key Learnings:
  What did you learn about your ads’ performance this week/month? What worked well, and what didn’t?
• Optimizations Needed:
  Are there any areas that need optimization? For example, if CPC is too high, consider adjusting bids or revising your target audience.
• Platform Performance Comparison:
  Which platform(s) delivered the best results? Which platforms need further adjustments or testing?

---

7. Budget Tracking

Platform	Allocated Budget	Actual Spend	Variance
Facebook	[Enter $]	[Enter $]	[Enter $]
Instagram	[Enter $]	[Enter $]	[Enter $]
Google Ads	[Enter $]	[Enter $]	[Enter $]
LinkedIn	[Enter $]	[Enter $]	[Enter $]
TikTok	[Enter $]	[Enter $]	[Enter $]