Budget Allocation for CPI, CPA & ROAS input template
A blank CSV containing only the columns this tool reads. Keep these headers for automatic matching where supported; tools with role selection ask you to choose the outcome and features. Data is processed in your browser and never sent to a server.
Budget Allocation for CPI, CPA & ROAS template
13 columns · 4 required roles
Template columns
| Column | Meaning | Type | Required |
|---|---|---|---|
date | Date | date | Required |
country | 국가 | string | Optional |
platform | 플랫폼(OS) | enum | Optional |
channel | Channel | string | One of: channel / campaign_name |
campaign_name | Campaign | string | One of: channel / campaign_name |
cost | Spend | number | Required |
impressions | Impressions | number | Optional |
clicks | Clicks | number | Optional |
installs | Installs | number | One of: installs / actions |
actions | Actions / signups | number | One of: installs / actions |
pu_d7 | 결제건수 D7 | number | Optional |
revenue_d7 | 매출 D7 | number | Optional |
snapshot_date | 데이터 기준일(Snapshot) | date | Optional |
Upload a platform export as is
These files can be uploaded without renaming columns—this tool recognizes the columns it needs. There is no need to copy them into the template.
Meta Ads Manager (Korean UI)
Campaign report broken down by day
| Column in the file | Read as |
|---|---|
일 | Date |
캠페인 이름 | Campaign |
지출 금액 (KRW) | Spend |
노출 | Impressions |
링크 클릭 | Clicks |
앱 설치 | Installs |
Columns not read
광고 세트 이름— These tools work at campaign level.구매 전환값— It follows the attribution window, not days since install, so it is not read as D7 revenue.
Meta Ads Manager (English UI)
Campaign report broken down by day
| Column in the file | Read as |
|---|---|
Day | Date |
Campaign name | Campaign |
Amount spent (USD) | Spend |
Impressions | Impressions |
Link clicks | Clicks |
App installs | Installs |
Columns not read
Ad set name— These tools work at campaign level.Purchases conversion value— It follows the attribution window, not days since install, so it is not read as D7 revenue.
Column names can differ with account language and column settings. If they do, pick the columns yourself on the mapping screen after upload.
Filling it in
- Use
YYYY-MM-DDfor every date. Mixed formats break period comparisons. - Numeric columns may use thousands separators and common currency wrappers such as
₩,$,KRW,USD, or원. Arbitrary text is rejected, so plain numbers remain the safest format. - Missing or invalid required values may exclude a row or stop the analysis, depending on the tool. Check its row and column diagnostics. Zero and blank are treated differently.
- Extra columns are fine—anything this tool does not use is ignored.