URL Click Extract

Last Updated: Wednesday, February 26, 2020

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.

File Name

urlsYYYY-MM-DD.txt

Tab Delimited Files

Tab delimited files are standard text fields with one record per line, with columns separated by a tab.

File Body

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

Field Name	Data Type	Field Length	Allows Nulls	Description
click_id	String	255		Unique click ID defined by Vibes.
person_id	String	255	✔︎	Unique Vibes-specified GUID representing the Person.
external_person_id	String	255	✔︎	The external_person_id associated with the Person.
mdn	String	20	✔︎	The Mobile Directory Number (MDN) associated with the Person. The Mobile Directory Number (MDN) must be in E.164 format. Example: +12295551234.
message_id	String	255	✔︎	Unique message ID defined by Vibes.
click_timestamp	Date/Time	N/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_domain	String	255		Domain that the shortened URL was created on. Example: vbs.cm.
short_key	String	20		URI of the shortened URL.
long_url	String	2048		Long URL that was shortened.
first_click	String	Boolean		Flag - if this was the first click.
first_device_click	String	Boolean		Flag - if this was the first click by the mobile device.
activity_type	String	255		Type of activity the message is associated with (Broadcast, Acquisition, and so on).
activity_id	String	255	✔︎	ID of the activity the message is associated with.
company_id	String	255	✔︎	ID of the company.

Example File