Excel for marketing ops: what was spent
A campaign spend sheet is one row per campaign in the period you are closing. The planned amount you type is the budget you agreed for that row. The actual amount you type is the figure from the invoice or the export you trust. IF marks the row over when actual is greater than planned. SUMIFS adds actual by the channel you typed. A performance sheet, with clicks and revenue, answers whether the campaign worked. This sheet answers whether the money you typed matches the plan you typed. You do not mix the two questions on one row. The guide below is the spend sheet. Elyx writes the variance and the sums from the amounts you typed. You still decide what to stop. The trial lasts 7 days, with no card.
- The campaign spend sheet
- Campaign analysis, if you want results rather than spend
- A budget, if the file is the whole company rather than campaigns
- AI tools for marketing in Excel
Frequently asked questions
What is one row on the spend sheet?
One campaign in the period: the channel, the planned amount, and the actual amount. The variance is actual minus planned.
Where do clicks and revenue go?
On a campaign analysis sheet. This sheet is the money. A result in the note does not change the variance.
Does the sheet pull spend from an ad platform?
No. You type the actual amount, or you paste it as a value from an export you already checked. The formula only subtracts.