I'm building a tool to help visualize daily budgets + spends for a joined account of 8 primary accounts with approximately 75-120 campaigns at the account level.
I've been looking through the fields available in both the "ACCOUNT_PERFORMANCE_REPORT" and the "BUDGET_PERFORMANCE_REPORT" and will continue looking through the documentation, however I was wondering if anyone else has experience looking for something like this. One approach I can see would be looking up each campaign + budget for each day and then summing up all campaigns for each account's daily total... but it seems like there would have to already exist a better solution?
Would appreciate any experiences/input from fellow analysts. Thanks!