Data reference - Adriel Knowledge Base

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 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

How to read the columnsData 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.

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

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

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

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.

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.

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​Delivery & clicks

​Cost & budget

​Conversions & revenue

​Indirect (post-view) conversions

​Campaign & creative metadata

​Date calculations

​Breakdowns

​Standard hierarchy

​Campaign & creative attributes

​Time & date grouping

​Limitations

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Delivery & clicks

Cost & budget

Conversions & revenue

Indirect (post-view) conversions

Campaign & creative metadata

Date calculations

Breakdowns

Standard hierarchy

Campaign & creative attributes

Time & date grouping

Limitations

See also