​

Planning Center Services Overview

​

What’s Available

​

📊 Core Capabilities

• Service Planning - Access all service plans, series, and scheduling data
• Volunteer Management - Track team participation, availability, and engagement
• Song Analytics - Monitor song usage, keys, themes, and rotation patterns
• Team Health - Analyze team capacity, confirmation rates, and scheduling gaps
• Resource Tracking - Manage attachments, chord charts, and media files
• Multi-Site Coordination - Synchronize services across campuses

​

🎯 Key Use Cases

​

Quick Start Examples

​

Who’s Serving This Sunday?

SELECT
    p.full_name,
    t.name as team,
    pp.team_position_name as role,
    pl.title as service,
    pp.status
FROM planning_center.services_plan_people pp
JOIN planning_center.services_people p ON pp.person_id = p.person_id
JOIN planning_center.services_teams t ON pp.team_id = t.team_id
JOIN planning_center.services_plans pl ON pp.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE
    AND pl.sort_date < CURRENT_DATE + INTERVAL '7 days'
ORDER BY pl.sort_date, t.name;

​

Top Songs This Quarter

SELECT
    s.title,
    s.author,
    COUNT(DISTINCT i.plan_id) as times_used,
    MAX(pl.sort_date) as last_used
FROM planning_center.services_songs s
JOIN planning_center.services_items i ON s.song_id = i.song_id
JOIN planning_center.services_plans pl ON i.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE - INTERVAL '3 months'
    AND i.item_type = 'song'
GROUP BY s.song_id, s.title, s.author
ORDER BY times_used DESC
LIMIT 20;

​

Volunteer Activity Summary

SELECT
    t.name as team,
    COUNT(DISTINCT pp.person_id) as volunteers,
    COUNT(CASE WHEN pp.status = 'C' THEN 1 END) as confirmed,
    COUNT(CASE WHEN pp.status = 'D' THEN 1 END) as declined,
    ROUND(AVG(CASE WHEN pp.status = 'C' THEN 100.0 ELSE 0 END), 1) as confirm_rate
FROM planning_center.services_plan_people pp
JOIN planning_center.services_teams t ON pp.team_id = t.team_id
JOIN planning_center.services_plans pl ON pp.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY t.name
ORDER BY volunteers DESC;

​

Available Tables

​

Core Planning Tables

• services_service_types - Service categories and settings
• services_plans - Individual service plans
• services_plan_times - Service and rehearsal times
• services_plan_templates - Reusable service templates
• services_items - Service order and elements
• services_series - Sermon series information

​

People & Teams

• services_people - Volunteer and staff records
• services_teams - Ministry teams
• services_team_positions - Roles within teams
• services_plan_people - Who’s scheduled when
• services_schedules - Individual scheduling records
• services_person_team_position_assignments - Role assignments

​

Worship Resources

• services_songs - Song library
• services_arrangements - Keys and arrangements
• services_attachments - Files and media
• services_media - Video and audio resources
• services_keys - Musical key information
• services_song_schedules - Song planning data

​

Scheduling & Availability

• services_blockouts - Unavailability patterns
• services_blockout_dates - Specific blocked dates
• services_blockout_exceptions - Override dates
• services_needed_positions - Unfilled positions
• services_time_preference_options - Scheduling preferences

​

Integration Benefits

​

With Check-ins

• Compare volunteer schedules with actual attendance
• Track volunteer family check-in patterns
• Analyze service time effectiveness

​

With People

• Access complete member profiles
• Track household serving patterns
• Coordinate family scheduling

​

With Giving

• Correlate serving with giving patterns
• Identify engaged members across ministries
• Track volunteer donor overlap

​

With Groups

• Find group members serving on teams
• Identify potential volunteers from groups
• Track ministry involvement paths

​

With Calendar

• Coordinate facility usage with services
• Manage resource conflicts
• Plan rehearsal spaces

​

Best Practices

​

Next Steps

1. Understand the Data Model - Learn about all tables and relationships
2. Start with Basic Queries - Simple SQL for common questions
3. Master Advanced Analytics - Complex analysis and optimization
4. Build Complete Reports - Production-ready dashboard queries