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

# List program spending daily reports

> Returns aggregated points-spending statistics for the program over the given date range and resolution. Optionally filters by card definition.

The date range and maximum values are limited per resolution:
- 90 days for `day`,
- 12 weeks for `week`,
- 12 months for `month`,
- 4 quarters for `quarter`,
- `start_date` must be before `end_date`,
- `end_date` is inclusive.

Returns `400` when query validation fails. Returns `404` when the program does not exist.



## OpenAPI

````yaml /openapi/loyalties-v2.json get /v2/loyalties/programs/{programId}/reports/spending/daily
openapi: 3.1.0
info:
  title: Voucherify Loyalty v2 API
  version: 2.0.0
  description: >-
    Complete OpenAPI specification for the Voucherify Loyalty v2 API.

    All endpoints require the LOYALTY_V2 feature flag.


    Combined from per-domain specs: programs.yaml, members.yaml,
    program-operations.yaml, card-definitions.yaml, earning-rules.yaml,
    tier-structures.yaml, benefits.yaml, rewards.yaml, examine.yaml
servers:
  - url: '{protocol}://{host}'
    variables:
      protocol:
        default: https
        enum:
          - https
          - http
      host:
        default: api.voucherify.io
security:
  - X-App-Id: []
    X-App-Token: []
  - bearerAuth: []
tags:
  - name: Programs
    description: >-
      Loyalty program CRUD, lifecycle management, program-scoped resource
      assignments (card definitions, earning rules, rewards, tier structures),
      member management (create, list, get, update, activate, deactivate,
      delete), membership retrieval (member + program + cards with tier
      progress, by customer ID, customer source ID, or member ID), card
      operations (points adjustment, pending points, expiring points,
      transactions), reward purchases, and activity history.
  - name: Card definitions
    description: >-
      CRUD operations, lifecycle management, and activity history for card
      definitions. Card definitions describe the configuration for loyalty
      cards, including code generation, points expiration, earning/spending
      limits, pending points, refunds, and balance settings.
  - name: Earning rules
    description: >-
      Manage earning rules that define how customers earn points or receive
      incentives based on triggers (events, segments, custom events). Includes
      CRUD, lifecycle, and activity history.
  - name: Tier structures
    description: >-
      CRUD operations, lifecycle management, and activity history for tier
      structures. Includes nested tier definitions (create, list, update,
      delete) within tier structures. Tier structures define the tiering model
      for loyalty programs - how members qualify for and move between tiers.
  - name: Benefits
    description: >-
      Manage benefit definitions (fixed points, proportional points, material,
      digital). Includes CRUD, lifecycle transitions, and activity history.
  - name: Rewards
    description: >-
      CRUD, lifecycle operations, and activity history for reward definitions.
      Rewards can be material (product/SKU) or digital (discount coupons, gift
      vouchers).
  - name: Examine
    description: >-
      Evaluation endpoints that estimate earning opportunities and reward
      availability for a customer across their loyalty program memberships,
      without side effects.
