COMMUNITY METRICS · Workflow idea
Organize selected metric rows from a team spreadsheet for the corresponding records in a community insights workspace. Keep definitions, reporting periods, and proposed changes visible so a person can check the numbers before they are applied.
01 / The starting point
Selected community or engagement measures maintained in a team spreadsheet
“Match each selected measure to the intended record, preserve its period and meaning, and wait for a reviewer to approve changes in the shared insights workspace.”
02 / The work
Helps a team carry selected community measures from a spreadsheet into a shared place for engagement review.
Choose only the spreadsheet rows the team intends to use and retain their labels and reporting periods.
Review what each measure represents and flag missing, inconsistent, or unusually formatted values.
Use agreed names or identifiers to connect each row with its correct destination and hold uncertain matches for review.
Show source and proposed destination values together so a reviewer can spot unexpected differences.
Require an authorized person to confirm the measures, period, and destination before shared records are changed.
Check that the approved figures appear with clear labels and period context and note any remaining data questions.
03 / The result
A reviewed set of metrics in the intended workspace, with unclear measures, periods, or matches held for clarification.
Reports & insights · Example outcome
A reviewed set of metrics in the intended workspace, with unclear measures, periods, or matches held for clarification.
Metrics can be delayed, defined differently, or tied to the wrong period. Verify the source row and destination, limit access to appropriate teammates, and require human review before shared account changes or financial decisions.
04 / Make it yours
A few choices shape the work around your team.
Document which rows and columns are in scope and how the team identifies each measure’s time period.
Define each measure and how spreadsheet labels map to the shared insights records.
Limit visibility to appropriate teammates and name who reviews and approves changes to shared figures.
Review a normal row, a changed value, and an unclear measure to confirm each is checked before updating the destination.