Dynamics Community Forum Thread Details

Outbound Marketing - Relationship between Accounts and Customer Journeys

Hello All!

I am a Power BI Developer tasked with showing what Accounts have Customer Journeys associated from a data perspective. I currently am unable to find the relationships between the two entities as well as any other entities between them.

Thought Process:

Customer Journeys use Segments that have Contacts that are related to Accounts (Customer Journeys > Segments > Contacts > Accounts).
On the Customer Journey General Tab there is a section for /Segments Used/.
The relationship between Segments and Customer journey are most likely Many to Many, so it would use a junction table, but I can't find it.
The relationship between Segments and Contacts are most likely Many to Many, so it would use a junction table, but I can't find it.

Questions:

What is the relationship between Customer Journey and Segments?
- Is there a junction table between Customer Journeys and Segments? If so, what is it?
What is the relationship between Segments and Contact?
- Is there a junction table between Segments and Contacts? If so, what is it?

Tables Referenced: