Skip to main content
POST
/
networks
/
reporting
/
entity
/
table
Get Aggregated Reporting Data
curl --request POST \
  --url https://api.eflow.team/v1/networks/reporting/entity/table \
  --header 'Content-Type: application/json' \
  --header 'X-Eflow-Api-Key: <api-key>' \
  --data '
{
  "from": "2026-03-01",
  "to": "2026-03-08",
  "timezone_id": 90,
  "currency_id": "USD",
  "columns": [
    {
      "column": "offer"
    }
  ]
}
'
{
  "table": [
    {
      "columns": [
        {
          "column_type": "<string>",
          "id": "<string>",
          "label": "<string>"
        }
      ],
      "custom_metric_columns": [
        {
          "column_type": "<string>",
          "label": "<string>",
          "network_reporting_custom_metric_id": 123
        }
      ],
      "reporting": {
        "avg_sale_value": 123,
        "cpa": 123,
        "cpc": 123,
        "cpm": 123,
        "ctr": 123,
        "cv": 123,
        "cvr": 123,
        "duplicate_click": 123,
        "epc": 123,
        "event": 123,
        "event_revenue": 123,
        "evr": 123,
        "gross_click": 123,
        "gross_sales": 123,
        "imp": 123,
        "invalid_click": 123,
        "invalid_cv_scrub": 123,
        "margin": 123,
        "media_buying_cost": 123,
        "on_hold_conversion_count": 123,
        "on_hold_potential_payout": 123,
        "on_hold_potential_revenue": 123,
        "payout": 123,
        "profit": 123,
        "revenue": 123,
        "roas": 123,
        "rpa": 123,
        "rpc": 123,
        "rpm": 123,
        "total_click": 123,
        "total_cv": 123,
        "unique_click": 123,
        "view_through_cv": 123,
        "public_events": 123
      },
      "usm_columns": [
        {
          "column_type": "<string>",
          "label": "<string>"
        }
      ]
    }
  ]
}
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: 
{
  "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: 
{
  "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: 
{
  "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}
  }
}

Authorizations

​
X-Eflow-Api-Key
string
header
required

The Everflow API key generated from the Control Center > Security.

Body

application/json
​
columns
object[]
required
​
currency_id
string
required
​
from
string
required
​
timezone_id
integer
required
​
to
string
required
​
query
object
​
usm_columns
string[] | null

Response

200 - application/json
​
table
object[]