← Back to portfolio
ITSynthetic interactive reconstruction based on real delivery patterns. No production or client data.
Case 02 / relational base explorer

Airtable systems across business units

Synthetic interactive reconstruction based on real delivery patterns. No production or client data.

What am I looking at?

"Where did this buyer come from?" answered in two clicks. This is the CRM: click any row and follow the links between leads, applications and purchases.

DemoCo Operations synthetic
⌕
-Rows shown
1Dedupe flags
3Buyers linked
€8,020Cash collected
Two Leads share [email protected] across TikTok and Instagram touches. The base flags the second with a dupe marker and a merge_into back-reference to recLD01, so the buyer is counted once and first-touch source is preserved.

How tables connect base schema

Click a table box to open it. Arrows follow the linked-record fields: Applications → Leads, Buyers → Applications, Touchpoints → Leads.