SayPro Performance Tracking Sheets

SayPro Employee Document Requirement: Performance Tracking Sheets

Document Name:

Performance Tracking Sheets

Required From:

Performance Marketers, Data Analysts, Digital Advertising Specialists, Campaign Managers, and anyone involved in campaign optimization and reporting.

---

Purpose of the Document:

The Performance Tracking Sheet is a live document used to monitor and evaluate the effectiveness of SayPro’s advertising campaigns across all digital platforms. By tracking key performance indicators (KPIs), this document enables data-driven decision-making, real-time optimizations, and post-campaign analysis to improve ROI and inform future strategies.

---

Mandatory Components of the Performance Tracking Sheet:

1. Campaign Details:
   • Campaign Name
   • Start and End Dates
   • Platform(s) used (e.g., Facebook, Google Ads, TikTok, LinkedIn)
   • Ad Set or Creative Variant (if applicable)
2. Ad Metrics to Track:
   (Each metric should be tracked per platform and per creative variation where applicable)
   • Impressions – Number of times the ad was shown
   • Clicks – Number of clicks received
   • Click-Through Rate (CTR) – Percentage of people who clicked after seeing the ad
   • Conversions – Actions completed (e.g., sign-ups, purchases, downloads)
   • Conversion Rate – Conversions as a percentage of total clicks
   • Cost Per Click (CPC) – Average cost for each click
   • Cost Per Acquisition (CPA) – Average cost for each conversion
   • Return on Ad Spend (ROAS) – Revenue generated divided by ad spend
   • Engagement Rate – Likes, shares, comments, saves (for social campaigns)
   • Video Views – For video-based ads (track 3s, 15s, and 100% views if available)
3. Performance Over Time:
   • Weekly or daily breakdown of metrics
   • Cumulative totals and trends
   • Annotations for spikes or dips in performance (e.g., external events, copy changes)
4. Traffic and Attribution Insights:
   • Top-performing channels
   • Device type breakdown (mobile vs. desktop)
   • Geographic insights (city/region/country-level data)
   • Attribution model used (e.g., last-click, first-click, linear)
5. Optimization Notes:
   • Actions taken (e.g., paused underperforming ads, A/B tested headlines)
   • Dates of adjustments and their impact on performance
   • Recommendations for future campaigns
6. Data Source References:
   • Platforms/tools used (e.g., Google Ads Manager, Meta Business Suite, Google Analytics, HubSpot)
   • UTM tracking parameters (if applicable)
   • Dashboard or BI tool links (for centralized reporting)

---

Submission Guidelines:

• Frequency:
  • Updated weekly during active campaigns
  • Final version submitted within 10 business days after campaign ends
• Format:
  • Excel, Google Sheets, or integrated dashboards (with exportable sheets)
  • Must follow SayPro’s Performance Tracking Sheet Template
  • Use consistent naming conventions and tab structures for clarity
• Approval Chain:
  1. Data Analyst or Performance Marketing Specialist
  2. Campaign Lead or Marketing Manager
  3. Chief Marketing Officer (CMO) – for final review in major campaigns