Metric Data Upload - Airbridge Help Center

NoteThe 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.

CSV File Preparation

The metric data shall be uploaded in a CSV file format. Refer to the following sample CSV file.

Sample CSV file for metric data upload

Data input rules

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.

Required rows

Row name	Date type	Description	Example	Row name available as
date	string	Date	2022-01-01	GroupBy; `Event Date`
channel	string	Ad channel	naver.searchad	GroupBy; `Channel`
event_category	string	Event category name	Click-email	Metric and GroupBy; `Category name`
event_value	double	Event value	10000	Metric; `Event Value (App)`

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.

Additional rows allowed

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 Airbridge 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.

Uploading CSV File

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.

Upload status

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.

Troubleshooting

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.

Error codes

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 `0` or `none` depending on the data type.
‘OOO’ cannot be coerced	Unsupported data type in the OOO row.	Make sure to input data in the supported data type.

Overwriting data

The metric data you upload can overwrite the data uploaded before.

Attention

Row names in the CSV file

Only designated row names are allowed in the CSV file. The row names are case-sensitive and space-sensitive.

Abiding by the file format

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.

Data overwriting

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.

Example

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

​CSV File Preparation

​Data input rules

​Uploading CSV File

​Upload status

​Troubleshooting

​Attention

Example

CSV File Preparation

Data input rules

Uploading CSV File

Upload status

Troubleshooting

Attention