Prompt
How do I set up a communications CRM for tracking relationships and touchpoints across our foundation staff?
Latest observation
To set up a communications CRM for tracking relationships and touchpoints across your foundation staff, start by designing it around people, organizations, interactions, and ownership—not just “contacts.”
Here’s a practical setup approach:
1) Define the core use case
Be clear on what the CRM needs to help staff do, such as:
- Track all relationships with grantees, donors, partners, policymakers, media, and community leaders
- Log touchpoints like emails, calls, meetings, events, and notes
- Avoid duplicate outreach and “relationship gaps”
- Coordinate across teams and departments
- Surface who knows whom and how often people have engaged
2) Choose the right CRM structure
At minimum, your CRM should include these data objects:
Contacts
Individual people with:
- Name
- Title
- Organization
- Email / phone
- Role or relationship type
- Geography / issue area
- Tags or segments
- Preferred owner or relationship manager
Organizations
Institutions like:
- Nonprofits
- Donors
- Media outlets
- Government agencies
- Universities
- Corporate partners
Fields to include:
- Organization type
- Sector / issue area
- Region
- Website
- Primary staff contacts
- Relationship owner
Touchpoints / Interactions
Every meaningful communication:
- Date
- Type: meeting, call, email, event, note, intro, site visit
- Participants
- Summary
- Follow-up actions
- Related campaign or initiative
- Owner
- Confidentiality level if needed
Opportunities / Engagements
If your foundation tracks strategic engagements or opportunities:
- Proposal or partnership stage
- Status
- Next step
- Expected timeline
- Internal lead
- External stakeholders
3) Decide on shared fields and standards
To make the system useful across staff, define required fields and naming conventions.
Examples:
- Standard relationship categories: donor, grantee, partner, advisor, government, media, etc.
- Standard touchpoint types
- Standard “owner” field for accountability
- Standard tags for programs, regions, and issue areas
- Required summary format for notes
A common rule: if everyone can enter data differently, the CRM becomes unusable.
4) Establish ownership rules
For each contact or organization, define:
- Primary owner
- Secondary owner or backup
- Whether the record is shared or restricted
- Who can edit vs. view
This helps avoid overlapping outreach and clarifies who is responsible for the relationship.
5) Build simple workflows
You’ll want workflows for:
After a meeting
- Staff logs the meeting within 24 hours
- Summarize key points, decisions, and next steps
- Tag relevant initiative/issue area
- Assign follow-up tasks
Before outreach
- Check recent touchpoints
- Review relationship owner
- Confirm no one else recently contacted the person
- Log outreach after it happens
For new contacts
- Add basic info immediately
- Assign owner
- Link to organization
- Tag source and relevance
6) Create reporting dashboards
Useful reports for foundation staff:
- Touchpoints by person, organization, and team
- Last interaction date
- Contacts with no recent engagement
- Relationship load by staff member
- Interactions by issue area or campaign
- Network map of who knows whom
These reports help identify both activity and relationship coverage.
7) Set governance and permissions
Because foundation communications can be sensitive, define:
- Who can see what
- Confidential note handling
- Retention rules
- Approval rules for data entry and imports
- Privacy compliance and consent expectations
If you work with donor or grant-related data, consult legal/compliance requirements relevant to your jurisdiction.
8) Integrate with tools staff already use
The CRM will only work if it fits existing habits. Common integrations:
- Email/calendar sync
- Event registration tools
- Form intake
- Donor management systems
- Project management tools
- Shared inboxes or Slack/Teams
9) Train staff on behavior, not just software
Training should cover:
- Why logging matters
- What gets logged
- How to write useful notes
- When to update ownership
- How to search before reaching out
- How to avoid duplicating records
10) Start small and refine
A good rollout is:
- Pilot with one team
- Test required fields and reports
- Fix duplicates and inconsistent tagging
- Expand to all staff
- Review monthly for data quality
Recommended minimum setup
If you want the simplest effective version, build these:
- Contacts
- Organizations
- Touchpoints
- Ownership
- Tags for program/issue area
- Basic dashboards
- Email/calendar integration
Example touchpoint note format
A useful standard format:
- Date
- Who attended
- What was discussed
- Key takeaways
- Follow-up
- Owner
- Tags
Example:
2026-08-12 — Met with Jordan Lee at Community Health Alliance. Discussed upcoming convening and interest in partnership. Jordan asked for more info on funding timeline. Follow-up: send deck by Friday. Owner: M. Chen. Tags: health, partnership, convening.
If you want, I can also help you with:
- a CRM field schema/template,
- a recommended platform shortlist (e.g., Salesforce, Airtable, HubSpot, etc.), or
- a step-by-step rollout plan for a foundation team.