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

Cafe24 Analytics is a schema-flexible source. The fields below are the standard fields Adriel exposes; the exact fields you can report on depend on your Cafe24 Analytics data. Data type uses Adriel’s vocabulary; API Key in code style is the literal source field; italic marks a value Adriel derives.

Cafe24 Analytics fields

Metric	Description	Data type	API Key
Adeffect Addetails: Ad	Advertising media name.	Text	`ad`
Adeffect Addetails: Keyword Name	Search keyword.	Text	`keyword`
Adeffect Addetails: Order Amount	Sales from each advertising media and keyword.	Number	`order_amount`
Adeffect Addetails: Order Amount Per Buyer	Average sales per purchase for each advertising media and keyword.	Number	`order_amount_per_buyer`
Adeffect Addetails: Order Amount Per Visitor	Average sales per visit for each advertising media and keyword.	Number	`order_amount_per_visitor`
Adeffect Addetails: Purchase Count	Purchases from each advertising media and keyword.	Number	`purchase_count`
Adeffect Addetails: Purchase Rate	Purchase rate for each advertising media and keyword.	Number	`purchase_rate`
Adeffect Addetails: Visit Count	Visits from each advertising media and keyword.	Number	`visit_count`
Adeffect Addetails: Visit Rate	Visit rate for each advertising media and keyword.	Number	`visit_rate`
Carts Action: Add Cart Count	Times the product was added to cart.	Number	`add_cart_count`
Carts Action: Add Cart Rate	Add-to-cart rate for the product.	Number	`add_cart_rate`
Carts Action: Count	Product views.	Number	`count`
Carts Action: Product Name	Product name.	Text	`product_name`
Carts Action: Product No	Product number.	Text	`product_no`
Datasource Name	The name of the connected data source.	Text	Adriel-side
Members Sales: Member Order Amount	Sales from signed-in customers.	Number	`member_order_amount`
Members Sales: Member Order Count	Purchases made by signed-in customers.	Number	`member_order_count`
Members Sales: Nonmember Order Amount	Sales from guest customers.	Number	`nonmember_order_amount`
Members Sales: Nonmember Order Count	Purchases made by guest customers.	Number	`nonmember_order_count`
Pages View: Count	Page views for each URL.	Number	`count`
Pages View: First Visit Count	First-time visits for each URL.	Number	`first_visit_count`
Pages View: URL	Page URL.	Text	`url`
Pages View: Visit Count	Visitors for each URL.	Number	`visit_count`
Products Categorydetails: Carts Count Per Category	Add-to-cart count for each category.	Number	`carts_count_per_category`
Products Categorydetails: Category Name	Category name.	Text	`category_name`
Products Categorydetails: Category No	Category number.	Text	`category_no`
Products Categorydetails: Product Code	Product code.	Text	`product_code`
Products Categorydetails: Product Name	Product name.	Text	`product_name`
Products Categorydetails: Product No	Product number.	Text	`product_no`
Products Categorydetails: Sales Count Per Category	Purchases for each category.	Number	`sales_count_per_category`
Products Categorydetails: Sales Item Per Category	Items sold for each category.	Number	`sales_item_per_category`
Products Categorydetails: Sales Price Per Category	Sales revenue for each category.	Number	`sales_price_per_category`
Products Sales: Order Amount	Sales for each product.	Number	`order_amount`
Products Sales: Order Count	Purchases for each product.	Number	`order_count`
Products Sales: Order Product Count	Items sold for each product.	Number	`order_product_count`
Products Sales: Product Name	Product name.	Text	`product_name`
Products Sales: Product No	Product number.	Text	`product_no`
Products View: Count	Product views.	Number	`count`
Products View: Product Name	Product name.	Text	`product_name`
Products View: Product No	Product number.	Text	`product_no`
Sales Paymethods: Buyers Count	Number of buyers for each payment method.	Number	`buyers_count`
Sales Paymethods: Order Amount	Sales for each payment method.	Number	`order_amount`
Sales Paymethods: Order Count	Purchases for each payment method.	Number	`order_count`
Sales Paymethods: Payment Method	Payment method code.	Text	`payment_method`
Sales Pervisitors: Order Amount Per Buyer	Average sales per buyer.	Number	`order_amount_per_buyer`
Sales Pervisitors: Order Amount Per Visitor	Average sales per visitor.	Number	`order_amount_per_visitor`
Sales Times: Buyers Count	Number of buyers for each hour.	Number	`buyers_count`
Sales Times: Hour	Hour of day.	Text	`hour`
Sales Times: Order Amount	Sales for each hour.	Number	`order_amount`
Sales Times: Order Count	Purchases for each hour.	Number	`order_count`
Unique Visitors: Date	Date.	Text	`date`
Unique Visitors: Unique Visit Count	Number of unique users on each date.	Number	`unique_visit_count`
Visitors Dailyactive: Date	Date.	Text	`date`
Visitors Dailyactive: User Count	Number of active users on each date.	Number	`user_count`
Visitors Pageview: Date	Date.	Text	`date`
Visitors Pageview: Hour	Hour of day.	Text	`hour`
Visitors Pageview: Page View	Page views for each date or hour.	Number	`page_view`
Visitors View: Date	Date.	Text	`date`
Visitors View: First Visit Count	First-time visitors for each date or hour.	Number	`first_visit_count`
Visitors View: Hour	Hour of day.	Text	`hour`
Visitors View: Re Visit Count	Returning visitors for each date or hour.	Number	`re_visit_count`
Visitors View: Visit Count	Visitors for each date or hour.	Number	`visit_count`
Visitpaths Adkeywordsales: Ad	Advertising media name.	Text	`ad`
Visitpaths Adkeywordsales: Keyword Name	Search keyword.	Text	`keyword`
Visitpaths Adkeywordsales: Order Amount	Sales attributed to each advertising media and keyword.	Number	`order_amount`
Visitpaths Adkeywordsales: Order Count	Purchases attributed to each advertising media and keyword.	Number	`order_count`
Visitpaths Ads: Ad	Advertising media name.	Text	`ad`
Visitpaths Ads: Visit Count	Visitors from each advertising media.	Number	`visit_count`
Visitpaths Adsales: Ad	Advertising media name.	Text	`ad`
Visitpaths Adsales: Order Amount	Sales attributed to each advertising media.	Number	`order_amount`
Visitpaths Adsales: Order Count	Purchases attributed to each advertising media.	Number	`order_count`
Visitpaths Domains: Domain	Referring domain.	Text	`domain`
Visitpaths Domains: Visit Count	Visitors from each referring domain.	Number	`visit_count`
Visitpaths Domainsales: Domain	Referring domain.	Text	`domain`
Visitpaths Domainsales: Order Amount	Sales attributed to each referring domain.	Number	`order_amount`
Visitpaths Domainsales: Order Count	Purchases attributed to each referring domain.	Number	`order_count`
Visitpaths Keyworddetails: Engine	Search engine.	Text	`engine`
Visitpaths Keyworddetails: Keyword Name	Search keyword.	Text	`keyword`
Visitpaths Keyworddetails: Order Amount	Sales from each search keyword.	Number	`order_amount`
Visitpaths Keyworddetails: Order Amount Per Buyer	Average sales per purchase for each search keyword.	Number	`order_amount_per_buyer`
Visitpaths Keyworddetails: Order Amount Per Visitor	Average sales per visit for each search keyword.	Number	`order_amount_per_visitor`
Visitpaths Keyworddetails: Purchase Count	Purchases from each search keyword.	Number	`purchase_count`
Visitpaths Keyworddetails: Purchase Rate	Purchase rate for each search keyword.	Number	`purchase_rate`
Visitpaths Keyworddetails: Visit Count	Visits from each search keyword.	Number	`visit_count`
Visitpaths Keywords: Keyword Name	Search keyword.	Text	`keyword`
Visitpaths Keywords: Visit Count	Visitors from each search keyword.	Number	`visit_count`
Visitpaths Keywordsales: Keyword Name	Search keyword.	Text	`keyword`
Visitpaths Keywordsales: Order Amount	Sales attributed to each search keyword.	Number	`order_amount`
Visitpaths Keywordsales: Order Count	Purchases attributed to each search keyword.	Number	`order_count`
Visitpaths Urls: URL	Visited URL.	Text	`url`
Visitpaths Urls: Visit Count	Visitors for each URL.	Number	`visit_count`

