In Analytics Best Practices
Store the values locally, ideally with HOUR granularity. When doing so, there should be no need to pull data for any entities other than line_items and promoted_tweets. For data display, roll these metrics up to get DAY and TOTAL granularity, or roll-ups higher up in the tree, such as at the campaign, funding instrument or account levels.
How can I roll out the data of promoted_accounts from line_items and promoted_tweets?