Analyse public consultations with many comments
Public administrations analyse public consultations with thousands of comments
Fits: Leaders & strategy · Office, administration & casework
Thousands of comments are sorted by topic, location and proposal, with a reference to each individual contribution. You get a robust overview for the council and the public faster, and no contribution gets lost.
Is this for you?
- Your administration runs public consultations, online or on paper, with hundreds or thousands of contributions.
- The contributions are available digitally or can be captured, with an ID for each contribution.
- The result feeds into council reports, the weighing of interests or a public report.
Make up twenty short comments on a project, like the ones you know from earlier consultations, with duplicates and an ironic contribution, or take published contributions from a completed consultation without names. Have them sorted with the template below and check whether every contribution has been assigned to a topic.
How to go about it
- Decide what the analysis should show
- Provide contributions with IDs
- Have a topic overview generated
- Check the assignment against the contributions
- Transfer the result to the weighing of interests or the report
- Save the topic framework and checking rules for future consultations
Templates to copy
The complete guide
- 6 steps explaining exactly what to do
- 3 proven templates to copy into your own AI
- Safe use: data, checking, deciding, informing
- Pitfalls, effort and how to recognise success
With the training you get all 430 guides for as long as your access runs.
Same approach, other use cases
10 more use cases follow the pattern “Summarising & taking minutes”.
VW-04 · Legal status 08.10.2026