Send a unique URL links to email contacts

Hi @caitlinknoepp, welcome to the community!

The three ways I can think of is 1) Upload the URLs as a Custom Property to each of the email address or 2) Use the SFTP batch sync Profile data or 3) Use the API to do this programmatically.

Download and Upload List CSV

Assuming you just have a list of URLs in a CSV, and it doesn’t matter who gets which URL so long as they each get one URL from the CSV.  The easiest way is to do the following:

• Export your List of emails, open it up in an spreadsheet (Google Spreadsheet or Excel) and add a column and paste in the URLs so that you have two-columns, where the first column is an email address, and the second column is the URL. 
• Then simply upload this CSV back into the proper Klaviyo List, give the URL a Custom Property name like (“personal_URL”) and that should work. 
• Then in your email, reference that Custom Property in your template just like any other personalization tag.
  Example: {{ person|lookup:'personal_URL' }}

References:

• How to export a list or segment to a CSV file
• How to import profile properties using a CSV upload

SFTP to update Profiles

This is a bit more technical, but you can use the SFTP to batch upload the CSV with Email and URL.  Just pay attention to properly format the first row of the CSV to match the field names that you want as the Custom Property field name (e.g. “personal_URL”.)  This is just like the Import tool but a bit more systematic and if your List is extremely large.

Reference:

• Developers Portal: Use Klaviyo's SFTP import tool

Use the API to Update Profiles

This is the most technical, and it’s implementation is a bit out of the scope here because it depends on how you want to do it and in what programming language.  But you can update Profiles via the “Update Profile” endpoint.

Reference:

• Developers Portal: Update Profile

Most likely, the first solution is the easiest and most straight forward.  However, if you are doing this repetitively or you have a large List of profiles, you can use the other more developer centric method as well.  Hope this helps!

---

Joseph Hsieh // retentioncommerce.com // twitter: @retenion