Blending data from different currency SA360 accounts.

[RobinMonster]

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!

[bananas]

Hi! I have the same issue, were you able to solve it?

[RobinMonster]

Hey, unfortunately, no. I've had to resort to using Google Ads as a source (for now that sufficed as my company currently doesn't use any other paid search platforms), but that's only a temporary solution. If I do find something, I'll make sure to update my post, or hopefully we'll get someone providing a solution here.