paths:
  /v2/loyalties/programs/{programId}/reports/spending/daily:
    parameters:
      - name: programId
        in: path
        required: true
        description: >-
          Unique loyalty program identifier (format: `lprg_` followed by
          hexadecimal characters).
        schema:
          type: string
    get:
      tags:
        - Programs
      summary: List program spending daily reports
      description: >-
        Returns aggregated points-spending statistics for the program over the
        given date range and resolution. Optionally filters by card definition.


        The date range and maximum values are limited per resolution:

        - 90 days for `day`,

        - 12 weeks for `week`,

        - 12 months for `month`,

        - 4 quarters for `quarter`,

        - `start_date` must be before `end_date`,

        - `end_date` is inclusive.


        Returns `400` when query validation fails. Returns `404` when the
        program does not exist.
      operationId: listProgramSpendingDailyReports
      parameters:
        - name: start_date
          in: query
          required: true
          description: >-
            Sets the inclusive start of the report date range (`YYYY-MM-DD`).
            Must be before `end_date`.
          schema:
            type: string
            format: date
            pattern: ^\d{4}-\d{2}-\d{2}$
        - name: end_date
          in: query
          required: true
          description: >-
            Sets the inclusive end of the report date range (`YYYY-MM-DD`). Must
            be after `start_date`.
          schema:
            type: string
            format: date
            pattern: ^\d{4}-\d{2}-\d{2}$
        - name: resolution
          in: query
          required: true
          description: >-
            Sets the aggregation resolution. Allowed date range: `day` max 90
            days, `week` max 12 weeks, `month` max 12 months, `quarter` max 4
            quarters.
          schema:
            type: string
            enum:
              - day
              - week
              - month
              - quarter
        - name: filters
          in: query
          required: false
          style: deepObject
          explode: true
          description: >-
            Filters rows by field conditions, e.g.
            `filters[card_definition_id][conditions][$is]=lcdef_...`.
          schema:
            $ref: '#/components/schemas/SpendingReportListFilters'
      responses:
        '200':
          description: Program spending daily report.
          content:
            application/json:
              schema:
                $ref: >-
                  #/components/schemas/LoyaltiesProgramsReportsSpendingDailyListResponseBody
              examples:
                'Daily spending report: Day resolution':
                  value:
                    data:
                      - date: '2026-06-30'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 3
                        success_on_reward: 0
                        success_on_order: 3
                        points: 423
                        points_on_rewards: 0
                        points_on_order: 423
                        amount_on_order: 423
                        object: spending_daily_report
                      - date: '2026-07-08'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 2
                        success_on_reward: 2
                        success_on_order: 0
                        points: 1000
                        points_on_rewards: 1000
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-10'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 4
                        success_on_reward: 0
                        success_on_order: 4
                        points: 48
                        points_on_rewards: 0
                        points_on_order: 48
                        amount_on_order: 48
                        object: spending_daily_report
                      - date: '2026-07-13'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 10
                        success_on_reward: 0
                        success_on_order: 10
                        points: 2232
                        points_on_rewards: 0
                        points_on_order: 2232
                        amount_on_order: 2232
                        object: spending_daily_report
                      - date: '2026-07-21'
                        card_definition_id: lcdef_128f495f720c4bec8c
                        success: 1
                        success_on_reward: 1
                        success_on_order: 0
                        points: 250
                        points_on_rewards: 250
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-21'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 1
                        success_on_reward: 1
                        success_on_order: 0
                        points: 500
                        points_on_rewards: 500
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-27'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 7
                        success_on_reward: 7
                        success_on_order: 0
                        points: 3500
                        points_on_rewards: 3500
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-29'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 3
                        success_on_reward: 0
                        success_on_order: 3
                        points: 240
                        points_on_rewards: 0
                        points_on_order: 240
                        amount_on_order: 240
                        object: spending_daily_report
                    object: report
                'Daily spending report: Week resolution':
                  value:
                    data:
                      - date: '2026-06-29'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 3
                        success_on_reward: 0
                        success_on_order: 3
                        points: 423
                        points_on_rewards: 0
                        points_on_order: 423
                        amount_on_order: 423
                        object: spending_daily_report
                      - date: '2026-07-06'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 6
                        success_on_reward: 2
                        success_on_order: 4
                        points: 1048
                        points_on_rewards: 1000
                        points_on_order: 48
                        amount_on_order: 48
                        object: spending_daily_report
                      - date: '2026-07-13'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 10
                        success_on_reward: 0
                        success_on_order: 10
                        points: 2232
                        points_on_rewards: 0
                        points_on_order: 2232
                        amount_on_order: 2232
                        object: spending_daily_report
                      - date: '2026-07-20'
                        card_definition_id: lcdef_128f495f720c4bec8c
                        success: 1
                        success_on_reward: 1
                        success_on_order: 0
                        points: 250
                        points_on_rewards: 250
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-20'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 1
                        success_on_reward: 1
                        success_on_order: 0
                        points: 500
                        points_on_rewards: 500
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-27'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 10
                        success_on_reward: 7
                        success_on_order: 3
                        points: 3740
                        points_on_rewards: 3500
                        points_on_order: 240
                        amount_on_order: 240
                        object: spending_daily_report
                    object: report
                'Daily spending report: Month resolution':
                  value:
                    data:
                      - date: '2026-06-01'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 3
                        success_on_reward: 0
                        success_on_order: 3
                        points: 423
                        points_on_rewards: 0
                        points_on_order: 423
                        amount_on_order: 423
                        object: spending_daily_report
                      - date: '2026-07-01'
                        card_definition_id: lcdef_128f495f720c4bec8c
                        success: 1
                        success_on_reward: 1
                        success_on_order: 0
                        points: 250
                        points_on_rewards: 250
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-01'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 27
                        success_on_reward: 10
                        success_on_order: 17
                        points: 7520
                        points_on_rewards: 5000
                        points_on_order: 2520
                        amount_on_order: 2520
                        object: spending_daily_report
                    object: report
                'Daily spending report: Quarter resolution':
                  value:
                    data:
                      - date: '2026-04-01'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 3
                        success_on_reward: 0
                        success_on_order: 3
                        points: 423
                        points_on_rewards: 0
                        points_on_order: 423
                        amount_on_order: 423
                        object: spending_daily_report
                      - date: '2026-07-01'
                        card_definition_id: lcdef_128f495f720c4bec8c
                        success: 1
                        success_on_reward: 1
                        success_on_order: 0
                        points: 250
                        points_on_rewards: 250
                        points_on_order: 0
                        amount_on_order: 0
                        object: spending_daily_report
                      - date: '2026-07-01'
                        card_definition_id: lcdef_128f4a88414c4bed69
                        success: 27
                        success_on_reward: 10
                        success_on_order: 17
                        points: 7520
                        points_on_rewards: 5000
                        points_on_order: 2520
                        amount_on_order: 2520
                        object: spending_daily_report
                    object: report
                Empty spending daily report:
                  value:
                    data: []
                    object: report
        '400':
          description: >-
            Query parameters failed validation, or `start_date` is not before
            `end_date`.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
              examples:
                'Invalid query parameters: `start_date` is required':
                  value:
                    code: 400
                    key: invalid_query_params
                    message: Invalid query params
                    details: Query must have required property 'start_date'
                    request_id: v-130eb43b3685e26454
                'Invalid query parameters: `end_date` is required':
                  value:
                    code: 400
                    key: invalid_query_params
                    message: Invalid query params
                    details: Query must have required property 'end_date'
                    request_id: v-130eb46d6c45e264b2
                'Invalid query parameters: `resolution` is required':
                  value:
                    code: 400
                    key: invalid_query_params
                    message: Invalid query params
                    details: Query must have required property 'resolution'
                    request_id: v-130eb4847405e264e3
                'Invalid query parameters: `resolution` is invalid':
                  value:
                    code: 400
                    key: invalid_query_params
                    message: Invalid query params
                    details: >-
                      Property .resolution must be equal to one of the allowed
                      values [ day, week, month, quarter ]
                    request_id: v-130eb4847405e264e4
                'Invalid query parameters: `start_date` is invalid':
                  value:
                    code: 400
                    key: invalid_query_params
                    message: Invalid query params
                    details: >-
                      Property .start_date cannot be recognized as a ISO-8601
                      compliant date
                    request_id: v-130eb43b3685e26455
                'Invalid query parameters: date range exceeds limit':
                  value:
                    code: 400
                    key: invalid_query_params
                    message: Invalid query params
                    details: >-
                      Query date range exceeds maximum allowed 90 days for
                      resolution 'day'
                    request_id: v-130eb43b3685e26456
                'Invalid payload: `start_date` is not before `end_date`':
                  value:
                    code: 400
                    key: invalid_payload
                    message: Invalid payload
                    details: Property 'start_date' must be before 'end_date'
                    request_id: v-130eb43b3685e26457
        '404':
          description: Resource not found.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
              examples:
                Program not found:
                  value:
                    code: 404
                    key: not_found
                    message: Resource not found
                    details: Cannot find program with id lprg_128f5829f4c4bf7b2
                    request_id: v-130eb4c2a6459642bb
                    resource_id: lprg_128f5829f4c4bf7b2
                    resource_type: program
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ErrorResponse'
              examples:
                Internal server error:
                  value:
                    code: 500
                    key: api_error
                    message: >-
                      Something went wrong. Don't worry, your campaigns are
                      still safe and the Voucherify Team has been notified.
                      Check out our Help Center and forums for help, or head
                      back to home.
