Hey everyone!
New SA360 connectors only allow you to choose accounts of the same currency. For my company, I want to be able to report on Google and Microsoft Bing Ads and get the total from all markets and campaigns. We have accounts in EUR, SEK and GBP currencies.
So I thought I'd go ahead and add 3 new SA360 sources to my dashboard; 1 capturing all EUR currency accounts and data, 1 for SEK and 1 for GBP, then blend the sources together (Reporting needs to be in USD, so I apply a simple currency conversion formula on the "Cost" metrics within the sources).
However, no matter how I blend, which dimensions or metrics I add, what conditions I choose for the sources within the blend, I cannot seem to generate even the total amount of clicks, much less any financial totals. Tables and scorecards either come up with "null" or only show the totals of all EUR accounts for example.
Does anyone have any idea why this is and how to get this blend to work? Can share screenshots if needed.
Thanks in advance!
LinkedIn
Twitter
