Data catalog

Every tool the dashboard can connect to through its own API, with the field names that come in (from API research, each with a status) and the dashboard metrics they feed.

DC1Tools

Each with its own official API

DC2Documented fields

616

Field names from API research, see Status per field

DC3Categories

Shop to hospitality

DC4Verified against docs

21%

11 of 52 tools verified against live docs; 32 from knowledge, 9 uncertain

DC5Browse the tools

Filter by category, verification or access. The search box also looks inside field names, entities and metrics.

52 of 52 tools

DC6Shopify: data that comes in

Select any card above to switch tool. 31 fields documented.

VerifiedWebshop platformAccess: App reviewOpen API docs

API: Admin GraphQL API + ShopifyQL + Bulk Operations
Authentication: OAuth 2.0 access token (X-Shopify-Access-Token), per shop
Access and approval: Custom app on own store needs no review; public app needs review. read_all_orders for orders older than 60 days; protected customer data level 1/2 for PII; read_reports for ShopifyQL.
Connection effort: MediumOAuth per shop and cost-based rate limits; read_all_orders and PII scopes need approval for public apps.

Derived dashboard metrics

Gross / net revenue
AOV
Refund rate
Cancellation rate
New vs returning
Repeat rate and LTV
Revenue by UTM source
Abandoned checkout rate
Sessions and conversion rate (ShopifyQL)

Feeds dashboard pages

/ecommerceE-commerce
/revenueRevenue
/retentionRetention
/paid-mediaPaid media

Fields (31)

