
Clean data tips for the engagement stages
You want to implement processes to keep your stakeholder data clean at this stage, so you've got everything you need when you’re reporting and engaging.
- Set regular inputting expectations – Make expectations clear for when everyone needs to input their data into the SRM (e.g., every day? At the end of the day each Friday?). If you have a regular reporting deadline, this can be a suitable time as everyone knows the data will be reported out on that day, and their name or work will be tied to it, so they’ll want to have it clean before it’s shared and reviewed!
- Discuss the data routinely – Consistent transparency and visibility on the state of your data is key to keeping it clean. Consider adding space to your regular meetings to talk about the data, ask questions and make plans for cleaning it if there are any inconsistencies. This allows everybody who has a role in the project to be updated and ask clarifying questions like, “This is the data currently in our SRM. Is anything missing? The subject on this record is inconsistent with the format we’ve set. What should it be instead? Who will be responsible for correcting this?”
- Choose regular maintenance dates – Set clear timelines and expectations for your data maintenance. Will you do a thorough clean each quarter? Continual cleaning every Monday? Choose a timeline, clarify who’s responsible for what on your team, and stick to the process.
-
- Make data corrections as you find them – If you find more duplicates or learn more about your stakeholders, ensure the information is corrected and added as you find it. While setting regular maintenance schedules is essential, establishing an additional “clean as you go” standard will help catch anything leftover or missed.
- Find the gaps – Use your SRM reports to find gaps in your data. These reports can give you another way to look at your data and identify areas that need to be completed or cleaned up (e.g., finding a section in a record that you may not have realized was missing and needs to be finished).
Clean data benefit #2 – Building stakeholder trust: Clean data can help you earn stakeholder trust. Whether you need to follow up on a stakeholder commitment or resolve a stakeholder issue, with all your data complete and accurate in your SRM, you can stay updated on everything important to your stakeholders, so you never miss deadlines or engagement opportunities. This is a big part of maintaining and building stakeholder trust!
Clean data tips for the post-engagement stages
At this stage, you want to consider, “Is everything that needs to be in the system inputted? Will the data provide value for someone who wants to learn from it later? Do we need to clarify anything?”
- Do a final data sweep – Go through notebooks, phone notes, and emails to see if any data still needs to be entered into your SRM. If you’ve set up general project email inboxes, is there anything to add from there? Take some time to do a final sweep to ensure everything’s added.
-
- Add any last uploads – Do you need to upload any other documents to the project or a specific record that might provide more information or context (e.g., final reports, images, PDFs, etc.).
- Incorporate data from other sources – If you worked with contractors, or added information to other systems, don’t forget to incorporate it into your SRM. If a contractor wasn’t involved in your tracking processes, is there anything that you need to add or collect from them?
- Look at your data from the perspective of someone outside the project – Take a final look at all your data. Are you confident that it’s something that would help people coming into a project? Would this data benefit people? Would any of it seem confusing or incomplete? Take the time to clarify, add and organize anything that might need final attention.
- Document any final learnings – Take some time to brainstorm any final learnings that might be useful for people to use in the future.
- Consider:
-
-
- Is there anything you learned about working with stakeholders that isn’t already logged? Are there any reflective notes or extra context that you want to add?
- Do you now know more about a previous stakeholder issue? Was the outcome of the issue positive? (e.g., “Looking at this data six months afterward, this issue was resolved, and we heard the following positive feedback from them.”).
-
- Run a comprehensive report – Run a final comprehensive report with all your project data and look for any remaining gaps you might have missed.
Clean data benefit #3 —Preparing for future questions: If someone is looking for information about a project from three years ago, you can confidently answer their questions. For example, if you’re asked whether a stakeholder was involved in a particular project or if a person attended a focus group, you could easily find these answers in your SRM when your data is clean. This is especially useful when somebody is asked about a project they weren’t involved in!
Next steps: Are you still using spreadsheets for your stakeholder data management?
If you’re still trying to make spreadsheets work for your stakeholder data management, read our three tips on how an SRM can help you manage your stakeholder data.
If you're ready to make the switch from spreadsheets to stakeholder relationship management software, check out our eBook, 'The Step-by-Step Guide to Say Goodbye to Spreadsheets.'