Konnektive CRM
Submit Ticket
  • Konnektive CRM
    • Getting Started!
    • CRM Dashboard
    • Customer Service
      • Customer Service Tutorial
      • Locate a Customer Record
      • Continuity Purchase Profile
      • Refund/Void a Transaction
      • Cancel an Order
      • Cancel or Pause a Subscription
      • Quality Assurance
      • C/S Fulfillment Actions
      • Resend emails to customers
      • Rerun a Declined New Sale
      • Merge Existing Customers
    • CRM Setup
      • Product Setup
        • Product Creation
        • Product Variations
          • Variant Bundles
      • Campaign Setup
        • Creating a Campaign
        • Campaign Categories
        • Campaign Types
        • Adding a Product to a Campaign
          • Common Offer Setups
          • Stagger Fulfillments
          • Stagger Payments
        • Landing Page Setup (Form-Code)
          • Adding Extra Products To Checkout Page (Upsells, Hidden Fees, Free Gifts, Order Bumps)
          • Additional Upsell Pages (Form-Code)
          • Configure Google Analytics
          • Form Code Integration
          • Multiple Product Lander
          • Performing Callbacks after Form Submits (For Dev)
          • Prepaid, Debit Card & Mastercard Redirect (For Devs)
          • Shopping Cart Lander
          • Single Product Lander
          • Upsell Selection on an Upsell Page (For Devs)
          • Wordpress Plugin Setup
            • Using WooCommerce Catalog with Konnektive Checkout Page
        • Auto-Responder Setup
          • Autoresponder Date Formats
        • Shipping Profiles
        • Campaign Coupons
        • Custom Fields
        • eSignature
          • Adding eSignature to Form-Code
        • Adding C.O.D. to Campaigns
        • Taxes
      • Call Center Setup
        • Adding and Editing Call Centers
        • Adding Call Center Agents
        • Setting Call Center Commissions
        • Batch Update Call Center Source Values
        • Cancellation Reasons, Refund Reasons, and Call Dispositions
      • Affiliate Setup
        • Adding and Editing Affiliates
        • Affiliate Tracking Link/String
        • Affiliate Pixels
          • Testing and Troubleshooting CPA Pixels
          • Testing CPC Pixels
        • Affiliate Commissions
        • Setting up an Affiliate User
        • Batch Update Affiliate Source Values
        • General External Affiliate Software/Network Setup
        • Facebook Pixel Setup
    • Fulfillment
      • Add and Editing Fulfillment House
      • Bundle Fulfillment
      • COD Fulfillment
      • Edit Fulfillment Items
      • Fulfillment Batch Update
      • Fulfillment Inventory
      • Fulfillment Status Types
      • Fulfillment Summary Report
      • Shipping Validation
      • Testing Fulfillment through Order Entry
      • Upload Returned Orders
      • Upload Tracking Numbers
      • Cash on Delivery setup
        • C.O.D. Order Entry Option
    • Gateway Setup
      • Gateway List
      • Adding a Gateway
        • Testing Your Gateway Through Order Entry
      • Gateway Integrations
        • accept.blue
        • Acquired
          • Acquired 3DS
          • Acquired V2
        • Adyen
        • Adyen V2
          • Klarna on Adyen V2
          • PayByBank on Adyen V2
          • Afterpay on Adyen V2
        • Affirm
        • Afterpay
        • Amazon Pay API Integration
          • Form Code: Login and Pay with Amazon
        • Apple Pay
        • Authorize.net
        • Bank of America
        • BitPay
        • Braintree
        • Cardinity
        • Cardstream
          • Cardstream - Alternate Payments
        • Celerispay
        • Checkout.com
          • Checkout.com - Alternate Payments
        • CentroBill
        • Corefy
        • Easytransac
        • eMerchantPay V3
          • eMerchantPay - Alternate Payments
        • Everyware
        • Fat Zebra
        • FibonatixV2
        • FlexFactor
        • Gala Technology
          • Gala Technology - Alternate Payments
        • Google Pay API Integration
        • HiPay 3DS
        • Innova
        • iyzico
        • Klarna
        • MARKETFLOW
        • Maverick
        • Merchant Warrior
        • MIDs
        • MojoPay
        • Mollie
        • Moonlight Payments
        • MuchBetter
        • MyCPO
        • NMI
          • NMI - useCustomerVault Configuration
        • NomuPay
          • NomuPay - Alternate Payments
          • Klarna on NomuPay
        • OpenPath
        • PagBrasil
        • Pathly
        • Pay.com
        • PAY.ON
        • Payex-GreenMoney
        • PayGate
        • Paynetworx
        • PayPal Commerce Checkout
          • PayPal Commerce Checkout (Direct API)
          • PayPal Commerce Checkout (Legacy)
          • PayPal Commerce Checkout (SDK)
          • PayPal Seamless Checkout (Form code)
          • PayPal Fastlane
        • Paysafe V2
        • Paystrax
        • PayXpert 3DS V2
        • Pixxles
        • Poynt
        • Priority Payments
        • Quaife
        • Quantum
        • QuickPay
        • Radom
        • RocketGate
        • SafeCharge
        • Sezzle
        • Skrill
        • Solid
        • Splitit
        • Square Payments
          • Square Payments V2
        • Stripe
          • Stripe - Alternate Payments
          • Klarna on Stripe
        • SurePay
        • TruCommerce
        • Truevo
        • Trust Payments
        • TRX
        • UrPay
        • Vantiv
        • WAAVE
        • WEBPAY
        • WhiteLabel (WL) Payments
        • WithReach
        • WorldLine (Bambora)
        • Worldline V2
          • Worldline V2 - Alternate Payments
        • Worldnet
        • Worldpay
      • Advanced Transaction Routing Interface (ATRI)
        • ATRI Algorithms
        • Cascade Profiles
        • ATRI Settings and Notifications
      • Recycle Billing
      • Standard BIN Mapping
      • PrePaid BIN Mapping
      • Decline Message Mapping
      • Dynamic Descriptors
      • RDR
      • Ethoca Refunds
      • Staggered Rebills Feature
      • Basic 3DS Instructions
      • dLocal Properties
      • Zero dollar card verification
    • Reports
      • Affiliate Report
      • Cancellation Report
      • Chargeback Details Report
      • Continuity Report
      • Customer Service Report
      • Fulfillment Details
      • Key Performance Indicators - KPIs
      • Order Details
      • Order Summary
      • Projected Billing Report
      • Reserve Report
      • Retention Report
      • Transaction Details Report
      • Transaction Summary Report
      • UTM Filters
      • Customer Details Report
    • Admin Setup
      • Plugins
        • Accounting
          • QuickBooks Online Plugin
        • Affiliate Systems
          • Everflow Integration
            • Everflow
          • Trackfiliates
            • CheckoutChamp
        • Analytics and Reporting
          • Wicked Reports
        • Authentication
          • PAAY Plugin
            • Authenticating with PAAY 3DS on Landers
          • PAAY 3RI
        • Chargeback Management
          • ChargebackHelp
          • Fraud Deflect
          • Ethoca
          • Midigator
          • Optimal Alerts
        • Data Sources
          • ClickBank
          • FluidPay Account Updater
          • Gorgias
          • HubSpot
          • Re:amaze
          • ShipEngine
          • Smarty
          • Zapier
          • Zendesk
        • Debt Collection
        • Email Service Providers
          • Active Campaign Deep Integration
          • Constant Contact
          • ConvertKit
          • Email Service Provider General Set Up
          • Email Service Provider Plugins
          • InboxFirst
          • Infusionsoft/Keap
          • Klaviyo
          • Mailchimp
          • Maropost
          • Ontraport
          • Sendgrid
          • SendLane
          • TxtFlo
          • ClickSend (Data Shuttle)
        • Express Consent
          • Expressed Consent
          • Expressed Consent CRM Configuration
          • Expressed Consent Guidelines
        • FlexPay
          • FlexPay Plugin
        • Fraud Services
          • Fraud Manager
          • Kount Enterprise
          • Device Data Collector Pixel (DDC Pixel)
          • IPQS
          • Sift
          • NoFraud
        • Fulfillment Houses
          • General Fulfillment House Setup
          • AliExpress
          • CJ Dropshipping
          • ShipBob
          • Shiphero
          • ShipStation
          • mintsoft
          • Fulfillment by Amazon
          • FTP Fulfillment Option
          • Save Rack
          • DesktopShipper
          • Fulfillplex
          • Amware
          • Store Pickup
        • IVR Systems
        • List Management Services
          • Red Crane Media
          • Sociallity
        • Membership Services
          • General Membership Club Plugin Setup
          • CustomClub
          • MemberMouse
          • Circle.so Webhook Guide
          • Kajabi Webhook Guid
        • Phone Switches
          • Five9 Sales Agent Call Pop
          • ViciDial
          • Ytel
        • RMA Services
        • Sales Call Tracking Services
        • Shipping Services
          • InsureShip
          • Route
        • SMS
          • SendPlex SMS Plugin
          • Twilio SMS Setup
        • SMTP Maintenance
          • SMTP Maintenance Setup
          • Sendgrid SMTP Profile
          • Maropost SMTP Profile
          • Gmail SMTP Profile
        • Tax Services
          • Interpayments
          • Avalara Tax
            • Add Avalara Tax to a Campaign
            • Add Freight Tax to Shipping
            • Add Tax Code to Products
            • Enabling and Setting Up the Avalara Tax Plugin
            • Order Entry
          • Tax Jar
            • Add Freight Tax Code to Shipping
            • Add Tax Code to Products
            • Add TaxJar to Campaigns
            • Tax Jar Address Verification- Customer Service/ Order Entry
            • Tax Jar Support Page
        • Telehealth
          • Beluga EHR
        • Twilio SMS Setup
          • Sendgrid SMTP Profile
          • SMTP Setup
        • Upsell
          • Integrated Upsell Program
      • Create a User
      • Create an Affiliate User
      • Create An API User
      • Import
        • Import Coupons
      • Export Webhook Profiles
        • Export Webhook Field Mapping Options
        • FTP Export Profile
        • Postback Export Profiles
      • Zones
      • Blacklist
      • Whitelist
      • Event Logs
      • Test Cards
      • Horizontal Migrations
      • Enable Automatic Cancel on Refund and Void
      • Create a Sub Account
      • Fraud Protection
      • Legacy Data Import
        • Activating Sticky.io Plug In
        • PGP Encryption Procedures
      • Leads Agents
    • Frequently Asked Questions
      • Affiliate Tracking FAQs
      • Developer FAQs
      • Fulfillment FAQs
      • General CRM FAQs
      • Order Processing FAQs
      • Reporting FAQs
    • How-to articles
      • Force Bill a Purchase
      • Submit a CRM Support Ticket
    • Click-to-Cancel
  • API Documentation
    • API Documentation
      • Recommended API Flow
      • Performing API Calls
  • Policies
    • EULA
    • Privacy Policy
    • Acceptable Use Policy
    • Billing Policy
