I am now looking at exactly how we can gather our normal stats from VBC. To do this I need to understand what look like some anomalies with the VBC data.
I am trying to create a list of volunteer enquiries for the last 3 months (Jan to Mar).
I have started by modifying the standard Activities report. Changing the time frame, adding in the required columns (eg Ethnicity, Employment status etc) and defining the activity to extract. For this latter I am using “Applied for Opportunity”, because VBC appears to generate this activity when the volunteer is imported.
However I have a couple of problems….
- Not all entries in “My Applications” that have been Imported have an “Applied for Opportunity” (or a “Volunteer Imported” activity). Why would this be?
- We have Volunteers who have applied for multiple opportunities. But they do not seem to have multiple “Applied for Opportunity” activities in their history. Can you explain exactly how all the activities are generated when Volunteers are imported?
- The activities report never seems to include multiple entries for the same volunteer where they have applied for multiple opportunities.
(if you need to look at our data, please check Rebecca Edwards and Holly Edwards. They have both applied for three Opps. Rebecca has only one "Applied for.. " activity in her history. Holly has none)
I hope that you can follow my thinking here. I really need to understand how all the activities are generated before using the reports.