Click data export

The click data export delivers link-click events from messages sent through Sotto to your SFTP server. Each row represents a single click, enriched with the associated user and message context.

Sotto configures and runs this export internally on your behalf. To set one up, contact support@withsotto.com with your destination SFTP details, desired file format (CSV or JSON), and schedule.

File format

Property	Value
Format	CSV (comma-separated values)
Encoding	UTF-8
Delimiter	Comma (`,`)
Text qualifier	Double quotes (`"`) around field values
Header row	Included as the first row
Date format	ISO 8601 (`YYYY-MM-DDTHH:MM:SSZ`, UTC)
Null values	Represented as the string `null`

Columns

Columns are exported in the following order.

User fields

Column	Type	Description	Example
`user_id`	Integer	Sotto user identifier.	`24730`
`user_third_party_id`	String	Your external identifier for the user, or `null`.	`CUST-001`
`phone_number`	String	E.164 phone number.	`+15551234567`

Message fields

Column	Type	Description	Example
`message_log_id`	Integer	Sotto message identifier.	`17406`
`message_third_party_id`	String	External message identifier, or `null`.	`null`
`campaign_id`	Integer	Identifier of the campaign the message belongs to, or `null`.	`8821`
`message_body`	String	Full text of the SMS, including any shortened links.	`Check out your cart https://example.bgco.ai/a4glEZao`
`message_date_delivered`	DateTime	When the message was confirmed delivered to the carrier (UTC).	`2025-09-18T15:08:31Z`
`message_date_sent`	DateTime	When the message was sent from Sotto (UTC).	`2025-09-18T15:08:27Z`
`message_date_last_updated`	DateTime	When the message record was last modified (UTC).	`2025-09-18T15:08:30Z`

Click fields

Column	Type	Description	Example
`link`	String (URL)	Destination URL the user was redirected to.	`https://example.myshopify.com/cart/c/abc123`
`click_time`	DateTime	When the click occurred (UTC).	`2025-09-18T15:08:46Z`
`user_agent`	String	HTTP `User-Agent` from the click request.	`Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X)`
`click_date_last_updated`	DateTime	When the click record was last modified (UTC).	`2025-09-18T15:08:46Z`
`click_date_created`	DateTime	When the click record was created (UTC).	`2025-09-18T15:08:46Z`

Multiple rows per message

A single message can produce multiple click rows — for example, when a user clicks the same link more than once, or when a link-preview bot (Facebook, Twitter, etc.) fetches the URL in addition to the user. Each click is a separate row with its own click_time, user_agent, and timestamps.

To filter out bot traffic, inspect the user_agent field for known bot identifiers such as facebookexternalhit or Twitterbot.

Example

user_id,user_third_party_id,phone_number,message_log_id,message_third_party_id,campaign_id,message_body,message_date_delivered,message_date_sent,message_date_last_updated,link,click_time,user_agent,click_date_last_updated,click_date_created
"24730","CUST-001","+15551234567","17406","null","8821","Check out your cart https://example.bgco.ai/a4glEZao","2025-09-18T15:08:31Z","2025-09-18T15:08:27Z","2025-09-18T15:08:30Z","https://example.myshopify.com/cart/c/abc123","2025-09-18T15:08:46Z","Mozilla/5.0 (iPhone; CPU iPhone OS 18_6_2 like Mac OS X) AppleWebKit/605.1.15","2025-09-18T15:08:46Z","2025-09-18T15:08:46Z"

Data notes

Timestamps are ISO 8601 in UTC (YYYY-MM-DDTHH:MM:SSZ). Convert to your local timezone during processing as needed.
Null values are the literal string null, most commonly for user_third_party_id, message_third_party_id, and campaign_id when not set.
User agents are raw browser strings; use a parsing library to extract device, OS, and browser details.
Link URLs are the full destination after redirect and may include query parameters such as cart tokens; they can be long.

Get started

Webhooks

Bulk data

Reference

Click data export

File format

Columns

User fields

Message fields

Click fields

Multiple rows per message

Example

Data notes

​File format

​Columns

​User fields

​Message fields

​Click fields

​Multiple rows per message

​Example

​Data notes

File format

Columns

User fields

Message fields

Click fields

Multiple rows per message

Example

Data notes