CRM-heads, help!

Hello! I’m an NYC standup comedian, and I want dearly to scale up my gig booking capabilities, so I can grow.

I’m adapting my current gig booking operation to this template Business OS @John_Coda / @John_Scrugham , but I keep getting lost on how to organize my tables, especially when I start chasing leads. Please help!

Problem:
I have 3 big tables, in no particular order:
(1) Venues - clubs, theaters, indie locations; and sometimes digital;
(2) Contacts - bookers, producers, comics, agents, managers, any huminoid with a connection to a career prospect; and
(3) Shows - permanent-like longstanding shows with a venue and contacts, festivals, pop-ups, etc .

In any gig booking lead/deal, I could chasing and contacting any permutation of the above tables: to make a deal with a booker from a show; a show production group, unknown person thru a referral as a form of discovery for a possible lead; a completely cold call submission to a festival; a venue with a booker/producer that can book for multiple venues; a producer at a venue; a general venue; a comedy production group; a producer; a freelance booker; a comic; a simple referral; etc etc.

Each gig booking lead/deal needs the capability to have multiple booking dates and times attached to it, as well as the capability to have proposed dates as place holders during negotiation, i.e. a production group or venue could offer me 2 shows in a night at the same venue, but a prospective booking the following day (anywhere).

Any pitches of booking pipleline status systems is welcomed, too

I’ve taken a crack at it, but my clarity-hungry mind keeps giving up, because I need clarity on a hierarchy or flow, I’M LOST. How do I adapt the CRM template Business OS to the above parameters.

Thanks my CRM-heads.

Hey d_y :wave: thanks for checking out my template.

Looks like you have many many dimensions to your opportunities whereas the template is just a few: company/ contact, opportunity, status, close date (two core tables).

I’d recommend some sort of Union table (
https://www.w3schools.com/sql/sql_union.asp) that merges the objects you’re tracking like venues contacts shows so that you can relate them to one another. This is a distinctly new table that has lookups to the others.

As for multiple tentative dates. Try a multi select that connects to a date table…. I know, it’s starting to get messy, but you don’t want multiple date columns on a table because it’s both limiting and breaking good system design hygiene.

Hope that gets you pointed in the right direction!

i’ll give it a go. thank you! i understand what it’s doing but i’m not quite sure how to use it to translate the types of opportunities I encounter into a coda column.

PS the CRM template you made and the coda series on crm building vibes so hard.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.