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
        • 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)
        • Algorithms
        • Cascade Profiles
        • 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
  • Transaction Summary Table Header Definitions
  • Additional Notes
  1. Konnektive CRM
  2. Reports

Transaction Summary Report

PreviousTransaction Details ReportNextUTM Filters

Last updated 9 months ago

The Transaction Summary Report is found under Reports → Payments → Transaction Summary

This report is designed to give you an overall summary of the transactions within the selected date range.

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

Filter Definitions
  • Date Range Type :

    • Transaction Created Date : Filter by the date that the specific transaction was created on (this is not always the original order date).

    • Order Created Date : Filter by the date that the order was originally placed.

    • Purchase Created Date : Filter by the date the continuity purchased was started.

  • Date Range : Choose either the defaulted date ranges or your own specific dates.

  • Campaign : Filter for transactions within a specific campaign.

  • Campaign Category : Filter for transaction within a specific campaign category.

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

  • Product Category : Filter for transactions from a specific product category.

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

  • Affiliate : Filter for transactions associated with a specific affiliate.

  • Call Center : Filter for transactions associated with a specific call center.

  • Agent : Filter for the agent tied to the order the transaction went against. Please note they must be added to a call center to show here.

  • Bill Type : Filter for New Sale transactions, Recurring transactions, or both.

  • Billing Cycle : Filter for transactions from a specific billing cycle.

  • Recycle # : Filter for transactions from a specific recycle billing cycle/attempt.

  • Transaction Type : Filter to Sale, Authorize, Capture, COD, Void, Refund, and Authorized and Not Captured.

  • Base Currency : Filter for transactions that ran in a specific currency.

  • Country : Filter for transactions from customers in a specific country.

  • State : Filter for transactions from customers in a specific state.

  • Gateway : Filter for transactions that ran against a specific gateway.

  • Gateway Category : Filter for transactions that ran against a specific gateway category.

  • Card Type : Filter for transactions where a specific card type was used.

  • Credit/Debit : Filter for transaction that used a credit and/or debit card.

  • 3D Secure : Filter for transactions that are Protected and/or Not Protected.

  • Exclude zero amount transactions : This toggle will omit transactions that were $0.00

  • Group order declines : Group all declines from a single order as one decline.

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.

he charts provide a visual representation for the New Sales, Recurring Bills, Gross Revenue, Refund Total, Expenses, Chargebacks, and Net Revenue for the transactions being displayed on the table below. You may select to view the chart as a bar graph, line graph or a pie chart.

The data table can be viewed By Gateway, By Campaign, By Source, By Product, and By Campaign Product, By Currency, By Date, By Funnel

Table Definitions

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

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 Product : See a breakdown of the data by base product.

By Campaign Product : See a breakdown of the data by campaign product.

By Currency : See a breakdown of the data by currency.

By Date : See a breakdown of the data by date.

By Funnel : See a breakdown of the data by funnel.

Transaction Summary Table Header Definitions

  • ID : ID # the gateway, campaign, source, product, or campaign product; dependent on the table you are viewing.

  • Gateway / Campaign / Source / Product / Campaign Product : Sort type; dependent on the table you are viewing

  • Sales : New Sales approvals(unique products)

  • Declines : New Sale declines(unique declines only)

  • Total Decline % : (New Sale declines + Rebill Declines) / (New Sale declines + New Sale approvals + Rebill declines + Rebill approvals)

  • Approval % : New Sale approvals / (New Sale declines + New Sale approvals)

  • Revenue : New Sale Revenue amount

  • Rebills : Rebill approvals

  • RB Declines : Rebill declines (unique declines only)

  • RB Approval % : Rebill approvals/(Rebill approvals + Rebill declines)

  • RB Revenue : Rebill revenue amount

  • Refunds : Number of successful Refunds and Voids transactions

  • Refund Amt : Refund revenue amount includes both successful Refund transactions and successful Void transactions

  • CB : Number of chargebacks

  • CB % : Chargebacks/New Sales + Rebills

  • CB Rev. : Chargedback Revenue Amount

  • Expenses : Discount price + Shipping discount + Product cost + Shipping cost

  • Sales Tax : Total Sales Tax Note: This does not represent additional revenue over New Sale and Rebill revenue

  • Gross Revenue : Sales Revenue + Rebill Revenue

  • Net Revenue : Sales revenue + Rebill revenue - Refund total - Expense Total

  • SKU : The SKU for the product (only on the By Product and By Campaign Product tables)

  • Quantity : How many of the product was purchased (only on the By Product and By Campaign Product tables)


Additional Notes

Chargeback numbers on the Transaction Summary Report are based on transaction date (the number of transactions in a date range that have been charged back). Use the chargeback details report to get the number of chargebacks received in a date range.

If you include both Auth and Capture on the filter at the same time, the report will only count the auth transactions and ignore the captures. (unless the product is an Auth/Hold trial, in which case the Capture is counted.)

Gateway Type : Filter for transactions that ran against a specific gateway type (NMI, , Stripe, PayPal, etc).

Auth.net