Free Resource
Campaign Tracking Spreadsheet
Log your CPL traffic tests, clicks, conversions, and network feedback in one place. Data stays in your browser — no account needed.
How to use: Each row is one traffic test or campaign. Log what you tried, what happened, and what you learned. Review weekly to spot patterns. Use Tab to move between cells, Enter to confirm edits.
| Date | Traffic Source | Campaign / Offer | Network | Clicks | Conv. | Rate % | Revenue | Cost | Profit | Notes | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-06-01 | Organic search | Free gift iPad offer | CPAlead | 120 | 3 | 2.5 | $4.50 | $0 | $4.50 | Low conversion — check landing page CTA |
How to export to Google Sheets
- Click Copy as TSV above — the data copies to your clipboard.
- Open Google Sheets and create a blank spreadsheet.
- Click cell A1 and paste (Ctrl+V / Cmd+V).
- The data will fill into columns automatically — ready to add charts, filters, and collaboration.
Columns explained
- Date
- When you ran the test or sent traffic. Use consistent format (YYYY-MM-DD) for sorting.
- Traffic Source
- Where the clicks came from: organic search, social, paid ads, email, forum, etc.
- Campaign / Offer
- The specific offer or campaign name. Be specific enough to identify it later.
- Network
- Which affiliate network the offer is from (CPAlead, CPAGrip, etc.).
- Clicks
- Number of clicks sent to the offer (from your tracker or network dashboard).
- Conv.
- Number of conversions (leads/signups) recorded.
- Rate %
- Conversion rate = conversions ÷ clicks × 100. Auto-calculated.
- Revenue
- Total revenue from conversions (payout × conversions).
- Cost
- Traffic cost, tool subscriptions, content costs — anything you spent.
- Profit
- Revenue minus cost. Auto-calculated.
- Notes
- What you learned, what to test next, rejection reasons, affiliate manager feedback.
Privacy note: All data is saved in your browser's localStorage. Nothing is sent to any server. Clearing your browser data will remove saved entries. Export regularly to Google Sheets for backup.