Skip to content
OpenPostDocs
OpenPostDocs
Analytics

Export stored analytics as CSV, Excel, or JSON

Exports the same stored measurements shown in Analytics. Missing provider metrics stay empty instead of becoming zero.

GET/analytics/export

Authorization

AuthorizationBearer <token>

In: header

Query Parameters

workspace_id*string

Workspace ID

days?integer

Reporting window in days (7, 30, or 90)

Formatint64
Default30
account_ids?string

Optional comma-separated social account IDs. Intersects with account_id and platforms when supplied.

account_id?string

Optional social account ID to export

platforms?string

Optional comma-separated platform filter, for example x,bluesky

format?string

File format. xlsx contains every table plus charts.

Default"csv"

Value in

  • "csv"
  • "xlsx"
  • "json"
timezone?string

IANA timezone used for publish times and day, week and month grouping

Default"UTC"
group_by?string

Row grouping for the report

Default"post"

Value in

  • "post"
  • "day"
  • "week"
  • "month"
  • "platform"
  • "account"
dataset?string

Table to export for csv and json. report follows group_by; xlsx always includes all tables.

Default"report"

Value in

  • "report"
  • "posts"
  • "daily"
  • "accounts"
metrics?string

Optional comma-separated post metric columns for posts and grouped reports. Defaults to every measured metric. Daily and accounts tables retain their fixed columns.

Response Body

application/problem+json

application/problem+json

application/problem+json

application/problem+json

curl -X GET "https://example.com/analytics/export?workspace_id=string"
"string"