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

# Data reference

> Metrics, breakdowns, refresh cadence, and limits for the Targeting Gates data source in Adriel.

## Introduction

Targeting Gates (operated by WiderPlanet) is a Korean programmatic advertising platform. The connector ingests campaign performance through a per-day CSV export URL issued by the Targeting Gates portal, normalizes it, and serves the resulting data through a daily cache. Both Korean and English column names are recognized by the mapper, so widgets work regardless of which locale the source CSV is exported in.

As a marketing connector, metrics, breakdowns, and currencies are standardized so widgets can aggregate across sources without additional configuration.

To connect this data source, see [How to connect Targeting Gates to Adriel](/data-sources/o-z/targeting-gates/how-to-connect).

## Data refresh strategy

### Architecture data

Architecture is derived from each day's CSV export. Newly active campaigns, ad groups, and creatives appear in the cache after the next scheduled refresh.

### Reports data

Reports include daily performance metrics for advertiser accounts, campaigns, ad groups, and creatives.

**Cache-only.** This is a daily-cache connector. Dashboard queries read from cached daily snapshots rather than fetching live from Targeting Gates.

* **Initial fetch**: after connection, the last **180 days** of daily data are retrieved one day at a time.
* **Refresh schedule**: at **5:00 PM UTC** and **5:00 AM UTC**, the latest **30 days** of data are refreshed in place.

## Architecture levels

Advertiser account → Campaign → Ad group → Creative

## Date range limits

Time-grouping breakdowns cap the range that can be split at once. Data outside these ranges may be truncated.

| Breakdown | Max range |
| --------- | --------- |
| Daily     | 93 days   |
| Weekly    | 1 year    |

The Targeting Gates CSV endpoint typically exposes up to a **2-year** window. Days requested beyond that window return empty rows in the cache rather than raising a connector error.

## Metrics

<Note>
  **How to read the columns**

  **Data type** uses this vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean.

  **API Key** in code style like `노출(수)` is the literal Targeting Gates CSV column name. The mapper also recognizes the equivalent English column names. *Italic text* describes how a value is produced when it doesn't map to a single CSV column.
</Note>

### Delivery & clicks

| Metric      | Description                                                                                              | Data type  | API Key  |
| ----------- | -------------------------------------------------------------------------------------------------------- | ---------- | -------- |
| Impressions | Ad displays.                                                                                             | Number     | `노출(수)`  |
| Clicks      | Ad clicks.                                                                                               | Number     | `클릭(수)`  |
| CTR (%)     | Click-through rate as reported by the platform. Stored as text; define a calculated metric to aggregate. | Percentage | `CTR(%)` |
| ECPM        | Effective cost per thousand impressions as reported by the platform.                                     | Currency   | `ECPM`   |

### Cost & budget

| Metric           | Description                         | Data type | API Key                                |
| ---------------- | ----------------------------------- | --------- | -------------------------------------- |
| Spend            | Reported spend in account currency. | Currency  | `광고비`                                  |
| Conversion cost  | Reported cost per conversion.       | Currency  | `전환 비용`                                |
| Daily budget     | Configured daily budget.            | Currency  | *Adriel-provided (no platform column)* |
| Remaining budget | Remaining budget.                   | Currency  | *Adriel-provided (no platform column)* |

### Conversions & revenue

| Metric              | Description                                                                                                                     | Data type  | API Key        |
| ------------------- | ------------------------------------------------------------------------------------------------------------------------------- | ---------- | -------------- |
| Conversions         | Attributed conversions.                                                                                                         | Number     | `전환(수)`        |
| Revenue             | Reported revenue from conversions.                                                                                              | Currency   | `매출`           |
| Conversion item sum | Total items across attributed conversions.                                                                                      | Number     | `전환 아이템합`      |
| Conversion rate (%) | Conversion rate as reported by the platform. Stored as text; define a calculated metric to aggregate.                           | Percentage | `전환율(%)`       |
| ROAS (%)            | Return on ad spend as reported by the platform. Stored as text; define a calculated metric to aggregate.                        | Percentage | `ROAS(%)`      |
| Post-view ROAS (%)  | Return on ad spend from post-view (impression-attributed) conversions. Stored as text; define a calculated metric to aggregate. | Percentage | `노출 후 ROAS(%)` |

### Indirect (post-view) conversions

| Metric                       | Description                                                                                            | Data type  | API Key         |
| ---------------------------- | ------------------------------------------------------------------------------------------------------ | ---------- | --------------- |
| Indirect conversions         | Conversions attributed indirectly (post-view).                                                         | Number     | `간접 전환(수)`      |
| Indirect conversion revenue  | Revenue from indirect conversions.                                                                     | Currency   | `간접 전환 매출`      |
| Indirect conversion item sum | Total items across indirect conversions.                                                               | Number     | `간접 전환 아이템합`    |
| Indirect conversion ROAS (%) | Return on ad spend from indirect conversions. Stored as text; define a calculated metric to aggregate. | Percentage | `간접 전환 ROAS(%)` |

### Campaign & creative metadata

