The numbers in Ad Spend Tracker are worked out from the spend entries you log. Nothing is fetched from ad platforms or from Sales Tracker.
The stat cards
- Total Spend: the sum of Spend Amount across your entries.
- Est. Revenue: the sum of Attributed Revenue across your entries.
- ROI: revenue minus spend, divided by spend, shown as a percentage. For example, $100 spent and $150 earned is +50.0%. It shows a dash when there is no spend.
- Active Campaigns: how many campaigns are marked Active.
- Avg Cost Per Click: total spend divided by total clicks. It shows a dash when no clicks were logged.
Each campaign row shows the same Spend, Revenue and ROI for that campaign alone. ROI is green when you earned more than you spent and red when you didn't.
Your main currency
Totals can't add euros to dollars, so the tracker picks a main currency: the currency you have logged the most spend in. Its code is shown in the card labels, for example Total Spend (USD).
Only entries in the main currency are added into Total Spend, Est. Revenue, ROI, Spend by Platform and each campaign's Spend, Revenue and ROI. Entries in other currencies are still saved and still appear, with their own currency, when you expand a campaign.
Filters
- Book: shows only campaigns for that book, or all books in one language. The stat cards follow the filter.
- Pen name: appears when you have two or more pen names.
- All Time, 3M, 6M, 1Y, YTD: limit the totals to entries dated in that window. 3M, 6M and 1Y count whole calendar months, including the current one. YTD starts on January 1.
The date buttons change the stat cards, the platform chart and each campaign's figures. When you expand a campaign, its full list of entries is always shown.
Sorting
Use Name, Platform, Start Date, Spend, Revenue, ROI and Status above the list to sort campaigns. Click again to reverse the order. With no sort chosen, active campaigns come first, newest first.