Skip to main content
Use Share Link to bring campaign and user journey statistics into Google Sheets or other tools that read CSV files. Each event counts toward the date it happened.

Connect to Google Sheets

Before entering the formula, review the date and data availability notes. Open the product you want to connect. In the left sidebar, open Settings and select Product & Project. Copy Project ID from Project Info.
  1. Create a Google spreadsheet.
  2. Copy the following formula into the cell where you want to import the data. Replace <project_id> with your project ID.
  3. When prompted, click Allow access to let the sheet retrieve data from the external URL.
  4. Use the date range and tag parameters to narrow the results.

CSV fields

The CSV includes up to ten conversions in conversion_1 through conversion_10.

Date range and tag parameters

The default date range is seven days. To set a range, use start and end together, or use since or last. To query a single day, set start and end to the same date.

Important notes

Use the YYYY-MM-DD format for dates in query parameters. Share Link rejects dates in a different format.
Share Link groups daily statistics by date in Korea Standard Time (KST, UTC+9).
Check the previous day’s data after 7 a.m. KST.
Share Link excludes data for the current day.
Daily totals are based on when each event occurred. For example, if a campaign was sent on July 23 and a recipient clicked on July 24, Share Link counts the send on July 23 and the click on July 24.

Errors

Share Link returns the following message when the CSV exceeds its 2 MB limit. Shorten the date range or filter by tag, then try again.
File size exceeds 2MB limit. Please try a shorter date range or filter by specific campaigns/tags.

CSV download API

To download the CSV, open the Share Link URL from your Google Sheets formula. The same date and tag filters apply. See Export message statistics as CSV.