Performance
Import performance CSV
Paste daily campaign performance rows exported from ads and affiliate reports.
CSV import
Rows are upserted by campaign and date. Derived metrics use the same calculations as manual entry.
Expected columns
Column names are flexible, but this order is recommended for clean imports.
| Column | Required | Notes |
|---|---|---|
| campaignId | Optional | Optional when externalCampaignId or campaignName is provided. This is the internal CommissionFlow campaign ID. |
| externalCampaignId | Optional | Optional when campaignId or campaignName is provided. Use Meta or platform campaign ID when importing ad exports. |
| campaignName | Optional | Optional when campaignId or externalCampaignId is provided. Must match one campaign name. |
| date | Required | Required. Use YYYY-MM-DD or MM/DD/YYYY. |
| spend | Required | Required. Non-negative dollars. |
| impressions | Required | Required. Whole number. |
| clicks | Required | Required. Whole number. |
| landingPageViews | Required | Required. Whole number. |
| leads | Required | Required. Whole number. |
| affiliateClickouts | Required | Required. Whole number. |
| estimatedConversions | Required | Required. Whole number. |
| confirmedConversions | Optional | Optional. Defaults to 0. |
| estimatedCommission | Required | Required. Non-negative dollars. |
| confirmedCommission | Optional | Optional. Defaults to 0. |