Custom Object Logical Help

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.

Looking forward to someone helping out here :smiley:

Thanks,

Mike

1 Like

Before you go deeper:
If you have 4 custom objects:

INTEREST - PRODUCT - AMOUNT
soccer - ball - 10.00
tennis - net - 300.00
golf - ball - 20
golf - cart - 20.000.00

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.

Just heads up.

Thanks for that @joeyk .

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.