1 / 28

April 2019

April 2019. Agenda. Introductions Goals Add Your Bio to the Seattle CFUG site Registration for CF Summit 2019 now open Integrating Twilio for Conversion Tracking with Your CF Web App Adobe ColdFusion Breakfast Recap

saenzc
Download Presentation

April 2019

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. April 2019

  2. Agenda • Introductions • Goals • Add Your Bio to the Seattle CFUG site • Registration for CF Summit 2019 now open • Integrating Twilio for Conversion Tracking with Your CF Web App • Adobe ColdFusion Breakfast Recap • Preparing and Incorporating Scalable Vector Graphics into Your ColdFusion Application • Next Meeting • Questions/Answers/Help Needed

  3. Introductions • Tell us a little bit about who you are • Share with us what you would like to get from this user group

  4. Goals • Assist ColdFusion Developers Throughout the Pacific Northwest • Promote ColdFusion Developers Throughout the Pacific Northwest • Connect Employers with ColdFusion Developers • Establish a Community of Friendship Between ColdFusion Developers • Provide Speaking Opportunities for ColdFusion Developers • Change the Perception of ColdFusion as a viable platform

  5. CF Summit 2019 • September 30 – October 2, 2019 at the Mirage Resort and Casino, Las Vegas • Early-Bird Registration of $99.00 • Adobe ColdFusion Specialist Certification Program/Test on September 30th: https://cfsummit.adobeevents.com/adobe-coldfusion-specialist/ • Now available for registration at https://cfsummit.adobeevents.com

  6. Integrating Twilio for Conversion Tracking with Your CF Web App This presentation will cover: • What is Twilio & why would I use it? • The Use Case • Getting Started with Twilio • Importing Data from Twilio using ColdFusion and SQL Server • Downloading data as a CSV file from Twilio using ColdFusion • Leveraging ColdFusion to generate spreadsheet and data-grid-based Twilio Conversion Reports

  7. Integrating Twilio for Conversion Tracking with Your CF Web App What is Twilio & Why Would I Use It? Twilio is a communications company that offers a variety of services for companies. It makes it super simple to integrate communications capabilities into your ColdFusion Application.All Twilio Solutions: https://www.twilio.com/solutions

  8. Integrating Twilio for Conversion Tracking with Your CF Web App The Use Case Customer is marketing on multiple online platforms, including Bing Places, Google My Business, Facebook, Instagram and MailChimp. The customer would like to track the effectiveness of marketing on each platform by tracking phone calls from each platform

  9. Integrating Twilio for Conversion Tracking with Your CF Web App Getting Started • Create an Account with Twilio at https://www.twilio.com/try-twilio • Get a free phone number (normally $1.00/month), plus per call fees. Trial account includes $15.00 credit • Configure the phone number to do something:https://www.twilio.com/labs

  10. Integrating Twilio for Conversion Tracking with Your CF Web App Getting Started • Download the TwilioConversionTracking.zip file from https://www.seattlecfug.org/demos/twilioConversionTracking/ • Extract the TwilioConversionTracking.zip file. Copy the contents of the code folder to the root folder of your application (site)

  11. Integrating Twilio for Conversion Tracking with Your CF Web App Getting Started • Access your Twilio Account SID and Auth Token • Live credentials available from Dashboard • Test credentials available from Settings > General (only able to test making a call, getting a new phone number or sending a text message) • Update the settings.cfm file to display the proper: • ColdFusion Data Source (DSN) info • Mail server info • Twilio SID and Auth Token

  12. Integrating Twilio for Conversion Tracking with Your CF Web App Getting Started • Execute the CreateTwilioObjects.sqlscript in SQL Server Management Studio to create the necessary tables, stored procedures and user-defined functions • Create a login that has permissions to truncate tables and write data. Alternatively, you can use the WITH EXECUTE as OWNER command to provide permissions to execute a stored procedure that could truncate tables.more info: https://dba.stackexchange.com/questions/52828/what-permissions-are-necessary-for-truncating-a-table

  13. Integrating Twilio for Conversion Tracking with Your CF Web App Getting Started • Make sure that you assign Execute permissions for all of the new Twilio Stored Procedures and Scalar Functions to the Logins that will need to execute.Tip: you could create a database role that could be assigned to your logins that would have execute permissions on the new stored procedures/functions

  14. Integrating Twilio for Conversion Tracking with Your CF Web App Importing Data from Twilio using ColdFusion and SQL Server • Open code/scheduledTasks/dailyTwilioImport.cfm • Make a CFHTTP GET Request to the Twilio API for Calls<cfhttpurl="https://api.twilio.com/2010-04-01/Accounts/AccountSID/Calls.csv?PageSize=1000" username=“AccountSID" password=“AuthToken" name="VARIABLES.Twilio">note: maximum number of records/request is 1000

  15. Integrating Twilio for Conversion Tracking with Your CF Web App Importing Data from Twilio using ColdFusion and SQL Server • Import Twilio data to a RawTwilio table first. This will allow you to: • Format the dates to be SQL compatible • Avoid importing duplicate records • Loop over the records in the RawTwilio table and import them to the RawTwilio table

  16. Integrating Twilio for Conversion Tracking with Your CF Web App Importing Data from Twilio using ColdFusion and SQL Server • Execute the importTwilioData stored procedure to process and import Twilio data to the Twilio table • Send a message to announce that the daily import was performed successfully.

  17. Integrating Twilio for Conversion Tracking with Your CF Web App Downloading data as a CSV file from Twilio using ColdFusion • Open code/scheduledTasks/dailyTwilioFileDownload.cfm • Set 2 variables: one for the CSV file name and one for the path to store the CSV file in a CFSCRIPT block: • VARIABLES.thisFile = 'Calls' & DateFormat(Now(),'mmddyyyy') & '.csv’ • VARIABLES.filePath = 'absolute path to the folder that will store downloaded Twilio files - example: D:\home\seattlecfug.org\TwilioFiles\';

  18. Integrating Twilio for Conversion Tracking with Your CF Web App Downloading data as a CSV file from Twilio using ColdFusion • Make a CFHTTP GET Request to the Twilio API for Calls. This will save the CSV file to the path you specified.<cfhttpurl="https://api.twilio.com/2010-04-01/Accounts/AccountSID/Calls.csv?PageSize=1000" username=“AccountSID" password=“AuthToken" file="#VARIABLES.thisFile#" path="#VARIABLES.filePath#">

  19. Integrating Twilio for Conversion Tracking with Your CF Web App Downloading data as a CSV file from Twilio using ColdFusion • Send a message to announce that the daily CSV file download was performed successfully.

  20. Integrating Twilio for Conversion Tracking with Your CF Web App Generating Reports/Spreadsheets from Twilio Data Now that we have Twilio data, we need to add intelligence to it. This can be done by mapping Twilio phone numbers to what is being tracked

  21. Integrating Twilio for Conversion Tracking with Your CF Web App Generating Reports/Spreadsheets from Twilio Data SQL Server tables: • TrackingType: includes all of the various types of marketing resources being tracked. Examples include: • Google My Business • Facebook • Number used in print materials and on vehicles

  22. Integrating Twilio for Conversion Tracking with Your CF Web App Generating Reports/Spreadsheets from Twilio Data SQL Server tables: • TrackingLocation: includes all of the locations being tracked. • Tracking: maps Twilio phone numbers to locations and tracking types. Joined with the Twilio table for generating Metrics.

  23. Integrating Twilio for Conversion Tracking with Your CF Web App Generating Reports/Spreadsheets from Twilio Data Appliance Master demo of Twilio reports.

  24. Preparing and Incorporating Scalable Vector Graphics into Your ColdFusion Application What are scalable vector graphics (SVG)?XML-based vector image format for two-dimensional graphics with support for interactivity and animation. The SVG specification is an open standard developed by the World Wide Web Consortium (W3C) since 1999. What can I use scalable vector graphics for? Logos, maps, other 2D artwork where the image needs to be crisp at all resolutions

  25. Preparing and Incorporating Scalable Vector Graphics into Your ColdFusion Application How do I create scalable vector graphics? Any vector art-based program like Adobe Illustrator or Corel Draw. Ideally, the source image was created and saved in an AI or EPS format. How can I get scalable vector graphics? The Noun Project - https://thenounproject.com: $39.95

  26. Preparing and Incorporating Scalable Vector Graphics into Your ColdFusion Application How can I get pre-done scalable vector graphics? The Noun Project - https://thenounproject.com • Over a million SVG icons. Completely searchable • Can colorize the icons to the exact color you need prior to download • $39.95 annually for Noun Pro – can use icons without attribution and get access to apps that integrate with many popular programs – PhotoShop, Illustrator… • API for developers

  27. Next Month’s Meeting May 15, 2019 – 5:00 PM PDT (online only via Zoom)Presentation by Charlie Arehart on the FusionReactor application performance monitor. Zoom link: https://zoom.us/j/588358063more info: https://www.fusion-reactor.com/

  28. Questions/Answers/Help!

More Related