WhatsApp is one of the major messenger tools in the APAC market, especially in countries such as Indonesia, Singapore, and Malaysia. Consequently, to better support this product, Treasure Data partnered with ADA Asia to use their APIs to write job results from the TD Console to WhatsApp.
- Create a TD workflow to send messages to WhatsApp
- This is not a direct integration.
- No batch file transfer is supported. Although bulk upload and bulk send are supported by ADA APIs, there is currently no option in Treasure Data to send a JSON file from the console.
- The ADA Send Text Message API has a 5 messages per second limit . You will need to set the wait>: operator to comply with this limit.
- There are no APIs for retrieving reports from ADA
- ADA offers reporting on performance, but currently only manual processing is supported.
Audience Studio
- Clients can create segments within TD Audience Studio but need to export to TD self environment and run workflow to deliver messages
- Basic knowledge of Treasure Data workflow
- Basic knowledge of REST APIs
- API access to the ADA Business console (This requires a contract with ADA.)
- ADA Activation keys
- Customer telephone numbers
The static IP address of Treasure Data is the access point and source of the linkage for this Integration. To determine the static IP address, contact your Customer Success representative or Technical support.
Log in to ADA Business Console.
After you have logged in, you will see a dashboard showing an overview of the service.
Copy your ADA API key
Go to Channel > WhatsApp to create your messages. For business initiated messages, you must use template-based communications.
(Optional) Create your own templates, where you can use variables for personalized content.
After your template has been approved, which may take some time, copy the template name.
- (Optional) To get a template name, you can also list templates by account using the API. (Refer to API document provided by ADA.)
After you have finished creating templates, log in to the TD Console (or use the TD CLI) to develop your workflow.
The following workflow project example, only covers API based integration (that is, exporting with http>: ). Treasure Data strongly recommends that, for production operations, TD users add more tasks such as error notifications, logging to avoid spamming, and returning status codes. Contact the customer support team for more information about workflow design for production environments.
There are two ways you can send messages to WhatsApp accounts by activating telephone numbers:
http>:operator- Custom Script (Python)
In this example, the http>: operator is used with a combination of td_for_each>: operator
Prepare datasets that contain phone numbers of users who have consented to to communication in WhatsApp.
Use the following format for telephone numbers: country code + phone number. For example, a telephone in Japan would have a country code of 81 followed by the 10-digit telephone number (e.g. 819012345678 ).
Currently Meta allows API users to send messages. When using the Meta API to send phone numbers, if those phone numbers are linked to a customer's WhatsApp account, those customers will receive your business initiated (template based) messages in WhatsApp (though they have options to accept, block, or report spam..)
- Create a workflow
If you want to send messages to end users (as a response to an end-user initiated message), change the data payload as instructed in the API document. For other Send Text Message options, refer to this document: ADA Business Messeging API V2.1.
Please note messages will be immediately sent to the customer's WhatsApp account upon execution of the workflow. Consequently, Treasure Data recommends that you use segment rules to design execution schedules that are appropriate for for specific target audiences.
On the ADA Business Console, a log can be found on the Report > Message Log Record page. You may download the log data to your local environment, and then upload it to Treasure Data to enrich your data
