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.
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 PlatformTab delimited files are standard text fields with one record per line, with columns separated by a tab.
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 Length||Allows Nulls|
|click_id||String||50255||Unique click ID defined by Vibes.|
|person_id||String||255||✔︎||Unique Vibes-specified GUID representing the Person.|
|external_person_id||String||40255||✔︎||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.|
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.|