# List Aggregated Reports As Csv ## OpenAPI Specification ```yaml openapi: 3.0.1 info: title: '' description: '' version: 1.0.0 paths: /v1/operations/revenue_reporting/reports/aggregated.csv: get: summary: List Aggregated Reports As Csv deprecated: false description: >- Returns reports CSV data aggregated by given subject within given time period. ## Query Parameters See [Reports -> List aggregated query params](api-3511300#query-parameters) ## Response Body Following reports data is returned in CSV: * Name * Revenue * Revenue - growth * Revenue average * Revenue average - growth * Revenue per area unit * Revenue per area unit - growth * Transactions no. * Transactions no. - growth * Transactions no. average * Transactions no. average - growth * Transactions no. per area unit * Transactions no. per area unit - growth * Complete data? Also, when aggregating by `store`, store attributes are returned: * Store Floor * Store Category * Store Zone * Store Area ## Example ```shell title="Aggregation by day" curl -X GET \ "https://api.mpc.placewise.com/v1/operations/revenue_reporting/reports/aggregated.csv?subject=day&date_from=2021-08-01&date_to=2021-08-03" \ -H 'authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCIgOiAiSldUIiwia2lkIiA6ICIyOE' \ -H 'content-type: application/json' \ -H 'x-loyalty-club-slug: infinity-mall' \ -H 'x-user-agent: CURL manual test' ``` ```csv title="When successful, returns reports CSV data aggregated by day for selected time period" "Name","Revenue","Revenue - growth","Revenue average","Revenue average - growth","Revenue per area unit","Revenue per area unit - growth","Transactions no.","Transactions no. - growth","Transactions no. average","Transactions no. average - growth","Transactions no. per area unit","Transactions no. per area unit - growth","Complete data?" "Total","1520.0","181.48","217.1429","141.27","6.08","181.48","14500","83.54","2071.43","57.32","58.0","83.54","false" "2021-08-01","1050.0","517.65","350.0","311.76","4.2","517.65","10400","352.17","3466.67","201.45","41.6","352.17","false" "2021-08-02","260.0","36.84","130.0","36.84","1.04","36.84","1700","-46.88","850.0","-46.88","6.8","-46.88","true" "2021-08-03","210.0","16.67","105.0","16.67","0.84","16.67","2400","0.0","1200.0","0.0","9.6","0.0","true" ``` ```shell title="Aggregation by store" curl -X GET \ "https://api.mpc.placewise.com/v1/operations/revenue_reporting/reports/aggregated.csv?subject=store&date_from=2021-08-02&date_to=2021-08-24" \ -H 'authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCIgOiAiSldUIiwia2lkIiA6ICIyOE' \ -H 'content-type: application/json' \ -H 'x-loyalty-club-slug: infinity-mall' \ -H 'x-user-agent: CURL manual test' ``` ```csv title="When successful, returns reports CSV data aggregated by store for selected time period" "Name","Revenue","Revenue - growth","Revenue average","Revenue average - growth","Revenue per area unit","Revenue per area unit - growth","Transactions no.","Transactions no. - growth","Transactions no. average","Transactions no. average - growth","Transactions no. per area unit","Transactions no. per area unit - growth","Complete data?","Store Floor","Store Category","Store Zone","Store Area" "Total","8040.0","-22.54","182.72729999999999","16.19","32.16","-22.54","77700","-28.06","1850.0","13.06","310.8","-28.06","false","","","" "Disc world","2060.0","-39.94","108.42110000000001","-2.01","10.3","-39.94","19200","-50.13","1010.53","-18.63","96.0","-50.13","true","0","0","Fashion","200" "Kitty world","2470.0","-24.23","117.619","11.85","49.4","-24.23","22400","-35.07","1178.95","5.93","448.0","-35.07","false","Zone B","1","nowa kategoria tanantowa","50" ``` tags: - API Reference/Operations API/Manager API/Revenue Reporting parameters: - name: Content-Type in: header description: '[Details](doc-341635)' required: true example: application/json schema: type: string default: application/json const: application/json - name: X-User-Agent in: header description: Arbitrary identifier of your client. [Details](doc-341635) required: true example: '{{X_USER_AGENT}}' schema: type: string default: '{{X_USER_AGENT}}' - name: X-Product-Name in: header description: API Product for API context. [Details](doc-341635) required: true example: '{{PRODUCT_NAME}}' schema: type: string default: '{{PRODUCT_NAME}}' - name: X-Loyalty-Club-Slug in: header description: LoyaltyClub for API context. [Details](doc-342138) required: false example: '{{LOYALTY_CLUB_SLUG}}' schema: type: string default: '{{LOYALTY_CLUB_SLUG}}' - name: X-Customer in: header description: Customer for API context. [Details](doc-342139) required: false example: '{{CUSTOMER_ID}}' schema: type: string default: '{{CUSTOMER_ID}}' - name: Authorization in: header description: '[Member](doc-342129) or [User](doc-342130) Authorization.' required: false example: Bearer {{_OAUTH_TOKEN}} schema: type: string default: Bearer {{_OAUTH_TOKEN}} - name: X-Client-Authorization in: header description: '[Token](doc-342128) Authorization.' example: '{{API_TOKEN}}' schema: type: string default: '{{API_TOKEN}}' responses: '200': description: '' content: application/json: schema: type: object properties: {} headers: {} x-apidog-name: Success security: [] x-apidog-folder: API Reference/Operations API/Manager API/Revenue Reporting x-apidog-status: pending x-run-in-apidog: https://app.eu.apidog.com/web/project/346351/apis/api-3511301-run components: schemas: {} securitySchemes: {} servers: - url: https://api.mpc.dev.placewise.com description: Staging security: [] ```