Planning Center Groups SQL Queries

Build Stronger Community Through Data-Driven Group MinistryCopy Anchor Link

Your small groups are where life change happens. With Parable's SQL access to Planning Center Groups data, you can understand participation patterns, identify growth opportunities, and ensure no one falls through the cracks in your community.

Quick StartCopy Anchor Link

Ready to explore your groups data? Here's your first query to see your active groups and their membership:

-- See your 10 most active groups with member counts
SELECT 
    g.group_id,
    g.name,
    g.description,
    g.memberships_count,
    g.schedule,
    g.location_type_preference,
    g.created_at
FROM planning_center.groups_groups g
WHERE g.archived_at IS NULL  -- Only active groups
ORDER BY g.memberships_count DESC NULLS LAST
LIMIT 10;

What You Can Do With Groups QueriesCopy Anchor Link

👥 Understand Group ParticipationCopy Anchor Link

• Track membership growth and retention
• Identify groups that need more members
• Find people not yet connected to a group
• Monitor leadership coverage across groups

📊 Measure EngagementCopy Anchor Link

• Analyze attendance patterns and trends
• Identify highly engaged vs occasional participants
• Track event participation rates
• Measure group meeting consistency

🎯 Strategic PlanningCopy Anchor Link

• Evaluate group types and their effectiveness
• Plan new groups based on participation gaps
• Optimize group locations and meeting times
• Balance group sizes for better community

📈 Generate Leadership ReportsCopy Anchor Link

• Track leader-to-member ratios
• Identify potential new leaders
• Monitor group health metrics
• Create dashboard views for ministry leaders

Available TablesCopy Anchor Link

Your Planning Center Groups data is organized into these main tables:

Understanding RelationshipsCopy Anchor Link

Parable stores Planning Center relationships in separate tables to maintain data integrity. This means connections between entities are stored in dedicated relationship tables:

• groups_groups_relationships - Links groups to types, locations, tags, etc.
• groups_memberships_relationships - Links memberships to groups and people
• groups_events_relationships - Links events to groups and locations
• groups_attendances_relationships - Links attendances to events and people

We'll show you exactly how to use these relationship tables in our query examples!

Key ConceptsCopy Anchor Link

Groups vs Memberships vs PeopleCopy Anchor Link

• Groups are the small groups, classes, or teams in your church
• Memberships connect people to groups with specific roles (member, leader)
• People are individuals who can be members of multiple groups

Events vs AttendancesCopy Anchor Link

• Events are scheduled group meetings or activities
• Attendances track who actually showed up to each event

Roles in GroupsCopy Anchor Link

Members can have different roles:

• member - Regular participant
• leader - Group leader with additional permissions

Next StepsCopy Anchor Link

📚 New to SQL? Start with Basic Queries for simple, powerful queries you can use today.

🚀 Ready for More? Check out Advanced Queries for complex analysis and reporting.

📊 Need Reports? See Reporting Examples for complete, production-ready reports.

🔍 Want Details? Review the Data Model for complete table documentation.

Common QuestionsCopy Anchor Link

Why do some fields show NULL?Copy Anchor Link

NULL values appear when:

• A group hasn't been archived (archived_at IS NULL means active)
• Optional information wasn't provided (like virtual_location_url)
• An event hasn't happened yet (canceled_at IS NULL means not canceled)

How do I filter for active groups only?Copy Anchor Link

SELECT group_id, name
FROM planning_center.groups_groups
WHERE archived_at IS NULL;  -- active groups haven't been archived

What's the difference between created_at and system_created_at?Copy Anchor Link

• created_at - When the group was created in Planning Center
• system_created_at - When the data was synced to Parable
• Use created_at for ministry metrics

How do I find a person's groups?Copy Anchor Link

You need to join through the memberships table:

SELECT 
    g.name as group_name,
    m.role,
    m.joined_at
FROM planning_center.groups_memberships m
JOIN planning_center.groups_memberships_relationships mr_group
    ON mr_group.membership_id = m.membership_id AND mr_group.relationship_type = 'Group'
JOIN planning_center.groups_groups g 
    ON g.group_id = mr_group.relationship_id
JOIN planning_center.groups_memberships_relationships mr_person
    ON mr_person.membership_id = m.membership_id AND mr_person.relationship_type = 'Person'
JOIN planning_center.groups_people p 
    ON p.person_id = mr_person.relationship_id
WHERE p.person_id = 'YOUR_PERSON_ID'
    AND g.archived_at IS NULL;

What does location_type_preference mean?Copy Anchor Link

This indicates where the group typically meets:

• physical - In-person at a location
• virtual - Online meetings

Tips for SuccessCopy Anchor Link

1. Start Simple - Begin with basic SELECT queries before adding complexity
2. Use Comments - Document what your queries do for future reference
3. Test with LIMIT - Add LIMIT 10 while developing queries
4. Handle NULLs - Use IS NULL or IS NOT NULL appropriately
5. Check Relationships - Remember to join through relationship tables

Getting HelpCopy Anchor Link

• 🐛 Found an issue? Report it at github.com/getparable/parable-api/issues
• 📖 Need more examples? Check our other query guides in this folder
• 💬 Have questions? Reach out to your Parable support team

Your groups data tells the story of community. Let's help you understand it better.