Get Site when campaign_hour_breakdown Dimension
I am using the campaign_hour_breakdown dimension (from the reports/campaign-summary endpoint) which is great because it gives me the hourly breakdown for every Campaign. However, the Site is not included in the results. Site is allowed as a filter for the campaign_hour_breakdown dimension, but for this I would need to make a request for each Site to get its hourly breakdown, and this in our case it can be thousands.
I know there's a site_breakdown dimension but data is not aggregated at an hourly level but daily.