Data reference - Adriel Knowledge Base

Introduction

Cafe24 is a Korean e-commerce platform that helps merchants run their direct-to-consumer storefronts. Cafe24 Analytics is the analytics surface of that platform — the pre-aggregated session, sales, product, ad-effect, and visit-path numbers that mall owners see inside Cafe24’s own analytics dashboard. This connector reads from the Cafe24 Data API (cafe24data.com), not the commerce Admin REST API. The data it returns is the same set of pre-aggregated reports Cafe24 ships in the merchant console: visitor sessions, page views, traffic sources, daily active visitors, product views and sales, cart actions, payment methods, sales-per-visitor analyses, and visit-path attribution. Many teams pair it with the Cafe24 commerce connector, which surfaces raw orders and products. As an analytics connector, session, event, and breakdown data are standardized so widgets can aggregate alongside ad-platform sources without additional configuration. To connect this data source, see How to connect Cafe24 Analytics to Adriel.

Data refresh strategy

Architecture data

Mall discovery and shop metadata are fetched at connection time and refreshed alongside the OAuth token. The Cafe24 Analytics endpoint catalog itself is registered statically in the connector (23 report endpoints plus six computed metrics) and does not change without a connector update.

Reports data

Cafe24 Analytics is a daily-cache connector backed by a JSON daily cache:

Initial fetch: when the data source is created, the last 90 days of daily data are loaded into the cache.
Daily refresh: the cache is refreshed twice daily, at 02:00 UTC and 14:00 UTC. Each cycle re-syncs the most recent 3 days of data.
History window: data older than the 90-day initial backfill is not available from cache.

Worker concurrency is forced to one at both job and group levels, and outgoing requests are rate-limited to one request per 500 ms per asset to stay within Cafe24’s quotas. Future-dated rows are clamped at fetch time.

Architecture levels

Mall (mall_id) → Shop / User (user_id) → Report endpoint → Row Each Cafe24 Data API report endpoint is a separate reporting surface; a single query targets one endpoint and returns its rows for the selected date range.

Date range limits

Breakdown	Max range per query
Daily	60 days
Weekly	12 weeks
Monthly	12 months

These caps are enforced per query and depend on the selected time breakdown. Longer historical pulls must be split into multiple queries, and data older than the 90-day initial backfill is not retained in cache.

Metrics

How to read the columnsCode style like visitors_unique__unique_visit_count is the connector’s field key, following the endpoint__field pattern where the endpoint is the report family and the field is the column. Italic text marks a value computed by Adriel (a derived metric) rather than returned directly by the Cafe24 Data API.Data type vocabulary: Number, Currency, Percentage, Ratio, Duration, Date, Text, URL, Array, Boolean. Currency values are reported in the mall’s settlement currency (KRW for most Cafe24 malls).

Users & sessions

Metric	Description	Data type	API Key
Daily active users	Distinct active visitors per day.	Number	`visitors_dailyactive__user_count`
Unique visitors	Distinct visitor count.	Number	`visitors_unique__unique_visit_count`
Visit count	Total visits (sessions).	Number	`visitors_view__visit_count`
First-visit count	Visits from first-time visitors.	Number	`visitors_view__first_visit_count`
Returning-visit count	Visits from returning visitors.	Number	`visitors_view__re_visit_count`

Engagement

Metric	Description	Data type	API Key
Page views	Total page views across the storefront.	Number	`visitors_pageview__page_view`
Add-to-cart count	Number of add-to-cart actions.	Number	`carts_action__add_cart_count`
Add-to-cart rate	Share of cart interactions that resulted in an add-to-cart.	Percentage	`carts_action__add_cart_rate`
Cart action count	Total cart events (add, remove, abandon).	Number	`carts_action__count`

Traffic acquisition

Metric	Description	Data type	API Key
Visits by referring domain	Visits attributed to each referring domain.	Number	`visitpaths_domains__visit_count`
Visits by keyword	Visits attributed to each search keyword.	Number	`visitpaths_keywords__visit_count`
Visits by ad referrer	Visits attributed to each ad referrer.	Number	`visitpaths_ads__visit_count`
Visits by referrer URL	Visits attributed to each referrer URL.	Number	`visitpaths_urls__visit_count`
Keyword visit count	Visits attributed to a keyword (keyword-detail report).	Number	`visitpaths_keyworddetails__visit_count`
Ad-effect visit count	Visits attributed to an ad reference (ad-effect report).	Number	`adeffect_addetails__visit_count`
Ad-effect visit rate	Share of visits attributed to an ad reference.	Percentage	`adeffect_addetails__visit_rate`

Events & conversions