Powered by GitBook
LogoLogo

Konnektive Links

  • CRM
  • Need more help?

No Account?

  • Schedule Sales Demo
On this page
  1. Konnektive CRM
  2. Reports

Retention Report

PreviousReserve ReportNextTransaction Details Report

Last updated 8 months ago

The Retention Report is found under Reports → Customers → Retention

This report will show the cycle-by-cycle statistics for your recurring offers.

Use the Date Range and Filter selections to determine what the report will display data for.

This report always searches by Purchase Created Date. This means that the report will only display purchases that were initially created within the selected date range.

Filter Definitions
  • Campaign : Filter for purchases within a specific Campaign.

  • Campaign Category : Filter for purchases within a specific Campaign Category.

  • Product : Filter for purchases where a specific product was purchased.

  • Campaign Product : Filter for purchases where a specific campaign product was purchased.

  • Affiliate : Filter for purchases that came from a specific affiliate.

  • Call Center : Filter for purchases that came from a specific Call Center.

  • Agent : Filter for purchases that came from a specific Agent within your account.

  • Base Currency : Filter for purchases that were processed in a specific base currency.

  • Country : Filter for purchases that bought from a specific country.

  • Credit/Debit : Filter for purchases that used a Debit or Credit card.

  • Card Type : Filter for purchases that used a specific card type/brand.

  • 3DSecure : Filter for purchases that are Protected or Not Protected.

  • Max Cycle : Display data up to a specific cycle.

