CCCC Member Growth Team

Green Intelligence

Turn community activity into timely, human follow-up: strengthen participation, support unanswered questions, and identify the signals worth bringing into member conversations.

Community health

What needs attention now

Loading the most recent Green snapshot…

How to refresh this page

Export the kpis, insight_engine, unanswered_topics, and optionally looker_green_intelligence_monthly_trends tabs as CSV files, then select them here together. Imported data stays in this browser. A live Google Sheets sync needs an authenticated server-side integration; do not put Google credentials in browser code.

Monthly active users

—

DAU / MAU (30-day avg.)

—

Monthly contributors

—

Average first response

—

Unanswered topics

—

Recommended focus

Priority actions

Generated from the current Green insight feed. These prompt staff action; they do not make automatic decisions.

    Community rhythm

    Recent topic creation from the imported monthly-trends export.

    Engagement signals and next steps

    Review the context and recommendation behind each community-health signal.

    SignalValueStatusMeaningAction

    Unanswered-topic queue

    Use this as a care queue for questions that may benefit from a timely response or handoff.

    TopicViewsLikesCreatedOpen daysNext step