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 37 Next »

Last Updated: Monday, November 18, 2019



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

urls_YYYY-MM-DD.txt

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

Description

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.

message_id

String

40✔︎

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: vbs.cm.
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

url_click_extract_samplefile.csv 

  • No labels