> ## Documentation Index > Fetch the complete documentation index at: https://developers.everflow.io/llms.txt > Use this file to discover all available pages before exploring further. # Get Aggregated Reporting Data The main reporting endpoint for pivoting data by columns. Limited to 10,000 rows. Requires from/to dates, timezone\_id, currency\_id, and at least one column. Returns incomplete\_results: true if the row limit is exceeded. The date range is limited to a maximum of one year (367 days). Requests exceeding this limit will return an error. ### Examples **Basic report by offer** (see the request example below) **Report filtered by country with device\_type breakdown:** ```json theme={null} { "from": "2026-03-01", "to": "2026-03-07", "timezone_id": 90, "currency_id": "USD", "columns": [{"column": "device_type"}], "query": { "filters": [ {"filter_id_value": "United States", "resource_type": "country"}, {"filter_id_value": "Canada", "resource_type": "country"} ] } } ``` **Multi-offer report with affiliate exclusion:** ```json theme={null} { "from": "2026-03-01", "to": "2026-03-07", "timezone_id": 90, "currency_id": "USD", "columns": [{"column": "affiliate"}], "query": { "filters": [ {"filter_id_value": "42", "resource_type": "offer"}, {"filter_id_value": "43", "resource_type": "offer"} ], "exclusions": [ {"filter_id_value": "1", "resource_type": "affiliate"} ] } } ``` **Smart Links report:** ```json theme={null} { "from": "2026-03-01", "to": "2026-03-07", "timezone_id": 90, "currency_id": "USD", "columns": [{"column": "campaign"}, {"column": "offer"}], "query": { "settings": {"campaign_data_only": true} } } ``` ## OpenAPI ````yaml openapi/reporting-aggregated.yaml post /networks/reporting/entity/table openapi: 3.0.3 info: title: Everflow Network API - Aggregated Reporting description: > Aggregated reporting endpoints for the Everflow partner marketing platform. Retrieve grouped reporting data, summaries, variance reports, post-conversion event reports, and MTTI metrics. version: 1.0.0 servers: - description: Production Server url: https://api.eflow.team/v1 security: [] tags: - name: Reporting description: Aggregated reporting endpoints. paths: /networks/reporting/entity/table: post: tags: - Reporting summary: Get Aggregated Reporting Data requestBody: content: application/json: example: from: '2026-03-01' to: '2026-03-08' timezone_id: 90 currency_id: USD columns: - column: offer schema: required: - from - to - timezone_id - currency_id - columns properties: columns: type: array items: type: object properties: column: type: string enum: - 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: type: string from: type: string query: properties: exclusions: type: array items: type: object properties: filter_id_value: type: string resource_type: enum: - 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 type: string filters: type: array items: type: object properties: filter_id_value: type: string resource_type: enum: - 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 type: string metric_filters: type: array items: type: object properties: metric_type: enum: - 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 type: string metric_value: type: number operator: enum: - less_than - less_than_or_equal - greater_than - greater_than_or_equal type: string settings: properties: campaign_data_only: type: boolean ignore_fail_traffic: type: boolean only_include_fail_traffic: type: boolean type: object user_metrics: properties: metric_aggr_function: enum: - sum - avg type: string metric_type: type: string type: object type: object timezone_id: type: integer to: type: string usm_columns: items: type: string nullable: true type: array type: object responses: '200': content: application/json: schema: properties: table: type: array items: properties: columns: type: array description: > Array of column entries matching the requested columns. Note: requesting the `offer` column automatically includes an `advertiser` column in the response. items: type: object properties: column_type: type: string description: The column type identifier. id: type: string description: The entity ID or value for this column. label: type: string description: Human-readable label for this column value. custom_metric_columns: type: array description: Custom metrics configured for this network. items: type: object properties: column_type: type: string description: The custom metric name. label: type: string description: The computed metric value (as a string). network_reporting_custom_metric_id: type: integer description: ID of the custom metric definition. reporting: properties: avg_sale_value: type: number cpa: type: number cpc: type: number cpm: type: number ctr: type: number cv: type: integer cvr: type: number duplicate_click: type: integer epc: type: number event: type: integer event_revenue: type: number evr: type: number gross_click: type: integer gross_sales: type: number imp: type: integer invalid_click: type: integer invalid_cv_scrub: type: integer margin: type: number media_buying_cost: type: number on_hold_conversion_count: type: integer on_hold_potential_payout: type: number on_hold_potential_revenue: type: number payout: type: number profit: type: number revenue: type: number roas: type: number rpa: type: number rpc: type: number rpm: type: number total_click: type: integer total_cv: type: integer unique_click: type: integer view_through_cv: type: integer public_events: type: integer type: object usm_columns: type: array description: User-specific metric columns. items: type: object properties: column_type: type: string label: type: string type: object type: object description: '' security: - API Key: [] components: securitySchemes: API Key: description: The Everflow API key generated from the Control Center > Security. in: header name: X-Eflow-Api-Key type: apiKey ````