Skip to content

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:

  1. Staff Organizer Coordination Committee
  2. Inside Committee
  3. Card Signer Network
  4. Activist Cadres
  5. Targeted Unorganized Members
  6. 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.