Ambiguity between tables

[B_atWork]

Hi Community,

I am trying to link our accounts in CRM to website activity in Google Analytics (GA) by using both service providers and network domains (fields in GA). I have pulled tables for our Accounts in CRM, Network Domains in GA, Service Providers in GA, and web page statistics. When I try to activate the relationship between Network and All Website Data, I get the message "You can't create a direct active relationship between ... because that would introduce ambiguity between accounts and All Website Data. ..." 

I was thinking of creating a combined primary key consisting of Network Domain and Service Provider, but some Accounts have varying numbers of Network domains and Service Providers and some that have Network Domains but no service providers. 

Ultimately I'd like to have a report that allows me to select a sales rep, show their accounts and then drill down into the website activity regardless of the Network Domain or Service Provider. 

Thank you.

[Lind25 · Accepted solution]

Hi

Your statement "some Accounts have varying numbers of Network domains and Service Providers and some that have Network Domains but no service providers" is why you cannot create the relationship - from your explanation there is no clear single way to filter the data.

Your new primary key approach is best. I would join your accounts, network and acct tables in to one dimension table and relate this to your all website table with your new primary key.

[B_atWork]

Thank you, @Lind25. I'm sure this will eventually work. However, once I tried to join the tables I ran into another a problem relating them to each other because there were no unique entries in one table. 

Now I am having issues connecting to GA because I exceeded the daily limit, so this project is on hold at the moment.