> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bily.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# List analytics datasets

> Lists the store-scoped datasets, required filters, available columns, and example SQL accepted by the query endpoint.



## OpenAPI

````yaml /openapi.json get /ad-metrics/{storeUrl}/query/catalog
openapi: 3.1.0
info:
  title: Bily API
  version: 1.0.0
  description: >-
    Discover stores, read analytics and commerce data, inspect connections, and
    run explicitly authorized actions with the Bily API.
  contact:
    name: Bily support
    email: support@bily.ai
servers:
  - url: https://app.bily.ai/api/customer/v1
    description: Production
security:
  - ApiKeyAuth: []
  - BearerAuth: []
tags:
  - name: Identity
    description: Discover the identity and organizations attached to a key.
  - name: Stores
    description: Discover stores within an organization.
  - name: Store data
    description: Read store profiles, readiness, catalogs, and connected accounts.
  - name: Commerce
    description: Run scoped commerce reads and explicitly approved GraphQL mutations.
  - name: Analytics
    description: >-
      Read normalized advertising, attribution, product, customer, and cohort
      metrics.
  - name: Analytics SQL
    description: Run constrained read-only SQL over store-scoped Bily datasets.
  - name: Customer journeys
    description: Read customer touchpoints within an authenticated store scope.
  - name: Connections
    description: Inspect available connections, support, and advertising assets.
  - name: Supported actions
    description: Synchronize connections and update supported advertising assets.
  - name: Campaign actions
    description: Create or clone supported advertising campaign resources.
  - name: Tracking connections
    description: >-
      List and manage store-scoped tracking connections without returning
      credential secrets.
paths:
  /ad-metrics/{storeUrl}/query/catalog:
    get:
      tags:
        - Analytics SQL
      summary: List analytics datasets
      description: >-
        Lists the store-scoped datasets, required filters, available columns,
        and example SQL accepted by the query endpoint.
      operationId: listAnalyticsDatasets
      parameters:
        - $ref: '#/components/parameters/StoreUrl'
        - $ref: '#/components/parameters/OrganizationId'
      responses:
        '200':
          description: Request completed successfully.
          headers:
            x-request-id:
              description: The request identifier selected or generated by Bily.
              schema:
                type: string
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/AnalyticsCatalogResponse'
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '403':
          $ref: '#/components/responses/Forbidden'
        '404':
          $ref: '#/components/responses/NotFound'
        '500':
          $ref: '#/components/responses/ServerError'
components:
  parameters:
    StoreUrl:
      name: storeUrl
      in: path
      required: true
      description: The exact store URL returned by GET /context or GET /stores.
      schema:
        type: string
        example: store.example.com
    OrganizationId:
      name: x-bily-organization-id
      in: header
      required: false
      description: >-
        An organization ID returned by GET /context or GET /organizations.
        Required for GET /stores and optional for store-scoped paths.
      schema:
        type: string
        example: org_01J8W7T9G3E6ZQ4M2K5N8P1R0S
  schemas:
    AnalyticsCatalogResponse:
      type: object
      required:
        - storeUrl
        - adAccountScope
        - datasets
      properties:
        storeUrl:
          type: string
        adAccountScope:
          type: integer
          minimum: 0
        datasets:
          type: array
          items:
            $ref: '#/components/schemas/AnalyticsCatalogEntry'
    AnalyticsCatalogEntry:
      type: object
      required:
        - id
        - title
        - description
        - requiredParams
        - optionalParams
        - columnHints
        - exampleSql
      properties:
        id:
          type: string
          enum:
            - ad_metrics
            - product_metrics
            - country_metrics
            - device_metrics
            - dimensions
            - customer_ltv
            - cohorts
            - platform_assets
            - data_quality
            - datasources_report
            - touchpoints
        title:
          type: string
        description:
          type: string
        requiredParams:
          type: array
          items:
            type: string
        optionalParams:
          type: array
          items:
            type: string
        columnHints:
          type: array
          items:
            type: string
        exampleSql:
          type: string
      additionalProperties: true
    Error:
      type: object
      required:
        - error
      properties:
        error:
          type: string
          example: Store not found
        requestId:
          type: string
          description: Present on some server errors.
        details:
          description: Optional safe details for an action failure.
        retryAfter:
          type:
            - string
            - 'null'
      additionalProperties: true
  responses:
    BadRequest:
      description: The request path, query, or body is invalid.
      headers:
        x-request-id:
          description: The request identifier selected or generated by Bily.
          schema:
            type: string
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    Unauthorized:
      description: Authentication is missing or invalid.
      headers:
        x-request-id:
          description: The request identifier selected or generated by Bily.
          schema:
            type: string
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    Forbidden:
      description: The identity or API key is not allowed to perform this request.
      headers:
        x-request-id:
          description: The request identifier selected or generated by Bily.
          schema:
            type: string
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    NotFound:
      description: The resource was not found in the caller's accessible scope.
      headers:
        x-request-id:
          description: The request identifier selected or generated by Bily.
          schema:
            type: string
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    ServerError:
      description: Bily could not complete the request.
      headers:
        x-request-id:
          description: The request identifier selected or generated by Bily.
          schema:
            type: string
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
  securitySchemes:
    ApiKeyAuth:
      type: apiKey
      in: header
      name: x-api-key
      description: >-
        A server-side Bily API key created under Settings > MCP > Access key
        fallback. Select the intended store before creating it.
    BearerAuth:
      type: http
      scheme: bearer
      bearerFormat: Bily API key
      description: An alternative way to send the same server-side Bily API key.

````