# Select Audience

To select the target audience to send the Broadcast message, you can either choose to [Upload Contacts from Excel](#upload-contacts-from-excel) or [Select from Contact Group in Gallabox](#select-from-contact-group).&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FlW70GCUF0Ze9jPnF9JS1%2FSelect%20the%20Audience.png?alt=media&#x26;token=4da6a8c1-919e-4377-845f-725bb56ac71e" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Make sure to add Phone numbers (**with country code,** e.g., +91, +1, or +971)
{% endhint %}

Let's see in detail both the options:

## Upload Contacts from Excel

Send Tailored Messages to Contacts in Your Excel Spreadsheet.&#x20;

1. Click on **Upload Contacts** button to download the sample file.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2Fx1xaeb4oC1wbWDpz6OV8%2FUpload%20contact%20button%20for%20Google%20Sheets.gif?alt=media&#x26;token=762f6647-bd05-4ca5-8bde-df14330a3071" alt=""><figcaption></figcaption></figure>

2. Download the *Sample file*. Restructure your data (the Names and the Phone number) as per the Sample file.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FwJTqFgKPDrbbzFcN6Oew%2FDownload%20Sample%20File.gif?alt=media&#x26;token=a0ba4bb8-775e-43bf-91fc-24082d1e5ace" alt=""><figcaption></figcaption></figure>

Sample File:&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FaaFlz1wk0FcoBUL3183W%2FSample%20File.png?alt=media&#x26;token=ed1ffb1a-62f3-4f8a-a1cc-fc7bd5c6bc57" alt=""><figcaption></figcaption></figure>

The Column Name 1 (in the above screenshot) is for the variables that you have defined in your Message Template. If your Message Template has 4 variables like {{name}}, {{orderId}}, {{price}}, and {{brandName}} then the sample file would be:&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FW88kXAcEB96dYCVnRU6S%2FSample_file.png?alt=media&#x26;token=f3c1bc43-5bf3-47e7-863d-e3471cdea209" alt=""><figcaption></figcaption></figure>

After re-structuring the data as per the sample file, it should look something like:

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FP24Hg6beHiAsNQcuOn7N%2FData%20in%20Sample%20File.png?alt=media&#x26;token=077bd3ee-12f9-4336-937b-fbaf53701d6b" alt=""><figcaption></figcaption></figure>

3. After you are done re-structuring the data as per the sample file, it is time to upload the excel file in Gallabox.&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2F3bmFHchRCraxxmJtKL5q%2FUpload%20the%20File.gif?alt=media&#x26;token=98457bb6-5ae2-4342-9947-95f6ec24d92d" alt=""><figcaption></figcaption></figure>

## Select from Contact Group

Make a New Contact Group or Pick an Existing one to send Tailored Messages to.

1. Click on **Select Group** button to create a contact group or select from the existing.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FceXiX5NDXgQkh5Q5W5C5%2FSelect%20group.gif?alt=media&#x26;token=0f55a935-380c-40e5-9417-61f84c3159c9" alt=""><figcaption></figcaption></figure>

2. To create a Contact Group, click on Create Group as shown the GIF below. Click on Filter and filter out the contacts based on Email, tags, marketing opt-in or other fields. Provide the name for the Contact group and click on Create Group.&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FeS6nMITlxAEzVfwm71DI%2FCreate%20Contact%20Group.gif?alt=media&#x26;token=bff86b0f-0a9e-4b17-814f-8494c2a3bf68" alt=""><figcaption></figcaption></figure>

### Map the variables

After the upload or selecting the contact group, you can preview the data to be mapped with the right values or variables.&#x20;

1. If your WhatsApp Template has pre-defied variables, then you can map the variables and add the Payload for the buttons in the WhatsApp Template (if you would like to run any Bot flow once you get the response from the customer).&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FhVdxamzf7ONQQxq4bRka%2FMapping%20the%20Variables.gif?alt=media&#x26;token=9a1fe6fb-9697-41b2-8ba6-1fcb520c7a1f" alt=""><figcaption></figcaption></figure>

2. If your WhatsApp Template has a CTA button with ***Dynamic URL*** you will have the option to pick one variable. Adding a variable creates a personalized link for the customer to view their info. Only one variable can be added to the end of a URL.

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2FiIvNasgjAUoUENWL6ary%2FDynamic%20URL-Broadcast.gif?alt=media&#x26;token=bce912f4-3f58-4bb4-89b0-af3f204b15ef" alt=""><figcaption></figcaption></figure>

3. If your WhatsApp Template has a Media, you have ethe option to add a variable or upload the media file from your device.&#x20;

<figure><img src="https://3137140735-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZcl3T6ePz95GpzjAeOLW%2Fuploads%2Fd9baPKS5O1WtbBn5TOuX%2FBroadcast%20variable.png?alt=media&#x26;token=714cb51c-fa61-4f47-9168-2c0cf77bb065" alt=""><figcaption></figcaption></figure>

### Related Read

<table data-card-size="large" data-view="cards"><thead><tr><th></th><th data-hidden></th><th data-hidden></th></tr></thead><tbody><tr><td><a href="review-and-send-broadcast">Review and Send Broadcast</a></td><td></td><td></td></tr></tbody></table>