Click the green Search button once you have made your filter selections. Once a search is submitted, scroll down to view the charts and data tables.

The charts provide a visual representation of the cycle-by-cycle retention rate for the purchases that fit within the filters you’ve selected. You may select to view the chart as a bar graph or a line graph.

The table at the bottom of the page shows statistics for each cycle that has occurred for the filtered data. This table can be viewed By Campaign, By Source, By Call Center, or By Gateway

Table Definitions

By Campaign: See a breakdown of the data by campaign. This data can be further expanded by the products within the campaign by clicking on the green triangle next to the campaign name.

By Source: See a breakdown of the data by source (affiliate). This data can be further expanded by the PublisherId and SubAffiliateId under an affiliate by clicking on the green triangle next to the Affiliate’s name.

By Call Center: See a breakdown of the data by call center. This data can be further expanded by the agents within the Call Center by clicking on the green triangle next to the Affiliate’s name.

By Gateway: See a breakdown of the data based on the gateway used for the purchases.

By Product: See a breakdown of the data based on the base product of the purchases.

Retention Report Table and Header Definitions

Scroll to the right on the table to view data for every cycle that has elapsed for the filtered data.

Initial

  • Purchases : Total number of initial purchases started (There may be several purchases on a single order)

  • Orders : Number of approved and completed initial orders

  • Cancels : Number of purchases canceled within cycle 1

  • Chargebacks : Number of Chargebacks within cycle 1

  • Gross : Gross revenue generated within cycle 1

  • Partial Refund : $ amount of partial refunds issued on cycle 1

  • Full Refund : $ amount of full refunds issued on cycle 1

  • Expenses : Product Costs + Shipping Costs + Transaction Fees + Discount Rate Fees

  • Commissions : Main Offer Commissions (Step 1) + Upsell Commissions (Step 2) Paid to Affiliates

  • CPA(Cost per Acquisition) : (Total commissions for cycle)/(Total approvals for cycle)

  • Net : Net Revenue = Gross Revenue - Chargebacks - Refunds - Expenses - Commissions

