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.- Create a Google spreadsheet.
-
Copy the following formula into the cell where you want to import the data. Replace
<project_id>with your project ID. - When prompted, click Allow access to let the sheet retrieve data from the external URL.
- 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
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.
