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

# Run a custom report

> Runs a custom analytics query and returns tabular rows plus a date-wise series, or streams a CSV when `download` is set. `tags` are resolved to video IDs before the query runs; a tag with no videos yields an empty report. Requires the `READ_ANALYTICS` scope.



## OpenAPI

````yaml POST /v1/api/analytics/raw
openapi: 3.1.0
info:
  title: PN Player API
  description: >-
    Manage videos, captions, playlists, tags, analytics, team members and
    account settings for your PN Player account.


    All `/v1/api` endpoints accept either an API key in the `X-Auth-Token`
    header or a JWT in the `Authorization: Bearer` header. Most endpoints also
    require the calling user to hold a specific role (scope): `READ_MEDIA`,
    `UPDATE_MEDIA`, `READ_ANALYTICS`, `READ_BILLING`, `READ_SETTINGS`,
    `UPDATE_SETTINGS` or `UPDATE_USERS`. The required scope is noted on each
    endpoint.
  version: 2.0.0
servers:
  - url: https://api.pnplayer.com
security:
  - apiKeyAuth: []
  - bearerAuth: []
tags:
  - name: Authentication
    description: >-
      Obtain a session token or reset a password. These endpoints do not require
      authentication.
  - name: Videos
    description: Create, list, update and delete videos.
  - name: Captions
    description: Upload, download, transcribe and manage caption tracks for a video.
  - name: Playlists
    description: Manual and rule-based (dynamic) playlists.
  - name: Tags
    description: Account-level tags that can be attached to videos.
  - name: Analytics
    description: Playback, engagement and usage metrics.
  - name: Reports
    description: Saved analytics report links.
  - name: Account
    description: Team members and account-wide streaming and security settings.
  - name: Profile
    description: The authenticated user's own profile.
  - name: API keys
    description: Long-lived keys for programmatic access.
  - name: Webhooks
    description: Configure the HTTPS endpoint that receives signed event notifications.
  - name: Billing
    description: Plan, usage, invoices, expansion packs and billing address.
  - name: Transcription settings
    description: Per-account key/value settings for automatic transcription.
  - name: Feature requests
    description: Submit, upvote and discuss feature requests.
  - name: Agreements
    description: Data processing agreement (DPA) and enterprise order form signing.
paths:
  /v1/api/analytics/raw:
    post:
      tags:
        - Analytics
      summary: Run a custom report
      description: >-
        Runs a custom analytics query and returns tabular rows plus a date-wise
        series, or streams a CSV when `download` is set. `tags` are resolved to
        video IDs before the query runs; a tag with no videos yields an empty
        report. Requires the `READ_ANALYTICS` scope.
      parameters:
        - name: download
          in: query
          description: >-
            Return a CSV of the `table` rows or the `dateWise` series instead of
            JSON
          schema:
            type: string
            enum:
              - table
              - dateWise
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              description: >-
                Report definition. Additional fields are forwarded to the
                analytics engine as-is.
              properties:
                from:
                  type: string
                  format: date
                to:
                  type: string
                  format: date
                videoIds:
                  type: array
                  items:
                    type: string
                  description: Restrict to these videos
                tags:
                  type: array
                  items:
                    type: integer
                  description: Restrict to videos carrying any of these tag IDs
              additionalProperties: true
      responses:
        '200':
          description: Report result
          content:
            application/json:
              schema:
                type: object
                properties:
                  summary:
                    type: object
                    additionalProperties: true
                  dateWise:
                    type: array
                    items:
                      type: object
                      additionalProperties: true
                  data:
                    type: array
                    items:
                      type: object
                      additionalProperties: true
                  totalRows:
                    type: integer
            text/csv:
              schema:
                type: string
        '400':
          description: Invalid report definition
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/Error'
        '403':
          $ref: '#/components/responses/Forbidden'
        '500':
          $ref: '#/components/responses/ServerError'
components:
  schemas:
    Error:
      type: object
      required:
        - message
      properties:
        message:
          type: string
  responses:
    Forbidden:
      description: The caller lacks the required scope
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
          example:
            message: Forbidden
    ServerError:
      description: Unexpected error
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
  securitySchemes:
    apiKeyAuth:
      type: apiKey
      in: header
      name: X-Auth-Token
      description: >-
        API key created in the dashboard or via `POST /v1/api/api-keys`. Keys
        are prefixed `pn_` and do not expire until revoked.
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT
      description: Session token from `POST /auth/token`, valid for 24 hours.

````