Date Calculation

Metric	Description	Data type	API Key
Number Of Days In Current Month	The total number of days in the current calendar month.	Number	Adriel-side
Number Of Days Per Row	The number of days each row of the source represents.	Number	Adriel-side
Remaining Days	The number of days remaining in the selected period.	Number	Adriel-side
Total Duration In Days	The total number of days covered by the selected date range.	Number	Adriel-side

Breakdowns

Cafe24 Analytics fields

Breakdown	Description	API Key
Adeffect Addetails	Breaks down ad-effect performance by advertising media and keyword.	`ad`, `keyword`
Carts Action	Breaks down cart activity by product.	`product_name`, `product_no`
Members Sales	Breaks down sales between signed-in customers and guest customers.	Adriel-side
Pages View	Breaks down page traffic by URL.	`url`
Products Categorydetails	Breaks down category performance by category.	`category_name`, `category_no`
Products Sales	Breaks down product sales by product.	`product_name`, `product_no`
Products View	Breaks down product views by product.	`product_name`, `product_no`
Sales Paymethods	Breaks down sales by payment method.	`payment_method`
Sales Pervisitors	Returns store-wide sales-per-visitor values.	Adriel-side
Sales Times	Breaks down sales by hour of day.	`hour`
Unique Visitors	Breaks down unique users by date.	`date`
Visitors Dailyactive	Breaks down daily active users by date.	`date`
Visitors Pageview	Breaks down page views by date or hour.	`date`, `hour`
Visitors View	Breaks down visitors by date or hour.	`date`, `hour`
Visitpaths Adkeywordsales	Breaks down attributed sales by advertising media and keyword.	`ad`, `keyword`
Visitpaths Ads	Breaks down visitors by advertising media.	`ad`
Visitpaths Adsales	Breaks down attributed sales by advertising media.	`ad`
Visitpaths Domains	Breaks down visitors by referring domain.	`domain`
Visitpaths Domainsales	Breaks down attributed sales by referring domain.	`domain`
Visitpaths Keyworddetails	Breaks down search keyword performance by keyword.	`keyword`
Visitpaths Keywords	Breaks down visitors by search keyword.	`keyword`
Visitpaths Keywordsales	Breaks down attributed sales by search keyword.	`keyword`
Visitpaths Urls	Breaks down visitors by URL.	`url`

