Metric Data Upload
Note
The data upload feature is available only to Owner and In-house Marketer users. Agency and Media Partner users cannot access it.
If the [Integrations]>[DATA UPLOAD] menu is not visible on your Airbridge dashboard, check your app role.
You can upload metric data to Airbridge in a CSV file format to add data that is not collected by Airbridge via channel integration or tracking links.
The data can be uploaded on the [Integrations]>[Self-serve Metric Data] page. With the data, you can define the self-serve metrics that you can use in the Overview Dashboard, Acutals Report, and Trend Report.
Self-serve metric data upload is different from cost data upload. For cost data upload, refer to this article.
The metric data shall be uploaded in a CSV file format. Refer to the following sample CSV file.
Make sure to abide by the following data input rules when preparing the CSV file to avoid errors.
GroupBy data shall be input in the same way as displayed in Airbridge so that the data you upload can be aggregated along with the data collected via the SDK and tracking links. For example, if the CSV includes “Android,” the data won’t be aggregated as “android” data because Airbridge displays data as “android,” not “Android.”
The maximum file size for CSV is 1MB with a limit of 10,000 rows.
Make sure no blank fields are included. For string-type data, 1 to 256 characters are allowed.
Only letters and numbers can be used in the event_category field. Special characters (\) are not allowed.
Only designated row names shall be used. Make sure no spaces are included in the row names. No blank cells should be included. The data won’t be uploaded properly if there is a blank cell in the required rows. If there is no data to input, input 0 or none, depending on the data type of the required row.
Row name | Date type | Description | Example | Row name available as |
|---|---|---|---|---|
date | string | Date | 2022-01-01 | GroupBy; |
channel | string | Ad channel | naver.searchad | GroupBy;
|
event_category | string | Event category name | Click-email | Metric and GroupBy; |
event_value | double | Event value | 10000 | Metric;
|
event_category is the name of the self-serve metric. The self-serve metrics can be searched by the event_category name in the Actuals Report. Refer to this article to learn about self-serve metrics.
If the date, channel, event_category combination are the same, add the event_value.
Note that the channel field must be input with the Airbridge dashboard display names so that the uploaded data can be aggregated along with the data Airbridge collects from the ad channels. The Airbridge dashboard display names of the ad channels can also be found on the [Integrations]>[Ad Channel Integration] page in grey.
The date field must be input in the required format. For example, if 2022.01.02 is input in the date row, the data won't be uploaded properly. Make sure you don't enter commas in the event_value row. Data upload may fail when commas are present.
Row name | Data type | Description | GroupBy |
|---|---|---|---|
campaign | string | Campaign name | Campaign |
ad_group | string | Ad group name | Ad Group |
ad_creative | string | Ad creative | Ad Creative |
content | string | Ad content type | Content |
event_source | string | Data source - app - web - tracking_link | Event Source |
os_name | string | Operating System | OS Name |
term | string | Ad keyword | Term |
country | string | 2-digit country code | Country |
currency | string | 3-digit currency code (ISO 4217) | Currency |
sub_publisher | string | Sub publisher name | Sub Publisher |
sub_sub_publisher_1 | string | Sub-sub publisher 1 name | Sub Sub Publisher 1 |
sub_sub_publisher_2 | string | Sub-sub publisher 2 name | Sub Sub Publisher 2 |
sub_sub_publisher_3 | string | Sub-sub publisher 3 name | Sub Sub Publisher 3 |
is_first_event_per_device_id | boolean | Whether the event is the first event that occurred on the device by device ID - true: first event - false: not the first event | Is First Event per Device ID |
is_first_event_per_user_id | boolean | Whether the event is the first event that occurred on the device by User ID - true: first event - false: not the first event | Is First Event per User ID |
For rows such as event_source and os_name, data shall be input in the same way as displayed in Airbridge so that the data you upload can be aggregated along with the data collected via the SDK and tracking links. For example, if the CSV includes “Android,” the data won’t be aggregated as “android” data because Airbridge displays data as “android,” not “Android.”
Airbridge supports the following 2-digit country codes:
kr, jp, us, ru, kz
Airbridge supports the following OS platforms:
Windows, Ubuntu, Tizen, Other, Mac OS X, Linux, iOS, Chrome OS, Android
Airbridge supports the following 3-digit currencies:
KRW, USD, EUR
Don't enter Web in the event_source row. Only web is allowed.
Either TRUE, FALSE or true, false is supported for the is_first_event_per_device_id and is_first_event_per_user_id rows. Don't mix upper and lowercase letters (e.g., True, False) as it will lead to errors in data upload.
Navigate to [Integrations]>[Self-serve Metric Data], and click CSV File Upload.
Drag and drop the CSV file or select your file from the finder.
Make sure you dropped or selected the correct file and click Upload.
Data processing may take up to 10 minutes. After clicking Confirm, you can use other features of Airbridge.
The upload status can be found in the Status column. The upload status is updated automatically.
Refer to the table below for the status details.
Status | Description |
|---|---|
In progress | Your file is being uploaded to Airbridge. It may take up to 10 minutes. |
Failed | Your file could not be uploaded. Click [Action]>[Details] to learn why. |
Success | Your file is successfully uploaded to Airbridge. |
The majority of problems occur when the CSV file does not abide by the designated format or in the process of overwriting. Make sure your network connection status is working.
The error code can be found by selecting [Action]>[View Details]. Refer to the table below to address errors.
Error code | Description | Solution |
|---|---|---|
unknown field | The row name is wrong or unsupported rows exist. | Make sure the file includes row names supported by Airbridge only. |
required field | Required rows don't exist. | Make sure the file includes all required rows. |
empty values not allowed | Blank fields exist in the required row. | Make sure to fill in all required row fields. If there is no data to input, enter |
‘OOO’ cannot be coerced | Unsupported data type in the OOO row. | Make sure to input data in the supported data type. |
The metric data you upload can overwrite the data uploaded before.
Only designated row names are allowed in the CSV file. The row names are case-sensitive and space-sensitive.
The data you input in the CSV file must be in the designated format. The required row fields shall not include blanks. If there is no data to input, enter 0 or none, depending on the data type.
GroupBy data shall be input in the same way as displayed in Airbridge so that the data you upload can be aggregated along with the data collected via the SDK and tracking links. For example, if the CSV includes “Android,” the data won’t be aggregated as “android” data because Airbridge displays data as “android,” not “Android.”
Also, make sure to input the currency row fields with 3-letter currency codes in capital letters. For example, if you input usd instead of USD, the data won't be uploaded properly.
The last uploaded data overwrites the data uploaded before when there are overlapping data in the date, channel, and event_category fields. Refer to the example below.
Let's say you have uploaded the following data as a CSV file.
date | channel | event_category | event_value |
|---|---|---|---|
2023-01-01 | Example-channel | click | 100 |
2023-01-02 | Example-channel | click | 150 |
2023-01-02 | Other | click | 200 |
Later, you upload the following data.
date | channel | event_category | event_value |
|---|---|---|---|
2023-01-02 | Example-channel | click | 200 |
2023-01-02 | Other | view | 400 |
2023-01-03 | Example-channel | click | 300 |
The data overlaps in date, channel, and event_category fields. The data in the file uploaded later overwrites the data in the previously uploaded file. As a result, the event_value (150) of the click on Example-channel for 2023-01-02 is replaced with the event_value (200) of Example-channel for 2023-01-02.
The data you can view in Airbridge after the second data upload is as follows.
date | channel | event_category | event_value |
|---|---|---|---|
2023-01-01 | Example-channel | click | 100 |
2023-01-02 | Example-channel | click | 200 |
2023-01-02 | Other | click | 200 |
2023-01-02 | Other | view | 400 |
2023-01-03 | Example-channel | click | 300 |
このページは役に立ちましたか？