Cycles 2+

  • Attempted : Number of purchases attempted within the billing cycle.

  • Approvals : Number of approvals in the billing cycle. This includes Recycle Saves.

  • Soft Declines : Number of soft declines in the billing cycle (Can be re-attempted/recycled)

  • Hard Declines : Number of hard declines in billing cycle (Ex. Stolen Card - Will not be re-attempted/recycled)

  • Pending : Purchases that have not billed yet for the billing cycle; Or Soft Declines set to be re-attempted through Recycle Billing.

  • Retention : Approvals / Initial Purchases

  • Approval % : Approvals / (Approvals + Soft Declines + Hard Declines)

  • Recycle Save : Number of purchases approved due to Recycle Billing. Recycle Saves are included in the approvals count in the cycle. Retention % for each recycle # is equal to: Saves / Initial Orders

  • Cancels : Number of purchases cancelled during the billing cycle.

  • Chargebacks : Number of chargebacks during the billing cycle.

  • Gross : Gross Revenue for the billing cycle.

  • Partial Refund : $ amount of partial refunds issued on the billing cycle.

  • Full Refund : $ amount of full refunds issued on the billing cycle.

  • Expenses : Product Costs + Shipping Costs + Transaction Fees + Discount Rate Fees for the billing cycle

  • Net : Gross Revenue - Chargebacks - Refunds - Expenses for the billing cycle

Totals

  • AVG LTV: Average Lifetime Value = (Total Net Revenue After All Cycles / Initial Purchases

  • Gross: Total Gross Revenue after all cycles

  • Net: Total Net Revenue after all cycles (Total Gross Revenue - Chargebacks Total - Refunds Total - Total Expenses - Total Commissions)

You can hover over any items in blue to see a further breakdown.

Chargebacks

Expenses

Product Costs and Shipping Costs are entered into the base product configuration.

Transaction Fees, Discount Fees, and Chargeback Fees are entered into the gateway configuration.

The system cannot calculate expenses if they are not added into the CRM. The example above shows that no product or shipping costs have been added to the base products, meaning the CRM was not able to calculate those values.

Recycle Breakdown

Attempt: Recycle Number Saves: Number of Approvals Through Recycle Ret%: Saves / Initial Orders

Pending

Not Billed Yet: Purchases that have not billed yet for the cycle The purchase is currently in a previous cycle and has an active or trial status and has not attempted to bill the cycle in question yet. This is often a trial extension to save a sale by customer service.

In Recycle: Purchases currently set to re-attempt in Recycle Billing

Billing Breakdown

The Billing Breakdown, which pops up when you hover over the Approval % value, shows the results of billing for that cycle. The billing breakdown describes where a purchase landed/ended up for that cycle, and the breakdown will only display recycle numbers that purchases ended at.

Each purchase will only be counted once in the Billing Breakdown. The table shows a summary of the end results of billing for the purchases. The table does not show all transactions attempted!

The Recycle Attempts displayed on the table are dependent on the following:

  1. The amount of recycle attempts that are configured within the Recycle Billing profile(s).

  2. If a purchase’s final attempt occurred on a recycle attempt.

Ex) If you have 4 Recycle Billing attempts, but Recycle Attempt 3 does not have any successes nor any declines that would prevent further billings, then Recycle 3 will not display on the table.

