The Sales Report by Campaign provides you the total number of orders that you got by campaign (based on currency if applicable) during a specific date range.
The first step in pulling this report will be to click on the down arrow in the search bar to view advanced searching options. Advanced Searching allows you to select the date range criteria for your report. Also, you are able to select a certain currency if your merchant processing involves multiple currencies. You will be able to export the CSV file of your report at any time if you need to.
This report provides you a breakdown of all your sales at the campaign level; the data it provides is data based on relevance, this means that it will only pull up those campaigns with data on them. If a campaign has not had any activity at all, this report will not include it.
The Initial column shows orders from new customers, and the Subscription column shows orders generated from your existing customers who are on an active subscription. The Total column represents the sum of the Initial and Subscription columns; therefore, the Total Revenue column is the sum of the Initial Revenue and Subscription Revenue columns.
The Shipping column indicates the number of shippable orders that you got per campaign, out of the total number of orders. The Shipping Revenue column contains the revenue amount that you generated from shipping charges.
The Declines column contains the total number of unique declines that you got under each campaign, as well as the Decline Revenue amount. If a customer is declined five times, then the report will only show it as one decline and one decline loss. This is the case since you are not losing five orders, you are only losing one order from a customer who attempted an order up to five times with no success.
Also, if a customer makes two order attempts in which the first time was declined, but the second time was successful, the Sales Report by Campaign will not show the declined because the second time was successful. In case this you have not lost any revenue.
The Void/Refund column contains the total of orders that have been voided, and fully refunded, it does not include partial refunds. The Void/Refund Revenue column shows the total amount that has been voided or refunded, including partial refunds. The number of void/refund orders is not included under the total number of orders.
The Hold/Cancels column contains the number of orders that were created within the selected date range which have been placed on hold/canceled. The actual hold/cancellation date of the order may be outside of the selected date range.
The Prior Hold/Cancels column contains the number of products that are on hold/canceled within the selected date range, but the order was created outside the selected date range.
The Hold/Cancels Revenue column contains the total revenue lost from the order being placed on the hold. The lost revenue total is calculated based on the next recurring order the hold/canceled order would have recurred to.
The Chargeback and Chargeback (%) columns show the total number and percentage of orders that have been marked or flagged as chargeback.
The Active Subscriptions column will provide you the total number of active subscription that you have per campaign during the selected date range.
The Average Order column gives you an average order amount based on the total revenue amount and the total number of orders.
The Sales Report by Campaign also provides you a breakdown of how many orders were brought to you by each affiliate. You just have to click the Aff Link Affiliate ID under a particular campaign and the system will open up a new window with a full report by affiliate.
The illustration below provides an example taken from (225) Club A (Recurring Upsell):
From the affiliate report, you can then access the sub-affiliate report by clicking on the Aff Link Sub ID under an Affiliate ID. This report will show you how many orders came through the sub-affiliates under a particular affiliate.
For this example we have taken affiliatexyz1, from the previous illustration: