---
title: "Get Aggregated Reporting Data"
method: POST
path: "/affiliates/reporting/entity/table"
tags: ["Affiliate Reporting"]
---

# Get Aggregated Reporting Data

`POST /affiliates/reporting/entity/table`

## Request body

- object
  - `from` string, required — Start date for the reporting period. Format `YYYY-MM-DD`.
  - `to` string, required — End date for the reporting period. Format `YYYY-MM-DD`.
  - `timezone_id` integer, required — Timezone identifier for the request.
  - `currency_id` string, required — Currency code for monetary values (e.g. "USD").
  - `columns` object[], required — Columns to group/pivot data by. Minimum 1, maximum 10. Only one time column (hour, date, week, month, year) is allowed per request.
    - `column` 'offer' | 'creative' | 'coupon_code' | 'offer_url' | 'country' | 'country_code' | 'region' | 'city' | 'dma' | 'carrier' | 'platform' | 'isp' | 'os_version' | 'device_type' | 'device_model' | 'device_make' | 'browser' | 'language' | 'sub1' | 'sub2' | 'sub3' | 'sub4' | 'sub5' | 'sub6' | 'sub7' | 'sub8' | 'sub9' | 'sub10' | 'source_id' | 'referer' | 'event_name' | 'connection_type' | 'campaign' | 'campaign_id' | 'tracking_domain' | 'hour' | 'date' | 'week' | 'month' | 'year', required — The dimension to group by. Time columns (hour, date, week, month, year) are mutually exclusive — only one allowed at a time.
  - `query` object — Query configuration.
    - `filters` object[] — Filters to narrow results. Same resource_type filters use OR logic; different resource_type filters use AND logic.
      - `filter_id_value` string, required — The value to filter on (e.g. offer ID, country name, sub value).
      - `resource_type` 'offer' | 'creative' | 'country' | 'country_code' | 'sub1' | 'sub2' | 'sub3' | 'sub4' | 'sub5' | 'sub6' | 'sub7' | 'sub8' | 'sub9' | 'sub10' | 'carrier' | 'device_platform' | 'device_type' | 'device_make' | 'browser' | 'language' | 'connection_type' | 'campaign' | 'source_id' | 'offer_url' | 'device_model' | 'os_version' | 'coupon_code', required — The resource type / dimension to filter on.

## Response `200`

- object
  - `table` object[] — Array of reporting data rows.
    - `columns` object[] — Dimension values for this row.
      - `column_type` string — The column/dimension type (matches the requested column value).
      - `id` string — Dimension value identifier (e.g. offer ID, country name).
      - `label` string — Human-readable label for the dimension value.
    - `reporting` object — Aggregated metrics for this row.
      - `imp` integer — Impression count.
      - `total_click` integer — Total click count.
      - `unique_click` integer — Unique click count.
      - `invalid_click` integer — Invalid/filtered click count.
      - `duplicate_click` integer — Duplicate click count.
      - `ctr` number — Click-through rate (impressions to clicks).
      - `cv` integer — Conversion count.
      - `view_through_cv` integer — View-through conversion count.
      - `event` integer — Post-conversion event count.
      - `cvr` number — Conversion rate (percentage).
      - `evr` number — Event rate.
      - `rpc` number — Revenue per click.
      - `rpm` number — Revenue per mille (per 1,000 impressions).
      - `revenue` number — Total revenue (affiliate payout amount).
      - `redirect_traffic_revenue` number — Revenue from redirect/fallback traffic.
      - `on_hold_conversion_count` integer — Number of conversions currently on hold.
      - `on_hold_potential_revenue` number — Potential revenue from on-hold conversions.

---

[API](https://skmtc.net/everflow/apis/everflow-network-api-tracking-domains.md) · [All operations](https://skmtc.net/everflow/apis/everflow-network-api-tracking-domains/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/everflow/everflow-network-api-tracking-domains/revisions/39242cee0e32/schema)