| A | B | C | D | E | F | G | H | J | K | L | M | N | O | P | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Paid Channel - Budget Tracker | ||||||||||||||
2 | Account Name (Change to match the Account name in your data) | Channel | Start Date | End Date | Spend | Allocated Budget | % of Time | % of Budget | 7 | < - Set to the number of days you want to see spend for | Last 7 Day Spend | Future Spend Required | Daily Spend Adjustment Required | Notes | |
3 | |||||||||||||||
4 | Website 1 Account One | 1-Jul-2020 | 30-Jun-2021 | $127,271 | $150,000 | 603% | 85% | 3-Jul-2026 | 9-Jul-2026 | $0.00 | -$12.39 | -$12.39 | |||
5 | Website 1 Account One | Bing | 1-Jul-2020 | 30-Jun-2021 | $21,753 | $50,000 | 603% | 44% | 3-Jul-2026 | 9-Jul-2026 | $0.00 | -$15.39 | -$15.39 | ||
6 | Website 1 Account One | 1-Jul-2020 | 30-Jun-2021 | $21,437 | $30,000 | 603% | 71% | 3-Jul-2026 | 9-Jul-2026 | $0.00 | -$4.67 | -$4.67 | |||
7 | 1-Jul-2020 | 30-Jun-2021 | $170,461 | $230,000 | 603% | 74% | |||||||||
8 | |||||||||||||||
9 | Website 2 Account One | 1-Jul-2020 | 30-Jun-2021 | $126,926 | $200,000 | 603% | 63% | 3-Jul-2026 | 9-Jul-2026 | $0.00 | -$39.82 | -$39.82 | |||
10 | Website 2 Account One | Bing | 1-Jul-2020 | 30-Jun-2021 | $21,516 | $50,000 | 603% | 43% | 3-Jul-2026 | 9-Jul-2026 | $0.00 | -$15.52 | -$15.52 | ||
11 | Website 2 Account One | 1-Jul-2020 | 30-Jun-2021 | $21,845 | $30,000 | 603% | 73% | 3-Jul-2026 | 9-Jul-2026 | $0.00 | -$4.44 | -$4.44 | |||
12 | 1-Jul-2020 | 30-Jun-2021 | $170,287 | $280,000 | 603% | 61% | |||||||||