πŸ“Š Contact Status

πŸ“‹ Field Schema

Field Name
Type
Description
Source
Required
Contact Name
Text
Full name of the contact person
From Opportunity / Manual
Yes
Email
Email
Primary email (unique identifier)
From Opportunity / Manual
Yes
Phone
Phone
Contact phone number
From Opportunity / Manual
No
Telegram
Text
Telegram handle (@username)
From Opportunity / Manual
No
Title/Role
Text
Job title (e.g., "Affiliate Manager")
From Opportunity / Manual
No
Contact Status
Status
Current relationship status
Manual / Auto
Yes
Status Options
Active Inactive Former
Related Group
Connect
Links to Groups board (company)
Auto from Opportunity
Yes
Primary Affiliation
Checkbox
Is this the main contact for their Group?
Manual / Auto
No
Active Deals
Connect
Links to Deals where this is primary contact
Auto
Auto
Deal Count
Formula
COUNT(Active Deals)
Formula
Auto
Source Opportunity
Connect
Original Opportunity that created this contact
Auto
Auto
Source
Text
How we acquired this contact
Auto / Manual
No
Account Manager
Person
AM managing this relationship
From Opportunity / Manual
Yes
Last Contact Date
Date
Last interaction with this person
Manual
No
Created Date
Date
When contact record was created
Auto
Auto
Days Since Contact
Formula
TODAY() - Last Contact Date
Formula
Auto
Notes
Long Text
Communication history & notes
Manual
No

πŸ”„ How Contacts Are Created

🎯

From Opportunity Approval

Auto-created when CMO + Setup approval triggers the automation. Contact info is copied from the Opportunity fields.

✏️

Manual Entry

AM can manually add contacts for existing relationships or contacts discovered outside the normal flow.

πŸ”—

CellXpert Sync (Future)

Planned integration to pull contact info from CellXpert affiliate profiles automatically.

βœ… Data Validation Rules

πŸ“§

Email Uniqueness

One email = One Contact record. Automation searches existing contacts by email before creating new ones to prevent duplicates.

🏒

Group Linkage

Every Contact must be linked to at least one Group. Freelancers can link to multiple Groups if they work with several companies.

⭐

Primary Contact

Each Group should have exactly one contact marked as "Primary Affiliation". This is the main point of contact for that company.

πŸ”„

Status Automation

Contact status auto-updates based on linked Deal statuses. If all deals end, status changes to "Former" after 90 days.

πŸ“ž

Contact Freshness

Alerts trigger if "Days Since Contact" exceeds 30 days for Active contacts, prompting AM follow-up.

πŸ”—

Bidirectional Links

Contact ↔ Group and Contact ↔ Deal connections are maintained automatically. Editing one side updates the other.