Campaign ROI Report

The Campaign ROI Report is the highest-level marketing analytics tool in AccuArk. While the Promotion Performance Report focuses on individual promotions and the Coupon Usage Report focuses on individual coupon codes, the Campaign ROI Report aggregates all performance data at the campaign level. It answers the fundamental question every business owner needs answered: Is this marketing campaign making or costing money?

Navigating to the Report

To access the Campaign ROI Report:

1. Open the Marketing module from the main navigation.
2. Click Reports in the Marketing submenu.
3. Select Campaign ROI from the report list.

The report loads with a list of all campaigns that have linked promotions or coupons with recorded activity. Campaigns with no activity (no invoices where their promotions or coupons were applied) are still shown but display zero values for all metrics.

What the Report Shows

The report displays a table with one row per campaign. Each row shows the campaign name, date range (start and end date of the campaign), status, and the following campaign-level metrics:

Total Revenue Influenced

Total revenue influenced is the sum of all invoice revenue (the final invoice total, after discounts and tax) from transactions where at least one of the campaign's promotions or coupons was applied.

This metric captures the full revenue from every transaction that the campaign touched. It does not isolate the incremental revenue generated by the campaign — it includes the entire transaction amount. The assumption is that the campaign's promotion or coupon was a factor in the customer's decision to make the purchase or to purchase more.

Total revenue influenced gives you a top-line number for the campaign's impact on sales. A campaign that influenced $50,000 in revenue is clearly driving significant transaction volume, even if the campaign's discounts were modest.

Total Discounts Given

Total discounts given is the sum of all discount amounts from the campaign's promotions and coupons across all invoices. This is the direct cost of the campaign to your business.

This metric aggregates discounts from all promotion types and coupon codes linked to the campaign. If a campaign has three promotions and two coupon codes, the total discounts given includes the cost of all five.

Compare this number against the campaign's planned budget to determine whether spending is on track. If total discounts given significantly exceeds the budget, the campaign may need tighter controls (lower discount amounts, stricter usage limits, or a shorter run time).

ROI Calculation

The return on investment (ROI) is calculated using the following formula:

ROI = (Revenue Influenced - Total Discounts) / Total Discounts x 100%

This gives you a percentage that represents how much revenue the campaign generated for every dollar spent on discounts:

• An ROI of 500% means the campaign generated $5 in revenue for every $1 in discounts given.
• An ROI of 100% means the campaign generated $1 in revenue for every $1 in discounts — a break-even point in terms of top-line revenue (though the actual profitability depends on your margins).
• An ROI below 100% means the campaign is generating less revenue than it is costing in discounts, which is a warning sign (though it may still be acceptable for customer acquisition or market share goals).

The ROI percentage is displayed prominently in the report and is color-coded for quick scanning: green for strong positive ROI, yellow for moderate ROI, and red for low or negative ROI.

Note that this ROI calculation uses revenue influenced (not profit), so a high ROI does not necessarily mean the campaign is profitable after accounting for cost of goods sold and operating expenses. However, it provides a useful relative measure for comparing campaigns against each other.

Budget Utilization

If a budget limit was set on the campaign during creation, the report shows how much of that budget has been consumed:

• Budget utilization is calculated as: Total Discounts Given / Campaign Budget x 100%.
• A utilization of 75% means three-quarters of the budget has been spent.
• A utilization of 100% or higher means the budget has been fully spent or exceeded.

Budget utilization provides an early warning system. If a campaign is at 80% utilization with two weeks remaining, you may want to tighten the promotion conditions or reduce the discount amounts to ensure the budget lasts the full campaign period.

If no budget limit was set on the campaign, the budget utilization column displays "No budget set" instead of a percentage.

Filtering the Report

The Campaign ROI Report supports the following filters:

• Date range — Filter by the campaign's activity dates to focus on campaigns that were active during a specific period.
• Campaign status — Filter by active, completed, or draft campaigns.

These filters help you focus on current campaigns or review historical performance of completed campaigns.

Cross-Links to Related Reports

The Campaign ROI Report includes links to the underlying detail reports:

• Promotion Performance Report — Click through to see the individual promotion metrics for all promotions linked to a specific campaign. This helps you understand which promotions within the campaign are driving the most usage and cost.
• Coupon Usage Report — Click through to see the coupon-level metrics for all coupon codes linked to a specific campaign. This helps you identify which coupons are being redeemed the most and whether any are being abused.

These drill-down links allow you to start at the campaign level for an executive summary and then dive into the details for any campaign that needs further analysis.

Use Cases

Here are practical ways to use the Campaign ROI Report:

Compare Campaign Effectiveness

Sort the report by ROI percentage to rank your campaigns from most effective to least effective. Campaigns with the highest ROI are generating the most revenue per discount dollar spent. Use these campaigns as templates for future marketing efforts — replicate their promotion types, discount levels, targeting strategies, and distribution channels.

Campaigns with low ROI may need restructuring. Review their linked promotions and coupons in the detail reports to identify what is not working — perhaps the discount is too generous, the targeting is too broad, or the eligible products have low demand.

Justify Marketing Spend

When presenting marketing results to stakeholders or management, the Campaign ROI Report provides the data you need to justify your discount spending. The total revenue influenced number demonstrates the sales impact, the ROI percentage shows the efficiency of the spend, and the budget utilization shows fiscal discipline.

Export the report data for inclusion in presentations, board reports, or budget planning documents. Having concrete ROI numbers transforms the marketing budget conversation from "How much did we spend?" to "What did we get for what we spent?"

Decide Which Campaigns to Repeat or Scale

At the end of a promotional period (quarter, season, or fiscal year), review the Campaign ROI Report to decide which campaigns deserve to be repeated or expanded:

• High ROI, high revenue influenced — Scale these campaigns. They are effective and impactful. Consider increasing the budget, extending the run time, or expanding to additional locations.
• High ROI, low revenue influenced — These campaigns are efficient but have limited reach. Consider wider distribution, additional promotion types, or a longer run time to increase their impact.
• Low ROI, high revenue influenced — These campaigns drive significant revenue but at a high cost. Tighten the discount amounts, add usage limits, or narrow the targeting to improve efficiency.
• Low ROI, low revenue influenced — Discontinue these campaigns. They are neither efficient nor impactful.

This framework provides a structured approach to marketing portfolio management, ensuring that your budget is allocated to the campaigns that deliver the best results.

What to Read Next

• Promotion Performance Report — Drill into individual promotion metrics for deeper analysis.
• Coupon Usage Report — Drill into coupon redemption data for campaigns that include coupon codes.
• Campaign Setup and Management — Learn how to create campaigns and link promotions and coupons for aggregated tracking.