Getting started with Group creation
Before sending texts or making calls in GetThru, you must first upload your list of contacts into a Group. Your file must be in .csv format to successfully upload it — .xls, .txt or any other format will fail.
Prefer a video? You can open our Groups video in our helpdesk, as a YouTube video, or download the file.
TABLE OF CONTENTS
Before uploading
Before uploading your CSV file to GetThru, open your file in Excel or another spreadsheet program. Once the file is open:
- Check that all of your columns have headers. If they do not, add a header row with labels. The first row of your file will always be processed as the header row, so a contact in the first row will not be included in the group.
- Check that there is a column for each of the 3 Required Fields: first name, last name, and phone number. If any of the required columns are missing, create columns in your file with those headers and input values into those cells. If a contact is missing any of the three required data points, the contact will not be included in the group.
- For example, if your file is missing some or all of your first name data, you can add a placeholder word such as "friend" for those contacts. Then, when using the first name field in your ThruText script, those contacts will be greeted as "friend" when you reference the contact's first name.
- Check the size of the CSV you're uploading. Groups can contain up to 50,000 rows, or have a file size of 15 MB. Some files close to 15 MB may get an error. If your file exceeds 50,000 rows, you can reduce its size by cutting and pasting some of the data into a new blank file, which you can upload as a separate group. You can add multiple groups to a single ThruTalk or ThruText campaign. Removing extra columns and restricting the amount of contacts in the file reduces the overall size of the file. Click here to read more about group size.
- Remove any columns that you do not need for syncing or as custom fields in your calling or messaging scripts. For example, to sync back to VAN, admins must map VAN IDs.
- To ensure high system performance, admins can only upload 3 groups in one account simultaneously. If you try to upload more than 3, you will see an error. To upload another group, please wait for one of the original 3 to finish uploading. Please check out our Groups Details guide for more information.
- After you have checked the content of your file, be sure to save it as a CSV!
Phone Number Formatting
GetThru can process various phone number formats, and recognizes different characters commonly found in phone numbers, including parentheses, dashes, or plus signs. Letters in the phone number field will result in an error for that row.
- U.S. and Canada phone numbers should have 10 digits, or 11 digits when the country code (+1) is used (e.g. +1 234 567 8910)
- UK phone numbers should have 10 digits, or 12 when the country code (+44) is added (e.g. +44 20 7123 4567)
How to upload a group
To start, click "Create New Group" from the left-side bar or the "Upload New Group" button on the admin dashboard, which will take you to the Group Upload wizard.
Step 1: Name & Country
Give your group a name, pick the country of origin for your phone numbers, and then click the "Next" button.
Using a naming convention at group upload can save you time and effort during campaign creation.
Step 2: Upload CSV
Select the file you wish to upload by clicking "Add a CSV" to select a file from your computer or drag and drop a file into the upload box. Once you've added your file, you can see the number of rows or clear the file if you want to upload something different. Ensure the wizard has completed assessing the number of rows before clicking the "Next" button to move forward.
You can use External Contact Lists if your GetThru account has a VAN integration set up. Read about managing your External Contact Lists or learn how to set up your account with a VAN Integration.
Step 3: Required Fields
Map your file with the three required fields: First Name, Last Name, and Phone Number.
All groups must have these columns, meaning any CSV you upload to create a group must also have values in these fields.
Step 4: Custom Fields
Map any custom fields you would like associated with your group. GetThru will list all of the custom fields on your account. When you upload a CSV with custom fields, GetThru will "guess" which column in your CSV should be associated with which custom field, just like in Step 3.
If "Select {CustomField} column" is left as the selection for a Custom Field, as shown for the "City" and "County" fields below, your custom fields will not be mapped.
In the above image, the "email" field is mapped.
NOTE - You must create your custom fields in your account before you can map them during the Group upload process. If the wizard skips from "Required Fields" to "Review," verify custom fields are created in your account.
If you have a VAN Integration for your account, you will also need to properly map your VAN IDs to ensure your data gets synced back.
Again, if you think that GetThru guessed incorrectly, you can change the mapping using your CSV headers' pulldown menus under each custom field name. Selecting "Ignore" will skip that custom field and not map it.
If you see custom headers listed that are no longer in use, you can archive custom fields to hide them from view and clean up clutter within your account.
Step 5: Review & Create Group
Make sure everything looks good. You can return to any previous steps to make edits if you wish. Once you are satisfied that everything is set up the way you want, click "Create Group."
Your group will show a yellow dot as it is actively validating your phone numbers and uploading your list. The time this takes will vary depending on your group's size or the level of usage on the platform (e.g., the upload may take a bit longer during busy times in a campaign cycle, like in November or right before a primary in your state).
A green dot indicates an active group that is ready for use on a campaign. It is now ready to be used on a campaign!
NOTE - A group upload should take less than 2 minutes to complete. If an upload is taking longer than that or numbers remain as "Unvalidated", please write to support at [email protected] for assistance.