Importing Contacts in Spur
Go to Database
Click on Import
Click on the Sample CSV Link
Make a copy of our sample CSV file
Fill the Google Sheet and export as "CSV" file.
Go back to Spur, click on Upload CSV.
Cross check the number of contacts and click on Import Contact.
Understanding the CSV Format
Country Code: This is the country code
Number: The phone number of the contact, without country code
Email: Email of the contact
First Name: First Name of the Contact
Last Name: Last Name of the Contact
Channel: For now, can only be WhatsApp
Profile Picture URL: If you have a profile picture of the contact, include it here!
Tags: Tags you want to add to the contact, separated by comma
Opted In: Whether they have opted in or not for WhatsApp marketing messages.
You can also add custom fields, any custom field name should look like
Custom[<field-name>]So if you want to add a custom field "Location", the header should be Custom[Location]
Sending a Broadcast to The Uploaded Contacts
Example -
You use a loyalty / reward app, that gives credits to customers after every purchase and a coupon code that can be used to redeem those credits.
You wish to broadcast a message to all of these customers and tell them about how much credits they have and give them their coupon code that they can use on their next purchase to redeem their credits.
Firstly, you'll need to export customer data from your loyalty / reward app and copy-paste relevant data into Spur's Sample CSV file.
Using Custom Fields to Set Template Variables in a Broadcast Message Template
You can import the Credits and Discount Code via Custom Fields. Add 2 new columns for the Custom Fields in the Sample CSV and follow the nomenclature - Custom[<field-name>] for the header.
Let's name them - Custom[Discount] and Custom[Discount Code] respectively.
Now, we can use Custom Fields in place of variables of the message template that you'll be using for the Broadcast. Currently, you can't select a Custom Field, but you can follow this format to add the desired Custom Field in the message - {{context.customer.custom["<field-name>"]}}
So for this example, let's add - {{context.customer.custom["Discount"]}} and {{context.customer.custom["Discount Code"]}} to replace variable 3 and coupon code variable of the limited-time offer template we're using.
Creating A Segment Using Tags
The easiest way to send a broadcast to all the contacts you just imported is to add a tag like, "loyal-customers" in the "Tags" column for all the customers.
Then we create a segment for all these customers, like this →
Note: You can find our more detailed guide to broadcast on Spur here.