I am looking for someone that can help me get my head around these custom objects. They seem super powerful and I am pretty able to create scenarios by building my own table with relationships of one to many.
SO an example that I am trying to see how I set up in Custom Objects is the following (and I am also lost on Master and Child).
Lets say I have a contact. This contact can be part of multiple verticals, for example he can be interested in soccer, tennis and golf. We have identiified the contact from the sites they have shopped at (so this we will call data source) for example if he shopped at soccer.com or tennis.com or golf.com.
In MySQL I would go about building out the following tables:
leads table:
id
firstname
email (unique)
vertical_names table:
id
name
verticals table:
id
vertical_id
lead_id
datasource_name table:
id
name
datasource table:
id
datasource_id
lead_id
So in the above example I have the flexibility to grow both my verticals and datasources, and a user can be associated with many verticals and many datasources.
How do I go about building this using Custom Obecjtect ? And what is the “Name” used for.
Now if you make a segment and try to filter for anyone who purchased a golf ball, you won’t be able to.
You will be only able to search for people who purchased a “ball” or purchased anything in the “golf” category. Not both.
I would still like to understand how exactly I go about setting up my example above if anyone can take me through a walk through of the best way to do this.
Our main objective currently is getting the setup correct, after this we will then be able to use either our own BI to visualize segments and maybe not use them, or maybe there is a way to use SQLConditions with custom objects inside a campaign.
But initially my goal is to get the basic understanding of how to best structure things.
@joeyk one more question, because I see that you handle with this plugin. How you link to custom objects? In my instance it wors only when I do it manual in contact card. List of custom objects to link in campaign editor is always empty.
