Sum Value Not Calculating With Date Range
Hey, I have created a blended data source between two different Google Ads accounts, I now want to create a scorecard that shows the total value something (like clicks, cost, impressions etc).
I have got this working (to a certain extent) by renaming the fields in the blended source so that I can easily add them together as a calculated field, the sum looks like this:
This works in the scorecard for a particular day, but it is not aggregated to show the correct sum for a date range.
Any ideas? I can provide more info is necessary.