Twilio Conversion Tracking

Overview

Companies all over the world are marketing their companies using social media, radio and TV advertising, and print media such as newspaper ads, brochures, vehicle wraps and billboards. However, many of those companies are struggling to determine which platform provides the best return on investment. Effective marketing campaigns measure the performance of each campaign using a variety of techniques. An effective way to measure marketing campaign performance is to assign unique phone numbers to each marketing touchpoint, and then to track phone calls (and conversions) generated from each marketing touchpoint.

Technologies Used

• Twilio - provides phone numbers and call tracking API (application programming interface)
• Adobe ColdFusion - Imports Twilio phone call data daily into a SQL Server database, exports data in Microsoft Excel format, and includes business logic.
• jQuery - JavaScript Framework
• Data Tables - jQuery-based plug-in to enhance the display of data in a table (sorting, paging ...)
• Kendo-UI - jQuery UI Components - used for the date picker functionality
• Microsoft SQL Server - Database which stores conversation tracking information, including imported Twilio data and marketing touchpoint data.

Live Demo