In this example, there were 146 purchases that were attempted to be billed for this cycle.

69 purchases successfully billed on the initial rebilling attempt 4 purchases soft declined on the initial rebilling attempt and were not re-attempted 11 purchases hard declined on the initial rebilling attempt and were not re-attempted

(69 successes / 146 total purchases attempted to rebill for this cycle) X 100 = 47.26% initial approval rate

Recycle 1

10 purchases successfully billed on the 1st recycle billing attempt for this cycle 0 purchases soft declined on the 1st recycle billing attempt and were not re-attempted 9 purchases hard declined on the 1st recycle billing attempt and were not re-attempted

((69 initial successes + 10 recycle1 successes) / 146 total purchases attempted to rebill for this cycle) X 100 = 54.11% approval rate after 1st recycle billing attempt

Recycle 2

3 purchases successfully billed on the 2nd recycle billing attempt for this cycle 0 purchases soft declined on the 2nd recycle billing attempt and were not re-attempted 1 purchase hard declined on the 2nd recycle billing attempt and were not re-attempted

((69 initial successes + 10 recycle1 successes + 3 recycle2 successes) / 146 total purchases attempted to rebill for this cycle) X 100 = 56.16% approval rate after 2nd recycle billing attempt

Recycle 3

1 purchase successfully billed on the 3rd recycle billing attempt for this cycle 9 purchases soft declined on the 3rd recycle billing attempt and were not re-attempted 1 purchase hard declined on the 3rd recycle billing attempt and were not re-attempted

((69 initial successes + 10 recycle1 successes + 3 recycle2 successes + 1 recycle3 success) / 146 total purchases attempted to rebill for this cycle) X 100 = 56.85% approval rate after 3rd recycle billing attempt

Recycle 4

2 purchase successfully billed on the 4th recycle billing attempt for this cycle 25 purchases soft declined on the 4th recycle billing attempt and were not re-attempted 1 purchase hard declined on the 4th recycle billing attempt and were not re-attempted

((69 initial successes + 10 recycle1 successes + 3 recycle2 successes + 1 recycle3 success + 2 recycle4 successes) / 146 total purchases attempted to rebill for this cycle) X 100 = 58.22% approval rate after 4th recycle billing attempt

Total

85 purchases successfully rebilled in total 38 purchases resulted in soft declines in total 22 purchases resulted in hard declines in total

85 + 38 + 22 = 146 = total number of purchases attempted to rebill for this cycle)

85 (successes) / 146 (attempted) X 100 = 58.22% Approval Rate

  • Ex) To find purchases due to bill on cycle 3, use the filters on the Continuity Report to filter to Active purchases on cycle 2 (the last successful cycle billed for the purchase) with a Next Bill Date that reaches past your billing interval.

Use the Rebills Calendar on the Dashboard to easily see rebill results and scheduled billings.


Retention Rate Calculation Notes:

Please note that this report considers purchases in "pending" status into the retention calculation. A pending order is any order that is in a previous cycle, in an active status and has not attempted to bill the cycle in question yet. This is often a trial extension as a save a sale by customer service, or the customer’s rebill date hasn’t occurred yet for that particular cycle.

Our calculation removes the trial extensions from the divisor. So that the calculation becomes: retention = approved / (orders - pending). It's important to note that orders in a recycle status still count against you. Another way to break the equation down this way: retention = approved / (approved + declined + recycles + cancels), as it allows you greater visibility into different factors affecting your retention rate.

Retention Calculation Example for Cycle 2:

Total Purchases: 3544

cycle/2/approved: 2647

cycle/2/declined: 367

cycle/2/recycles: 32

cycle/2/pending: 4

cycle/1/cancels: 494 (always the previous cycle's cancels)

All those columns are available in the CSV export

Equation #1:

retention = approved / (orders - pending) = 2647 / (3544 - 4) = 0.74774

Equation #2:

retention = approved / (approved + declined + recycles + cancels) = 2647 / (2647 + 367 + 32 + 494) = 0.74774

Being able to express the retention rate both ways gives us a useful check to ensure our numbers are always accurate.

You can use the to view detailed information about purchases and/or check the Retention Report calculations. Useful filters include: Date Range Type, Status, Billing Cycle, Recycle #, and Last Decline Type.

See the for detailed information about the individual transactions.

Continuity Report
Transaction Details Report