Date
- Requirement
- Recommended
- Example
- 2026-06-01
- Purpose
- Creates performance trends
Upload advertising performance data to compare campaign spend, attributed revenue, conversions, ROAS, cost per acquisition, and channel performance.
VizMint converts structured exports from paid media platforms into a clear performance report while showing which metrics depend on attribution, conversion, or customer data.
Supports structured .csv and .xlsx files. Public examples use synthetic data. Review VizMint’s current privacy and retention policy before uploading sensitive information.
Use the fixed preview below to switch between the source spreadsheet and a dashboard sample. Open the full demo in a new tab for every KPI and chart.
ROAS Dashboard
Interactive preview from the sample campaign performance dataset
Switch preview
Total Records
48
rows in sample
Total Impressions
13,177,122
sum of Impressions
Total Attributed Revenue
4,657,245
sum of Attributed Revenue
Bin width 50,000 · 48 observations
Full dashboard with all KPI details and 6 charts is on the demo page.
Open full demoThe sample contains 48 campaign records across 4 campaigns and 2 platforms. Charts and KPI cards are generated from the same JSON dataset.
Sample totals: $1,000,612 spend, $4,657,245 attributed revenue, and 4.65x reported ROAS — clearly separating attributed performance from profit.
Compare advertising spend and attributed revenue while keeping attribution and profit limitations visible.
Marketing metrics can look strong while hiding attribution gaps, different platform windows, or missing costs. The content must distinguish reported campaign performance from verified business profit.
The campaign sample contains $1,000,612 in spend and $4,657,245 in attributed revenue, producing 4.65x reported ROAS while clearly separating ROAS from profit.
The workflow is designed around transparent attribution boundaries, comparison periods, and calculation evidence.
Advertising platforms provide impressions, clicks, spend, conversions, and conversion value, but campaign exports are difficult to compare across periods or channels. A ROAS dashboard brings the important metrics into one visual workflow.
The page must separate attributed revenue from profit and explain when CPA, CAC, or ROAS cannot be calculated.
Follow the same dataset from source rows to the generated dashboard preview. The spreadsheet table, KPI cards, and charts all come from one JSON sample, so every visible result can be checked against the source.
The source preview highlights the exact columns and representative rows used in the analysis.
| Date | Quarter | Campaign | Performance Tier | Impressions |
|---|---|---|---|---|
| 2025-07-01 | Q3 2025 | Brand Search | Excellent | 117,167 |
| 2025-07-01 | Q3 2025 | Non-Brand Search | Strong | 163,939 |
| 2025-07-01 | Q3 2025 | Retargeting | Excellent | 115,916 |
| 2025-07-01 | Q3 2025 | Prospecting | Needs Work | 586,495 |
| 2025-08-01 | Q3 2025 | Brand Search | Excellent | 118,570 |
The finished example is generated from the sample dataset rather than an unrelated mockup or stock image.
Bin width 50,000 · 48 observations
VizMint works best when every column has one clear heading and each row represents one consistent record.
| Column | Requirement | Example | Purpose |
|---|---|---|---|
| Date | Recommended | 2026-06-01 | Creates performance trends |
| Platform | Recommended | Google Ads | Enables platform comparison |
| Campaign | Required | Brand Search | Identifies campaign |
| Ad Group | Optional | Core Keywords | Adds detail |
| Impressions | Optional | 120000 | Calculates CTR |
| Clicks | Optional | 4200 | Calculates CTR and CPC |
| Spend | Required for ROAS/CPA | 5400 | Stores advertising cost |
| Conversions | Required for CPA | 240 | Stores conversion count |
| Conversion Value or Revenue | Required for ROAS | 21000 | Stores attributed value |
| New Customers | Required for CAC | 90 | Calculates customer acquisition cost |
| Leads | Optional | 320 | Supports lead reporting |
| Currency | Recommended | USD | Identifies currency |
Total paid media cost.
Revenue or conversion value attributed to campaigns.
Total recorded conversions.
Attributed revenue divided by ad spend.
Ad spend divided by conversions.
Acquisition spend divided by new customers.
Clicks divided by impressions.
Spend divided by clicks.
Conversions divided by clicks.
| Chart or Output | Required Fields | Business Question |
|---|---|---|
| Spend vs Revenue Trend | Date, spend, attributed revenue | Are returns keeping pace with spend? |
| ROAS by Campaign | Campaign, spend, revenue | Which campaigns are most efficient? |
| Conversion Trend | Date, conversions | How is conversion volume changing? |
| CPA Comparison | Campaign, spend, conversions | Which campaigns acquire conversions at the lowest cost? |
| Platform Comparison | Platform, spend, revenue, conversions | Which channels perform best? |
| Campaign Ranking | Campaign and selected KPI | Which campaigns deserve attention? |
Use clear headers, one record per row, consistent dates, and numeric values stored as numbers.
Select the CSV or Excel file using the page’s upload control.
For multi-sheet workbooks, choose the sheet containing the relevant data table.
Review the detected fields and map any column VizMint could not identify confidently.
Check dates, numbers, categories, missing values, and record counts before generation.
Create the supported dashboard, report, presentation, chart, or answer.
Review calculations and limitations, then save, share, or export using the options available in the active plan.
| Metric | Formula or Method | Required Fields | Important Rule |
|---|---|---|---|
| ROAS | Attributed revenue ÷ advertising spend | Spend and revenue or conversion value | ROAS does not include all business costs. |
| CPA | Advertising spend ÷ conversions | Spend and conversions | Do not calculate when conversions are zero. |
| CAC | Acquisition spend ÷ new customers | Spend and new customers | Leads or conversions are not automatically customers. |
| CTR | Clicks ÷ impressions × 100 | Clicks and impressions | Unavailable when impressions are zero. |
| Conversion Rate | Conversions ÷ clicks × 100 | Conversions and clicks | Definitions must match the source platform. |
| Problem | Recommended Fix |
|---|---|
| Spend and revenue use different currencies | Convert before comparison. |
| Campaign names change | Use stable campaign IDs where possible. |
| Conversion values are missing | Hide ROAS and show spend and conversion metrics only. |
| Different attribution windows are mixed | Label the source and attribution definition. |
| Leads are treated as customers | Use a separate new-customer field for CAC. |
| Totals include test campaigns | Filter invalid or test activity. |
Available options depend on the live VizMint plan. The final page should list only verified capabilities, such as saving the analysis, downloading chart images, exporting PDF or PowerPoint files, creating a shareable link, refreshing with updated data, or removing branding on eligible plans.
Do not publish a plan comparison until product and billing owners confirm every feature.
VizMint analyzes exports; it does not replace the accounting, CRM, help-desk, HR, warehouse, advertising, or project-management system that produced them.
Upload a structured CSV or Excel file, review the detected fields, and generate the workflow-specific output described on this page.