Entity	Field	Unit	Meaning	Feeds metric	Status
Order	id, name, createdAt, processedAt	GID, string, DateTime	Order id, display number (#1001), creation and processing time	Time series, order count	Verified
Order	totalPriceSet	MoneyBag	Total before returns, incl. tax and shipping	Gross revenue	Verified
Order	currentTotalPriceSet	MoneyBag	Total after returns and refunds	Net revenue	Verified
Order	subtotalPriceSet / currentSubtotalPriceSet	MoneyBag	Line items after line discounts, before shipping and tax	Product revenue	Verified
Order	totalDiscountsSet / currentTotalDiscountsSet	MoneyBag	Total discount (current = after returns)	Discount amount, discount rate	Verified
Order	totalTaxSet / currentTotalTaxSet	MoneyBag	VAT / tax	Tax, ex-tax revenue	Verified
Order	totalShippingPriceSet	MoneyBag	Shipping charged	Shipping revenue	Verified
Order	totalRefundedSet	MoneyBag	Cumulative amount refunded	Refund amount, refund rate	Verified
Order	netPaymentSet	MoneyBag	Received minus refunded	Cash-basis net	Verified
Order	currencyCode, presentmentCurrencyCode	CurrencyCode	Shop currency and customer currency	Multi-currency normalisation	Verified
Order	sourceName	String (web, pos, shopify_draft_order, app name)	Channel the order was created in	Revenue per sales channel	Verified
Order	channelInformation { channelId, channelDefinition { handle, channelName } }	Object	Sales channel (Online Store, Shop, POS, Facebook & Instagram)	Revenue per channel	Verified
Order	customerJourneySummary { firstVisit, lastVisit, daysToConversion, momentsCount, ready }	Object	Attribution journey before purchase	First / last touch attribution	Verified
CustomerVisit	landingPage, referrerUrl, source, sourceType, occurredAt, referralCode	URL / string	Per visit in the journey	Landing page, referrer	Verified
CustomerVisit	utmParameters { source, medium, campaign, content, term }	Object	UTM tags of the visit	Revenue by UTM source / campaign	Verified
Order	cancelledAt, cancelReason	DateTime, enum	Cancellation	Cancellation rate	Verified
Order	displayFinancialStatus, displayFulfillmentStatus	enum	PAID, PENDING, PARTIALLY_REFUNDED, REFUNDED / UNFULFILLED, FULFILLED	Funnel, fulfilment rate	Verified
Order	test	Boolean	Test order flag	Filter out test data	Verified
Order	customer { id, numberOfOrders, amountSpent, createdAt }	Object	Customer (null for guest checkout)	New vs returning, LTV	Verified
Order	discountCodes, discountApplications	[String], connection	Codes used and discount applications	Discount usage per code	Verified
Order	shippingAddress { countryCode, provinceCode, city }	Object (PII-limited)	Destination	Revenue per country	Verified
LineItem	quantity, sku, title, originalUnitPriceSet, discountedUnitPriceSet, totalDiscountSet	int / MoneyBag	Line level price and quantity	Units per order, top products	Verified
LineItem	variant.inventoryItem.unitCost	Money	Cost per unit, only if the merchant filled it in	Gross margin	Uncertain
Refund	totalRefundedSet, createdAt, refundLineItems { quantity, subtotalSet, restockType }	MoneyBag / connection	Refund detail per line	Refund rate per product and month	Verified
OrderTransaction	kind, status, amountSet, gateway, processedAt	enum / MoneyBag	Payments (SALE, CAPTURE, REFUND)	Payment mix, fees	Verified
Customer	numberOfOrders, amountSpent, createdAt, lastOrder, tags	UnsignedInt64 / MoneyV2	Lifetime values	LTV, repeat rate	Verified
AbandonedCheckout	abandonedCheckoutUrl, lineItems, subtotalPriceSet, totalPriceSet, discountCodes, createdAt	object	Abandoned checkouts with contact details	Abandoned checkout rate, recovery	Verified
InventoryLevel	quantities(names: [available, on_hand])	Int	Stock per location	Stock-outs, days of cover	Verified
SubscriptionContract	status, lines, nextBillingDate, billingPolicy	object	Native subscriptions (Shopify Subscriptions apps only)	MRR, churn	Verified
ShopifyQL	FROM sales SHOW total_sales, net_sales, orders, average_order_value	table	Pre-aggregated analytics, same numbers as Shopify Analytics	Net sales, AOV	Verified
ShopifyQL	FROM sessions SHOW sessions, conversion_rate	table	Sessions and conversion (dataset names from knowledge)	Sessions, conversion rate	Uncertain

Notes and limitations

Orders default to the last 60 days unless read_all_orders is approved.
customerJourneySummary is only filled for Online Store orders; headless or server-side orders can return ready=false. Pass UTMs as cart attributes as a workaround.
Sessions, bounce and conversion are not per order; use ShopifyQL (read_reports) or the GA4 API.
GraphQL cost-based rate limit (max 1000 points per query); use Bulk Operations for volume and webhooks plus a reconciliation poll.
COGS only exists when the merchant fills in unitCost. Ad spend is not in Shopify.

DC7Unified data model

Where each normalised dashboard field comes from in every tool. A dash means the tool does not provide it.

Normalised orders, order lines and refunds across webshop platforms. Amounts as decimal plus currency; mark tax-inclusive amounts explicitly.

Normalised field	Shopify	Magento	WooCommerce	BigCommerce	Shopware 6	Squarespace	Wix
order_id	Order.id (GID), name	entity_id, increment_id	id, number	id	id, orderNumber	id, orderNumber	id, number
created_at	createdAt	created_at	date_created_gmt	date_created	orderDateTime	createdOn	purchasedDate / createdDate
gross (incl. tax)	totalPriceSet.shopMoney	grand_total (base_grand_total)	total	total_inc_tax	amountTotal	grandTotal	priceSummary.total
subtotal	subtotalPriceSet	subtotal	sum of line_items.subtotal	subtotal_ex_tax	positionPrice	subtotal	priceSummary.subtotal
discounts	totalDiscountsSet	discount_amount (abs)	discount_total	discount_amount + coupon_discount	order_line_item type=promotion	discountTotal	priceSummary.discount
tax	totalTaxSet	tax_amount	total_tax	total_tax	price.calculatedTaxes	taxTotal	priceSummary.tax
shipping	totalShippingPriceSet	shipping_amount	shipping_total	shipping_cost_ex_tax	shippingTotal	shippingTotal	priceSummary.shipping
refunds (total)	totalRefundedSet	total_refunded	sum of refunds[].total (negative)	refunded_amount	order_transaction refund state (uncertain)	refundedTotal	balanceSummary.refunded
net (after refunds)	currentTotalPriceSet	grand_total - total_refunded	total + sum(refunds.total)	total_inc_tax - refunded_amount	amountTotal - refund	grandTotal - refundedTotal	balanceSummary.paid - refunded
currency	currencyCode / presentmentCurrencyCode	order_currency_code / base_currency_code	currency	currency_code	currency.isoCode + currencyFactor	grandTotal.currency	currency
status	displayFinancialStatus, displayFulfillmentStatus	state, status	status	status_id	stateMachineState.technicalName	fulfillmentStatus, paymentState	status, paymentStatus
is_cancelled	cancelledAt != null	state = canceled	status in (cancelled, failed)	status_id = 5	state cancelled	fulfillmentStatus = CANCELED	status = CANCELED
customer_id	customer.id (null = guest)	customer_id (customer_is_guest)	customer_id (0 = guest)	customer_id (0 = guest)	orderCustomer.customerId	- (email)	buyerInfo.contactId
customer_email	email (PII-limited)	customer_email	billing.email	billing_address.email	orderCustomer.email	customerEmail	buyerInfo.email
channel	sourceName, channelInformation	store_id (store view)	created_via	channel_id, order_source	salesChannelId	channel	channelInfo.type
utm_source / medium / campaign	customerJourneySummary.lastVisit.utmParameters	- (GA4 or extension)	meta_data._wc_order_attribution_utm_*	-	campaignCode, affiliateCode (limited)	-	- (attributionSource only)
referrer	lastVisit.referrerUrl	-	_wc_order_attribution_referrer	-	-	-	-
landing_page	lastVisit.landingPage	-	_wc_order_attribution_session_entry	-	-	-	-
discount_codes	discountCodes	coupon_code	coupon_lines[].code	/orders/{id}/coupons	promotion line items payload	discountLines[].promoCode	via activities (uncertain)
shipping_country	shippingAddress.countryCode	shipping_assignments[].shipping.address.country_id	shipping.country	shipping addresses country_iso2	order_delivery.shippingOrderAddress.country	shippingAddress.countryCode	recipientInfo.address.country
line: sku	LineItem.sku	items[].sku	line_items[].sku	products[].sku	payload.productNumber	lineItems[].sku	physicalProperties.sku
line: qty	quantity	qty_ordered	quantity	quantity	quantity	quantity	quantity
line: unit price	originalUnitPriceSet	price	price	base_price	unitPrice	unitPricePaid	price / priceBeforeDiscounts
line: qty_refunded	refundLineItems.quantity	qty_refunded	refunds[].line_items[].quantity	refund items[]	limited	limited	refundQuantity
line: cogs	variant.inventoryItem.unitCost	base_cost	- (plugin)	cost_price_ex_tax	product.purchasePrices	-	-
abandoned checkout	abandonedCheckouts query	/carts/search (is_active)	- (plugin)	Abandoned Carts API / webhook	cart table / plugin	-	Abandoned Checkouts API
sessions / conversion	ShopifyQL sessions	GA4	GA4	GA4	GA4	GA4	Wix Analytics API / GA4
realtime push	ORDERS_CREATE etc.	Adobe I/O Events / observer	order.created / updated	store/order/created	app webhooks / flow	order.create	OrderApproved / OrderUpdated

Source: _plan/research (section Gemeenschappelijk datamodel) per category

DC8Which client uses which source

29 of 52 catalog tools are in use by at least one demo client. Stacks come from the client portfolio.

Tool	Category	Maison Velours	Atelier Linen Co.	Fleur de Sel Paris	Hôtel Lumière Paris
	Webshop platform	Connected	Not used	Not used	Not used
	Webshop platform	Not used	Connected	Not used	Not used
	Webshop platform	Not used	Not used	Connected	Not used
	Marketplace	Connected	Connected	Not used	Not used
	Marketplace	Not used	Not used	Connected	Not used
	Marketplace	Connected	Connected	Not used	Not used
	Marketplace	Not used	Connected	Not used	Not used
	Marketplace	Not used	Not used	Connected	Not used
	Email & SMS	Connected	Not used	Connected	Not used
	Email & SMS	Not used	Connected	Not used	Connected
	Email & SMS	Not used	Not used	Connected	Not used
	CRM & lead forms	Connected	Connected	Not used	Connected
	CRM & lead forms	Not used	Not used	Connected	Connected
	CRM & lead forms	Not used	Connected	Not used	Not used
	Advertising	Connected	Connected	Not used	Not used
	Advertising	Connected	Connected	Connected	Connected
	Advertising	Connected	Connected	Connected	Connected
	Advertising	Not used	Not used	Connected	Not used
	Advertising	Connected	Not used	Connected	Not used
	Analytics	Connected	Connected	Connected	Connected
	Affiliate & creators	Connected	Not used	Not used	Not used
	Affiliate & creators	Not used	Connected	Connected	Not used
	Affiliate & creators	Not used	Not used	Connected	Not used
	Subscriptions	Connected	Not used	Not used	Not used
	Reviews	Not used	Connected	Connected	Not used
	Reviews	Connected	Not used	Not used	Not used
	Payments	Not used	Connected	Connected	Connected
	Hospitality	Not used	Not used	Not used	Connected
	Hospitality	Not used	Not used	Not used	Connected
Sources per client		13	14	15	9

Source: src/lib/clients.ts CLIENTS (webshop, marketplaces, email, crm, affiliate, ads, other)

DC9Connection effort

A rough estimate per tool based on authentication, approval and rate limits.

Category	Effort	Access	Reason
Webshop platform	Medium	App review	OAuth per shop and cost-based rate limits; read_all_orders and PII scopes need approval for public apps.
Webshop platform	Medium	Open	No review, but auth and rate limits differ per installation and attribution must come from GA4.
Webshop platform	Easy	Open	Key and secret per site, no review; only hosting limits and missing sessions and abandoned carts need workarounds.
Webshop platform	Easy	Open	Simple API account with scopes; limits per plan and no attribution in the order.
Webshop platform	Medium	Open	Easy auth, but refunds and attribution are thin and field names must be checked per installation.
Webshop platform	Medium	Plan-gated	Plan requirement and a thin API without refund lines, UTM or sessions.
Webshop platform	Medium	Plan-gated	Rich order object, but premium plan and thin attribution and traffic data.
Marketplace	Hard	Role approval	Role approvals (Brand Analytics, PII), async reports, strict token buckets and a separate Ads auth.
Advertising	Hard	App review	Separate application and approval, profile-scoped tokens, async reports with 31-day windows.
Marketplace	Hard	App review	Request signing, app review, region-dependent endpoints and unclear analytics availability.
Marketplace	Easy	Open	Self-service client credentials; only async exports and a separate ads credential to handle.
Marketplace	Hard	Contract only	Contract-only access and no traffic, ads or financial data.
Marketplace	Medium	App review	OAuth with PKCE, commercial access for multiple shops and no traffic or ads data.
Marketplace	Medium	App review	Keyset and scopes are manageable, but daily limits and restricted Finances access need care.
Email & SMS	Medium	Open	Easy auth, but very tight reporting rate limits force a caching layer.
Email & SMS	Easy	Open	API key and simple REST; monthly growth only and revenue needs a connected store.
Email & SMS	Easy	Open	Single API key and a ready-made attribution endpoint.
Email & SMS	Medium	Open	Easy auth, but only 55 report calls per day, so everything must be cached.
Email & SMS	Hard	Partner approval	No reporting API: aggregation from webhooks or SFTP feeds, and revenue is not available.
Email & SMS	Hard	Open	Docs largely unreachable, endpoints and revenue fields unconfirmed.
CRM & lead forms	Medium	Plan-gated	Easy private app token, but attribution depends on plan and needs custom logic on properties.
CRM & lead forms	Easy	Open	Personal token and one endpoint; UTM depends on form setup.
CRM & lead forms	Easy	Open	Token auth and a small, clear data model.
CRM & lead forms	Easy	Open	API key and one endpoint; UTM needs hidden fields.
CRM & lead forms	Easy	Open	Key and secret per site, no review.
Advertising	Hard	App review	App review and business verification for client accounts, BUC rate limiting, versioned API and attribution quirks.
Advertising	Hard	App review	Developer token and access levels via an MCC, GAQL segment compatibility rules and two-query joins.
Advertising	Hard	App review	App review, per-event metric names that are partly unverified and per-level metric limits.
Advertising	Medium	App review	Trial-to-Standard access upgrade and default attribution that must be aligned.
Advertising	Hard	Partner approval	MDP approval, versioned headers with a sunset date and hard response limits.
Advertising	Medium	Open	Async reports and a developer token, but clear OAuth and no review.
Analytics	Easy	Open	Free, service account auth and a well-documented schema; only quotas and sampling to watch.
Analytics	Easy	Open	Free and a single endpoint; row limits and a 2 to 3 day delay.
Affiliate & creators	Easy	Open	Basic auth with account SID and token; real work is the partner-type mapping.
Affiliate & creators	Easy	Open	Personal API token; watch the 31-day window and 20 calls per minute.
Affiliate & creators	Medium	Open	GraphQL with 31-day windows and clicks in a separate product.
Affiliate & creators	Hard	Partner approval	Account-manager gated access and unverified status and new-customer fields.
Affiliate & creators	Easy	Open	Key and secret, but a small and partly unverified model.
Affiliate & creators	Easy	Open	Key pair and Shopify-native data.
Affiliate & creators	Hard	Partner approval	Account-manager access and a fully unverified field list.
Affiliate & creators	Hard	Plan-gated	Plan-gated API with unverified fields.
Affiliate & creators	Hard	Partner approval	Access on request and all fields unverified.
Subscriptions	Easy	Open	Single token and a small clean model; MRR is a simple derivation.
Reviews	Easy	Open	Key and secret; small data model.
Reviews	Easy	Open	Key based and a small model.
Reviews	Easy	Open	Public API key covers the read use case.
Payments	Easy	Open	Read-only key, stable and well-documented API.
Payments	Medium	Plan-gated	Feature must be enabled and the 31-day window forces chunked syncs.
Hospitality	Hard	Partner approval	Partner-gated access and unverified field names.
Hospitality	Hard	Partner approval	No open API: partner approval or manual exports.
Hospitality	Medium	Partner approval	Token per property and the partner programme for production integrations.
Hospitality	Medium	App review	OAuth app per integration; model is simple.