New Sales Report

Analyze first-cycle transaction performance including approval rates, customer acquisition, and order success across all sales channels.

The New Sales Report focuses exclusively on first-cycle (initial) transactions — the very first charge attempt for each order. This gives you a precise view of your sales funnel performance: how many transactions were attempted, how many succeeded, how many customers you acquired, and how much revenue those initial orders generated. It's your go-to report for understanding acquisition efficiency.

What This Report Includes

This report covers all first-cycle transactions grouped by the date the offer was created. It includes both direct sale transactions and authorization-then-capture flows, giving you a complete picture of initial order activity.

Transactions Included:

  • First-cycle transactions only (initial billing cycle, excludes rebills and subscription renewals)
  • Sale and authorization transaction types
  • Looks at the transaction's line items
  • Test orders are excluded
  • Date range is based on Order Created Date (when the order was created)

Why This Matters: Your initial sale is the entry point for every customer relationship. Understanding approval rates, decline patterns, and the mix of recurring vs. one-time sales helps you optimize both your acquisition funnel and your payment processing strategy.

📘

Revenue calculations depend on your Company Profile settings for shipping and tax inclusion.


Report Metrics

Total Transactions

The total number of first-cycle transaction attempts during the period, including both successful and declined transactions. This is your top-of-funnel number — every attempt to process an initial order.

Successful Transactions / Successful Transactions Rate

The number and percentage of first-cycle transactions that were approved by the payment processor. Your successful transaction rate is one of the most important operational metrics — it directly determines how much of your sales effort converts to revenue.

Declined Transactions / Declined Transactions Rate

The number and percentage of first-cycle transactions that were declined. Declines represent lost revenue and potentially lost customers. Breaking down decline reasons (available in other reports) helps identify whether the issue is with card quality, processor routing, or fraud filters.

Authorizations / Successful Authorizations / Successful Authorization Rate

Authorization transactions reserve funds on a customer's card without immediately capturing payment. The successful authorization rate shows how often these holds are approved. A low authorization rate may indicate issues with your payment gateway configuration or the customer payment methods being used.

Declined Authorizations / Declined Authorization Rate

Authorizations that were rejected by the payment processor. These customers had their card checked but funds could not be reserved.

Captured Authorizations / Captured Authorization Rate

The number and percentage of successful authorizations that were subsequently captured (converted to actual charges). A gap between successful authorizations and captured authorizations may indicate fulfillment delays, order cancellations, or manual review processes.

Sales / Successful Sales / Successful Sale Rate

Direct sale transactions (where authorization and capture happen simultaneously) and their success rate. Most subscription businesses primarily use sale transactions rather than auth-then-capture flows.

Declined Sales / Declined Sale Rate

Direct sale transactions that were declined by the payment processor.

Total Customers

The number of unique customers who had at least one first-cycle transaction attempt during the period. Each customer is counted once regardless of how many transaction attempts they had.

Successful Customers / Successful Customer Rate

Customers who had at least one successful first-cycle transaction. This is your true customer acquisition number — the people who actually completed a purchase.

Declined Customers / Declined Customer Rate

Customers whose first-cycle transactions were all declined. These are potential customers you failed to convert due to payment issues. Reducing this number through better payment routing or retry logic directly increases your customer base.

Total Orders

The total number of unique orders attempted during the period. An order may contain multiple transaction attempts if the first attempt was declined and retried.

Successful Orders / Successful Order Rate

Orders that resulted in at least one successful transaction. This rate accounts for retry logic — an order that failed on the first attempt but succeeded on a retry is counted as successful.

Declined Orders / Declined Order Rate

Orders where all transaction attempts were declined. These represent fully lost sales opportunities.

Recurring Transactions / Recurring Transactions Rate

The number and percentage of successful first-cycle transactions that are associated with recurring subscriptions. This tells you what share of your new sales will generate ongoing revenue.

One Time Sale Transactions / One Time Sale Transactions Rate

Successful first-cycle transactions that are one-time purchases with no recurring component. Tracking the mix of recurring vs. one-time helps you forecast future revenue.

Revenue

The total revenue generated from successful sale transactions and captured authorizations during the period. This represents actual money collected from first-cycle orders. Only successful, non-declined transactions contribute to this number.


Available Dimensions

Dimensions let you group, filter, and drill into your data. Select any dimension to break down your metrics by that attribute.

