Hey Nat A.your first workbook 'prototype' will likely be messy, but as Satiesh S. said in a Linkedin comment this week, your ROI = wisdom!!!
Head of GTM Engineering at Clay said in an interview a while back to deploy one signal per table, and I love this suggestion.
I'm developing prompts to help me think through these kinds of questions, here's the response for your query, which is how I'd approach it initially:
1. Company – Static Enrichment (firmo /techno, source-of-truth keys)
2. Person – Static Enrichment (role, seniority, socials etc)
3. Company Signals – 1 table per signal (e.g., “G2 intent”, “Site visit”, “News: funding”)
3. Person Signals – 1 table per signal (e.g., “Job change”, “New post on X/LinkedIn”, “Email reply”)
4. Company Scoring (pulls #1 + relevant company-signal tables via references / formula columns for weights)
5. Person Scoring (pulls #2 + relevant person-signal tables / formula columns for weights)
Once you've built the workflow and seen how 10 rows cascade across the tables, you'll get a better idea of how the workflow should be designed. It always comes back to "what is my end goal" and what do I want it to look like.