| Metric              | Description                                     | Data type | API Key                                |
| ------------------- | ----------------------------------------------- | --------- | -------------------------------------- |
| Date                | Reporting date.                                 | Date      | `날짜`                                   |
| Advertiser ID       | Targeting Gates advertiser identifier.          | Text      | `광고주 ID`                               |
| Advertiser login ID | Advertiser login identifier.                    | Text      | `광고주 로그인 ID`                           |
| Advertiser name     | Advertiser name.                                | Text      | `광고주명`                                 |
| Campaign ID         | Campaign identifier.                            | Text      | `캠페인 ID`                               |
| Campaign name       | Campaign name.                                  | Text      | `캠페인명`                                 |
| Campaign start time | Campaign start timestamp.                       | Date      | `캠페인 시작 시각`                            |
| Campaign end time   | Campaign end timestamp.                         | Date      | `캠페인 종료 시각`                            |
| Creative ID         | Creative identifier.                            | Text      | `소재 ID`                                |
| Creative size       | Physical size of the creative (width × height). | Text      | `소재 사이즈`                               |
| Creative URL        | Creative asset URL.                             | URL       | *Adriel-provided (no platform column)* |
| Device              | Device on which the ad was served.              | Text      | `디바이스`                                 |

### Date calculations

<Note>
  These helper metrics are computed by Adriel from the selected date range, not returned by Targeting Gates.
</Note>

| Metric                 | Description                           | Data type | API Key           |
| ---------------------- | ------------------------------------- | --------- | ----------------- |
| Number of days per row | Number of days covered by each row.   | Number    | *Adriel-provided* |
| Remaining days         | Days remaining in the selected range. | Number    | *Adriel-provided* |
| Datasource name        | Name of the Adriel data source.       | Text      | *Adriel-provided* |

## Breakdowns

### Standard hierarchy

| Breakdown          | Description          | API Key     |
| ------------------ | -------------------- | ----------- |
| Advertiser account | Group by advertiser. | `adAccount` |
| Campaign           | Group by campaign.   | `campaign`  |
| Ad group           | Group by ad group.   | `adSet`     |
| Creative           | Group by creative.   | `ad`        |

### Campaign & creative attributes

| Breakdown           | Description                                             | API Key      |
| ------------------- | ------------------------------------------------------- | ------------ |
| Advertiser ID       | Group by advertiser identifier.                         | `광고주 ID`     |
| Advertiser login ID | Group by advertiser login identifier.                   | `광고주 로그인 ID` |
| Advertiser name     | Group by advertiser name.                               | `광고주명`       |
| Campaign ID         | Group by campaign identifier.                           | `캠페인 ID`     |
| Campaign start time | Group by campaign start timestamp.                      | `캠페인 시작 시각`  |
| Campaign end time   | Group by campaign end timestamp.                        | `캠페인 종료 시각`  |
| Creative ID         | Group by creative identifier.                           | `소재 ID`      |
| Creative size       | Group by the creative's physical size (width × height). | `소재 사이즈`     |
| Device              | Group by device on which the ad was served.             | `디바이스`       |
| Date                | Group by reporting date.                                | `날짜`         |

### Time & date grouping

<Note>
  Targeting Gates returns daily records; Adriel groups them into these views for reporting, so all time-grouping breakdowns are Adriel-side aggregations of the same underlying daily data.
</Note>

| Breakdown           | Description                                                  |
| ------------------- | ------------------------------------------------------------ |
| Auto Time Breakdown | Automatically picks the best granularity for the date range. |
| Daily               | Split reports by day.                                        |
| Weekly (Start: Mon) | Split reports by ISO week, starting Monday.                  |
| Monthly             | Split reports by calendar month.                             |
| Quarterly           | Split reports by calendar quarter.                           |
| Yearly              | Split reports by calendar year.                              |
| No Grouping         | Return a single aggregated row.                              |

## Limitations

* **Pre-computed percentages are text** — ratio fields returned by Targeting Gates (CTR, conversion rate, ROAS, post-view ROAS, and indirect ROAS) are stored as strings and are not aggregated automatically. Widgets that need a rolled-up ratio should define a calculated metric over the underlying counts, spend, and revenue.
* **One day per fetch** — the CSV endpoint is queried one day at a time. Long historical windows are walked sequentially during the initial fetch and on each scheduled refresh.
* **CSV export size** — the endpoint can truncate very large exports. If a single day spans an unusually large number of rows, some rows may not reach the cache.
* **2-year data availability** — data is available for up to 2 years from the current date. Historical data beyond this period may not be accessible through the CSV export.
* **Platform-side prerequisites** — the Adriel platform IPs must be whitelisted and API access must be enabled in the Targeting Gates account. If either is missing, the connector reports an error and auto-disconnects the data source; correct the platform setting and reconnect.

## See also

* [How to connect Targeting Gates to Adriel](/data-sources/o-z/targeting-gates/how-to-connect) (paired how-to)
* [Naver Search Ads data reference](/data-sources/g-n/naver-search-ads/data-reference) — for another Korean-market paid advertising connector