General

Breakdown	Description	API Key
Datasource Name	Groups results by connected data source.	Adriel-side
No Grouping	Shows all results as a single combined group.	Adriel-side

Date

Breakdown	Description	API Key
Auto Time Breakdown	Automatically groups results by an appropriate time interval for the selected date range.	Adriel-side
Daily Breakdown	Groups results by calendar day.	Adriel-side
Monthly Breakdown	Groups results by calendar month.	Adriel-side
Quarterly Breakdown	Groups results by calendar quarter.	Adriel-side
Week Date Breakdown	Groups results by the date representing each reporting week.	Adriel-side
Week Number Breakdown (W#)	Groups results by week number in the year.	Adriel-side
Weekly Breakdown (Start: Mon)	Groups results by calendar week (Monday start).	Adriel-side
Weekly Breakdown (Start: Sun)	Groups results into weeks running from Sunday through Saturday.	Adriel-side
Yearly Breakdown	Groups results by calendar year.	Adriel-side

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

​Cafe24 Analytics fields

​Date Calculation

​Breakdowns

​Cafe24 Analytics fields

​General

​Date

​Limitations

​API references

​See also

Introduction

Data refresh strategy

Architecture data

Reports data

Architecture levels

Date range limits

Metrics

Cafe24 Analytics fields

Date Calculation

Breakdowns

Cafe24 Analytics fields

General

Date

Limitations

API references

See also