> ## Documentation Index > Fetch the complete documentation index at: https://help.airbridge.io/llms.txt > Use this file to discover all available pages before exploring further. # Upload Metric Data Request to upload metric data in CSV format.

Header

The `Content-Type` in the Request Header uses multipart/form-data. ```header-multipart theme={"theme":{"light":"github-dark-dimmed","dark":"github-dark-dimmed"}} Content-Type: multipart/form-data; charset=utf-8 ```

CSV file format and schema

##### Content rules and schema of ad spend CSV files
Category Column Name Type Description Required
Group by date string The date the spend was incurred.
The date must be in the format 'YYYY-MM-DD' This date should correspond with the timezone set in the Airbridge app. Future dates are not permitted. Upload requests that violate this condition will not be processed. 		**Required**
Group by channel string The channel. **Required**
Group by event\_category string The event category.
It is viewed as a metric name in the report. 		**Required**
Metric event\_value double The event value. **Required**
Group by campaign string The campaign. Optional
Group by ad\_group string The ad group. Optional
Group by ad\_creative string The ad creative. Optional
Group by content string The content. Optional
Group by event\_source string The event source.
`app`, `web`, `tracking_link`, `sms_link` (case-sensitive) 		Optional
Group by os\_name string The OS Name.
Be aware that data in columns with a type defined as 'string' is case-sensitive.
e.g. Android, iOS 		Optional
Group by term string The term. Optional
Group by country string 2-digit lowercase country value.
e.g. kr, us, gb, fr 		Optional
Group by currency string The currency.
Must use capitalized, three-letter currency codes that comply with ISO 4217.
e.g. KRW, USD 		Optional
Group by sub\_publisher string The sub publisher. Optional
Group by sub\_sub\_publisher\_1 string The sub-sub publisher 1. Optional
Group by sub\_sub\_publisher\_2 string The sub-sub publisher 2. Optional
Group by sub\_sub\_publisher\_3 string The sub-sub publisher 3. Optional
Group by is\_first\_event\_per\_device\_id boolean Whether the first event is based on device ID.
true or false (case-sensitive) 		Optional
Group by is\_first\_event\_per\_user\_id boolean Whether the first event is based on user ID.
true or false (case-sensitive) 		Optional

Sample CSV File

