This article is an index of commonly used output metrics found in reports. This library is useful for learning about and understanding the output columns of unformatted Standard and Custom Reports. This is also helpful for selecting the appropriate output columns when building Custom Reports.
Each entry includes a metric’s definition and the wrappers and Report Types the metric will be found in. We've only listed commonly used output metrics, so not all Report Types, wrappers or metrics are listed here.
TIP: Before starting, you should have a comprehensive understanding of running and reading Reports in Spektrix. If you’re building Custom Reports, you should be familiar with the foundational components needed to create your report.
Before looking at this index, we recommend being familiar with:
Metrics will be organized by what Report Type and wrapper they are found in, and the index can be viewed in two ways: By Report Type or By Metric Name.
Metrics of the Same Name
As you look through the Metrics Library, you may find metrics with the same name. Metrics of the same name will differ based on the Report Type and wrapper.
For example, the Amount metric in the Donation wrapper will display the amount received but will only display when the Item is a Donation. The Amount metric in the Payment wrapper will display the amount received but will only display when the Item is a Payment. This means some rows may have blank cells in one column while some rows have blank cells in another.
In this example, we see a Donation with an Amount of $400 (column D) and a Cash Payment with an Amount of $400 (column C). The Donation has a blank cell in column C as a value will only display if the Item Type was a Payment. Similarly, the Cash Payment has a blank cell in column D, as this Amount refers to Donation Amounts.
View By Report Type
In this section, metrics are organized by the Report Type they are in. Each Report Type lists the available wrappers, and within each wrapper, you’ll find available metrics.
REMINDER: This index lists only commonly used metrics. Not all Report Types, wrappers or metrics are listed here.
Click to skip to the following Report Type (listed in alphabetical order):
- Accounting
- Activities
- Analysis
- Attendee
- Campaigns
- Customer
- Customer Audit
- Event Instances
- Invitee
- Mailing ROI
- Memberships
- Opportunities
- Opportunity Stages
- Pledges & Legacies
- Sales
- Soft Credit
- Ticket Vouchers
How to View Metrics By Report Type
Each entry in this view will have the following components:
-
1. Report Type
Metrics are first organized by Report Type. The headings of each section show the name of the Report Type and includes a description about how data is output by row. In this example, the Report Type is Accounting.
REMINDER: This index lists only commonly used metrics. Not all Report Types are listed here.
In Spektrix, Report Type is selected at the start of building a custom report:
For existing Standard and Custom Reports, you can find its Report Type in the Report Explorer:
-
2. Wrappers
Under each Report Type heading, you’ll find tabs that represent the available wrappers. In this example, the available wrappers listed in the Accounting Report Type are Donations, Payments and Purchase Items.
REMINDER: This index lists only commonly used metrics. Not all wrappers are listed here.
In Spektrix, wrappers will appear under Available Columns when selecting Output:
-
3. Metrics
After you’ve selected the Wrapper tab, you’ll find a table with commonly used metrics. In this example, an available metric in the Donations wrapper in an Accounting Report Type is Amount.
REMINDER: This index lists only commonly used metrics. Not all metrics are listed here.
In Spektrix, available metrics will appear when a wrapper is opened when selecting Output:
For existing unformatted Standard and Custom Reports, you can find the metrics as headings of the output columns:
REMINDER: The metrics in this index refer to the headings in the output columns on unformatted reports only. Formatted reports may share similar column names but may be calculated differently, for example, to include tax and commissions.
-
4. Description
The description of the metric in this wrapper and Report Type, which may include links to more information about the metric.
Some metrics may include Related Metrics in their descriptions. These metrics are accounting metrics that complement each other.
For example, Price with related metrics NetPrice and VATPrice, where Price is the value of an Item plus tax, NetPrice is the value of an Item excluding tax and VATPrice is the value of the tax on the Item.
Most accounting metrics follow a similar naming convention where "Metric" is the sum of "NetMetric" and "VATMetric."
REMINDER: You must use both the correct Report Type and wrapper, as definitions and values for metrics with the same name may differ. Metrics with the same name in the same Report Type will differ if they are from different wrappers.
-
5. Example
An example of how the metric will display when output. Common data output formats include:
-
00.00: A number value up to two decimal places. If a currency value, currency symbols won’t display. For example, the Price metric.
-
TRUE/FALSE: If the reported item has this value, the cell will display TRUE. If the reported item doesn’t have this value, the cell will display FALSE. For example, the Never Booked metric.
-
1/0: If the reported item has this value, the cell will display 1. If the reported item doesn’t have this value, the cell will display 0. For example, the Subscription is Current metric.
-
Text: A text value. For example, the Item Name metric.
- YYYY-MM-DD hh:mm: A date and time value displayed by year, month number, date, hour (24-hour format) and minutes. For example, the Date Confirmed metric.
-
00.00: A number value up to two decimal places. If a currency value, currency symbols won’t display. For example, the Price metric.
Accounting
Accounting Reports show a row for each action in a transaction. They show how much money was taken and the end financial result. Accounting Reports are generally used by the Finance and Box Office teams for financial reconciliation.
-
Commissionable Items
Metric Description Example Commission The gross value of the commission on the Item, including tax. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission.
- Merchandise: The value of the Merchandise Postage and Packing.
Related metrics: NetCommission, VATCommission
00.00 NetCommission The net value of the commission on the Item, excluding tax on the commission. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission.
- Merchandise: The value of the Merchandise Postage and Packing.
Related metrics: Commission, VATCommission
00.00 VATCommission The amount taxed on the commission on the Item. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Commission.
- Merchandise: The amount taxed on the Merchandise Postage and Packing.
Related metrics: Commission, NetCommission
00.00 -
Custom Payments
Metric Description Example Custom Payment Name The name of the Custom Payment Type used. Text -
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Potential Duplicate If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE if a potential duplicate. TRUE/FALSE -
Donations
Metric Description Example Amount The amount received as a Donation in a transaction. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Donation to an Education fund, a line will be displayed for each Donation. 00.00 Gift Aid Claimable If the Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation must not have been opted out of Gift Aid. TRUE/FALSE Gift Aid Claimed If the Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Membership Name If the Donation was received as a portion of a Membership, then the cell displays the name of the Membership as entered in the Membership details. Text -
Event Instances
Metric Description Example Event Date/Time The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm -
Events
Metric Description Example Event Name The name of the Event as entered in the Event Details. Text -
Memberships
Metric Description Example Membership Name The name of the Membership as entered in the Membership details. Text -
Payments
Metric Description Example Amount The amount received as a Payment in a transaction. If a transaction takes two Payments, for example, a Card Payment and a Cash Payment, a line will be displayed for each Payment type. 00.00 -
Purchase Items
Metric Description Example Levy The gross value of the Levy set against the Ticket, including tax.
Related metrics: NetLevy, VATLevy
00.00 NetLevy The net value of the Levy set against the Ticket, excluding tax on the Levy.
Related metrics: Levy, VATLevy
00.00 NetPrice The net value of the Item at the time it was purchased, with any Offers or overrides applied. Depending on the Item Type, NetPrice will include and exclude the following for:
- Tickets: Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
- Merchandise: Excludes tax, Merchandise Postage and Packaging.
Related metrics: Price, VATPrice
00.00 NetPriceAfterLevy The net value of the Ticket, with any Offers or overrides applied and excluding Levy and tax. Also excludes Ticket Commissions. Includes Agent Commission.
Related metrics: PriceAfterLevy, VATPriceAfterLevy
00.00 Price The value of the Item at the time it was purchased, with any Offers or overrides applied. Depending on the Item Type, Price will include and exclude the following for:
- Tickets: Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
- Merchandise: Includes tax. Excludes Merchandise Postage and Packaging.
Related metrics: NetPrice, VATPrice
00.00 PriceAfterLevy The value of the Ticket, with any Offers or overrides applied and excluding Levy. Also excludes Ticket Commissions. Includes tax, Agent Commission.
Related metrics: NetPriceAfterLevy, VATPriceAfterLevy
00.00 VATLevy The amount taxed on the Levy set against the Ticket.
Related metrics: Levy, NetLevy
00.00 VATPrice The amount taxed on the Item at the time it was purchased, with any Offers or overrides applied. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Price. Includes Levy, Agent Commission. Excludes Ticket Commissions.
- Merchandise: The amount taxed on the Merchandise Price. Excludes Merchandise Postage and Packaging.
Related metrics: Price, NetPrice
00.00 VATPriceAfterLevy The amount taxed on the Ticket Price, with any Offers or overrides applied and excluding Levy. The Ticket Price includes Agent Commission and excludes Ticket Commissions.
Related metrics: PriceAfterLevy, NetPriceAfterLevy.
00.00 -
Tickets / Reservations
Metric Description Example Area The name of the Seating Plan Area of the Ticket or Reservation. Text InsideCommissionPercentage The gross monetary value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentageNet, InsideCommissionPercentageVAT
00.00 InsideCommissionPercentageNet The net monetary value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageVAT
00.00 InsideCommissionPercentageVAT The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageNet
00.00 InsideCommissionRate The rate of the Agent commission structure on the Ticket. Depending on how the rate is entered, the following will display:
- Percentage based: The decimal value. For example, 20% will display as 0.20.
- Value based: The value. For example, $5 will display as 5.00.
00.00 InsideCommissionValue The gross value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is value based.
Related metrics: InsideCommissionValueNet, InsideCommissionValueVAT
00.00 InsideCommissionValueNet The net value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueVAT
00.00 InsideCommissionValueVAT The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueNet
00.00 Is Comp If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 -
Transaction Items
Metric Description Example Date Confirmed The date/time the transaction was confirmed by a Sales User or a Customer online. YYYY-MM-DD hh:mm Item Type The type of the Item or Payment in the transaction. For example, Ticket Sale, Card Payment or Transaction Commission. Text NetOutputs The total net amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and excluding tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, Levy. Excludes tax, Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
Related metrics: Total Charged, VATOutputs
00.00 Total Charged The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value.
Related metrics: NETOutputs, VATOutputs
00.00 Total Received The total amount received as a Payment. Depending on the Item Type purchased, Total Received is the inverse for:
- Tickets: The value of the Ticket, with any Offers or overrides applied. Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value for the refund.
00.00 VATOutputs The amount taxed on the total amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
Related metrics: Total Charged, NETOutputs
00.00
Activities
The Activities Report shows a row for each Activity and for each link to an Individual/Organisation. This Report is intended for Opportunities Interface users.
-
Campaigns
Metric Description Example Active If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE -
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE
Analysis
Analysis Reports show a row for each item sold or returned. Items include Tickets, Reservations, Merchandise and Gift Vouchers. Analysis Reports are usually used by the Box Office and Marketing teams. Analysis Reports also have the largest number of secondary tables (Wrappers) available.
-
Commissionable Items
Metric Description Example Commission The gross value of the commission on the Item, including tax. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission.
- Merchandise: The value of the Merchandise Postage and Packing.
Related metrics: NetCommission, VATCommission
00.00 NetCommission The net value of the commission on the Item, excluding tax on the commission. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission.
- Merchandise: The value of the Merchandise Postage and Packing.
Related metrics: Commission, VATCommission
00.00 VATCommission The amount taxed on the commission on the Item. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Commission.
- Merchandise: The amount taxed on the Merchandise Postage and Packing.
Related metrics: Commission, NetCommission
00.00 -
Custom Payments
Metric Description Example Custom Payment Name The name of the Custom Payment Type used. Text -
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Booked Once If the Customer has booked Tickets for only one Event ever, then the cell displays 1. This includes if they've booked for multiple Instances within the same Event or have bought Tickets for the same Event through multiple Orders. If they later return their Tickets, then they are no longer considered having booked once. 1/0 Never Booked If the Customer has never booked Tickets for any Event ever, then cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE Potential Duplicate If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE if a potential duplicate. TRUE/FALSE -
Donations
Metric Description Example Amount The amount received as a Donation in a transaction. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Donation to an Education fund, a line will be displayed for each Donation. 00.00 Gift Aid Claimable If the Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation must not have been opted out of Gift Aid. TRUE/FALSE Gift Aid Claimed If the Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Is Returned If the Donation was returned, then the cell displays TRUE. TRUE/FALSE Membership Name If the Donation was received as a portion of a Membership, then the cell displays the name of the Membership as entered in the Membership details. Text Purchased with Ticket If the Order includes any Ticket, then the cell displays TRUE. TRUE/FALSE -
Event Instances
Metric Description Example Event Date/Time The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm -
Events
Metric Description Example Event Name The name of the Event as entered in the Event Details. Text -
Fixed Subscriptions
Metric Description Example Total Price The total sum of the values of all the Tickets in a Fixed Series, at the time it was purchased. Includes tax, Levy. Excludes Ticket Commissions. 00.00 -
Memberships
Metric Description Example Membership Name The name of the Membership as entered in the Membership details. Text Subscription is Current If the Membership hasn't expired as of today, then the cell displays 1. This includes a Membership with an expiration date in the future or with no expiration date. 1/0 Subscription is Latest If the Membership is the Customer's latest subscription of the Membership type, then the cell displays 1. This includes current Memberships or the last expired Membership. 1/0 -
Order Items
Metric Description Example Date Confirmed The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm Item Type The type of the Item or Payment in the Order. For example, Ticket, Merchandise, Donation or Membership. Text Total Charged The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value.
Related metrics: NETOutputs, VATOutputs
00.00 Total Received The total amount received as a Payment. Depending on the Item Type purchased, Total Received is the inverse for:
- Tickets: The value of the Ticket, with any Offers or overrides applied. Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value for the refund.
00.00 -
Payments
Metric Description Example Amount The amount received as a Payment in a transaction. If a transaction takes two Payments, for example, a Card Payment and a Cash Payment, a line will be displayed for each Payment type. 00.00 -
Seats
Metric Description Example Area The name of the Seating Plan Area of the Seat. Text Gross Value The current default Price of the Seat, as set in the Price List. The Price depends on the Seat's Price Band and the selected default Web Ticket Type. 00.00 -
Tickets / Reservations
Metric Description Example Area The name of the Seating Plan Area of the Ticket or Reservation. Text Is Comp If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 Is Returned If the Ticket or Reservation was returned, then the cell displays TRUE. TRUE/FALSE Levy The gross value of the Levy set against the Ticket, including tax.
Related metrics: NetLevy, VATLevy
00.00 NetLevy The net value of the Levy set against the Ticket, excluding tax on the Levy.
Related metrics: Levy, VATLevy
00.00 NetPrice The net value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
Related metrics: Price, VATPrice
00.00 NetPriceAfterLevy The net value of the Ticket, with any Offers or overrides applied and excluding Levy and tax. Also excludes Ticket Commissions. Includes Agent Commission.
Related metrics: PriceAfterLevy, VATPriceAfterLevy
00.00 Price The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice
00.00 PriceAfterLevy The value of the Ticket, with any Offers or overrides applied and excluding Levy. Also excludes Ticket Commissions. Includes tax, Agent Commission.
Related metrics: NetPriceAfterLevy, VATPriceAfterLevy
00.00 Purchased with Donation If the Order includes any Donation, then the cell displays TRUE.
TRUE/FALSE VATLevy The amount taxed on the Levy set against the Ticket.
Related metrics: Levy, NetLevy
00.00 VATPrice The amount taxed on the Ticket at the time it was purchased, with any Offers or overrides applied. The Ticket Price includes Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: Price, NetPrice
00.00 VATPriceAfterLevy The amount taxed on the Ticket Price, with any Offers or overrides applied and excluding Levy. The Ticket Price includes Agent Commission and excludes Ticket Commissions.
Related metrics: PriceAfterLevy, NetPriceAfterLevy
00.00
Attendee
Attendee Reports show a row for each Attendee. This Report is only available to Opportunities Interface users.
-
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE -
Event Instances
Metric Description Example Event Date/Time The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm -
Events
Metric Description Example Event Name The name of the Event as entered in the Event Details. Text -
Seats
Metric Description Example Area The name of the Seating Plan Area of the Seat. Text Gross Value The current default Price of the Seat, as set in the Price List. The Price depends on the Seat's Price Band and the selected default Web Ticket Type. 00.00 -
Tickets / Reservations
Metric Description Example Area The name of the Seating Plan Area of the Ticket or Reservation. Text Is Comp If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 Is Returned If the Ticket or Reservation was returned, then the cell displays TRUE. TRUE/FALSE NetPrice The net value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
Related metrics: Price, VATPrice
00.00 Price The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice
00.00 VATPrice The amount taxed on the Ticket at the time it was purchased, with any Offers or overrides applied. The Ticket Price includes Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: Price, NetPrice
00.00
Campaigns
Campaign Reports show a row for every item related to each Campaign. This Report is only available to Opportunities Interface users.
-
Campaign Items
Metric Description Example Amount The amount received as a Donation linked to the Campaign, Sub-campaign or Sub-sub-campaign. This can include a Donation, a fulfilled Pledge, a fulfilled Legacy or the Donation portion of a Membership. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Pledge Installment, a line will be displayed for each Donation. 00.00 Date Depending on the Item Type, the following will display for:
- Donation: The Date Transaction Confirmed or Accounting Date of the Donation
- Membership: The Date Transaction Confirmed or Accounting Date of the Membership purchase or renewal
- Opportunity: Expected Close Date as entered when creating the Opportunity
- Pledge: Installment Date as calculated when creating the Pledge
- Legacy: The Date Transaction Confirmed or Accounting Date of the Donation when the Legacy is fulfilled
YYYY-MM-DD hh:mm Gift Aid Claimable If the Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation must not have been opted out of Gift Aid. TRUE/FALSE Gift Aid Claimed If the Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Item Name The name of the Item that was purchased against the Campaign, Sub-campaign or Sub-sub-campaign. Depending on the Item type, the following will display:
- Donation: Fund name as entered in the Fund details
- Pledge: Fund name as entered in the Pledge details
- Memberships: Membership name as entered in the Membership details
- Legacy: Fund name as entered in the Legacy details if the Legacy is fulfilled. The Item Type changes to Donation
- Opportunities: Displays a blank cell
Text Item Type The type of the Item purchased against the Campaign, Sub-campaign or Sub-sub-campaign. For example, a Donation or a Membership. When a Pledge or Legacy is fulfilled, the Item Type changes to Donation. Memberships will split Item Type if they have a benefit (Membership) and donation portion (Donation). Text -
Campaigns
Metric Description Example Active If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE
Customer
Customer Reports show a row for each customer in the database. They are often used to guide Marketing decisions.
-
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Booked Once If the Customer has booked Tickets for only one Event ever, then the cell displays 1. This includes if they've booked for multiple Instances within the same Event or have bought Tickets for the same Event through multiple Orders. If they later return their Tickets, then they are no longer considered having booked once. 1/0 Never Booked If the Customer has never booked Tickets for any Event ever, then cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE Potential Duplicate If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE if a potential duplicate. TRUE/FALSE
Customer Audit
A Customer Audit Report shows a row for each Customer Audit. This is useful for tracking changes made to Customer accounts.
-
Customer Audit Outputs
Metric Description Example Date The date/time at which the change on the Customer Record was made. YYYY-MM-DD hh:mm
Event Instances
Event Instance Reports show a row for each Event Instance, providing summary data about each one such as number of seats sold, masked, locked etc.
-
Event Instances
Metric Description Example Event Date/Time The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm -
Events
Metric Description Example Event Name The name of the Event as entered in the Event Details. Text
Invitee
Invitee Reports show a row for each Invitation. This Report is only available to Opportunities Interface users.
-
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE -
Event Instances
Metric Description Example Event Date/Time The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm -
Events
Metric Description Example Event Name The name of the Event as entered in the Event Details. Text
Mailing ROI
Mailing ROI Reports show a line per Mailing per related Event, as well as summary data to do with the success of the mailing. These types of reports are useful for the Marketing team to track return on investment.
-
Events
Metric Description Example Event Name The name of the Event as entered in the Event Details. Text -
Order Items
Metric Description Example Date Confirmed The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm -
Tickets / Reservations
Metric Description Example Price The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice
00.00
Memberships
Membership Reports show a row for each membership. They can be filtered to show active or expired Memberships. Membership reports are generally used by Marketing and Development teams.
-
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Never Booked If the Customer has never booked Tickets for any Event ever, then cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE Potential Duplicate If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE if a potential duplicate. TRUE/FALSE -
Memberships
Metric Description Example Gift Aid Claimable If the Donation portion of a Membership can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation portion of the Membership must not have been opted out of Gift Aid. TRUE/FALSE Gift Aid Claimed If the Donation portion of a Membership has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Is Returned If the Membership was returned, then the cell displays TRUE. TRUE/FALSE Membership Name The name of the Membership as entered in the Membership details. Text Price The value of the Membership at the time it was purchased, with any overrides applied. Includes tax. 00.00 Subscription is Current If the Membership hasn't expired as of today, then the cell displays 1. This includes a Membership with an expiration date in the future or with no expiration date. 1/0 Subscription is Latest If the Membership is the Customer's latest subscription of the Membership type, then the cell displays 1. This includes current Memberships or the last expired Membership. 1/0
Opportunities
Opportunity Reports show a row for each Opportunity. This Report is only available to Opportunities Interface users.
-
Campaigns
Metric Description Example Active If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE -
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE
Opportunity Stages
Opportunity Stage Reports show a row for each stage of an Opportunity. This Report is only available to Opportunities Interface users.
-
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE
Pledges & Legacies
A Pledges & Legacies Report shows a row for each Pledge / Legacy. This Report is only available to Opportunities Interface users.
-
Campaigns
Metric Description Example Active If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE -
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE -
Pledges & Legacies
Metric Description Example Date Depending on the Item Type, the following will display for:
- Pledge: The Date of Pledge as entered in the Pledge details.
- Legacy: The Date of Legacy as entered in the Legacy details. If the Legacy has been fulfilled, the Date Transaction Confirmed or Accounting Date.
YYYY-MM-DD hh:mm
Sales
Sales Reports show a row for each seat. They are normally filtered to show the seats for a particular Event Instance. Sales Reports are generally used by the Box Office or producers.
-
Commissionable Items
Metric Description Example Commission The gross value of the commission on the Item, including tax. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing
Related metrics: NetCommission, VATCommission
00.00 NetCommission The net value of the commission on the Item, excluding tax on the commission. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing
Related metrics: Commission, VATCommission.
00.00 VATCommission The amount taxed on the commission on the Item. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Commission
- Merchandise: The amount taxed on the Merchandise Postage and Packing.
Related metrics: Commission, NetCommission
00.00 -
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Potential Duplicate If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE if a potential duplicate. TRUE/FALSE -
Donations
Metric Description Example Amount The amount received as a Donation in a transaction. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Donation to an Education fund, a line will be displayed for each Donation. 00.00 Gift Aid Claimable If the Ticket Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Ticket Donation must not have been opted out of Gift Aid. TRUE/FALSE Gift Aid Claimed If the Ticket Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE -
Event Instances
Metric Description Example Event Date/Time The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm -
Events
Metric Description Example Event Name The name of the Event as entered in the Event Details. Text -
Order Items
Metric Description Example Date Confirmed The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm Item Type The type of the Item or Payment in the Order. For example, Ticket, Merchandise, Donation or Membership. Text Total Charged The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission
- Gift Vouchers: Displays a zero
- Ticket Vouchers and Reissues: Displays a zero
- Item return: Displays a negative value
Related metrics: NETOutputs, VATOutputs.
00.00 Total Received The total amount received as a Payment. Depending on the Item Type purchased, Total Received is the inverse for:
- Tickets: The value of the Ticket, with any Offers or overrides applied. Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value for the refund.
00.00 -
Seats
Metric Description Example Area The name of the Seating Plan Area of the Seat. Text Gross Value The current default Price of the Seat, as set in the Price List. The Price depends on the Seat's Price Band and the selected default Web Ticket Type. 00.00 Gross Value After Levy The current default Price of the Seat, as set in the Price List, excluding Levy. The Gross Value depends on the Seat's Price Band and the selected default Web Ticket Type. The Levy depends on the Seat's default Ticket Type and the Levy set on the Instance. 00.00 -
Tickets / Reservations
Metric Description Example Area The name of the Seating Plan Area of the Ticket or Reservation. Text InsideCommissionPercentage The gross monetary value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentageNet, InsideCommissionPercentageVAT
00.00 InsideCommissionPercentageNet The net monetary value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageVAT
00.00 InsideCommissionPercentageVAT The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageNet
00.00 InsideCommissionRate The rate of the Agent commission structure on the Ticket. Depending on how the rate is entered, the following will display:
- Percentage based: The decimal value. For example, 20% will display as 0.20.
- Value based: The value. For example, $5 will display as 5.00.
00.00 InsideCommissionValue The gross value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is value based.
Related metrics: InsideCommissionValueNet, InsideCommissionValueVAT
00.00 InsideCommissionValueNet The net value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueVAT
00.00 InsideCommissionValueVAT The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueNet
00.00 Is Comp If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 Is Returned If the Ticket or Reservation was returned, then the cell displays TRUE. TRUE/FALSE Levy The gross value of the Levy set against the Ticket, including tax.
Related metrics: NetLevy, VATLevy
00.00 NetLevy The net value of the Levy set against the Ticket, excluding tax on the Levy.
Related metrics: Levy, VATLevy
00.00 NetPrice The net value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
Related metrics: Price, VATPrice
00.00 NetPriceAfterLevy The net value of the Ticket, with any Offers or overrides applied and excluding Levy and tax. Also excludes Ticket Commissions. Includes Agent Commission.
Related metrics: PriceAfterLevy, VATPriceAfterLevy
00.00 Price The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice
00.00 PriceAfterLevy The value of the Ticket, with any Offers or overrides applied and excluding Levy. Also excludes Ticket Commissions. Includes tax, Agent Commission.
Related metrics: NetPriceAfterLevy, VATPriceAfterLevy
00.00 VATLevy The amount taxed on the Levy set against the Ticket.
Related metrics: Levy, NetLevy
00.00 VATPrice The amount taxed on the Ticket at the time it was purchased, with any Offers or overrides applied. The Ticket Price includes Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: Price, NetPrice
00.00 VATPriceAfterLevy The amount taxed on the Ticket Price, with any Offers or overrides applied and excluding Levy. The Ticket Price includes Agent Commission and excludes Ticket Commissions.
Related metrics: PriceAfterLevy, NetPriceAfterLevy
00.00
Soft Credit
Soft Credit Reports show a line per Order Item for the actual Order as well as a line per Order Item for each entity the order has been soft credited to.
-
Customers
Metric Description Example Active If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Never Booked If the Customer has never booked Tickets for any Event ever, then cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE -
Memberships
Metric Description Example Membership Name The name of the Membership as entered in the Membership details. Text Subscription is Current If the Membership hasn't expired as of today, then the cell displays 1. This includes a Membership with an expiration date in the future or with no expiration date. 1/0 Subscription is Latest If the Membership is the Customer's latest subscription of the Membership type, then the cell displays 1. This includes current Memberships or the last expired Membership. 1/0 -
Order Items
Metric Description Example Date Confirmed The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm Item Type The type of the Item or Payment in the Order. For example, Ticket, Merchandise, Donation or Membership. Text Total Charged The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value.
Related metrics: NETOutputs, VATOutputs
00.00
Ticket Vouchers
This Report shows a breakdown of Ticket Subscription vouchers owned by Customers. Useful for those reporting on Ticket Subscriptions.
-
Ticket Voucher
Metric Description Example Commission The value of the Ticket Commission of the Ticket Voucher, including tax. 00.00 Is Returned If the Ticket Voucher was returned, then the cell displays TRUE. TRUE/FALSE Price The value of the Ticket Voucher at the time it was purchased. Includes tax. Excludes Ticket Commissions. 00.00
View By Metric Name
In this section, metrics are organized by the name of the metric. Each metric will display a table showing the Report Type and wrapper where a metric is found.
REMINDER: This index lists only commonly used metrics. Not all metrics are listed here.
Click to skip to the table containing the metric (listed in alphabetical order):
- Metrics that start with A- G
- Metrics that start with I-L
- Metrics that start with M-R
- Metrics that start with S-Z
How to View Metrics By Metric Name
Each entry in this view will have the following components:
-
1. Metrics
You’ll find tabs that represent listed metrics. In this example, we see the metrics Amount, Levy, NetLevy and Price.
REMINDER: This index lists only commonly used metrics. Not all metrics are listed here.
In Spektrix, available metrics will appear when a wrapper is opened when selecting Output:
For existing unformatted Standard and Custom Reports, you can find the metrics as headings of the output columns:
REMINDER: The metrics in this index refer to the headings in the output columns on unformatted reports only. Formatted reports may share similar column names but may be calculated differently, for example, to include tax and commissions.
-
2. Report Type
This column lists all the Report Types the metric is available in. In this example, the Amount metric is found in the Accounting, Analysis, Campaigns and Sales Report Types.
In Spektrix, Report Type is selected at the start of building a custom report:
For existing Standard and Custom Reports, you can find its Report Type in the Report Explorer:
-
3. Wrappers
This column lists the wrappers the metric can be found within that Report Type.
In this example, the Amount metric is found in the Payments and Donations wrappers in Accounting and Analysis Report Types, the Campaign Items wrapper in the Campaigns Report Type and the Donations wrapper in the Sales Report Types.
REMINDER: A metric can appear in a Report Type more than once under different wrappers. However, these metrics will have different definitions and may not output the same values.
In Spektrix, wrappers will appear under Available Columns when selecting Output:
-
4. Description
The description of the metric in this wrapper and Report Type, which may include links to more information about the metric.
Some metrics may include Related Metrics in their descriptions. These metrics are accounting metrics that complement each other.
For example, Price with related metrics NetPrice and VATPrice, where Price is the value of an Item plus tax, NetPrice is the value of an Item excluding tax and VATPrice is the value of the tax on the Item.
Most accounting metrics follow a similar naming convention where "Metric" is the sum of "NetMetric" and "VATMetric."
REMINDER: You must use both the correct Report Type and wrapper, as definitions and values for metrics with the same name may differ. Metrics with the same name in the same Report Type will differ if they are from different wrappers.
-
5. Example
An example of how the metric will display when output. Common data output formats include:
-
00.00: A number value up to two decimal places. If a currency value, currency symbols won’t display. For example, the Price metric.
-
TRUE/FALSE: If the reported item has this value, the cell will display TRUE. If the reported item doesn’t have this value, the cell will display FALSE. For example, the Never Booked metric.
-
1/0: If the reported item has this value, the cell will display 1. If the reported item doesn’t have this value, the cell will display 0. For example, the Subscription is Current metric.
-
Text: A text value. For example, the Item Name metric.
- YYYY-MM-DD hh:mm: A date and time value displayed by year, month number, date, hour (24-hour format) and minutes. For example, the Date Confirmed metric.
-
00.00: A number value up to two decimal places. If a currency value, currency symbols won’t display. For example, the Price metric.
Metrics that start with A-G
-
Active
Report Type Wrapper Description Example Accounting Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Activities Campaigns If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Analysis Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Attendee Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Campaigns Campaigns If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE Customer Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Invitee Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Memberships Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Opportunities Campaigns If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Opportunity Stages Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Pledges & Legacies Campaigns If the Campaign, Sub-campaign or Sub-sub-campaign has the Inactive box unchecked, then the cell displays TRUE. TRUE/FALSE Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Sales Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE Soft Credit Customers If the Customer Record has the Active box checked, then the cell displays TRUE. TRUE/FALSE -
Amount
Report Type Wrapper Description Example Accounting Donations The amount received as a Donation in a transaction. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Donation to an Education fund, a line will be displayed for each Donation. 00.00 Payments The amount received as a Payment in a transaction. If a transaction takes two Payments, for example, a Card Payment and a Cash Payment, a line will be displayed for each Payment type. 00.00 Analysis Donations The amount received as a Donation in a transaction. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Donation to an Education fund, a line will be displayed for each Donation. 00.00 Payments The amount received as a Payment in a transaction. If a transaction takes two Payments, for example, a Card Payment and a Cash Payment, a line will be displayed for each Payment type. 00.00 Campaigns Campaign Items The amount received as a Donation linked to the Campaign, Sub-campaign or Sub-sub-campaign. This can include a Donation, a fulfilled Pledge, a fulfilled Legacy or the Donation portion of a Membership. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Pledge Installment, a line will be displayed for each Donation. 00.00 Sales Donations The amount received as a Donation in a transaction. If a transaction takes multiple Donations, for example, a Donation to a General Operating fund and a Donation to an Education fund, a line will be displayed for each Donation. 00.00 -
Area
Report Type Wrapper Description Example Accounting Tickets / Reservations The name of the Seating Plan Area of the Ticket or Reservation. Text Analysis Seats The name of the Seating Plan Area of the Seat. Text Tickets / Reservations The name of the Seating Plan Area of the Ticket or Reservation. Text Attendee Seats The name of the Seating Plan Area of the Seat. Text Tickets / Reservations The name of the Seating Plan Area of the Ticket or Reservation. Text Sales Seats The name of the Seating Plan Area of the Seat. Text Tickets / Reservations The name of the Seating Plan Area of the Ticket or Reservation. Text -
Booked Once
Report Type Wrapper Description Example Analysis Customers If the Customer has booked Tickets for only one Event ever, then the cell displays 1. This includes if they've booked for multiple Instances within the same Event or have bought Tickets for the same Event through multiple Orders. If they later return their Tickets, then they are no longer considered having booked once. 1/0 Customer Customers If the Customer has booked Tickets for only one Event ever, then the cell displays 1. This includes if they've booked for multiple Instances within the same Event or have bought Tickets for the same Event through multiple Orders. If they later return their Tickets, then they are no longer considered having booked once. 1/0 -
Commission
Report Type Wrapper Description Example Accounting Commissionable Items The gross value of the commission on the Item, including tax. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing
Related metrics: NetCommission, VATCommission
00.00 Analysis Commissionable Items The gross value of the commission on the Item, including tax. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing
Related metrics: NetCommission, VATCommission
00.00 Sales Commissionable Items The gross value of the commission on the Item, including tax. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing
Related metrics: NetCommission, VATCommission
00.00 Ticket Vouchers Ticket Voucher The value of the Ticket Commission of the Ticket Voucher, including tax. 00.00 -
Custom Payment Name
Report Type Wrapper Description Example Accounting Custom Payments The name of the Custom Payment Type used. Text Analysis Custom Payments The name of the Custom Payment Type used. Text -
Date
Report Type Wrapper Description Example Campaigns Campaign Items Depending on the Item Type, the following will display for:
- Donation: The Date Transaction Confirmed or Accounting Date of the Donation
- Membership: The Date Transaction Confirmed or Accounting Date of the Membership purchase or renewal
- Opportunity: Expected Close Date as entered when creating the Opportunity
- Pledge: Installment Date as calculated when creating the Pledge
- Legacy: The Date Transaction Confirmed or Accounting Date of the Donation when the Legacy is fulfilled.
YYYY-MM-DD hh:mm Customer Audit Customer Audit Outputs The date/time at which the change on the Customer Record was made. YYYY-MM-DD hh:mm Pledges & Legacies Pledges & Legacies Depending on the Item Type, the following will display for:
- Pledge: The Date of Pledge as entered in the Pledge details
- Legacy: The Date of Legacy as entered in the Legacy details. If the Legacy has been fulfilled, the Date Transaction Confirmed or Accounting Date
YYYY-MM-DD hh:mm -
Date Confirmed
Report Type Wrapper Description Example Accounting Transaction Items The date/time the transaction was confirmed by a Sales User or a Customer online. YYYY-MM-DD hh:mm Analysis Order Items The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm Mailing ROI Order Items The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm Sales Order Items The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm Soft Credit Order Items The date/time the most recent transaction was confirmed by a Sales User or a Customer online. For example, if Tickets were purchased and then later returned, the Date Confirmed would be the latest date which is the date returned. YYYY-MM-DD hh:mm -
Event Date/Time
Report Type Wrapper Description Example Accounting Event Instances The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm Analysis Event Instances The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm Attendee Event Instances The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm Event Instances Event Instances The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm Invitee Event Instances The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm Sales Event Instances The date/time of the Instance as entered in the Instance Details. YYYY-MM-DD hh:mm -
Event Name
Report Type Wrapper Description Example Accounting Events The name of the Event as entered in the Event Details. Text Analysis Events The name of the Event as entered in the Event Details. Text Attendee Events The name of the Event as entered in the Event Details. Text Event Instances Events The name of the Event as entered in the Event Details. Text Invitee Events The name of the Event as entered in the Event Details. Text Mailing ROI Events The name of the Event as entered in the Event Details. Text Sales Events The name of the Event as entered in the Event Details. Text -
Gross Value
Report Type Wrapper Description Example Analysis Seats The current default Price of the Seat, as set in the Price List. The Price depends on the Seat's Price Band and the selected default Web Ticket Type. 00.00 Attendee Seats The current default Price of the Seat, as set in the Price List. The Price depends on the Seat's Price Band and the selected default Web Ticket Type. 00.00 Sales Seats The current default Price of the Seat, as set in the Price List. The Price depends on the Seat's Price Band and the selected default Web Ticket Type. 00.00 -
Gross Value After Levy
Report Type Wrapper Description Example Sales Seats The current default Price of the Seat, as set in the Price List, excluding Levy. The Gross Value depends on the Seat's Price Band and the selected default Web Ticket Type. The Levy depends on the Seat's default Ticket Type and the Levy set on the Instance. 00.00 -
Gift Aid Claimable
Report Type Wrapper Description Example Accounting Donations If the Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation must not have been opted out of Gift Aid. TRUE/FALSE Analysis Donations If the Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation must not have been opted out of Gift Aid. TRUE/FALSE Campaign Campaign Items If the Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation must not have been opted out of Gift Aid. TRUE/FALSE Membership Memberships If the Donation portion of a Membership can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Donation portion of the Membership must not have been opted out of Gift Aid. TRUE/FALSE Sales Donations If the Ticket Donation can be claimed as Gift Aid and if the Customer has made a Gift Aid Declaration that starts before today (the day the Report is run) and ends after today (the day the Report is run), then the cell displays TRUE. The Ticket Donation must not have been opted out of Gift Aid. TRUE/FALSE -
Gift Aid Claimed
Report Type Wrapper Description Example Accounting Donations If the Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Analysis Donations If the Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Campaign Campaign Items If the Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Membership Memberships If the Donation portion of a Membership has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE Sales Donations If the Ticket Donation has been successfully claimed as Gift Aid using the Spektrix Gift Aid Claim tool, then the cell displays TRUE. TRUE/FALSE
Metrics that start with I-L
-
InsideCommissionPercentage
Report Type Wrapper Description Example Accounting Tickets / Reservations The gross monetary value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentageNet, InsideCommissionPercentageVAT
00.00 Sales Tickets / Reservations The gross monetary value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentageNet, InsideCommissionPercentageVAT
00.00 -
InsideCommissionPercentageNet
Report Type Wrapper Description Example Accounting Tickets / Reservations The net monetary value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageVAT
00.00 Sales Tickets / Reservations The net monetary value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageVAT
00.00 -
InsideCommissionPercentageVAT
Report Type Wrapper Description Example Accounting Tickets / Reservations The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageNet
00.00 Sales Tickets / Reservations The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is percentage based.
Related metrics: InsideCommissionPercentage, InsideCommissionPercentageNet
00.00 -
InsideCommissionRate
Report Type Wrapper Description Example Accounting Tickets / Reservations The rate of the Agent commission structure on the Ticket. Depending on how the rate is entered, the following will display:
- Percentage based: The decimal value. For example, 20% will display as 0.20.
- Value based: The value. For example, $5 will display as 5.00.
00.00 Sales Tickets / Reservations The rate of the Agent commission structure on the Ticket. Depending on how the rate is entered, the following will display:
- Percentage based: The decimal value. For example, 20% will display as 0.20.
- Value based: The value. For example, $5 will display as 5.00.
00.00 -
InsideCommissionValue
Report Type Wrapper Description Example Accounting Tickets / Reservations The gross value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is value based.
Related metrics: InsideCommissionValueNet, InsideCommissionValueVAT
00.00 Sales Tickets / Reservations The gross value of the Agent Commission set on the Ticket, including tax. The value will display only if the commission is value based.
Related metrics: InsideCommissionValueNet, InsideCommissionValueVAT
00.00 -
InsideCommissionValueNet
Report Type Wrapper Description Example Accounting Tickets / Reservations The net value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueVAT
00.00 Sales Tickets / Reservations The net value of the Agent Commission set on the Ticket, excluding tax on the Agent Commission. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueVAT
00.00 -
InsideCommissionValueVAT
Report Type Wrapper Description Example Accounting Tickets / Reservations The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueNet
00.00 Sales Tickets / Reservations The amount taxed on the Agent Commission set on the Ticket. The value will display only if the commission is value based.
Related metrics: InsideCommissionValue, InsideCommissionValueNet
00.00 -
Is Comp
Report Type Wrapper Description Example Accounting Tickets/Reservations If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 Analysis Tickets/Reservations If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 Attendee Tickets/Reservations If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 Sales Tickets/Reservations If the Ticket is a complimentary Ticket with a Total Charged value of zero, then the cell displays 1. 1/0 -
Is Returned
Report Type Wrapper Description Example Analysis Donations If the Donation was returned, then the cell displays TRUE. TRUE/FALSE Tickets/Reservations If the Ticket or Reservation was returned, then the cell displays TRUE. TRUE/FALSE Attendee Tickets/Reservations If the Ticket or Reservation was returned, then the cell displays TRUE. TRUE/FALSE Memberships Memberships If the Membership was returned, then the cell displays TRUE. TRUE/FALSE Sales Tickets/Reservations If the Ticket or Reservation was returned, then the cell displays TRUE. TRUE/FALSE Ticket Vouchers Ticket Voucher If the Ticket Voucher was returned, then the cell displays TRUE. TRUE/FALSE -
Item Name
Report Type Wrapper Description Example Campaigns Campaign Items The name of the Item that was purchased against the Campaign, Sub-campaign or Sub-sub-campaign. Depending on the Item type, the following will display:
- Donation: Fund name as entered in the Fund details.
- Pledge: Fund name as entered in the Pledge details.
- Memberships: Membership name as entered in the Membership details.
- Legacy: Fund name as entered in the Legacy details if the Legacy is fulfilled. The Item Type changes to Donation.
- Opportunities: Displays a blank cell.
Text -
Item Type
Report Type Wrapper Description Example Accounting Transaction Items The type of the Item or Payment in the transaction. For example, Ticket Sale, Card Payment or Transaction Commission. Text Analysis Order Items The type of the Item or Payment in the Order. For example, Ticket, Merchandise, Donation or Membership. Text Campaigns Campaign Items The type of the Item purchased against the Campaign, Sub-campaign or Sub-sub-campaign. For example, a Donation or a Membership. When a Pledge or Legacy is fulfilled, the Item Type changes to Donation. Memberships will split Item Type if they have a benefit (Membership) and donation portion (Donation). Text Sales Order Items The type of the Item or Payment in the Order. For example, Ticket, Merchandise, Donation or Membership. Text Soft Credit Order Items The type of the Item or Payment in the Order. For example, Ticket, Merchandise, Donation or Membership. Text -
Levy
Report Type Wrapper Description Example Accounting Purchase Items The gross value of the Levy set against the Ticket, including tax.
Related metrics: NetLevy, VATLevy
00.00 Analysis Tickets / Reservations The gross value of the Levy set against the Ticket, including tax.
Related metrics: NetLevy, VATLevy
00.00 Sales Tickets / Reservations The gross value of the Levy set against the Ticket, including tax.
Related metrics: NetLevy, VATLevy
00.00
Metrics that start with M-R
-
Membership Name
Report Type Wrapper Description Example Accounting Donations If the Donation was received as a portion of a Membership, then the cell displays the name of the Membership as entered in the Membership details. Text Memberships The name of the Membership as entered in the Membership details. Text Analysis Donations If the Donation was received as a portion of a Membership, then the cell displays the name of the Membership as entered in the Membership details. Text Memberships The name of the Membership as entered in the Membership details. Text Memberships Memberships The name of the Membership as entered in the Membership details. Text Soft Credit Memberships The name of the Membership as entered in the Membership details. Text -
NetCommission
Report Type Wrapper Description Example Accounting Commissionable Items The net value of the commission on the Item, excluding tax on the commission. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing.
Related metrics: Commission, VATCommission
00.00 Analysis Commissionable Items The net value of the commission on the Item, excluding tax on the commission. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing
Related metrics: Commission, VATCommission
00.00 Sales Commissionable Items The net value of the commission on the Item, excluding tax on the commission. Depending on the Item Type, the following will display for:
- Tickets: The value of the Ticket Commission
- Merchandise: The value of the Merchandise Postage and Packing
Related metrics: Commission, VATCommission
00.00 -
NetLevy
Report Type Wrapper Description Example Accounting Purchase Items The net value of the Levy set against the Ticket, excluding tax on the Levy.
Related metrics: Levy, VATLevy
00.00 Analysis Tickets / Reservations The net value of the Levy set against the Ticket, excluding tax on the Levy.
Related metrics: Levy, VATLevy
00.00 Sales Tickets / Reservations The net value of the Levy set against the Ticket, excluding tax on the Levy.
Related metrics: Levy, VATLevy
00.00 -
NetOutputs
Report Type Wrapper Description Example Accounting Transaction Items The total net amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and excluding tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, Levy. Excludes tax, Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
Related metrics: Total Charged, VATOutputs
00.00 -
NetPrice
Report Type Wrapper Description Example Accounting Purchase Items The net value of the Item at the time it was purchased, with any Offers or overrides applied. Depending on the Item Type, NetPrice will include and exclude the following for:
- Tickets: Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
- Merchandise: Excludes tax, Merchandise Postage and Packaging.
Related metrics: Price, VATPrice
00.00 Analysis Tickets/Reservations The net value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
Related metrics: Price, VATPrice
00.00 Attendee Tickets/Reservations The net value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
Related metrics: Price, VATPrice
00.00 Sales Tickets/Reservations The net value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes Levy, Agent Commission. Excludes tax, Ticket Commissions.
Related metrics: Price, VATPrice
00.00 -
NetPriceAfterLevy
Report Type Wrapper Description Example Accounting Purchase Items The net value of the Ticket, with any Offers or overrides applied and excluding Levy and tax. Also excludes Ticket Commissions. Includes Agent Commission.
Related metrics: PriceAfterLevy, VATPriceAfterLevy
00.00 Analysis Tickets/Reservations The net value of the Ticket, with any Offers or overrides applied and excluding Levy and tax. Also excludes Ticket Commissions. Includes Agent Commission.
Related metrics: PriceAfterLevy, VATPriceAfterLevy
00.00 Sales Tickets/Reservations The net value of the Ticket, with any Offers or overrides applied and excluding Levy and tax. Also excludes Ticket Commissions. Includes Agent Commission.
Related metrics: PriceAfterLevy, VATPriceAfterLevy
00.00 -
Never Booked
Report Type Wrapper Description Example Analysis Customers If the Customer has never booked Tickets for any Event ever, then the cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE Customer Customers If the Customer has never booked Tickets for any Event ever, then the cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE Memberships Customers If the Customer has never booked Tickets for any Event ever, then the cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE Soft Credit Customers If the Customer has never booked Tickets for any Event ever, then the cell displays TRUE. If a Customer returns their only Tickets to any Event, then they will revert back to the Never Booked status. TRUE/FALSE -
Potential Duplicate
Report Type Wrapper Description Example Accounting Customers If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE. TRUE/FALSE Analysis Customers If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE. TRUE/FALSE Customer Customers If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE. TRUE/FALSE Memberships Customers If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE. TRUE/FALSE Sales Customers If the Customer Record has been flagged as a potential duplicate of another Customer Record, based on matching first initial, last name and parts of the address (postcode/zip code or first line of the address), then the cell displays TRUE. TRUE/FALSE -
Price
Report Type Wrapper Description Example Accounting Purchase Items The value of the Item at the time it was purchased, with any Offers or overrides applied. Depending on the Item Type, Price will include and exclude the following for:
- Tickets: Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
- Merchandise: Includes tax. Excludes Merchandise Postage and Packaging.
Related metrics: NetPrice, VATPrice
00.00 Analysis Tickets/Reservations The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice
00.00 Attendee Tickets/Reservations The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice
00.00 Mailing ROI Tickets/Reservations The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice.
00.00 Memberships Memberships The value of the Membership at the time it was purchased, with any overrides applied. Includes tax. 00.00 Sales Tickets/Reservations The value of the Ticket at the time it was purchased, with any Offers or overrides applied. Includes tax, Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: NetPrice, VATPrice
00.00 Ticket Vouchers Ticket Voucher The value of the Ticket Voucher at the time it was purchased. Includes tax. Excludes Ticket Commissions. 00.00 -
PriceAfterLevy
Report Type Wrapper Description Example Accounting Purchase Items The value of the Ticket, with any Offers or overrides applied and excluding Levy. Also excludes Ticket Commissions. Includes tax, Agent Commission.
Related metrics: NetPriceAfterLevy, VATPriceAfterLevy
00.00 Analysis Tickets/Reservations The value of the Ticket, with any Offers or overrides applied and excluding Levy. Also excludes Ticket Commissions. Includes tax, Agent Commission.
Related metrics: NetPriceAfterLevy, VATPriceAfterLevy
00.00 Sales Tickets/Reservations The value of the Ticket, with any Offers or overrides applied and excluding Levy. Also excludes Ticket Commissions. Includes tax, Agent Commission.
Related metrics: NetPriceAfterLevy, VATPriceAfterLevy
00.00 -
Purchased with Donation
Report Type Wrapper Description Example Analysis Ticket / Reservations If the Order includes any Donation, then the cell displays TRUE. TRUE/FALSE -
Purchased with Ticket
Report Type Wrapper Description Example Analysis Donations If the Order includes any Ticket, then the cell displays TRUE. TRUE/FALSE
Metrics that start with S-Z
-
Subscription is Current
Report Type Wrapper Description Example Analysis Memberships If the Membership hasn't expired as of today, then the cell displays 1. This includes a Membership with an expiration date in the future or with no expiration date. 1/0 Memberships Memberships If the Membership hasn't expired as of today, then the cell displays 1. This includes a Membership with an expiration date in the future or with no expiration date. 1/0 Soft Credit Memberships If the Membership hasn't expired as of today, then the cell displays 1. This includes a Membership with an expiration date in the future or with no expiration date. 1/0 -
Subscription is Latest
Report Type Wrapper Description Example Analysis Memberships If the Membership is the Customer's latest subscription of the Membership type, then the cell displays 1. This includes current Memberships or the last expired Membership. 1/0 Memberships Memberships If the Membership is the Customer's latest subscription of the Membership type, then the cell displays 1. This includes current Memberships or the last expired Membership. 1/0 Soft Credit Memberships If the Membership is the Customer's latest subscription of the Membership type, then the cell displays 1. This includes current Memberships or the last expired Membership. 1/0 -
Total Charged
Report Type Wrapper Description Example Accounting Transaction Items The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value.
Related metrics: NETOutputs, VATOutputs
00.00 Analysis Order Items The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value.
Related metrics: NETOutputs, VATOutputs
00.00 Sales Order Items The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value.
Related metrics: NETOutputs, VATOutputs
00.00 Soft Credit Order Items The total gross amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied and including tax. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value.
Related metrics: NETOutputs, VATOutputs
00.00 -
Total Price
Report Type Wrapper Description Example Analysis Fixed Subscriptions The total sum of the values of all the Tickets in a Fixed Series, at the time it was purchased. Includes tax, Levy. Excludes Ticket Commissions. 00.00 -
Total Received
Report Type Wrapper Description Example Accounting Transaction Items The total amount received as a Payment. Depending on the Item Type purchased, Total Received is the inverse for:
- Tickets: The value of the Ticket, with any Offers or overrides applied. Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value for the refund.
00.00 Analysis Order Items The total amount received as a Payment. Depending on the Item Type purchased, Total Received is the inverse for:
- Tickets: The value of the Ticket, with any Offers or overrides applied. Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value for the refund.
00.00 Sales Order Items The total amount received as a Payment. Depending on the Item Type purchased, Total Received is the inverse for:
- Tickets: The value of the Ticket, with any Offers or overrides applied. Includes Ticket Commissions, tax, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
- Item return: Displays a negative value for the refund.
00.00 -
VATCommission
Report Type Wrapper Description Example Accounting Commissionable Items The amount taxed on the commission on the Item. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Commission
- Merchandise: The amount taxed on the Merchandise Postage and Packing
Related metrics: Commission, NetCommission
00.00 Analysis Commissionable Items The amount taxed on the commission on the Item. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Commission
- Merchandise: The amount taxed on the Merchandise Postage and Packing
Related metrics: Commission, NetCommission
00.00 Sales Commissionable Items The amount taxed on the commission on the Item. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Commission
- Merchandise: The amount taxed on the Merchandise Postage and Packing
Related metrics: Commission, NetCommission
00.00 -
VATLevy
Report Type Wrapper Description Example Accounting Purchase Items The amount taxed on the Levy set against the Ticket.
Related metrics: Levy, NetLevy
00.00 Analysis Tickets/Reservations The amount taxed on the Levy set against the Ticket.
Related metrics: Levy, NetLevy
00.00 Sales Tickets/Reservations The amount taxed on the Levy set against the Ticket.
Related metrics: Levy, NetLevy
00.00 -
VATOutputs
Report Type Wrapper Description Example Accounting Transaction Items The amount taxed on the total amount that a Customer or Agent is charged for the Item, with any Offers or overrides applied. Depending on the Item Type purchased, Total Charged for:
- Tickets: Includes Ticket Commissions, Levy. Excludes Agent Commission.
- Gift Vouchers: Displays a zero.
- Ticket Vouchers and Reissues: Displays a zero.
Related metrics: Total Charged, NETOutputs
00.00 -
VATPrice
Report Type Wrapper Description Example Accounting Purchase Items The amount taxed on the Item at the time it was purchased, with any Offers or overrides applied. Depending on the Item Type, the following will display for:
- Tickets: The amount taxed on the Ticket Price. Includes Levy, Agent Commission. Excludes Ticket Commissions.
- Merchandise: The amount taxed on the Merchandise Price. Excludes Merchandise Postage and Packaging.
Related metrics: Price, NetPrice
00.00 Analysis Tickets/Reservations The amount taxed on the Ticket at the time it was purchased, with any Offers or overrides applied. The Ticket Price includes Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: Price, NetPrice
00.00 Attendee Tickets/Reservations The amount taxed on the Ticket at the time it was purchased, with any Offers or overrides applied. The Ticket Price includes Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: Price, NetPrice
00.00 Sales Tickets/Reservations The amount taxed on the Ticket at the time it was purchased, with any Offers or overrides applied. The Ticket Price includes Levy, Agent Commission. Excludes Ticket Commissions.
Related metrics: Price, NetPrice
00.00 -
VATPriceAfterLevy
Report Type Wrapper Description Example Accounting Purchase Items The amount taxed on the Ticket Price, with any Offers or overrides applied and excluding Levy. The Ticket Price includes Agent Commission and excludes Ticket Commissions.
Related metrics: PriceAfterLevy, NetPriceAfterLevy
00.00 Analysis Tickets/Reservations The amount taxed on the Ticket Price, with any Offers or overrides applied and excluding Levy. The Ticket Price includes Agent Commission and excludes Ticket Commissions.
Related metrics: PriceAfterLevy, NetPriceAfterLevy
00.00 Sales Tickets/Reservations The amount taxed on the Ticket Price, with any Offers or overrides applied and excluding Levy. The Ticket Price includes Agent Commission and excludes Ticket Commissions.
Related metrics: PriceAfterLevy, NetPriceAfterLevy
00.00