Database
Organizing Data
Why is data important?
- A successful organizing drive is developed through relationships between workers of a workplace.
- An organizer's job is to map, track, and use these relationships to build a succesful campaign.
- All data supports the development of the strategic plan for the campaign.
- An organizer will choose the data management tool that gets the job done with the least hassle.
Characteristics of an organizing drive
- Must move quickly.
- Limited bureaucracy.
- Built on the trust of the inside committee.
- In most drives, inside committees organize workplaces, not union staff organizers.
Structures of a drive
Top-level organizing structure hierarchy:
- Staff Organizer Coordination Committee
- Inside Committee
- Card Signer Network
- Activist Cadres
- Targeted Unorganized Members
- Non-Targeted Unorganized Members
Data Driven Structures
Structures are data-driven:
- Each structure needs scaffolding to hold that structure up.
- All members/individuals are assigned to a level by what the data we collect and manage says.
- Relationships, recruiting, follow-ups, understanding if the drive has run out of room is all decided by the data map.
Basic information: The List
- Lists are the what allows a drive to be successful.
- Lists are needed for filing at the Board.
- Not just the list from the employer, is built through campaign.
- Contains more than just name and contact information.
- Who you have talked to.
- Who it was that signed the member.
- Who was not able to sign a member.
- Referrals.
- Workplace leadership/influencers.
Basic information:
- You should be able to draw a map from the start of the drive to the end of who signed who, when, why, and sometimes where.
- We track issues, questions, follow-ups, problems, engagement with the campaign, recruitment, anti-union activity, and the physical workplace.
- A full map of influence netwrok in the workplace.
- Complex campaign: Recruitment & supporting the structures are not possible without a detailed and current list.
- Without a comprehensive list, we cannot file at the Board.
Why a Database?
Spreadsheets do not provide
- Centralization
- Security
- Access Control
- Standardization
- Portability
- Ease of use
Benefits of a database
- Limit duplication
- Automation
- Mapping networks
- Managing follow-ups
- Managing budgets
- Managing Member Organizers
- Analysis across multiple drives
Database from the ground-up
- Track Drive information
- Track Member Organizer assignment
- Calculate resources/budgets
- Store full contact lists
- Track organizer assignments
- Allow analysis of success and failures
- Facilitate reporting
- Track legal work for each drive
Additional needs
- Flexibility of design
- Ease of use for normal users
- Templates for export/imports
- Granular permissions
- Ease of back-up & restore
- Scales to full needs of the department
- Full mobile access
- Free
Organizing in Ontario's Database
Rukovoditel
The Database of choice for Ontario Organizing is Rukovoditel[^1]. It has the following characteristics which makes it ideal for our needs:
- Open Source (free)
- Self-hosted
- Extremely flexible design
- Project management tools built-in
- Mobile Friendly
- Graphical export templates
- Form-driven
- LAMP based
- Clean MySQL structure
- Light server requirements
- Easy to manage
[^1]: Rukovoditel is an open source project management software solution for small teams.