DimensionDescription
Order Created DateThe date the order was created
Order Created HourHour of day the order was created
Order Created Day Of WeekDay of the week the order was created
Order Created WeekYear-week of the order
Order Created MonthYear-month of the order
Order Created YearYear the order was created
Customer EmailCustomer's email address
Customer IDCustomer identifier
Customer InformationCombined name, email, and phone for quick lookup
ConnectionThe connection (storefront) the customer belongs to
Order IDOrder identifier
Order Offer IDOrder-offer line item identifier
Offer StatusCurrent status of the offer
Transaction AttemptThe attempt number for this charge
Transaction CycleThe billing cycle number
Is BlacklistWhether the customer is blacklisted
OfferThe offer associated with the transaction
Offer NameOffer name (text-searchable)
Offer CodeOffer code identifier
Primary Offer CategoryPrimary category assigned to the offer
Secondary Offer CategorySecondary category assigned to the offer
ItemThe item on the transaction
Item SKUSKU of the item (uses shipped SKU if available)
Item CategoryCategory of the item
CampaignThe campaign attributed to the order
Primary Campaign CategoryPrimary category assigned to the campaign
Secondary Campaign CategorySecondary category assigned to the campaign
Is Prepaid OfferWhether the offer is a prepaid subscription
Discount CodeCoupon or discount code applied
Discount NameName of the discount applied
MerchantThe merchant account used for the transaction
Merchant GroupMerchant group the account belongs to
Primary Merchant CategoryPrimary category assigned to the merchant
Secondary Merchant CategorySecondary category assigned to the merchant
ProcessorPayment processor name
GatewayPayment gateway used
Payment RouterThe payment router used for transaction routing
Payment MethodPayment method type (credit card, PayPal, etc.)
CurrencyTransaction currency
Card TypeCard brand (Visa, Mastercard, etc.)
Card Bin NumberFirst 6 digits of the card number
Card Bin Number + Card Last 4BIN and last 4 combined
Card Last 4Last 4 digits of the card number
Card IssuerIssuing bank name
Card CategoryCard category (consumer, business, etc.)
Card CountryCountry of the card issuer
Is Prepaid CardWhether the card is a prepaid card
Gateway Response CodeResponse code returned by the gateway
Gateway AVS CodeAddress Verification System response code
Gateway CVV CodeCVV verification response code
Gateway Transaction IDGateway's transaction reference ID
Processor ResponseResponse text from the payment processor
Transaction TypeSale, capture, refund, void, chargeback, or alert
Transaction Created UserUser who created the transaction
Alert|Chargeback CodeReason code for alerts or chargebacks
3DS Verified Status3D Secure verification status
Ship CountryCustomer's shipping country
Ship StateCustomer's shipping state
Tracking 1–20Custom tracking parameters on the order

Key Business Insights

  1. Successful transaction rate is your conversion rate for payments. Even small improvements — from 85% to 88% — translate to significant revenue gains at scale. Monitor this daily and investigate any sudden drops immediately.

  2. Customer success rate vs. transaction success rate reveals retry effectiveness. If your customer success rate is higher than your transaction success rate, your retry and routing logic is recovering sales that would otherwise be lost.

  3. Recurring transaction rate predicts future revenue. A high percentage of recurring first-cycle sales means your new sales are creating long-term value, not just one-time revenue spikes.

  4. Order success rate is the truest measure of sales performance. Because it accounts for retries within an order, it shows your actual ability to convert purchase intent into completed sales.

  5. Declining authorization capture rates may indicate operational issues. If you authorize successfully but don't capture, investigate whether fulfillment bottlenecks or manual review queues are causing delays.


Optimization Strategies

Improve Transaction Approval Rates Work with your payment processor to optimize routing rules, ensure billing information collection is thorough, and implement intelligent retry logic for soft declines. Even a 1-2% improvement in approval rates compounds into substantial revenue over time.

Reduce Customer Decline Rates Analyze declined customers to identify patterns — are declines concentrated in certain geographies, payment types, or offer price points? Use this data to adjust your checkout flow, add alternative payment methods, or implement address verification.

Optimize the Recurring vs. One-Time Mix If your business model favors recurring revenue, test strategies to convert one-time buyers into subscribers — such as subscribe-and-save discounts, subscription upsells on the thank-you page, or defaulting to recurring at checkout.

Monitor Authorization-to-Capture Gaps If you use auth-then-capture flows, ensure the time between authorization and capture is minimized. Authorizations expire, and customers may dispute charges they don't remember authorizing days earlier.


Pro Tips

  1. Enable hidden columns for deep analysis. The default view shows the most important metrics, but enabling columns like Declined Authorization Rate or One Time Sale Rate can reveal specific optimization opportunities.

  2. Compare weekday vs. weekend performance. Transaction approval rates often vary by day of week due to bank processing patterns. Understanding these patterns helps you time promotions and set realistic daily targets.

  3. Use this alongside the Subscriptions LTV Report. New Sales tells you how well you acquire customers; Subscriptions LTV tells you how much those customers are worth. Together, they give you the full acquisition-to-value picture.

  4. Watch for declining order success rates over time. A gradual decline may indicate your traffic quality is changing, your fraud filters are too aggressive, or your payment processor needs attention.


Frequently Asked Questions

Q: Why does this report only show first-cycle transactions? A: This report is specifically designed to measure new sales and acquisition performance. Renewal transactions (cycle 2+) are tracked in the Subscriptions LTV and Sales LTV reports, which focus on lifetime value rather than initial conversion.

Q: What's the difference between a Sale and an Authorization? A: A sale transaction authorizes and captures payment in one step — the customer is charged immediately. An authorization only reserves funds on the customer's card; a separate capture step is needed to actually collect payment. Both are tracked in this report.

Q: Can a single customer appear in both the Successful and Declined counts? A: No. Each customer is classified based on their best outcome. If a customer had one declined transaction but then a successful one, they are counted as a Successful Customer only.