Metric	Description	Data type	API Key
Keyword purchase count	Purchases attributed to a keyword.	Number	`visitpaths_keyworddetails__purchase_count`
Keyword purchase rate	Share of keyword visits that resulted in a purchase.	Percentage	`visitpaths_keyworddetails__purchase_rate`
Ad-effect purchase count	Purchases attributed to an ad reference.	Number	`adeffect_addetails__purchase_count`
Ad-effect purchase rate	Share of ad-referred visits that resulted in a purchase.	Percentage	`adeffect_addetails__purchase_rate`

Ecommerce

Metric	Description	Data type	API Key
Product order amount	Revenue by product.	Currency	`products_sales__order_amount`
Product order count	Order count by product.	Number	`products_sales__order_count`
Product ordered-item count	Units ordered by product.	Number	`products_sales__order_product_count`
Category sales count	Order count by category.	Number	`products_categorydetails__sales_count_per_category`
Category sales item count	Units sold by category.	Number	`products_categorydetails__sales_item_per_category`
Category sales amount	Revenue by category.	Currency	`products_categorydetails__sales_price_per_category`
Category cart count	Add-to-cart actions by category.	Number	`products_categorydetails__carts_count_per_category`
Member order amount	Revenue from member customers.	Currency	`members_sales__member_order_amount`
Member order count	Orders from member customers.	Number	`members_sales__member_order_count`
Non-member order amount	Revenue from non-member customers.	Currency	`members_sales__nonmember_order_amount`
Non-member order count	Orders from non-member customers.	Number	`members_sales__nonmember_order_count`
Order amount by payment method	Revenue split by payment method.	Currency	`sales_paymethods__order_amount`
Order count by payment method	Order count split by payment method.	Number	`sales_paymethods__order_count`
Buyers by payment method	Distinct buyers split by payment method.	Number	`sales_paymethods__buyers_count`
Order amount per buyer	Revenue divided by distinct buyers.	Currency	sales_pervisitors__order_amount_per_buyer
Order amount per visitor	Revenue divided by visitors.	Currency	sales_pervisitors__order_amount_per_visitor
Sales by time — order amount	Revenue bucketed by hour of day.	Currency	`sales_times__order_amount`
Sales by time — order count	Order count bucketed by hour of day.	Number	`sales_times__order_count`
Sales by time — buyers	Distinct buyers bucketed by hour of day.	Number	`sales_times__buyers_count`
Domain order amount	Revenue attributed to referring domains.	Currency	`visitpaths_domainsales__order_amount`
Domain order count	Orders attributed to referring domains.	Number	`visitpaths_domainsales__order_count`
Ad order amount	Revenue attributed to ad referrers.	Currency	`visitpaths_adsales__order_amount`
Ad order count	Orders attributed to ad referrers.	Number	`visitpaths_adsales__order_count`
Ad-keyword order amount	Revenue attributed to paid-keyword referrers.	Currency	`visitpaths_adkeywordsales__order_amount`
Ad-keyword order count	Orders attributed to paid-keyword referrers.	Number	`visitpaths_adkeywordsales__order_count`
Keyword order amount	Revenue attributed to search keywords.	Currency	`visitpaths_keywordsales__order_amount`
Keyword order count	Orders attributed to search keywords.	Number	`visitpaths_keywordsales__order_count`
Keyword-detail order amount	Revenue attributed to a keyword (keyword-detail report).	Currency	`visitpaths_keyworddetails__order_amount`
Keyword order amount per buyer	Keyword revenue divided by distinct buyers.	Currency	visitpaths_keyworddetails__order_amount_per_buyer
Keyword order amount per visitor	Keyword revenue divided by visitors.	Currency	visitpaths_keyworddetails__order_amount_per_visitor
Ad-effect order amount	Revenue attributed to an ad reference.	Currency	`adeffect_addetails__order_amount`
Ad-effect order amount per buyer	Ad-effect revenue divided by distinct buyers.	Currency	adeffect_addetails__order_amount_per_buyer
Ad-effect order amount per visitor	Ad-effect revenue divided by visitors.	Currency	adeffect_addetails__order_amount_per_visitor

Pages & screens

Metric	Description	Data type	API Key
Page view count	View count by page URL.	Number	`pages_view__count`
Page visit count	Visits landing on a page.	Number	`pages_view__visit_count`
Page first-visit count	First-time visits landing on a page.	Number	`pages_view__first_visit_count`
Product detail views	Views of product detail pages.	Number	`products_view__count`

Breakdowns

How to read the columnsEach Cafe24 Analytics report endpoint exposes exactly one grouping column, so a widget selects one report breakdown at a time. Code style like products_sales is the connector’s endpoint breakdown key. Italic text marks a breakdown produced by Adriel rather than by the Cafe24 Data API.

Visitors

