Loading...

CDN.com.tr Help

Export reports as CSV or Excel

Data consumption, Cache overview and the security events table each hand you the same numbers as a file: CSV for a script, XLSX for a spreadsheet.

Export reports as CSV or Excel

Data consumption, Cache overview and the security events table each hand you the same numbers as a file: CSV for a script, XLSX for a spreadsheet.

The reports behind the files

The export is one button on pages that are worth understanding in their own right.

The numbers

Data consumption

How traffic, storage and the monthly quota are counted before you export them.

Open the topic
Security data

Security events and WAF logs

The table the 10,000-row export is taken from, and how to read a blocked request.

Open the topic
Platform usage

Platform usage

Runtime, database and storage consumption for accounts running on Platforms.

Open the topic

Panel path

  1. Management Panel
  2. CDN Accounts
  3. Observability
  4. Data consumption / Cache overview
  5. Download Excel / Download CSV

Prerequisites

  • An account must be selected and it must have traffic in the period you are exporting.
  • You need access to the report page itself; the export is allowed wherever the page is.
  • For the security events export, open the security events table for the account first.

Decision model

Which report answers the question?

The three exports carry different columns because they answer different questions.

  • Data consumption: traffic volume per hour and per day — the one finance and tenders ask for.
  • Cache overview: hit and miss ratio — the one that shows whether the CDN is doing its job.
  • Security events: the WAF and blocking record — the one that goes into an incident report.

CSV or XLSX?

Same numbers, different destination.

  • CSV: a script, a data warehouse import, a diff against your own logs.
  • XLSX: a colleague who will open it, filter it and paste a chart into a document.

Step-by-step guide

1

Set the range on the report

Everything about the file is decided here. The buttons only package what the page is already showing.

  • Open Data consumption or Cache overview for the account.
  • Pick the period in the date field next to the export buttons.
  • Let the graph and the table reload, and sanity-check the totals before exporting.

Expected result: The page shows exactly the period you want in the file.

cdnctl equivalent
GET /getgraphinfo/export?format=csv
GET /getcachegraphinfo/export?format=xlsx
2

Download the file

Two buttons, one per format, above the report table.

  • Click Download Excel for an XLSX file or Download CSV for a plain text file.
  • Wait for the download; large ranges take a moment to build.
  • Open the file and confirm the period and the totals match the page.

Expected result: A file lands with the same rows the table showed for that range.

cdnctl equivalent
GET /getgraphinfo/export?format=xlsx
3

Export the security events table

The WAF table has its own export with its own limit.

  • Open Security events for the account and set the time range.
  • Use Export Report and choose XLSX or CSV.
  • If the file stops at 10,000 rows, split the period and export again rather than treating it as a complete record.

Expected result: The blocked and challenged requests for that range arrive as a file, up to the row cap.

cdnctl equivalent
GET /management/cdn/advanced-management-waf-export/<account_uuid>

Verification

  • The period in the file matches the period on screen.
  • The totals in the file match the totals the page displayed.
  • A security events export that ends at exactly 10,000 rows was truncated — narrow the range and repeat.

Use cases

Finance wants last month in a spreadsheet, a tender asks for consumption evidence, or you want to chart traffic next to your own application metrics. Reading numbers off a graph is not an answer for any of those.

Quick workflow

  1. Open the report you need: Data consumption for traffic, Cache overview for hit and miss ratios, Security events for WAF activity.
  2. Set the date range first. The export follows the range and filters currently on screen, not a fixed period.
  3. Click Download Excel for XLSX or Download CSV for a plain file.
  4. Open the file and check that the range and the totals match what the page showed.

Checks

  • The export mirrors the screen. Change the date range and you change the file.
  • CSV is the right choice for a script or an import; XLSX is the right choice when a person will open it.
  • The security events export is capped at 10,000 rows. If you hit the cap, narrow the time range instead of assuming that is all the traffic there was.
  • Exports are per account. Two accounts mean two files.