Exploring data

Explore turns the analytical model published by Enrich into current evidence, repeatable Analyses, and custom answers. It reads the organization's own Products, Variants, Listings, Offers, Reviews, Stores, and Changes.

Choose the right Explore surface

Use a packaged Analysis whenever it fits the question. Its metric, eligibility, coverage, and evidence rules are versioned. AI is the exploratory surface for other cuts of the data; it does not silently redefine an Analysis.

Browse the evidence layer

The Explore overview summarizes countries, taxonomy, brands, Stores, Variants, Listings, current Offers, availability, currencies, and the latest observation time. Facets return filter choices that actually exist in the organization's dataset. Facets are bounded suggestions rather than a pageable result.

Current markets group qualifying Offers by exact Variant, country, and currency. They show price range, availability, Store and seller coverage, and freshness. Relationship and Changes pages provide the path from a Product to its Variants, Listings, Offers, Reviews, and Store context.

A Variant page separates three concerns:

• canonical Product and Variant identity;
• current Offers, sellers, availability, and source URLs;
• observed Offer history with its actual timestamps.

In the public API, Variant metadata, current Offers, and history are separate resources so Offers and history can be paged independently. See the generated OpenAPI document for exact routes, filters, sort options, and response schemas.

Run packaged Analyses

Explore currently provides four Analyses through the dashboard, public API, and dashboard Agent.

Brand, category, and Store filters are available where they preserve the Analysis grain. Countries, currencies, conditions, Listings, and sellers are never combined silently.

Price position

For each exact Variant, each Store contributes its lowest current available Offer. The reference Store is compared with the conventional median of the other Stores. A Variant is comparable only when the reference Store and at least two comparison Stores have qualifying Offers.

The Analysis reports the reference price, competitor range and median, price deltas, rank, price index, comparable coverage, freshness, and the Offers used as evidence. It does not recommend a price or infer margin, demand, sales, market share, or MAP compliance.

Price movements

Movement is measured within one Listing, seller, condition, and currency series. The Analysis compares the two latest observations in the selected window and uses earlier history to keep newly observed series separate from ordinary one-observation gaps.

A missing later Offer is not a price decrease, and prices in different currencies are not comparable.

Availability changes

Availability keeps four situations distinct: explicitly available, explicitly unavailable, unknown, and no longer observed. Multiple simultaneous currencies do not create different availability series. At Store and Variant grain, a Store is available when any qualifying current Offer is available.

Listing removal remains explicit Listing evidence; it is not rewritten as an out-of-stock transition. Explore does not infer units on hand, lost sales, or continuous outage duration between observations.

Assortment overlap

Assortment is the set of distinct exact Variants connected to active Listings for each selected Store and country. Duplicate Listings and marketplace sellers do not increase membership. The result reports shared and Store-only sets, coverage from each side, and Jaccard similarity.

A Store-only Variant is an observed gap within the extracted scope. It is not proof of exhaustive catalog absence or a sales opportunity.

Read an Analysis result

Every Analysis response includes:

• a stable Analysis id and version;
• the normalized scope and generation time;
• eligible, limited, or ineligible status with issue codes;
• a summary, coverage, and oldest/newest evidence time;
• typed evidence rows and an opaque next_cursor when another API page exists.

eligible means the minimum evidence exists. limited means the result is valid but materially constrained by coverage or freshness. ineligible means the selected data cannot support the headline metric. An observed zero is not the same as missing evidence.

For pageable Analysis routes, summary, coverage, and freshness describe the whole selected Analysis scope; rows contains only the current evidence page. On unchanged data, later pages repeat the same scope-level values. Preserve the filters and sort, and pass next_cursor back unchanged. Pagination reads live data rather than freezing a transaction across requests.

Ask with Explore AI

Explore AI starts with the connected model rather than a table picker. Ask about products, markets, prices, availability, reviews, or assortment; Extralt loads the relevant entity definitions and relationships, generates SQL, runs it through the read-only organization-scoped service, and persists the question, SQL, result, and status at one dashboard URL.

The model defines active Listings, current Offers and Reviews, observed assortment, first-observed evidence, explicit removal, and availability. Query results contain at most 100 rows and are not pageable; a truncated result means the question or generated query should be narrowed. Explore AI is a dashboard surface, not a public v1 endpoint or direct ClickHouse connection.

Ask through the Agent

The dashboard Agent can run the same four packaged Analyses and link to their dedicated pages. It returns the complete status, issues, summary, coverage, and freshness plus a bounded evidence preview, and tells you when more evidence is available on the page.

For a custom question, the Agent uses the same Query model, persistence, and result page as Explore AI. See Using the dashboard Agent for operation and approval boundaries.

Interpretation boundaries

• Results describe the Stores, countries, URLs, and observation times the organization chose to collect, not the entire market.
• "Current" means the latest observation represented by the surface, not a continuously synchronized market snapshot.
• Matching depends on identifiers and product evidence available during Enrich; exact Variant comparisons do not imply perfect market coverage.
• Store means an organization-scoped hostname and country, not a retailer group or legal company.
• Explore does not contain sales, revenue, traffic, demand, margin, or market share unless a future data source and contract explicitly add them.

Saved or scheduled Analysis configurations, alerts, and dedicated Analysis file exports are not current capabilities. API evidence can be traversed with cursor pagination.

Continue with Query semantics for the definitions behind current state, time, availability, coverage, and freshness.