Breakdown	Description	API Key
Daily active visitors	Groups rows by day of active-visitor reporting.	`visitors_dailyactive`
Visitor page views	Groups rows by the page-view visitor report.	`visitors_pageview`
Unique visitors	Groups rows by the unique-visitor report.	`visitors_unique`
Visitor view	Groups rows by the visitor-view report.	`visitors_view`

Pages

Breakdown	Description	API Key
Page URL	Groups rows by page URL.	`pages_view`

Products

Breakdown	Description	API Key
Product view	Groups rows by product for detail-page views.	`products_view`
Product sales	Groups rows by product for sales.	`products_sales`
Category details	Groups rows by category.	`products_categorydetails`

Cart

Breakdown	Description	API Key
Cart action	Groups rows by product for cart events.	`carts_action`

Sales

Breakdown	Description	API Key
Member sales	Groups rows by member vs non-member.	`members_sales`
Sales per visitor	Groups rows for per-visitor and per-buyer revenue.	`sales_pervisitors`
Sales by time	Groups rows by hour of day.	`sales_times`
Sales by payment method	Groups rows by payment method.	`sales_paymethods`

Visit paths

Breakdown	Description	API Key
Referring domains	Groups rows by referring domain.	`visitpaths_domains`
Domain sales	Groups rows by referring domain for revenue.	`visitpaths_domainsales`
Keywords	Groups rows by search keyword.	`visitpaths_keywords`
Keyword details	Groups rows by keyword with visit and purchase detail.	`visitpaths_keyworddetails`
Keyword sales	Groups rows by keyword for revenue.	`visitpaths_keywordsales`
Ads	Groups rows by ad referrer.	`visitpaths_ads`
Ad sales	Groups rows by ad referrer for revenue.	`visitpaths_adsales`
Ad keyword sales	Groups rows by paid-keyword referrer for revenue.	`visitpaths_adkeywordsales`
Referrer URLs	Groups rows by referrer URL.	`visitpaths_urls`

Ad effect

Breakdown	Description	API Key
Ad-effect details	Groups rows by ad reference for effectiveness diagnostics.	`adeffect_addetails`

Time

Adriel groups Cafe24 Analytics’ daily-granularity results into these standard views for reporting alongside other connectors.

Breakdown	Description
Auto Time Breakdown	Automatically picks day, week, or month based on the requested date range.
Daily	Split reports by day. Date range capped at 60 days per query.
Weekly (Start: Mon)	Split reports by week, starting Monday. Date range capped at 12 weeks per query.
Monthly	Split reports by calendar month. Date range capped at 12 months per query.
Quarterly	Split reports by calendar quarter. Ranges that do not align with quarter boundaries still return the full quarter.
Yearly	Split reports by calendar year. Partial-year ranges still return the full calendar year.

General

These grouping options are provided by Adriel and apply across connectors.

Breakdown	Description
No grouping	Returns aggregate totals for the report scope.
Datasource name	Groups rows by the Adriel data source name.

Limitations

One breakdown per query. Each endpoint exposes exactly one grouping column. Widgets that combine more than one non-time breakdown are rejected with INVALID_DIMENSIONS_METRICS_COMBINATION. The reserved channel value is stripped internally before execution.
Metrics depend on the selected breakdown. Because each report family is a separate endpoint, the available metrics change with the chosen breakdown; metrics from one endpoint cannot be mixed with a different endpoint’s breakdown.
90-day history. Only the last 90 days are backfilled into cache at connection time; older data is not available.
Per-query date-range caps. Daily queries cap at 60 days, weekly at 12 weeks, and monthly at 12 months. Longer ranges must be split.
Throttled, serialized fetching. Requests are paced to one per 500 ms per asset and worker concurrency is forced to one, so large queries are paced rather than parallelized.
Pre-aggregated source. Values are Cafe24’s own pre-aggregated dashboard numbers and may differ from raw order-level figures surfaced by the Cafe24 commerce connector.

API references

Cafe24 Developers Center
Cafe24 OAuth 2.0 authentication
Cafe24 Data API (statistics reports) — host cafe24data.com / ca-api.cafe24data.com

​Introduction

​Data refresh strategy

​Architecture data

​Reports data

​Architecture levels

​Date range limits

​Metrics

​Users & sessions

​Engagement

​Traffic acquisition

​Events & conversions

​Ecommerce

​Pages & screens

​Breakdowns

​Visitors

​Pages

​Products

​Cart

​Sales

​Visit paths

​Ad effect

​Time

​General

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Users & sessions

Engagement

Traffic acquisition

Events & conversions

Ecommerce

Pages & screens

Breakdowns

Visitors

Pages

Products

Cart

Sales

Visit paths

Ad effect

Time

General

Limitations

API references

See also