* [Example CSV File](https://static.airbridge.io/samples/Self-serve_sample.csv)

🚧 Case Sensitivity

Please be aware that data in columns with a type defined as 'string' is case-sensitive. Note that Airbridge records mobile OS names as 'Android' and 'iOS'. When uploading your data, it's essential to use 'Android' and 'iOS' for OS names. Failure to do so may result in separate rows in the dashboard when data is grouped by results. Please adhere to this naming convention for consistency and accurate data representation.

**Overwrite Previously Ingested Metric Data**

Previously ingested metric data can be overwritten by using CSV files that contain data with the identical key of data previously ingested. The key is formed from the 'date', 'channel', and 'event\_category' fields. If the keys match, data ingested last overwrites data previously ingested. ##### \[Example A] **1. 2022-08-03:** Upload for date, channel, campaign and ad\_group. | date | channel | campaign | ad\_group | event\_category | event\_value | | ---------- | -------------- | --------------------- | ------------ | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_female | self\_event | 100000 | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_male | self\_event | 80000 | **2. 2022-08-04:** Upload for date, channel and campaign. | date | channel | campaign | event\_category | event\_value | | ---------- | -------------- | --------------------- | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | self\_event | 150000 | **3. Result:** Spend data from '2022-08-03' was overwritten by data from '2022-08-04' because '2022-08-04' was last ingested and the identical key is the same. (ad group is overwritten null) | date | channel | campaign | event\_category | event\_value | | ---------- | -------------- | --------------------- | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | self\_event | 150000 | ##### \[Example B] **1. 2022-08-03:** Upload for date, channel and campaign. | date | channel | campaign | event\_category | event\_value | | ---------- | -------------- | --------------------- | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | self\_event | 100000 | **2. 2022-08-04:** Upload for date, channel, campaign and ad\_group. | date | channel | campaign | ad\_group | event\_category | event\_value | | ---------- | -------------- | --------------------- | ------------ | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_female | self\_event | 150000 | **3. Result:** Based on the values 'date', 'channel', and 'campaign', the data was overwritten by '2022-08-04' (ad\_group value are also updated.) | date | channel | campaign | ad\_group | event\_category | event\_value | | ---------- | -------------- | --------------------- | ------------ | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_female | self\_event | 150000 | ##### \[Example C] **1. 2022-08-03:** Upload for date, channel, campaign and ad\_group. | date | channel | campaign | ad\_group | event\_category | event\_value | | ---------- | -------------- | --------------------- | ------------ | --------------- | ------------ | | 2022-08-01 | owned\_website | promotion\_campaign | 2030\_female | self\_event | 10000 | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_female | self\_event | 100000 | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_male | self\_event2 | 80000 | **2. 2022-08-04:** Upload for date, channel, campaign and ad\_group. | date | channel | campaign | ad\_group | event\_category | event\_value | | ---------- | -------------- | --------------------- | ------------ | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_male | self\_event | 90000 | | 2022-08-01 | owned\_website | ua\_campaign | 2030\_female | self\_event | 120000 | **3. Result:** Based on the values 'date', 'channel', and 'campaign', the data was overwritten by '2022-08-04' | date | channel | campaign | ad\_group | event\_category | event\_value | | ---------- | -------------- | --------------------- | ------------ | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_male | self\_event2 | 80000 | | 2022-08-01 | owned\_website | retargeting\_campaign | 2030\_male | self\_event | 90000 | | 2022-08-01 | owned\_website | ua\_campaign | 2030\_female | self\_event | 120000 |

Archive Data

If you want a previously uploaded metric to be invisible in a report, please request it through your CSM.

Note

* Only be used as an API token for Owner, In-house Marketer permission accounts. * The order of the columns in the CSV file does not affect the upload functionality. * The maximum size of a CSV file in a single request is 1 MB. * Column values of type string are limited to at least one character and up to 256 characters. * Ensure there are no spaces before or after the column name and value. * event\_category can accept alphabets and numbers. * event\_category cannot contain , " . * New data registered during upload (e.g. self\_serve\_test\_campaign for campaign) will not be visible in the selection options when using a filter. You can use it by entering it in freeform. * If the CSV file has rows where both the groupBy and the event category are the same, the data is displayed in the report as summed values for the same row. * Upload data | date | channel | campaign | event\_category | event\_Value | | ---------- | -------------- | --------------------- | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | self\_event | 150000 | | 2022-08-01 | owned\_website | retargeting\_campaign | self\_event | 100000 | | 2022-08-01 | owned\_website | retargeting\_campaign | self\_event | 10000 | * Display report | date | channel | campaign | event\_category | event\_value | | ---------- | -------------- | --------------------- | --------------- | ------------ | | 2022-08-01 | owned\_website | retargeting\_campaign | self\_event | 251000 | ```text POST theme={"theme":{"light":"github-dark-dimmed","dark":"github-dark-dimmed"}} https://api.airbridge.io/self-serve-data/v1/metric/requests ```

Request

***

Headers

You can specify the language to use for API requests and responses. It follows the ISO-639-1 format. Represents the media type of the resource. Defaults to `application/json`. The key value to use for API requests. Instructions for getting API keys are in "[how to generate API Keys](/en/references/introduction#authorization)". ```shellscript Request theme={"theme":{"light":"github-dark-dimmed","dark":"github-dark-dimmed"}} curl -X POST 'https://api.airbridge.io/self-serve-data/v1/metric/requests' \ -H 'Accept-Language: ko' \ -H 'Content-Type: application/json' \ -H 'Authorization: Bearer {AIRBRIDGE-API-TOKEN}' ```

Response

*** ### 200 | Name | Description | Example | | ---------- | ------------------------------------- | ------------------------------------ | | requestId | The request ID. | 08844672-62d8-4da8-9d48-e14961651e0c | | status | The progress for the upload request. | ingested | | prevStatus | The status before the current status. | validated | | reason | The reason the upload failed. | \{"date": \["invalid date"]} | | createdAt | The date that request was created. | 2022-08-09T08:59:15 | | updatedAt | The date that request was updated. | 2022-08-09T08:59:15 | ```json 200 theme={"theme":{"light":"github-dark-dimmed","dark":"github-dark-dimmed"}} { "reason": null, "status": "uploaded", "createdAt": "2023-01-01T09:00:00", "requestId": "08844672-62d8-4da8-9d48-e14961651e0c", "updatedAt": "2023-01-01T09:00:00", "prevStatus": null } ```