Expense categories

How to track online advertising month by month

Track online advertising spend monthly: compare daily caps with real charges, log results and work out cost per enquiry with simple worked numbers.

Editorial illustration for How to track online advertising month by month

To track online advertising, record each charge or top-up when it leaves your account, check it weekly against the daily budget you set, and divide the month's spend by the enquiries it brought to get a cost per enquiry. Five minutes a week keeps ad money from drifting quietly upward.

What do you record?

  • Every charge or top-up, with date, amount and the channel it funds.
  • The daily budget you have set on each campaign.
  • Enquiries, calls or orders that came from that channel.
  • Any pause, increase or new campaign, with the date.

The last item is the one people skip. A note such as raised cap from 600 to 800 explains a jump in spend months later, when nobody remembers why.

How often should you look?

CheckHow oftenWhat you compare
Spend against capWeeklyCharges on the statement and the daily budget times days
ResultsWeeklyEnquiries or orders against spend
Full reviewMonthlyTotal, cost per enquiry, change from last month
Agency or tool feesQuarterlyWhether you still use what you pay for

A sample month

Say you set a daily cap of ₹800 and your month has thirty days. The most the campaign could spend is ₹24,000. These numbers are for illustration.

PeriodDays runningSpend
Week 17₹5,600
Week 27₹5,600
Week 36₹4,800
Week 47₹5,600
Last two days2₹1,600
Month total29₹23,200

Week 3 is lower because the campaign was off for a day. The month came to ₹23,200, which is ₹800 under the ₹24,000 ceiling. If the campaign brought 40 enquiries, the cost per enquiry is ₹580, since 23,200 divided by 40 is 580. That figure is only useful next to last month's, so write it down.

How do you spot a change?

Numbers are only useful when you know what normal looks like, so keep the last three months in view. Three patterns are worth catching. Spend jumps without a cap change, which may be a setting you did not intend. Spend falls because a card was declined or a prepaid balance ran out. Or spend is steady but enquiries fall, meaning the same money is buying less. Each needs a different fix, and you only see them if you track results next to cost.

Also watch for charges that carry on after a campaign has ended. A forgotten subscription to a design or scheduling tool is the quiet leak in many ad budgets, and a monthly look at the Creative and tools line is usually enough to spot it. Cancel what you have not opened in the last month.

How do you keep the numbers trustworthy?

Use the same account for ad charges every month where you can. If top-ups come from three cards and two UPI apps, you will miss one at month end. A single funding route, even if it means moving money first, makes the statement the one place where the whole story appears. It also makes a missing charge stand out immediately.

What should a monthly review decide?

Ask three questions. Did the total match the plan? Did the cost per enquiry rise or fall? And is there a channel you would cut or a channel you would feed? Write one sentence for each. A plan that fits in three lines is far more likely to be followed than a long analysis.

If you already import statements into SpendixAI, an ad-spend sub-category and a rule for the platform's merchant name will total the month for you, and a Report builder view can group it by month.

Weekly routine in four steps

  1. Open the statement entries for the week and add notes for changes.
  2. Compare the total with days running times the cap.
  3. Log enquiries by channel.
  4. On the last weekend of the month, work out cost per enquiry and compare.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports