Custom reports
Overview
Custom reports help you extract account activity data through a series of predefined filters. You can use the default custom reports provided by 2Checkout or you can create your own.
You can use the following default custom reports:
- Currency breakdown. Top 5 currencies based on gross value across all your sales channels in the current month. Includes VAT, sales tax and refunds.
- Quarterly Revenue. Quarterly comparison of net income across all your sales channels in the last 12 months compared to the previous 12 months.
- Yearly Comparison. Weekly split of top customer languages based on the number of products sold in the current month, compared with the same period last year.
- Sales By Source (SRC) - this year. Weekly split of top 5 sales sources in the current month.
- Net Income from Renewals. Total net income from automatic and manual renewals in the current month.
- Monthly orders. Monthly comparison of the number of orders across all your sales channels for the last 12 months, compared to the previous 12 months.
- Sales by Region. Top 3 geographic regions based on net sales in the last 12 months. VAT and taxes not included.
- Sales by Channel - Last 12 Months. Monthly comparison of the top 5 sales channels based on net sales for the last 12 months compared to the previous 12 months. VAT and taxes not included.
- Products Sold - Last 12 Months. Monthly comparison of the top 5 products sold in the last 12 months compared to the previous 12 months.
To access the Custom Reports section go to Reports center -> Custom reports.
Creating a custom report
Follow the steps below to create your own custom report.
- Go to Reports center -> Custom reports and click New custom report. Enter a unique name to easily identify the new report.
- Select a Report type.
- Gross Sales (includes VAT, shipping, commissions and sales tax)
- Net Sales (does not include VAT and other tax, otherwise it's the same as Gross Sales)
- Net Income (includes earnings generated from shipping but excludes discounts, taxes such as VAT, commissions, 2Checkout fees)
- Number of Orders
- Number of Products
- Define the advanced filters based on your needs
- Click Build report.
- Click Save report to save the new custom report to use it later. You can find it in the Custom reports section. The latest reports created are listed first and marked in blue in the Custom reports area, with the 2Checkout default custom reports displayed last and marked in red. Once you save a report, you have the option to delete it, modify it and save it as a new report, schedule it to run at predefined intervals and email the results to recipients of your choosing, or revert changes made without saving it as a new report.
Report settings
While editing custom reports you can configure multiple filters to aggregate data.
- Grouping (top 5 or less). You can group results by:
- Products
- Geographic regions
- Countries
- Sales channels
- Order currencies
- Customer languages
- Sales sources
- License types
- Partners (if Channel Manager is active on your account)
- Payment method
- Display additional results - Builds the report displaying additional results in the Other column.
- Date. Custom reports are not generated in real time. These reports centralize data available starting with the day prior to the moment you generate the report. A report built on July 10, 2015 provides information starting with July 9, 2015, 11:59:59 PM (GMT+2:00) and stretching back to the mark you set via the date drop down menu.
- Compare to past. Compare your business performance in a given time interval with an interval of the same length, either immediately preceding it, or from the previous year.
- Divide period by. Depending on the selected time interval, you can divide it by:
- Day (selected time interval is at least 1 day long)
- Week (selected time interval is at least 2 weeks long)
- Month (selected time interval is at least 2 months long)
- Quarter (selected time interval is at least 2 quarters long)
- Year (selected time interval is at least 2 years long).
- Aggregate reporting data for multiple accounts. Use the Accounts to include in report selector to specify which of the multiple accounts you own should the system extract data from when compiling the report. This option is only visible if you use multiple accounts.
Advanced filters
Product filters
Select products, both Active and Disabled, and extra delivery services such as DIS (Download Insurance) to include in the report.
Order and License filters
Custom reports can centralize data for completed and refunded orders. Refunded orders count as positive for custom reports. If you check the Refunded orders box, the report calculates the total revenue, and subtracts the refunds. When an order is refunded, 2Checkout generates a new order with a negative value (reflecting the amount of the refund). The total number of orders is the sum of initial and refunded orders.
Sales source (SRC). Select the sales sources to be included in the report. This filter only applies for less than 2000 available sales sources. If you have more than 2000 sources, all of them will be selected by default.
The report can include the following subscription types:
- New licenses (mobile and web)
- Renewals (automatic and manual, based on the Orders Origin filter)
- Upgrades
- Trials
- New licenses from trials (trial upgrades)
Localization filters
Filter the data included in the report based on:
- Geographic regions
- Countries
- Order language
Use the Show only the transactions converting to filter to build the report only with the transactions converting to the specified settlement currency.
Currency conversion rates
For each settlement currency, only the amounts settled in that currency are included. If your account only has one settlement currency, the report will convert all transactions from other billing currencies to that settlement currency.
Note: If your account has EUR and USD as settlement currencies and uses EUR as default, selecting EUR as the settlement currency to display amounts will include orders settled in EUR and all other currencies, with the exception of USD. When selecting USD, the report only shows the orders settled in USD.
Sales channel filters
Filter the report data sales channel:
- eStore
- Affiliates Network
- Network cross-selling (displayed only if the module is active)
- Partners (specific partners can be selected) (displayed only if channel manager is active)
You can select specific affiliates only if you have less than 100 active affiliates. If the number of affiliates you're working with exceeds 100 they will all be select by default.
Scheduling reports
You can schedule all custom reports to be performed automatically by 2Checkout system according to the privileges of the user configuring them. Once defined, the system will send out emails daily, weekly, monthly or quarterly including the report in PDF and/or CSV format.
You can set the recipients' email address, name the scheduled report, enter a description, set the schedule, and select specific reports that you want delivered.
eCommerce events
Overview
This article lists all eCommerce events supported by the ConvertPlus shopping cart.
The ConvertPlus cart caters to the following Web Metrics solutions:
- Google Universal Analytics
- Google Tag Manager (with Universal Analytics)
- Adobe Dynamic Tag Manager
- Google Analytics 4
- Google Tag Manager (with GA4)
Each solution handles enhanced events triggered by the ConvertPlus Cart differently. Due to the fact that each Web Metrics solution prefers its data arranged in a particular way, we'll document each web solution separately, alongside a distinct section for the custom cartUpdated event.
The parameters below are used to track eCommerce events triggered by the ConvertPlus and InLine carts.
Availability
Merchant tracking is available for all 2Checkout accounts.
eCommerce events grouped by Web Metric
Google Universal Analytics
The Google Universal Analytics DataLayer differs from Google Tag Manager and Adobe's Dynamic Tag Manager in that it is an array of arrays. Each event pushed in the DataLayer is an array with various indexes, based on the type of the triggered event:
- The first element of the array determines the type of payload added to the DataLayer (it can either be event or config).
- The second element of the array determines the sub-type of the first element.
- The third element is an object with the actual data/payload.
Event | Triggered by | Notes | Example |
---|---|---|---|
begin_checkout |
LOAD_CART (load-cart) |
|
|
purchase | PLACE_ORDER (place-order:success) |
|
|
remove_from_cart |
DELETE_ITEM (delete-item) |
|
|
page_redirect |
LOAD_PAGE (load-page) | Is only triggered if the cart is redirected to the retry page |
|
Google Analytics 4
The Google Analytics 4 DataLayer differs from Google Tag Manager and Adobe's Dynamic Tag Manager in that it is an array of arrays. Each event pushed in the DataLayer is an array with various indexes, based on the type of the triggered event:
-
The first element of the array determines the type of payload added to the DataLayer (it can either be event or config).
-
The second element of the array determines the sub-type of the first element.
-
The third element is an object with the actual data/payload.
Event |
Triggered by |
Notes |
Example |
---|---|---|---|
begin_checkout |
LOAD_CART (load-cart) |
|
|
purchase |
PLACE_ORDER (place-order:success) |
|
|
remove_from_cart |
DELETE_ITEM (delete-item) |
|
|
page_redirect |
LOAD_PAGE (load-page) |
Is only triggered if the cart is redirected to the retry page |
|
add_to_cart
|
ADD_ITEM (add-item) |
|
|
view_item_list
|
LOAD_CROSS_SELL (load-cross-sell) |
|
|
Google Tag Manager with Universal Analytics
For the Google Tag Manager with Universal Analytics, the DataLayer is an array of objects. The object payload passed to the DataLayer is mainly made up of two keys: event & eCommerce.
The event key determines the type of event passed to the Datalayer, while the eCommerce key holds the eCommerce object with all the relevant event data.
Both Google Tag Manager and Adobe’s Dynamic Tag Manager follow the same advanced eCommerce layout and they also have the ability to support Custom Events (cartUpdated).
Event | Triggered by | Notes | Example |
---|---|---|---|
checkout |
|
|
|
purchase |
PLACE_ORDER (place-order:success) |
|
|
removeFromCart |
DELETE_ITEM (delete-item) |
|
|
addToCart |
ADD_ITEM (add-item) |
|
|
Google Tag Manager with GA4
Google tag manager GA4 respects the Google analytics 4 structure. The DataLayer is an array of objects. The object payload passed to the DataLayer is mainly composed of two keys: event & ecommerce.
The event key determines the type of event passed to the Datalayer, while the eCommerce key holds the eCommerce object with all the relevant event data.
Event |
Triggered by |
Notes |
Example |
---|---|---|---|
begin_checkout |
LOAD_CART (load-cart) SET_ECOMMERCE (set-ecommerce) |
|
|
purchase |
PLACE_ORDER (place-order:success) |
|
|
remove_from_cart |
DELETE_ITEM (delete-item) |
|
|
add_to_cart |
ADD_ITEM (add-item) |
|
|
add_to_cart
|
LOAD_CROSS_SELL (load-cross-sell) |
|
|
Adobe's Dynamic Tag Manager
Event | Triggered by | Notes | Example |
---|---|---|---|
checkout |
|
|
|
purchase |
PLACE_ORDER (place-order:success) |
|
|
removeFromCart |
DELETE_ITEM (delete-item) |
|
|
addToCart |
ADD_ITEM (add-item) |
|
|
Custom events (cartUpdated)
Some Web Metric solutions allow the use of custom events. Currently, these solutions are Adobe’s Dynamic Tag Manager and Google Tag Manager.
Custom events allow us to pass any values under any keys we see fit, as long as we provide an acceptable and consistent format.
The format of a custom event is as follows:
{
"event": "cartUpdated",
"CUSTOM_KEY_1": "custom_value_1",
"CUSTOM_KEY_2": "custom_value_2",
...
}
The event key will always be populated with the cartUpdated value as this is the name of our custom event. Alongside the event key, you can find any number of custom keys, like their number, names, and values vary and depend on the action that the user performed in the cart.
The Convert Plus shopping cart implements an event buffer.
When a shopper performs an action in the cart, the cart triggers a lot of internal events that in turn trigger other events which may lead to the cart being overloaded when booting for changing its state.
To prevent the DataLayer from being spammed by unnecessary small updates, the event buffer was designed to do just that, buffer events. Catch all events in a designated time (1 s at the moment of this writing), keeping only their newest value, and release them in bigger chunks.
The custom keys used by the cartUpdated event are as follow:
Event | Triggered by | Values | Notes | Example |
---|---|---|---|---|
PAGE_NAME |
|
|
|
|
PAGE_THEME |
|
|
The loaded theme’s name. |
|
merchant_CODE |
|
The 2CheckOut code form GAP. |
|
|
ONESTEPCART |
|
Boolean |
|
|
SHORT_FORM |
|
Boolean |
|
|
PURCHASE_COMPLETE |
|
Boolean |
|
|
TEMPLATE_CREATION_DATE |
|
|
|
|
TEMPLATE_LAST_MODIFIED_DATE |
|
|
|
|
PAGE_STYLE_NAME |
|
The name of the customized theme. |
|
|
PROFESSIONAL_SERVICES |
|
Boolean | Determined by whether the template has been customized by professional services. |
|
TEST_ORDER |
|
Boolean | Is true if the loaded cart is in test mode. |
|
PRODUCT_SOURCE |
|
|
Determined by the products in the cart. |
|
CART_LOCK |
|
Boolean | Is set to true if the cart is locked. |
|
DISCOUNT_COUPON |
|
Coupon code |
|
|
DISCOUNT_COUPON_STATUS |
|
|
|
|
COMPANY_NAME |
|
Company name. | The company name entered by the user while the company flow is selected. |
|
ORDER_EXT_REF |
|
String | The external reference set by the merchant. |
|
CUSTOMER_EXT_REF |
|
String | The external customer reference set by the merchant. |
|
AUTO_RENEWAL |
|
|
The status is computed based on the visibility of the recurring button (Recurring option in GAP account settings) & the actual recurring status of the order. |
|
PURCHASE_TYPE |
|
|
|
|
ADDITIONAL_HIDDEN_FIELDS |
|
The value of the additional hidden field may be null if it has no value. | Array of hidden additional fields. |
|
BILLING_COUNTRY |
|
The country code. |
|
|
VISITOR_COUNTRY |
|
The country code. |
|
|
BILLING_CURRENCY |
|
The currency code. |
|
|
LANGUAGE |
|
The language code. |
|
|
FORM_ERROR |
SET_ERRORS (set-errors) | Form field names separated by | | The form field where an error occurred in the cart. |
|
PAYMENT_METHOD |
UPDATE_PAYMENT_METHOD (change:paymentMethod) | The payment method code. |
|
|
PAYMENT_METHOD_TYPE |
UPDATE_PAYMENT_METHOD (change:paymentMethod) |
|
|
|
PAYMENT_CATEGORY |
UPDATE_PAYMENT_METHOD (change:paymentMethod) | Payment method label. | The payment method label selected in the shopping cart (Credit card, wire, or any other method). |
|
QUANTITY_CHANGED |
UPDATE_ITEM (update-item) | Integer |
|
|
CART_STEP |
UPDATE_CART_STEP (change:cartStep) |
|
Only triggered for the InLine themes. |
|
ADDITIONAL_FIELDS_COUNT |
UPDATE_ADDITIONAL_FIELD_COUNT (additional-fields-count-changed) | Integer | The number of additional fields present in the cart. |
|
PURCHASE_FLOW |
UPDATE_PURCHASE_FLOW (set-purchase-flow) |
|
Set by the customer when selecting the purchase flow. |
|
SOURCE |
UPDATE_ADDITIONAL_FIELD_COUNT (additional-fields-count-changed) | The source value. | Merchant defined source. |
|
time |
SET_ECOMMERCE (set-ecommerce) | Timestamp | Sets the current time as a timestamp after a SET_ECOMMERCE event. |
|
CREDIT_CARD_INSTALLMENTS |
UPDATE_HAS_INSTALLMENTS (set-has-cc-installments) |
|
|
Top affiliates
Top Affiliates provides an overview of top affiliates per region: EMEA, APAC, CIS, LATAM, and ROW (Asia Pacific, Europe, the Middle East and Africa, Latin America, North America, and the Rest of the World). The report can list top affiliates according to the number of orders, the total revenue they provide or profit. Includes finished orders and refunds.
Revenue split
Overview
A graphical report including only data for finished and refunded orders, spanning over the selected time frame.
The report is designed to offer information on the evolution of the Net product price, 2Checkout fees and commissions, tax/VAT, Download insurance services (DIS) profit and costs, disputes balance, RRT fee, chargeback fees, and shipping costs from one month to another.
The data centralized by the Revenue Split report is meant to be as close as possible to the 2Checkout Sales Report, albeit still estimate, and as such the info may differ from the finalized details.
Availability
The Revenue Split report is available for all merchants on all accounts. However, the 'All converted to' filter is visible only for merchants who have more than 1 payout method activated.
Revenue Split
Totals for specific Payout currency - this option causes the Revenue Split report to present results for finished and refunded orders settled in the same currency also selected as the Totals for specific Payout currency.
For example, if EUR is selected for the 'Totals for specific payout currency' filter, the results will centralize data from orders paid for by customers in EUR, as well as for orders paid in other currencies, but that were settled in EUR. Only settlement currencies can also act as 'Totals for specific payout currency'. Currency conversions taken into consideration for the Revenue Split report are made using the exchange rates applied for each transaction at the moment of completion.
All converted to – this option causes the Revenue Split report to present results for all finished and refunded orders settled in a specific payout currency.
For example, if EUR is selected for the 'All converted to selected currency' filter, the results will centralize data from orders paid for by customers in EUR, as well as for orders paid in other currencies, no matter the payout currency. Only settlement currencies can also act as 'All converted to the selected currency'. Currency conversions taken into consideration for the Revenue Split report are made using the daily exchange rates and this report presents an estimate of the revenue that will be paid in the selected payout currencies.
Totals for specific Transaction currency – this option causes the Revenue Split report to present results for all finished and refunded orders placed in a specific currency, no matter the settled currency.
Integrate WIX
Overview
Wix is a complete web solution that offers a global user base, open SDK, and unparalleled design capabilities to create a unique ecosystem. Partners, developers, web designers, and other online professionals can effectively market their apps and services to millions through Wix.
The Wix connector enables merchants to process orders with 2Checkout.
Availability
WiX integration is available only for 2Checkout accounts that handle their own tax and invoice management (2Sell and 2Subscribe accounts).
Recurring payments are not yet available.
Wix Settings
Follow the instructions below to integrate your WiX account with 2Checkout:
- Log into your WIX dashboard.
- Under Settings, click on Select Payments.
- Under the Credit/Debit Cards tab, click on Change provider, and then click on Connect, under the 2Checkout logo.
- If you want to sign up for a 2Checkout account, click on Create an Account and follow the instructions.
- If you already have a 2Checkout account, click on Connect Existing Account and follow the instructions below.
- Make sure your account has been approved by 2Checkout (this can take several days if you have just opened one).
- Log into your 2Checkout account, navigate to the Integrations → Webhooks & API section and retrieve your Publishable Key and Private Key.
- Retrieve your Seller ID from the 2Checkout Merchant Code in the API section.
6. Insert the keys (see the above steps) and the Seller ID into the Wix Connect your Account Form.
7. Click on Connect My Account button. Once you are connected, you can accept payments with 2Checkout.
2Checkout Settings
- Sign in to your 2Checkout account.
- Navigate to Dashboard → Integrations → Webhooks & API section.
- Follow these steps to activate Redirect URL:
- In the Redirect URL section check “Enable return after sale”
- For the Return method, select Header Redirect or Link in Thank You page
- Set the Approved URL to your Wix URL
4. (Optional) In the Instant Notification System (INS) section check the “Enable INS” box → Set up a Global URL Endpoint.
5. Click Update to save your settings.
About WiX
Wix is the brainchild of Avishai Abrahami, Nadav Abrahami, and Giora Kaplan. Like many great ideas, it was discovered through accidental fate (on the beach). While constructing a website to be the basis of another start-up idea, the tech-savvy threesome quickly discovered that creating their own website was difficult, frustrating, and very costly. It was this agonizing experience that led them to a light bulb moment - build a platform that empowered anyone to create their own website with no coding or design skills needed. Better yet, make it free. Find out more about WiX here.
Orders origin
Overview
2Checkout monitors the source of orders placed by your customers via eStore, and helps you gain insight into shopper behavior and habits.
The tracking set in place enables the 2Checkout system to provide accurate information on the origin of eStore orders (new acquisitions, renewals and upgrades are all covered). There are three (3) sources for the orders placed by your customers, according to the interface they used to finalize the purchase process.
Web |
encompasses all orders placed using the desktop browser version of the 2Checkout shopping cart |
---|---|
Mobile |
is characteristic of orders placed using the mobile version of the 2Checkout shopping cart. Note: Mobile is only available if the 2Checkout mobile shopping cart is active for your account |
API |
used for orders involving the 2Checkout API. Note: API is available only if you're using the 2Checkout API to allow customers to place orders. The API origin is shown regardless of the device customers use to place orders, as long as the process involves the 2Checkout API |
Automatic billing |
includes all orders placed through the automatic renewal flow. For products that have renewals configured, customers can opt in for automatic renewal of their orders. |
When exporting CSV (comma separated values) files or Excel (XLS) documents, you will be able to find information on the source of orders in the Origin column.