Sometimes you need to promote multiple leads at once. The easiest way to do that in Coworks is to use the CSV importer in the Migrations tab in your community settings.
How to use the bulk promoter
First, download the contacts or leads report from the Reports tab.
Next, remove any leads or contacts from the report that you do not want to promote.
Update/Verify your spreadsheet data.
Verifying Fields
Any leads or contacts left in the list when you upload it using the bulk promoter will be processed by the system.
You must keep the email addresses the same, otherwise, the lead will be treated as a new lead or contact, and won't be promoted properly.
Since members require teams, the "Team Name" field (company_name in the CSV Leads or Contacts reports) for a lead/contact is what the system uses as the team you would like to promote them to. If we find an exact match of a team that already exists in your Directory, the lead/contact will be promoted to that team. Otherwise, a new team will be created with the name in the "Team Name" column in the CSV. If no team name is present, Coworks will default to
first name + last name's team as the team name.
If Coworks finds a new team name in your spreadsheet multiple times, it will assign the first person on that team in the spreadsheet as the admin of the team.
Additional Supported Fields
We support
Room Permissionsas a column name that takes a comma-separated list of room permission groups that would like to assign to this new member. An example would beGroup Blue, Group A. You will have to add the column manually as it doesn't exist in the lead/contact report. Make sure to match theRoom Permissionsexactly.
(Billing only)
Plans Column (Required): We also support
Plansas a column that will create a membership using a comma-separated list of plans. An example would beCoworking Plan, Parking Pass.
Note: Those plans must already exist to be processed properly. If the team doesn't already exist, these plans will be set up to bill on the beginning of the next month (or a different day of the next month based on yourDefault Billing Cycle Datesettings from your billing settings.)
Monthly Bill Date: By default, we will set the recurring bill date based on your billing settings here. You can override this and set a different recurring bill date for the member by adding a column titled "Monthly Bill Date," which is a number between 1-31 representing the day of the month to bill. By default, billing will start at the next occurrence of that date. For example, if uploading on May 15 with a bill date of "5," the billing will start on June 5th.
Billing Start Date: We also support custom billing start dates. This allows you to set the start date of when your customers should be billed. By default, we will use the monthly bill date you've set in your settings or in the column provided and start billing at the next occurrence of that date. Alternatively, you can set an exact date in the future to start billing. The customer will still be billed on a recurring basis according to their recurring bill date, but they will receive a prorated invoice on the "Billing Start Date" for the time in between. This works the same way that our "Add Member" flow works.
Note: Format must be: "MM/DD/YYYY"
Custom Fields
Any extra columns added to the spreadsheet will be treated as Custom Fields.
For example: Let's say you want to keep track of member key fob numbers. You can add a column at the end called "Key Fob."
The system will recognize that this is as a unique column and then add that attribute on each member as a custom field.
Note: Any information you change between downloading the CSV and uploading through the migrations tab will be reflected in the new member's profile except Follow-up dates, tour dates, promoted dates.
Upload the CSV of the remaining leads or contacts you want to be promoted using the "Promote Existing Leads or Contacts" section in the Migrations tab. Any leads or contacts that have an email address from the CSV that matches one in the system will be promoted and will be removed from your CRM.
You will have the option to send onboarding emails at the time of the upload. You can do this manually if you choose to not send them at the time of upload.
Done!
If you have any trouble with this, please reach out! It's much easier to set up the spreadsheet correctly ahead of time.
Happy Coworking!