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:
msdyncrm_customerjourney
msdyncrm_segment
contact
account
Any information would be greatly appreciated. Please let me know if any information is needed from my end as well.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
3
Share
Report
All responses (
Answers (
