Where it usually breaks
And how to keep it from happening.
- The rollup runs twice and a day's figures double. Each post, account and day keeps one row.
- A post outside the campaign's dates is linked to it and inflates the result.
- Competitor figures captured at different times are compared as if they were the same day.