User Guides
Send query results to Vozzi¶
Vozzi is a text messaging (SMS) platform for sports and entertainment brands. Brands use Vozzi to send mass text messages and one-to-one text messages to the contacts on their Vozzi lists.
Note
This destination uses the Vozzi API.
Beta
The Vozzi connector is in beta. Contact your Amperity representative to learn more.
The steps that are required to send phone numbers to Vozzi from Amperity.
Caution
This destination is available for sending query results to Vozzi after it is configured by a Datagrid Operator or your Amperity representative.
If this destination cannot be selected for orchestrations ask your Datagrid Operator or Amperity representative to configure a destination for sending query results to Vozzi.
Build query¶
Build a query that returns a field named phone_number, in lower case. Amperity sends only the phone_number field to Vozzi, where it adds and removes contacts on a Vozzi list. The first run adds every phone number that the query returns.
Each run sends every audience change that Amperity has not yet committed: phone numbers that joined the audience are added to the list, and phone numbers that left it are removed. Amperity commits a change only after a run succeeds more than 3 days after the change, so a change is sent again on every run until then. A run that fails commits nothing, so the next run sends every uncommitted change again, including the contacts that the failed run already added or removed.
The following example returns the phone numbers that are opted in to SMS messages from the SMS Opt Status table:
SELECT DISTINCT
phone AS phone_number
FROM SMS_Opt_Status
WHERE is_sms_opted_in = true
AND phone IS NOT NULL
Important
Amperity converts each phone number to E.164 format, and then removes the leading plus sign, which is the format Vozzi uses. For example, (206) 555-1234 is sent as 12065551234. You can return phone numbers with spaces, dashes, or parentheses.
A phone number without a country code is treated as a United States number. Include the country code, such as +44, for every phone number outside the United States. A phone number that Amperity cannot read is not sent and is counted as failed.
Amperity compares phone numbers as your query returns them, before it converts them. Return each phone number in one consistent format. When the same number appears in two formats and one of them leaves the audience, Amperity removes the contact from the list, even though the number is still in the audience in its other format.
Important
Amperity does not send consent or opt-in status to Vozzi. Send only phone numbers that have consented to receive text messages from your brand.
For example, bring SMS subscriber status to Amperity as a data source, and then use the SMS Opt Status table to return only phone numbers that are opted in.
Important
A Vozzi list holds up to 1,000 contacts. Amperity does not check how many contacts a list holds before it adds more. Keep the total for each list at 1,000 phone numbers or fewer, including contacts that are already on the list.
Add orchestration¶
An orchestration defines the relationship between query results and a destination, including the destination and the frequency at which an orchestration runs.
Open the Activations page, select the Orchestrations tab, and then click the Add orchestration button. This opens the Add orchestration dialog box.
From the Object type dropdown, select Query.
From the Object dropdown, select the query for which results is sent to Vozzi.
From the Destination dropdown, select a destination that is configured for sending data to Vozzi.
Verify all settings.
Set the workflow to Manual. You can change this to automatic later, after verifying the end-to-end workflow.
Click Save.
Set List name to the name of the Vozzi list that this orchestration keeps in sync. Use a separate list for each query that you send to Vozzi.
Run orchestration¶
Run the orchestration manually to validate that it works.
Open the Activations page, select the Orchestrations tab, and then open the menu for the Vozzi orchestration. Select Run.
The Status column for the orchestration updates to say “Waiting to start”, after which the notifications pane updates to include a notification that shows the current status.
When the orchestration has run successfully, the status is updated to “Completed”.