Monthly employee engagement report for your People team

On the first Monday of every month at 8am, build our employee engagement pulse report for the People team.

Start in SurveyMonkey. Call Get Survey Details for the engagement survey first and build a lookup that maps answer and choice IDs to the real question text and answer text. This step is required, not optional: the response endpoints return answer and choice IDs only, so without this map every rating and comment comes back as an opaque ID. Then call Get Survey Rollups for the aggregate scores across the survey, and Get Survey Trends for the month over month movement on each question. Finally call List Survey Responses (Bulk) to pull the individual responses including the written open ended comments, resolving every answer ID through the map you built from Get Survey Details.

Next, call Get Employee Directory in BambooHR and match each respondent's work email address against their employee record. Use that to tag every response with the respondent's department and their tenure, calculated from their hire date. Group tenure into bands such as under six months, six months to two years, and over two years. If a respondent's email does not match anyone in the directory, keep their response in the overall scores but place them in the Other group.

Apply the anonymity floor before writing anything. Any department with fewer than five responses this month must not be reported on individually. Roll every one of those departments together into a single Other bucket. Never name a department below the floor, never report a score for a group below the floor, and never quote a comment in a way that could identify the person who wrote it. This rule is what makes the report safe to circulate, so treat it as non negotiable.

Now write the summary. Cover what improved since last month and what slipped, leaning on the trend data rather than this month's raw scores alone. Identify the two or three issues that recur across the open ended comments, and quote one short representative comment for each, anonymously, with no name, job title, team, or other identifying detail. Call out any department or tenure band that stands out against the company average, subject to the five response floor. Keep it to roughly a page and lead with what the People team should actually act on.

Log the numbers to the tracker using Google Sheets Append Values. Add one row per department per month, with the month, the department (or Other), the response count, and the key scores. This is append only, so history accumulates and nothing is overwritten. There is no need to read the sheet back, because the month over month comparison already comes from SurveyMonkey's own Get Survey Trends data. The sheet exists purely as a long term record.

Finally, post the written summary to our People team channel using Slack Bot Send a Message. Format it for Slack with short labelled sections and the quoted comments clearly set apart from the analysis. Put the total response count and the response rate at the top so the reader knows how much weight to give the findings.