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

# Get Aggregated Reporting Data

`POST /networks/reporting/entity/table`

## Request body

- object
  - `columns` object[], required
    - `column` 'unix_timestamp' | 'offer' | 'offer_group' | 'affiliate' | 'advertiser' | 'creative' | 'category' | 'affiliate_manager' | 'account_manager' | 'country' | 'carrier' | 'platform' | 'os_version' | 'device_type' | 'browser' | 'device_make' | 'language' | 'sub1' | 'sub2' | 'sub3' | 'sub4' | 'sub5' | 'sub6' | 'sub7' | 'sub8' | 'sub9' | 'sub10' | 'event_name' | 'region' | 'city' | 'dma' | 'connection_type' | 'campaign' | 'source_id' | 'hour' | 'date' | 'week' | 'month' | 'year' | 'offer_url' | 'device_model' | 'project_id' | 'referer' | 'offer_id' | 'offer_group_id' | 'affiliate_id' | 'advertiser_id' | 'campaign_id' | 'creative_id' | 'payout_type' | 'payout_amount' | 'revenue_type' | 'revenue_amount' | 'currency' | 'sales_manager' | 'account_executive' | 'derived_affiliate_manager' | 'derived_account_manager' | 'derived_sales_manager' | 'derived_project_id' | 'derived_account_executive' | 'isp' | 'adv1' | 'adv2' | 'adv3' | 'adv4' | 'adv5' | 'adv6' | 'adv7' | 'adv8' | 'adv9' | 'adv10' | 'offer_status' | 'hourly' | 'originating_offer' | 'is_proxy' | 'affiliate_status' | 'coupon_code' | 'advertiser_campaign_name' | 'app_identifier' | 'bundle_id' | 'meta_platform' | 'score_rating' | 'total_rating' | 'size' | 'developer' | 'version' | 'advertiser_event_name' | 'tracking_domain' | 'postal_code' | 'order_id' | 'attribution_method' | 'custom_payout_revenue' | 'custom_payout_revenue_id' | 'country_code' | 'day_of_week' | 'transaction_id' | 'derived_referred_by'
  - `currency_id` string, required
  - `from` string, required
  - `query` object
    - `exclusions` object[]
      - `filter_id_value` string
      - `resource_type` 'offer' | 'offer_group' | 'affiliate' | 'advertiser' | 'creative' | 'account_manager' | 'affiliate_manager' | 'category' | 'billing_frequency' | 'country' | 'region' | 'city' | 'dma' | 'carrier' | 'device_platform' | 'device_type' | 'device_make' | 'browser' | 'event_name' | 'language' | 'connection_type' | 'campaign' | 'source_id' | 'transaction_id' | 'error_code' | 'offer_url' | 'device_model' | 'business_unit' | 'label' | 'sales_manager' | 'account_executive' | 'everflow_account_manager' | 'adv1' | 'adv2' | 'adv3' | 'adv4' | 'adv5' | 'adv6' | 'adv7' | 'adv8' | 'adv9' | 'adv10' | 'currency' | 'revenue_type' | 'revenue_amount' | 'payout_type' | 'payout_amount' | 'os_version' | 'project_id' | 'isp' | 'offer_status' | 'sub1' | 'sub2' | 'sub3' | 'sub4' | 'sub5' | 'sub6' | 'sub7' | 'sub8' | 'sub9' | 'sub10' | 'originating_offer' | 'channel' | 'coupon_code' | 'affiliate_tier' | 'tracking_domain' | 'country_code' | 'advertiser_billing_frequency'
    - `filters` object[]
      - `filter_id_value` string
      - `resource_type` 'offer' | 'offer_group' | 'affiliate' | 'advertiser' | 'creative' | 'account_manager' | 'affiliate_manager' | 'category' | 'billing_frequency' | 'country' | 'region' | 'city' | 'dma' | 'carrier' | 'device_platform' | 'device_type' | 'device_make' | 'browser' | 'event_name' | 'language' | 'connection_type' | 'campaign' | 'source_id' | 'transaction_id' | 'error_code' | 'offer_url' | 'device_model' | 'business_unit' | 'label' | 'sales_manager' | 'account_executive' | 'everflow_account_manager' | 'adv1' | 'adv2' | 'adv3' | 'adv4' | 'adv5' | 'adv6' | 'adv7' | 'adv8' | 'adv9' | 'adv10' | 'currency' | 'revenue_type' | 'revenue_amount' | 'payout_type' | 'payout_amount' | 'os_version' | 'project_id' | 'isp' | 'offer_status' | 'sub1' | 'sub2' | 'sub3' | 'sub4' | 'sub5' | 'sub6' | 'sub7' | 'sub8' | 'sub9' | 'sub10' | 'originating_offer' | 'channel' | 'coupon_code' | 'affiliate_tier' | 'tracking_domain' | 'country_code' | 'advertiser_billing_frequency'
    - `metric_filters` object[]
      - `metric_type` 'impression' | 'total_click' | 'unique_click' | 'invalid_click' | 'duplicate_click' | 'cv' | 'invalid_cv_scrub' | 'view_through_cv' | 'event' | 'payout' | 'revenue' | 'event_revenue' | 'gross_sales' | 'affiliate_event' | 'affiliate_revenue' | 'media_buying_cost'
      - `metric_value` number
      - `operator` 'less_than' | 'less_than_or_equal' | 'greater_than' | 'greater_than_or_equal'
    - `settings` object
      - `campaign_data_only` boolean
      - `ignore_fail_traffic` boolean
      - `only_include_fail_traffic` boolean
    - `user_metrics` object
      - `metric_aggr_function` 'sum' | 'avg'
      - `metric_type` string
  - `timezone_id` integer, required
  - `to` string, required
  - `usm_columns` string[], nullable

## Response `200`

- object
  - `table` object[]
    - `columns` object[] — Array of column entries matching the requested columns. Note: requesting the `offer` column automatically includes an `advertiser` column in the response.
      - `column_type` string — The column type identifier.
      - `id` string — The entity ID or value for this column.
      - `label` string — Human-readable label for this column value.
    - `custom_metric_columns` object[] — Custom metrics configured for this network.
      - `column_type` string — The custom metric name.
      - `label` string — The computed metric value (as a string).
      - `network_reporting_custom_metric_id` integer — ID of the custom metric definition.
    - `reporting` object
      - `avg_sale_value` number
      - `cpa` number
      - `cpc` number
      - `cpm` number
      - `ctr` number
      - `cv` integer
      - `cvr` number
      - `duplicate_click` integer
      - `epc` number
      - `event` integer
      - `event_revenue` number
      - `evr` number
      - `gross_click` integer
      - `gross_sales` number
      - `imp` integer
      - `invalid_click` integer
      - `invalid_cv_scrub` integer
      - `margin` number
      - `media_buying_cost` number
      - `on_hold_conversion_count` integer
      - `on_hold_potential_payout` number
      - `on_hold_potential_revenue` number
      - `payout` number
      - `profit` number
      - `revenue` number
      - `roas` number
      - `rpa` number
      - `rpc` number
      - `rpm` number
      - `total_click` integer
      - `total_cv` integer
      - `unique_click` integer
      - `view_through_cv` integer
      - `public_events` integer
    - `usm_columns` object[] — User-specific metric columns.
      - `column_type` string
      - `label` string

---

[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)