TRIFACTA Recipe for handling Facebook Form Ads Data

The recipe will perform the following:

  • Change phone number to integer
  • Remove – from phone number
  • Remove invalid code from phone number
  • Append 60 to phone number that has 9 digits (Malaysia phone number)
  • Append 6 to phone number that has 10 digits and start with 0
  • Split full name to first name and last name
  • Convert First Name and Last Name to proper case
  • Create a new column and put a constant value

Leave a Reply