b2c-cip

name

b2c-cip

description

Run analytics reports and SQL queries against B2C Commerce Intelligence data using the b2c CLI. Use this skill whenever the user needs sales analytics, search query performance metrics, payment data, or KPI exports, OR technical/developer analytics such as SCAPI/OCAPI request volume, API error rates, response-time/latency distributions, cache hit ratios, or SFRA controller health. Also use when they need to discover available data tables, run custom SQL, or pull aggregate reports — even if they just say "show me sales data", "what are our top search terms", or "which SCAPI endpoints are slow or erroring".

B2C CIP Skill

Use b2c cip commands to query B2C Commerce Intelligence (CIP), also known as Commerce Cloud Analytics (CCAC).

Tip: If b2c is not installed globally, use npx @salesforce/b2c-cli.

Command Structure

cip
├── tables                        - list metadata catalog tables
├── describe <table>              - describe table columns
├── query                         - raw SQL execution
└── report                        - curated report topic
    ├── list                       - list the catalog grouped by category
    ├── Sales:      sales-analytics, sales-summary, revenue-by-channel
    ├── Technical:  ocapi-requests, ocapi-client-usage, scapi-traffic-latency,
    │               scapi-error-rate-by-status, scapi-latency-distribution,
    │               scapi-cache-hit-ratio, controller-health-scorecard,
    │               controller-error-rate-trend, remote-include-performance
    ├── Product:    top-selling-products, product-co-purchase-analysis, recommender-effectiveness
    ├── Promotion:  promotion-discount-analysis, promotion-roi-leaderboard, discount-depth-breakdown
    ├── Search:     search-query-performance, zero-result-searches
    ├── Customer:   customer-registration-trends, new-vs-returning-buyer-revenue
    ├── Payment:    payment-method-performance
    ├── Traffic:    top-referrers, checkout-funnel-dropoff, bot-traffic-share
    └── Inventory:  inventory-stockout-by-location