Cost Manual Upload Process

Kochava provides a manual upload process for Media Partners that do not have an API.

WARNING: Any data uploaded via this process is permanent and cannot be edited or deleted. Please keep accurate records of uploads, so that duplicate data is not created by overlapping dates. Recommend uploading on a specific cadence like daily or Mon-Sun to ensure no duplicate data is created.

---

Cost Configuration User Interface

---

Creating a Manual Upload Configuration

NOTE: Only Media Partners with the upload icon are eligible for this process.

NOTE: By default, the current user’s email address who is setting up the configuration will automatically entered into the Notifications field.

8. Click Save.

NOTE: Manual Upload files will need to be requested from the Media Partner’s UI or representative – and be in the CSV format with a single tab. If the file does not match Kochava’s column mapping the file needs to be edited or the upload will fail.

BEST PRACTICES: When working to integrate each Media Partner, Kochava requests the base report file, so that any subsequent reports used for upload will hopefully be the same and not require editing. However, the best practice is to verify the file to make sure the column headers match – in the event that the report was changed or is a different type.

---

Google Sheet Upload:

The manual upload process may also be completed utilizing Google Sheets.

NOTE: Files may contain multiple days, but only a single tab. Any additional tabs in the spreadsheet will be ignored. Date format must be mm-dd-yyyy. For example: 2-26-2022 must be formatted as 02-26-2022.

CAUTION: Any data uploaded via this process is permanent and cannot be edited or deleted. Please keep accurate records of uploads, so that duplicate data is not created by overlapping dates. Recommend uploading on a specific cadence like Mon-Sun to ensure no duplicate data.

---

Uploading Additional Files:

To add additional files after the initial upload:

1. Click on the Configuration Edit (⋮) button.
2. Click Upload New File.
3. Follow the procedures from the upload process above.

NOTE: Some configuration values will persist from the original upload, but others may need to be entered again before clicking Save.

---

Daily Cost Data Ingestion

This option is designed for ongoing, day-to-day cost reporting through a CSV file upload.

---

Historical Data Ingestion (Backfill)

This option is designed for media partners that have historical cost data that needs to be backfilled.

---

Data Restatement & Resync Mechanisms

To account for late-arriving data or corrections to previously reported spend, the system supports comprehensive data restatement.

Standard Daily Restatement (≤ 7-Day Window)

• The system supports automatic cost data restatement for a maximum of 7 days from the current date.
• If updates are available within this rolling 7-day window, users simply re-upload the respective YYYY-MM-DD.csv file. The system will automatically detect the file and sync the updated data.

Extended Restatement (> 7-Day Window)

• For data corrections falling outside the standard 7-day window, automatic syncing is disabled to protect historical data integrity.
• You must explicitly utilize the “Daily Resync” action in the portal after uploading the updated dated file to force the restatement.

Status View Resync Initiation

Observability & System Monitoring

To ensure data fidelity and provide transparency, the connector portal includes a robust observability layer for customers and account managers.

• File-Level Tracking: Every uploaded file (both daily and backfill) is tracked with an explicit state: Pending, Processing, Success, or Failed.
• Error Logging: In the event of a Failed status, the UI exposes detailed error descriptions, enabling users to quickly identify and remediate formatting or data discrepancies before attempting a re-upload.