> ## 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 Cafe24 Analytics data source in Adriel.

## 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-sources/a-f/cafe24-analytics/how-to-connect).

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

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

  Code 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).
</Note>

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

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

  Each 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.
</Note>

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

<Note>
  Adriel groups Cafe24 Analytics' daily-granularity results into these standard views for reporting alongside other connectors.
</Note>

| 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

<Note>
  These grouping options are provided by Adriel and apply across connectors.
</Note>

| 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](https://developers.cafe24.com/)
* [Cafe24 OAuth 2.0 authentication](https://developers.cafe24.com/docs/en/api/admin/#authentication)
* Cafe24 Data API (statistics reports) — host `cafe24data.com` / `ca-api.cafe24data.com`

## See also

* [How to connect Cafe24 Analytics](/data-sources/a-f/cafe24-analytics/how-to-connect) (paired how-to)
* [Cafe24 data reference](/data-sources/a-f/cafe24/data-reference) — the commerce connector, for raw orders, products, and customer data
* [Google Analytics 4 data reference](/data-sources/g-n/google-analytics-4/data-reference) — for a general-purpose web analytics companion