Special Post for Salesforce Community Group Leaders: How to do a salary survey

A few people from a Salesforce user group asked my mom to launch the group's first ever salary survey. Mom said yes, but I quickly decided to take over the whole process for her.  I am, after all, very good at being in charge... in the photo above, you can see me wearing my crown.  What I learned: Power = responsibility.  Avoid both.... or read up on a quick guide to do your own Salesforce community group salary survey.

1. The "duh" question: Does the group want a survey? 
   Yes?  If so... What security needs to be used to protect the group's personal information.  For my mom's group, the decision was made to do an anonymous survey, with no "required" questions so a person could answer as few or as many as they liked.  The results are to be shown at a meeting only, and not posted for public view.
    
2. Create the survey.
   A huge thank you to GetFeedback and the Denver User Group for templates.
   
   
3. Distribute and Promote! 
   These are the easy steps, and, I thought that the work was nearly finished when nearly 100 people responded...then I realized that the hard part was still to come....the analytics.
   


4. Upload results
   As this is a "Salesforce" group, the only place I considered was a Salesforce dev org. I started by creating a custom object then the fields.  This is where I made my first HUGE mistake and created several multi select picklists.  Boo. Not only was uploading to them a pain, the reporting options were.... great.  (I assume you can catch the sarcasm.)  I should have re-created the data model then started from the  beginning, but the clock was rapidly approaching naptime and I am, after all, a volunteer.
   


5. Custom Report Type  
   Create reports and dashboards... My favorite metrics:
   High and Low Salary Ranges
   Average Salary by Years of Experience by Role
   The "standard" benefits..... maybe I'll leave this one off of my dashboard.

Coronation.