Why do ad campaign numbers keep changing after the fact?
Marketing reports often look profitable at first, but later backfilled conversions, refunds, and source updates rewrite past performance data. Because original versions are overwritten, it becomes impossible to fairly evaluate whether a past decision was actually good or if the data simply shifted afterward.
What people tried
Every workaround mentioned in the threads below. We haven’t tested any of them — and nobody here is claiming they worked.
- 1Manually saving reports every day
- 2leaving conflicting adjustment entries unedited and hoping auditors do not notice
- 3stacking multiple sequential correction entries across consecutive months
In their words
Unedited, grouped by where they were said, most upvoted first within each place, each linked to the thread it came from.
“Has anyone ever described an accounting adjustment as a true up in monthly reporting and the following month had to create another accounting adjustment to true down the previous true up, and hope that nobody remembers the previous month true up when reporting again.”source ↗
“Every month I adjust an asset up, then down the next month based on the statement.”source ↗
“We’ve had a few campaigns look profitable when we increased spend, then checked the same date range a couple weeks later and the result was noticeably worse.”source ↗
“Right now once the source updates, we lose the original version, so it’s hard to tell whether the decision was bad or the data just changed afterward.”source ↗
Where this came up
People with this problem also raised
- 2How to track historical data in CRM without a data warehouse
- 7How to move on after a ruined milestone celebration?
- 9How to handle undocumented legacy database changes
- 3Why does team documentation always go out of date?
- 4Why does software become just a system of record?
- 7How to survive a performance improvement plan