Hi,
Please see below, I am having problems getting blended data segmented by week to match - trying to combine the data from 2 accounts based on the campaign name and week. I currently have a Full Outer Join based on the Campaign Name, blending both accounts. FYI in this instance joining by Week doesn’t work..
https://lookerstudio.google.com/reporting/33f70154-4837-467c-a6df-4d52fe39e1bf/page/NafeD/edit
In the “Directories Overall” tab, the “Combined Cost” Scorecard is correct, it looks at the last full week, Monday to Sunday. Both the Scorecard and the Table use the same formula for Combined Cost, but the top row in the table either displays “null” or the a lower cost value, it’s as if it is completely ignoring one of the accounts.
Any ideas here?
Thanks in Advance
Ben