> ## Documentation Index
> Fetch the complete documentation index at: https://docs.notifly.tech/llms.txt
> Use this file to discover all available pages before exploring further.

# Share Link guide

> Import campaign and user journey statistics into Google Sheets with Share Link.

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](#important-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.

   ```
   =IMPORTDATA("https://api.notifly.tech/v1/projects/<project_id>/statistics.csv")
   ```

3. When prompted, click **Allow access** to let the sheet retrieve data from the external URL.

4. Use the [date range and tag parameters](#date-range-and-tag-parameters) to narrow the results.

## CSV fields

| Field | Example | Description | Notes |
| - | - | - | - |
| date | "22/10/2025" | Event date in Korea Standard Time (KST) | The CSV uses `DD/MM/YYYY`. If Google Sheets imports the value as text, check the spreadsheet locale before formatting the column as a date. |
| resource\_type | "campaign" | Resource type (`campaign` or `user_journey`) | |
| resource\_id | "cmp123" | Resource ID | |
| resource\_name | "Welcome message" | Resource name | |
| node\_id | "node12" | ID of the user journey message node | Blank for campaigns. |
| node\_name | "First message two days after signup" | Name of the user journey message node | Blank for campaigns. |
| variant\_id | "var123" | A/B test variant ID | Blank for campaigns without an A/B test. |
| variant\_name | "Group A" | A/B test variant name | Blank for campaigns without an A/B test. |
| channel | "push-notification" | Messaging channel | |
| channel\_subtype | "image" | Messaging channel subtype | |
| brand\_message\_target | "M" | Kakao Brand Message audience type | Blank for other channels. |
| tags | "프로모션" | Campaign tags | Multiple tags are comma-separated. Blank if the campaign has no tags. |
| message\_sent | 1200 | Successful sends | Successful sends for messaging channels. For app and web popups, this field counts impressions. |
| message\_failed | 10 | Failed sends | Number of sends that failed. The CSV uses `0` when this metric is unavailable. |
| delivered | 1150 | Reported deliveries | Counts reported deliveries for app push and email. A successful send can still fail to reach a device or inbox. The CSV uses `0` when this metric is unavailable. |
| click | 200 | Clicks | Counts app push and email clicks, clicks on the main popup button, and tracked link opens for supported Kakao channels. Share Link outputs `0` for channels without a click metric in this export, including text messaging. |
| conversion\_1\_name | "구매" | Conversion event name | Blank if the conversion event did not occur. |
| conversion\_1\_type | "직접 전환" | Conversion type. The CSV uses `전체 전환` (total conversions), `직접 전환` (direct conversions), or `전환 매출` (conversion revenue). | Blank if no conversion is reported for this slot. Direct conversions count qualifying events within the tracking window after a click. Total conversions also include qualifying events without a click. |
| conversion\_1\_count | 20 | Conversion event count (total revenue for conversion revenue) | Blank if the conversion event did not occur. |

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

### Date range and tag parameters

| Parameter | Description | Formula example | Example result at 12:00 KST on 2025-07-01 |
| - | - | - | - |
| `start` & `end` | Set a specific date range. | `=IMPORTDATA("https://api.notifly.tech/v1/projects/<project_id>/statistics.csv?start=2022-01-01&end=2022-03-01")` | 2022-01-01 to 2022-03-01 |
| `since` | Start on the specified date. | `=IMPORTDATA("https://api.notifly.tech/v1/projects/<project_id>/statistics.csv?since=2025-05-01")` | 2025-05-01 to 2025-06-30 |
| `last` | Query the last N periods. The default `timeUnit` is `day`. | `=IMPORTDATA("https://api.notifly.tech/v1/projects/<project_id>/statistics.csv?last=7")` | 2025-06-24 to 2025-06-30 |
| `timeUnit` | Set the unit to `day` (default), `week`, or `month`. Use it with `last` or `offset`. | `=IMPORTDATA("https://api.notifly.tech/v1/projects/<project_id>/statistics.csv?last=4&timeUnit=week")` | 2025-06-03 to 2025-06-30 |
| `offset` | Move the reference date back by N periods. Use it with `since` or `last`. It does not change an explicit `start` and `end`. | `=IMPORTDATA("https://api.notifly.tech/v1/projects/<project_id>/statistics.csv?last=4&timeUnit=week&offset=4")` | 2025-05-06 to 2025-06-02 |
| `tag` | Filter by tag. A campaign matches if it has at least one specified tag (OR). User journeys are excluded when tags are supplied. | `=IMPORTDATA("https://api.notifly.tech/v1/projects/<project_id>/statistics.csv?tag=프로모션&tag=공지")` | Campaigns tagged `프로모션`, `공지`, or both |

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

> [!WARNING]
>
> Use the `YYYY-MM-DD` format for dates in query parameters. Share Link rejects dates in a different format.

> [!NOTE]
>
> Share Link groups daily statistics by date in Korea Standard Time (KST, UTC+9).

> [!NOTE]
>
> Check the previous day's data after 7 a.m. KST.

> [!NOTE]
>
> Share Link excludes data for the current day.

> [!NOTE]
>
> 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.

> [!NOTE]
>
> 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](https://docs.notifly.tech/en/api-reference/get-campaign-statistics-csv.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.