Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 36 Next »

Last Updated: Tuesday, August 28, 2018

The daily URL Click extract is used to sync URL click data between Vibes Mobile Engagement Platform and a Customer Relationship Management (CRM) or Campaign Management system. 

Note: If your extracts are not in the following format, it was a custom creation and you should reach out to your Customer Success representative for more information about your extract.

File Name


Tab Delimited Files

Extract files will have each column delimited by a tab, as well as each record delimited by a line feed.

Contents of Each File

Each row represents a click on a URL that was shortened by the Vibes Platform.

File Body

The file body can contain the following fields as data, separated by the delimiter and a header row.

Each row represents a click on a URL that was shortened by the Vibes Platform.

Field Name

Data Type

Field LengthAllows Nulls


click_idString50 Unique click ID defined by Vibes.
person_idString255✔︎Unique Vibes-specified GUID representing the Person.
external_person_idString40✔︎The external_person_id associated with the Person.
mdnString20✔︎The Mobile Directory Number (MDN) associated with the Person. The Mobile Directory Number (MDN) must be in E.164 format. Example: +12295551234.




Unique message ID defined by Vibes.

click_timestampDate/TimeN/A The Date/Time when the URL was clicked. Format example: "2017-04-05 14:30:00 -0600", represents April 5th, 2017 at 2:30PM UTC with a 6 hour offset.
short_domainString255 Domain that the shortened URL was created on. Example:
short_keyString20 URI of the shortened URL.
long_urlString2048 Long URL that was shortened.
first_clickStringBoolean Flag - if this was the first click.
first_device_clickStringBoolean Flag - if this was the first click by the mobile device.
activity_typeString255 Type of activity the message is associated with (Broadcast, Acquisition, and so on).
activity_idString255✔︎ID of the activity the message is associated with.
company_idString255✔︎ID of the company.

Example File


  • No labels