Animal Shelter Adoption Funnel Analysis Builder

You are a nonprofit data analyst helping an animal shelter improve adoption flow and capacity while treating animals, adopters, and staff respectfully. Build an analysis plan for:

Shelter type: [municipal shelter, nonprofit rescue, foster-based rescue, humane society, species-specific rescue, multi-site shelter]
Animal population: [dogs, cats, rabbits, small animals, mixed species]
Data sources: [intake records, kennel roster, foster records, adoption applications, website views, inquiries, meet-and-greets, medical holds, behavior notes, return records]
Time period: [last month, quarter, year, seasonal campaign, pre/post process change]
Funnel stages: [available, profile viewed, inquiry, application started, application approved, meet-and-greet, adoption, foster-to-adopt, return]
Capacity constraints: [kennels, foster homes, staff review time, veterinary clearance, transport, quarantine, behavior support]
Key questions: [long stay drivers, application drop-off, species or age bottlenecks, foster conversion, marketing gaps, return patterns]
Data quality issues: [duplicate animals, missing outcome dates, inconsistent reasons, manual notes, small sample sizes]
Privacy and ethics limits: [adopter privacy, sensitive surrender reasons, staff safety, animal behavior nuance]
Output needs: [operations dashboard, board report, grant narrative, adoption campaign brief, staff meeting summary]

Create:
1. Data inventory and cleaning checklist for animal ID, stage, dates, status, species, age, foster, and outcome fields.
2. KPI definitions for length of stay, stage conversion, application cycle time, foster placement rate, kennel utilization, returns, and inquiry response time.
3. Funnel analysis by species, age group, size, location, foster status, profile completeness, and campaign source.
4. Capacity analysis for kennels, foster homes, veterinary clearance, staff review time, and meet-and-greet slots.
5. Long-stay analysis that avoids stigmatizing animals and separates data from interpretation.
6. Dashboard layout for leadership, adoption counselors, foster coordinators, and marketing staff.
7. Recommendations menu for profile updates, foster recruitment, process changes, transport, events, and follow-up.
8. Return and post-adoption support analysis with careful caveats.
9. Grant-ready narrative connecting demand, outcomes, capacity constraints, and planned improvements.
10. Data ethics checklist for privacy, small groups, behavior labels, and humane language.

Do not infer temperament, medical status, adopter quality, or surrender reasons beyond supplied data. Flag sensitive findings for staff review before publication.