components:
  schemas:
    SpendingReportListFilters:
      type: object
      description: Filters for spending reports.
      properties:
        junction:
          description: >-
            Logical junction between the field filters. Defaults to AND
            behavior.
          oneOf:
            - type: string
              enum:
                - AND
                - OR
            - type: 'null'
        card_definition_id:
          description: Filter by card definition id.
          oneOf:
            - $ref: >-
                #/components/schemas/SpendingReportFilterCardDefinitionIdConditions
            - type: 'null'
      additionalProperties: false
    LoyaltiesProgramsReportsSpendingDailyListResponseBody:
      type: object
      title: Loyalties Programs Reports Spending Daily List Response Body
      description: >-
        Response body schema for **GET**
        `/v2/loyalties/programs/{programId}/reports/spending/daily`.
      properties:
        data:
          type: array
          description: >-
            List of report entries, one per aggregation period and card
            definition.
          items:
            $ref: '#/components/schemas/SpendingReportDailyEntry'
        object:
          type: string
          const: report
          description: Object type marker. Always `report`.
      required:
        - data
        - object
    ErrorResponse:
      type: object
      description: Standard error response returned by all Loyalty v2 endpoints.
      properties:
        code:
          type: integer
          description: HTTP status code of the error.
        key:
          type: string
          description: Machine-readable error key.
        message:
          type: string
          description: Human-readable error message.
        details:
          type: string
          description: Additional details about the error.
        request_id:
          type: string
          description: Unique identifier of the request that produced the error.
        resource_id:
          type: string
          description: Unique identifier of the resource that produced the error.
        resource_type:
          type: string
          description: Type of the resource that produced the error.
    SpendingReportFilterCardDefinitionIdConditions:
      type: object
      description: >-
        ID filter conditions for card definition ids. Values must match pattern
        `^lcdef_[a-f0-9]+$`. `$is`/`$is_not` accept a single value (string or
        1-element array); `$in`/`$not_in` accept a string or an array of 1-100
        values.
      properties:
        conditions:
          type: object
          minProperties: 1
          additionalProperties: false
          properties:
            $is:
              description: Matches rows whose card definition id equals the given value.
              oneOf:
                - type: string
                  pattern: ^lcdef_[a-f0-9]+$
                - type: array
                  items:
                    type: string
                    pattern: ^lcdef_[a-f0-9]+$
                  minItems: 1
                  maxItems: 1
                - type: 'null'
            $is_not:
              description: >-
                Matches rows whose card definition id does not equal the given
                value.
              oneOf:
                - type: string
                  pattern: ^lcdef_[a-f0-9]+$
                - type: array
                  items:
                    type: string
                    pattern: ^lcdef_[a-f0-9]+$
                  minItems: 1
                  maxItems: 1
                - type: 'null'
            $in:
              description: >-
                Matches rows whose card definition id is one of the given
                values.
              oneOf:
                - type: string
                  pattern: ^lcdef_[a-f0-9]+$
                - type: array
                  items:
                    type: string
                    pattern: ^lcdef_[a-f0-9]+$
                  minItems: 1
                  maxItems: 100
                - type: 'null'
            $not_in:
              description: >-
                Matches rows whose card definition id is not one of the given
                values.
              oneOf:
                - type: string
                  pattern: ^lcdef_[a-f0-9]+$
                - type: array
                  items:
                    type: string
                    pattern: ^lcdef_[a-f0-9]+$
                  minItems: 1
                  maxItems: 100
                - type: 'null'
      required:
        - conditions
      additionalProperties: false
    SpendingReportDailyEntry:
      type: object
      description: >-
        Aggregated program spending statistics for one period and card
        definition. Numeric fields default to `0`.
      properties:
        date:
          type: string
          format: date
          description: >-
            Identifies the start of the truncated aggregation period
            (`YYYY-MM-DD`). For `week` this is Monday. For `month` this is the
            first day. For `quarter` this is the quarter start.
        card_definition_id:
          type: string
          description: Identifies the card definition (`lcdef_...`).
        success:
          type: number
          description: Counts successful spending operations in the period.
        success_on_reward:
          type: number
          description: Counts successful reward purchases in the period.
        success_on_order:
          type: number
          description: Counts successful order payments in the period.
        points:
          type: number
          description: Totals points spent in the period.
        points_on_rewards:
          type: number
          description: Totals points spent on reward purchases in the period.
        points_on_order:
          type: number
          description: Totals points spent on order payments in the period.
        amount_on_order:
          type: number
          description: Totals order amount paid with points in the period.
        object:
          type: string
          const: spending_daily_report
          description: Object type marker. Always `spending_daily_report`.
      required:
        - date
        - card_definition_id
        - success
        - success_on_reward
        - success_on_order
        - points
        - points_on_rewards
        - points_on_order
        - amount_on_order
        - object
  securitySchemes:
    X-App-Id:
      type: apiKey
      name: X-App-Id
      in: header
    X-App-Token:
      type: apiKey
      name: X-App-Token
      in: header
    bearerAuth:
      type: http
      scheme: bearer
      bearerFormat: JWT

````