Data Source Details

This guide provides a comprehensive reference to all the data sources available in our reporting platform. Whether you're analyzing ticket sales, monitoring operational efficiency, reconciling financials, or understanding customer behavior, each dataset is purpose-built to answer specific questions about your cinema’s performance.

These data sources are used in conjunction with our core report components—tables, aggregate charts, widgets, and time charts—to build flexible, powerful, and visually rich reports. Each source includes clearly defined fields and metrics, ranging from high-level summaries to line-item granularity, supporting everything from daily operations to strategic decision-making.

Where applicable, fields are marked as groupable, filterable, summable, or averagable, allowing for custom aggregation and filtering tailored to your needs.

Use this overview as a map to understand the structure of your data, explore its full potential, and ensure consistency in your analysis across teams and time periods.

Order Items
Individual line-item details for tickets, concessions, gift cards, and memberships.

Showings
Performance metrics per showing: attendance, revenue, concession per-caps, financials.

Tickets
Individual ticket sale details including timing, types, demographics. Granular analysis beyond showing-level data.

Payments
Transaction data across all payment methods.

Time Clock Sessions
Employee shift details, job types, pay calculations.

Cash Deposits
Cash deposit details such as amounts, personnel, and notes.

Cash Drops
Individual cash drops with amounts and personnel.

Cash Adjustments
Manual cash count adjustments with reasons and personnel.

Broken Seats
Unavailable seats, maintenance periods, affected tickets.

Screen Swap
Showing relocations between screens with original and new assignments.

Concession Per Cap
Per-customer spending across revenue streams.

Inventory Variance
Discrepancies between expected and actual inventory levels.

Inventory Item Adjustments
Inventory modifications with reasons and personnel.

Inventory Receipt Average Cost Prices
Average cost price of inventory receipts.

Inventory Item Sales Adjustment Comparison
Comparison of sales adjustments and computed sales quantities.

Inventory Sales Source
Order item sales sources for inventory items.

Box Office Report
Official Box Office Reports, which are used for studio reporting and revenue sharing calculations. Each entry represents a single playweek according to the Box Office Report (BOR) reporting cycle. The start and end dates can vary depending on the specific studio reporting rules.

Box Office Settlement
Box Office Settlements, used to track rental fees payable to studios.

Showings By Box Office Week
Showing data aligned with Box Office Report play weeks.

Tickets By Box Office Week
Ticket sales by Box Office Report play weeks.

Item Modifiers
Concession item customizations and add-ons.

Miscellaneous Items
Non-standard and promotional item sales.

Visit Reviews
Customer feedback on service aspects.

Page Views
Website traffic patterns and user behavior.

Membership Sales
Membership program transactions and changes.

Member Activity
Member interactions and benefit usage.

Historic Metrics
Long-term membership performance metrics.

Daily Deposits
Daily deposits across payment methods.

Transfer Payouts
Financial transfers and status updates.

Credit Card Reconciliation
Credit card reconciliation details.

Cash Counts
Cash count details.

Journal Entries
Double-entry financial transactions.

Order Item Taxes
Tax calculations by jurisdiction.

Gift Card Liability
Outstanding gift card balances and usage.

Malformed Orders
Orders with processing anomalies.

Accounting Adjustment Items
Manual accounting adjustments and reasons.

Reconciliation Data
Expected versus actual financial totals.

Sales Reconciliation Data
Sales validation across channels.

Effective Reconciliation Data
Transaction timing for accounting.

Paid Reconciliation Data
Payment completion verification.

Attendance Reconciliation Data
Ticket sales versus attendance.

Attendance Reconciliation
Ticket usage versus attendance.

Ticket Sales Reconciliation
Ticket revenue across channels.

Configuration Audit
System settings and operational parameters.

Configuration Audit Checks
Configuration changes and their authors.

Order Items Daily
Identical to Order Item Source, but computed daily instead of hourly, use for accounts receivable reporting.

Individual line-item details for tickets, concessions, gift cards, and memberships.

Groupable Fields

Identifiers

order_id (groupable, filterable)
The unique identifier for the order

Main

site (groupable, filterable)
The site

order_item_type (groupable, filterable)
The type of item in the order (ticket, concession, membership, etc.)

item (groupable, filterable)
The item being sold, such as popcorn, soda, etc.

item_variation (groupable, filterable)
The specific variation of an item such as the size of popcorn or type of drink. There is always exactly one item variation per item. When there is no need for a variation, the item variation is named Regular.

item_variation_and_item (groupable, filterable)
The item variation with the item name, e.g. Popcorn (Item) - Large ( Item Variation).

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Items and Inventory

item_class (groupable, filterable)
Item class of the inventory item

Packages and Products

item_package (groupable, filterable)
Packages that can be used to sell combinations of tickets, concessions, etc.

gift_card_amount (groupable, filterable)
Amount on gift card ($5, $10, $20, $50, $100, or custom)

Tickets

ticket_type (groupable, filterable)
The internal name of the type of the type of ticket (e.g. Adult After Price Change etc.)

Movie

movie (groupable, filterable)
The movie title

genre (groupable, filterable)
The genre of the movie

rating (groupable, filterable)
The rating of the movie (For everyone, PG, PG-13, R, etc.)

showing_badges (groupable, filterable)
Additional information about the showing such as if it is a 3D showing, IMAX, etc.

Purchase Analytics

relative_purchase_time (groupable, filterable)
Time of purchase relative to showing or effective time

showing_hour_of_day (groupable, filterable)
Hour of day when showing occurs

Payment Processing

payment_type (groupable, filterable)
The type of payment used (card, cash, gift card, etc.)

payment_subtype (groupable, filterable)
The specific subtype of payment used

Vouchers and Discounts

voucher_purchase (groupable, filterable)
Type of voucher being purchased

voucher_package_purchase (groupable, filterable)
Package of vouchers being purchased

redeemed_voucher (groupable, filterable)
Whether a voucher was redeemed

redeemed_voucher_type (groupable, filterable)
Type of voucher that was redeemed

redeemed_discount (groupable, filterable)
Whether a discount was redeemed

discount (groupable, filterable)
Type of discount applied

Membership Details

membership_owner_type (groupable, filterable)
Type of membership the owner has

order_user_membership_type (groupable, filterable)
Type of membership the ordering user has

Details

employee (groupable, filterable)
The employee that handled the order item purchase

register_station (groupable, filterable)
The physical register station where the transaction occurred

register_type (groupable, filterable)
The type of register (e.g., box office, concession)

delivery_type (groupable, filterable)
The method of delivery for the item

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

Invoice

company_name (groupable, filterable)
Name of company for business transactions

invoice (groupable, filterable)
Whether the order was invoiced

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

tax_description (groupable, filterable)
Description of the tax applied

taxable (groupable, filterable)
Whether the item is subject to tax

credit_sales (groupable, filterable)
Whether the transaction was a credit sale

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

showing_attribution_type (groupable, filterable)
How we determine the showing for the line item

Output Fields

Main

net (summable, averagable)
The amount paid by the customer, after all redemptions, and before taxes

gross (summable, averagable)
The total amount paid by the customer, including taxes

tax (summable, averagable)
The amount of tax applied to the item

count (summable)
The number of order items

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

group_gross (summable)
Percentage of gross amount within group

group_count (summable)
Percentage of count within group

profit (summable, averagable)
The profit of the order item, calculated as the net revenue less the cost

cost (summable, averagable)
The cost of the order item, calculated from the item variation and modifier costs or the ticket rental fee

Vouchers and Discounts

redeemed_voucher_value (summable, averagable)
Value of the redeemed voucher

discount_amount (summable, averagable)
Amount of discount applied in cents

redeemed_voucher_net (summable, averagable)
Net amount of redeemed voucher before taxes

redeemed_voucher_tax (summable, averagable)
Tax amount of redeemed voucher

redeemed_voucher_gross (summable, averagable)
Gross amount of redeemed voucher after taxes

recognized_voucher_revenue (summable, averagable)
Recognized revenue from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_net (summable, averagable)
Recognized net amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_tax (summable, averagable)
Recognized tax amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_gross (summable, averagable)
Recognized gross amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

Loyalty and Points

points_used (summable, averagable)
Number of loyalty points used in transaction

points_earned (summable, averagable)
Number of loyalty points earned from transaction

Statistics and Metrics

share (summable)
Percentage share of all entries

gross_share (summable)
Percentage share of gross revenue

profit_share (summable)
Percentage share of profit

Other Fields

Financial

profit_margin
The profit margin calculated as a percentage of net revenue

average_amount_cents
Average amount in cents

average_gross
Average gross per entry

average_profit
Average profit per entry

Source Only Fields

description

user_email

created_at

placed_at

paid_at

voided_at

effective_at

collected_at

prepared_at

delivered_at

date_and_time

state

user

id

user_id

Performance metrics per showing: attendance, revenue, concession per-caps, financials.

Groupable Fields

Timing

end_time (groupable, filterable)
End time of the showing

date (groupable, filterable)
Date of the showing

time_slot (groupable, filterable)
Time slot of the showing, e.g. Morning, Matinee, Evening, Late Night, as defined by the circuit

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Main

site (groupable, filterable)
The site

Movie

movie (groupable, filterable)
The movie title

studio (groupable, filterable)
The studio that distributed the movie

genre (groupable, filterable)
The genre of the movie

rating (groupable, filterable)
The rating of the movie (For everyone, PG, PG-13, R, etc.)

screen (groupable, filterable)
The screen where the movie was shown

showing_badges (groupable, filterable)
Additional information about the showing such as if it is a 3D showing, IMAX, etc.

title_class (groupable, filterable)
All movies have exactly one title class, used for grouping movies together for reporting purposes, and for controlling applicability of discounts and vouchers (e.g. Fathom Events, Virtual Reality, Event Cinema, etc.)

Box Office Report

box_office_week (groupable, filterable)
The Box Office Reporting week, independent of the actual day of the start of the reporting period, this will always resolve to the first day of the week

week_number (groupable, filterable)
Sequence of play week

Output Fields

Movie

showing_count (summable)
Number of showings

terms (averagable)
Terms of the showing agreement as a percentage

average_terms (averagable)
Average terms across showings

Statistics and Metrics

share (summable)
Percentage share of all entries

group_share (summable)
Percentage share of subgroup

Performance Metrics

tickets_sold (summable)
Number of tickets sold

seat_count (summable)
Total number of seats available at that time (i.e. broken seats are not included)

empty_count (summable)
Number of showings with no tickets sold

complimentary_count (summable)
Number of complimentary tickets sold (any ticket that was $0 for any reason, including free tickets, use of vouchers, 100% discounts, etc.)

refund_count (summable)
Number of tickets refunded

orders_with_concessions_count (summable)
Number of orders that include concession items

orders_with_tickets_count (summable)
Number of orders that include tickets

orders_with_tickets_and_concessions_count (summable)
Number of orders that include both tickets and concessions

total_orders_count (summable)
Total number of orders (tickets, concessions, or both)

Profit and Loss - Revenue

revenue (summable)
The sum of box office and concession net revenue

box_office_revenue (summable)
Total box office net revenue

concession_revenue (summable)
Total concession net revenue

concession_count (summable)
Number of concession items sold

Box Office Paid

box_office_retail_net (summable)
Net retail amount of the tickets sold at box office (the net price before any redemptions or taxes)

box_office_gross_paid (summable)
Total gross amount paid at box office after redemptions and after taxes, the amount the customer paid including taxes

box_office_tax_paid (summable)
Total tax paid at box office

box_office_net_paid (summable)
Total net amount paid at box office after redemptions and before taxes

Box Office Reported

box_office_net_reported (summable)
Net amount reported to the studio for box office sales

box_office_gross_reported (summable)
Gross amount reported to the studio for box office sales

Profit and Loss - Cost of Goods Sold

box_office_cost (summable)
Rental fee paid, calculated as box office net reported times the terms for this Box Office Report engagement (with fallback value of 60% terms if no terms were provided)

concession_cost (summable)
Cost of all concession items and modifiers sold (with fallback value of 70% profit margin, configurable at the circuit level if no cost was provided for the item or modifier)

cost (summable)
The sum of box office cost and concession cost

Profit and Loss - Gross Profit

gross_profit (summable)
The sum of box office gross profit and concession gross profit

gross_profit_share (summable)
Share of total gross profit

box_office_gross_profit (summable)
Gross profit from box office sales

concession_gross_profit (summable)
Gross profit from concession sales

Profit and Loss - Overhead and Margins

variable_overhead_cost (summable)
Variable overhead costs

variable_cost (summable)
Total variable costs

fixed_overhead_cost (summable)
Fixed overhead costs

contribution_margin (summable)
Contribution margin (revenue minus variable costs)

operating_profit (summable)
Operating profit (profit after all costs)

Timing

duration_hours (summable)
Duration of showing in hours

average_duration_hours (summable)
Average duration per showing in hours

Profit and Loss - Labor

allocated_labor_hours (summable)
Allocated labor hours

average_labor_hours (summable)
Average labor hours per showing

labor_hours (summable)
Total labor hours

allocated_labor_cost (summable)
Allocated cost of labor

average_labor_cost (summable)
Average labor cost per showing

labor_cost (summable)
Total labor cost

post_labor_profit (summable)
Profit after accounting for labor costs

Other Fields

Performance Metrics

occupancy
The number of tickets sold divided by the number of available seats at that time (i.e. broken seats are not included)

empty_percent
Percentage of showings with no tickets sold

strike_rate_per_ticket
Percentage of tickets that resulted in concession purchases (Count of orders with concessions / count of tickets sold)

strike_rate_per_ticket_order
Percentage of ticket orders that also included concessions (Count of orders with concessions / count of orders with tickets)

concession_items_per_ticket
Average number of concession items sold per ticket

Box Office Paid

average_box_office_retail_net
Average net retail amount per ticket sold at box office (the net price before any redemptions or taxes)

average_box_office_revenue
Average net box office revenue per ticket sold at box office (the net price before any redemptions or taxes)

average_box_office_gross_paid
Average gross amount paid per ticket sold at box office after redemptions and after taxes

average_box_office_net_paid
Average net amount paid per ticket sold at box office after redemptions and before taxes

Box Office Reported

average_box_office_net_reported
Average net reported amount per ticket sold at box office

average_box_office_gross_reported
Average gross amount reported to the studio per ticket sold at box office

Profit and Loss - Gross Profit

profit_margin
The profit margin calculated as a percentage of net revenue

box_office_profit_margin
Profit margin percentage for box office sales

concession_profit_margin
Profit margin percentage for concession sales

Statistics and Metrics

concession_per_cap
Average concession spending per ticket

average_revenue
Average revenue per ticket across all sources

average_cost
Average cost per ticket

average_gross_profit
Average gross profit per ticket

average_contribution_margin
Average contribution margin per ticket

Profit and Loss - Overhead and Margins

contribution_profit_margin
Contribution margin as a percentage of revenue

operating_profit_margin
Operating profit as a percentage of revenue

Profit and Loss - Labor

labor_cost_percentage
Labor cost as a percentage of total revenue

labor_hours_per_ticket
Number of labor hours per ticket sold

labor_cost_per_ticket
Labor cost per ticket sold

tickets_per_labor_hour
Number of tickets sold per labor hour

concessions_per_labor_hour
Number of concession items sold per labor hour

revenue_per_labor_hour
Total revenue generated per labor hour

box_office_revenue_per_labor_hour
Box office revenue generated per labor hour

concession_revenue_per_labor_hour
Concession revenue generated per labor hour

post_labor_profit_margin
Profit margin after labor costs

Source Only Fields

date_and_time

id

Individual ticket sale details including timing, types, demographics. Granular analysis beyond showing-level data.

Groupable Fields

User Activity

user_class (groupable, filterable)
Class of user

Main

site (groupable, filterable)
The site

Identifiers

site_identifier (groupable, filterable)
Unique identifier for a site

Movie

movie (groupable, filterable)
The movie title

studio (groupable, filterable)
The studio that distributed the movie

showing (groupable, filterable)
The showing of the movie

screen (groupable, filterable)
The screen where the movie was shown

showing_badges (groupable, filterable)
Additional information about the showing such as if it is a 3D showing, IMAX, etc.

title_class (groupable, filterable)
All movies have exactly one title class, used for grouping movies together for reporting purposes, and for controlling applicability of discounts and vouchers (e.g. Fathom Events, Virtual Reality, Event Cinema, etc.)

Timing

paid_at (groupable, filterable)
Date and time when the order was paid

date (groupable, filterable)
Effective date of entry

date_of_first_showing (groupable, filterable)
Date of the first showing of the movie

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Box Office

box_office_week (groupable, filterable)
The Box Office Reporting week, independent of the actual day of the start of the reporting period, this will always resolve to the first day of the week

Performance Metrics

seat_count (groupable, filterable)
Total number of seats available at that time (i.e. broken seats are not included)

Tickets

ticket_type (groupable, filterable)
The internal name of the type of the type of ticket (e.g. Adult After Price Change etc.)

ticket_type_display_name (groupable, filterable)
Display name for the ticket type as shown to customers (e.g. Adult, Child, Senior, etc.)

ticket_type_reporting_name (groupable, filterable)
Reporting name for the ticket type as a special reporting control to group tickets together, for example you might use Adult where the the ticket display name is Adult IMAX but you want to report on all adult tickets regardless of the format

box_office_reporting_name (groupable, filterable)
Box Office Reporting name for the ticket as reported to the stuido in the Box Office Report

seat_name (groupable, filterable)
Name or identifier of the seat, e.g. 1A or 10B

group_size (groupable, filterable)
Size of the group for group tickets

price_card (groupable, filterable)
New name of the collections of tickets available for the showing, e.g. Matinee, Evening, etc.

Vouchers and Discounts

voucher_type (groupable, filterable)
Type of voucher used

discount (groupable, filterable)
Type of discount applied

Membership Details

membership_owner_type (groupable, filterable)
Type of membership the owner has

order_user_membership_type (groupable, filterable)
Type of membership the ordering user has

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

Purchase Analytics

relative_purchase_time (groupable, filterable)
Time of purchase relative to showing or effective time

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

taxable (groupable, filterable)
Whether the item is subject to tax

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Ticket Counts

void_count (summable)
Number of tickets voided

Statistics and Metrics

count (summable)
Count of entries

share (summable)
Percentage share of all entries

group_share (summable)
Percentage share of subgroup

paid_count (summable)
Number of entries paid

showings_count (summable)
Number of showings

gross_reported (summable)
Gross amount reported

Performance Metrics

complimentary_count (summable)
Number of complimentary tickets sold (any ticket that was $0 for any reason, including free tickets, use of vouchers, 100% discounts, etc.)

collected_count (summable)
Number of tickets collected

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

net_paid (summable)
The amount paid by the customer, after all redemptions, and before taxes

gross_paid (summable)
The total amount paid by the customer, including taxes

retail_net (summable)
The retail price before any redemptions or taxes

net_reported (summable)
The net amount reported to the studio

tax_reported (summable)
The amount of tax reported

tax_paid (summable)
The amount of tax paid

Vouchers and Discounts

redeemed_voucher_value (summable, averagable)
Value of the redeemed voucher

discount_amount (summable, averagable)
Amount of discount applied in cents

recognized_voucher_revenue (summable, averagable)
Recognized revenue from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_tax (summable, averagable)
Recognized tax amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

Loyalty and Points

points_used (summable, averagable)
Number of loyalty points used in transaction

points_earned (summable, averagable)
Number of loyalty points earned from transaction

Tickets

booking_fee (summable)
Ticket booking fee

Movie

terms (averagable)
Terms of the showing agreement as a percentage

Profit and Loss - Cost of Goods Sold

cost (summable)
The sum of box office cost and concession cost

Profit

profit (summable)
The profit calculated as revenue minus cost

Other Fields

Statistics and Metrics

average_net_paid
Average net amount paid per entry

average_gross_paid
Average gross amount paid per entry

average_retail_net_paid
Average net retail amount paid per entry

average_net_reported
Average net amount reported per entry

average_gross_reported
Average gross amount reported per entry

Profit

profit_margin
The profit margin calculated as a percentage of net revenue

Source Only Fields

description

user_email

showing_time

created_at

placed_at

voided_at

effective_at

collected_at

date_and_time

state

user

id

order_id

user_id

Transaction data across all payment methods.

Groupable Fields

Main

site (groupable, filterable)
The site

type (groupable, filterable)
The type of record or transaction

subtype (groupable, filterable)
Additional type classification

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Payment Processing

payment_details (groupable, filterable)
Details of the payment

payment_type_reason (filterable)
Manually entered reason for the payment type

card_type (groupable, filterable)
Type of card used for payment

credit (groupable, filterable)
Whether the transaction is a credit

custom (groupable, filterable)
Whether the transaction is custom

refund (groupable, filterable)
Whether the transaction is a refund

Transfer Details

state (groupable, filterable)
The state of the transfer

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

Invoice

company_name (groupable, filterable)
Name of company for business transactions

invoice (groupable, filterable)
Whether the order was invoiced

Output Fields

Statistics and Metrics

count (summable)
Count of entries

share (summable)
Percentage share of all entries

group_share (summable)
Percentage share of subgroup

Financial

amount (summable)
The total amount of money collected through payments including redemptions and taxes

Credit Card Reconciliation

stripe_fee (summable, averagable)
Total amount of Stripe fees, including tax and net

indy_fee (summable, averagable)
Total amount of Indy fees

Other Fields

Statistics and Metrics

average_amount
Average amount per entry

Source Only Fields

employee

user_email

paid_at

date_and_time

name_on_card

last_four

stripe_payment_intent_id

terminal_transaction_ids

user

id

order_id

user_id

Employee shift details, job types, pay calculations.

Groupable Fields

Main

site (groupable, filterable)
The site

Identifiers

site_identifier (groupable, filterable)
Unique identifier for a site

Users

user (groupable, filterable)
User associated with the record

Time and Attendance

employee_id (groupable, filterable)
Employee identifier

job_type (groupable, filterable)
Type of job

Transfer Details

state (groupable, filterable)
The state of the transfer

Timing

date (groupable, filterable)
Effective date of the data

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

day (groupable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

started_at (groupable, filterable)
Start time of shift

ended_at (groupable, filterable)
End time of shift

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Details

created_manually (groupable, filterable)
Whether the record was created manually

Output Fields

Time and Attendance

hours_worked (summable)
Number of hours worked

source_hourly_rate (summable)
Source hourly rate

total_pay (summable)
Total pay for the period

sessions_clocked (summable)
Number of sessions clocked

Other Fields

Time and Attendance

hourly_rate
Rate per hour

average_hourly_rate
Average hourly rate

Source Only Fields

date_and_time

id

Cash deposit details such as amounts, personnel, and notes.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

Users

user (groupable, filterable)
User associated with the record

Notes

note (groupable, filterable)
Note content

Output Fields

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

Cash Management

cash_payment (summable, averagable)
Amount paid in cash

cash_refund (summable, averagable)
Amount refunded in cash

cash_net (summable, averagable)
Net cash transaction amount

cash_over_under (summable, averagable)
Cash over/under amount

expected_cash_deposit (summable, averagable)
Expected cash deposit amount

cash_deposit_over_under (summable, averagable)
Difference between actual and expected cash deposit

drop_count (summable)
Number of cash drops

Individual cash drops with amounts and personnel.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

Users

user (groupable, filterable)
User associated with the record

Notes

note (groupable, filterable)
Note content

Output Fields

Cash Management

drop_amount (summable, averagable)
Amount of cash dropped

drop_count (summable)
Number of cash drops

Manual cash count adjustments with reasons and personnel.

Groupable Fields

Main

site (groupable, filterable)
The site

description (groupable, filterable)
Detailed description of the record

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

Time and Attendance

employee (groupable, filterable)
The employee that handled the transaction

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

Source Only Fields

adjusted_at

id

Unavailable seats, maintenance periods, affected tickets.

Groupable Fields

Main

site (groupable, filterable)
The site

Movie

movie (groupable, filterable)
The movie title

showing (groupable, filterable)
The showing of the movie

screen (groupable, filterable)
The screen where the movie was shown

Tickets

seat_chart (groupable, filterable)
Name of the seat chart used for the showing, e.g. Screen 1 or "Screen 1 - No Front Row

seat (groupable, filterable)
Seat identifier, e.g. 1A or 10B

ticket (groupable, filterable)
Ticket associated with seat

broken_at (groupable, filterable)
When seat was marked as broken

broken_until (groupable, filterable)
When seat is expected to be fixed

Timing

date (groupable, filterable)
Effective date of entry

Users

user (groupable, filterable)
User associated with the record

order (groupable, filterable)
Order associated with the record

Showing relocations between screens with original and new assignments.

Groupable Fields

Movie

movie (groupable, filterable)
The movie title

showing (groupable, filterable)
The showing of the movie

screen (groupable, filterable)
The screen where the movie was shown

Users

user (groupable, filterable)
User associated with the record

Tickets

seat_name (groupable, filterable)
Name or identifier of the seat, e.g. 1A or 10B

original_screen (groupable, filterable)
Original screen for seat

original_seat_name (groupable, filterable)
Original name of seat

Per-customer spending across revenue streams.

Groupable Fields

Main

site (groupable, filterable)
The site

Output Fields

Performance Metrics

tickets_sold (summable)
Number of tickets sold

items_sold (summable)
Number of items sold

item_amount_cents (summable)
Amount in per item

Other Fields

Performance Metrics

per_cap
The number of dollars spent on concessions per ticket sold (uses only Item Classes that are designated to be included in per cap calculations and uses net or gross depending on the configuration)

items_per_order
Average number of items per order

Discrepancies between expected and actual inventory levels.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

Items and Inventory

location (groupable, filterable)
Location of inventory, e.g. Concession Stand 1, Kitchen, Stock Room, etc.

inventory_item (groupable, filterable)
The countable item in inventory that are used in a recipe, e.g. Single Box of Milkduds, Medium Soda Cup, Large Popcorn Bucket, Pizza Sauce, etc.

unit (groupable, filterable)
Unit of measurement, e.g. oz, g, ml, pcs

item_class (groupable, filterable)
Item class of the inventory item

Output Fields

Items and Inventory

unit_cost_entry (summable)
Entry for cost per unit of inventory

opening_balance_entry (summable)
Entry for opening balance of inventory

damage (summable)
Count of damaged inventory items

misc (summable)
Count of miscellaneous inventory adjustments

prep (summable)
Count of inventory prepared

prep_usage (summable)
Count of inventory prepared and used

receipts (summable)
Count of inventory receipts

theft (summable)
Count of inventory lost to theft

transfer_out (summable)
Count of inventory transferred out

transfer_in (summable)
Count of inventory transferred in

wastage (summable)
Count of inventory wastage

sales (summable)
Count of inventory sold

expected_closing_balance (summable)
Expected closing inventory balance

provisional_closing_balance_entry (summable)
Entry for provisional closing inventory balance

final_closing_balance_entry (summable)
Entry for actual closing inventory balance

variance (summable)
Difference between expected and actual inventory

Profit and Loss - Cost of Goods Sold

cost (summable)
The sum of box office cost and concession cost

Other Fields

Items and Inventory

unit_cost
Declared cost per unit of inventory

opening_balance
Opening balance of inventory

provisional_closing_balance
Provisional closing inventory balance

final_closing_balance
Actual closing inventory balance

Source Only Fields

Error processing columns for InventoryVarianceDataSource: Missing column sort value for key

Inventory modifications with reasons and personnel.

Groupable Fields

Items and Inventory

location (groupable, filterable)
Location of inventory, e.g. Concession Stand 1, Kitchen, Stock Room, etc.

inventory_item (groupable)
The countable item in inventory that are used in a recipe, e.g. Single Box of Milkduds, Medium Soda Cup, Large Popcorn Bucket, Pizza Sauce, etc.

unit (groupable)
Unit of measurement, e.g. oz, g, ml, pcs

adjustment_type (groupable, filterable)
The type of inventory adjustment

item_class (groupable)
Item class of the inventory item

Timing

date (groupable, filterable)
Effective date of the data

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Items and Inventory

qty (summable)
Quantity of inventory

unit_cost (summable)
Declared cost per unit of inventory

adj_cost (summable)
Cost of the inventory adjustment

adj_unit_cost (summable)
Cost per unit of the inventory adjustment

Profit and Loss - Cost of Goods Sold

cost (summable)
The sum of box office cost and concession cost

Source Only Fields

date_and_time

committed_at

adjustment_reason

Average cost price of inventory receipts.

Groupable Fields

Items and Inventory

inventory_item (groupable, filterable)
The countable item in inventory that are used in a recipe, e.g. Single Box of Milkduds, Medium Soda Cup, Large Popcorn Bucket, Pizza Sauce, etc.

item_class (groupable, filterable)
Item class of the inventory item

Output Fields

Items and Inventory

average_base_unit_cost (summable, averagable)
Average cost price of inventory receipts

current_base_unit_cost (summable)
Current cost price of inventory

base_unit_cost_difference (summable)
Difference between current and average cost price of inventory

Comparison of sales adjustments and computed sales quantities.

Groupable Fields

Items and Inventory

location (groupable, filterable)
Location of inventory, e.g. Concession Stand 1, Kitchen, Stock Room, etc.

inventory_item (groupable, filterable)
The countable item in inventory that are used in a recipe, e.g. Single Box of Milkduds, Medium Soda Cup, Large Popcorn Bucket, Pizza Sauce, etc.

item_class (groupable, filterable)
Item class of the inventory item

Output Fields

Items and Inventory

sales_adjustment_qty (summable)
Quantity of inventory sales adjustments

sales_computation_quantity (summable)
Quantity of inventory sold, computed from sales totals

sales_adjustment_qty_difference (summable)
Difference between sales adjustment quantity and computed sales quantity

Order item sales sources for inventory items.

Groupable Fields

Items and Inventory

inventory_item (groupable, filterable)
The countable item in inventory that are used in a recipe, e.g. Single Box of Milkduds, Medium Soda Cup, Large Popcorn Bucket, Pizza Sauce, etc.

source_location (groupable, filterable)
Location of item source

placed_register_station (groupable, filterable)
Register station where the item was placed

collected_register_station (groupable, filterable)
Register station where the item was collected

inventory_location (groupable, filterable)
Location of inventory

item_class (groupable, filterable)
Item class of the inventory item

Details

delivery_type (groupable, filterable)
The method of delivery for the item

Main

description (groupable)
Detailed description of the record

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Official Box Office Reports, which are used for studio reporting and revenue sharing calculations. Each entry represents a single playweek according to the Box Office Report (BOR) reporting cycle. The start and end dates can vary depending on the specific studio reporting rules.

Groupable Fields

Main

site (groupable, filterable)
The site

status (groupable, filterable)
Status of whether BOR has been sent out (complete), overdue, due now, or upcoming

Movie

movie (groupable, filterable)
The movie title

studio (groupable, filterable)
The studio that distributed the movie

movie_term (groupable, filterable)
The specific studio reporting term, usually associated with a format or language (e.g. 2D, 3D, IMAX, Spanish Subtitled, etc.)

Report Timing

box_office_week (groupable, filterable)
The Box Office Reporting week, independent of the actual day of the start of the reporting period, this will always resolve to the first day of the week

week_number (groupable, filterable, averagable)
Sequence of play week

start_date (groupable, filterable)
Start date of reporting period

end_date (groupable, filterable)
End date of reporting period

Invoice Status

has_invoice_date (groupable, filterable)
Whether report has invoice date

invoice_paid (groupable, filterable)
Whether invoice has been paid

invoice_date (groupable, filterable)
Date of invoice

invoice_date (groupable, filterable)
Date of invoice

invoice_number (groupable, filterable)
Invoice number

Engagement

has_flat_fee (groupable, filterable)
Whether or not this Box Office Report engagement requires a flat fee

has_minimum_guarantee (groupable, filterable)
Whether or not this Box Office Report engagement requires a minimum guarantee

Timing

date (groupable, filterable)
Effective date of the data

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Engagement

count (summable)
Number of Box Office Reports

flat_fee (summable, averagable)
The flat fee amount for this Box Office Report engagement

minimum_guarantee (summable, averagable)
The minimum guarantee amount for this Box Office Report engagement

deposit_paid (summable, averagable)
Whether or not a deposit is required for this Box Office Report engagement

Ticket Counts

complimentary_count (summable)
Number of complimentary tickets sold (any ticket that was $0 for any reason, including free tickets, use of vouchers, 100% discounts, etc.)

gross_count (summable)
The count of all tickets sold, including tickets that were later voided or refunded

void_count (summable)
Number of tickets voided

net_count (summable)
The count of tickets sold, excluding tickets that were later voided or refunded

Financial

gross_amount (summable, averagable)
The total amount paid by the customer, including taxes

tax_amount (summable, averagable)
The amount of tax applied to the item

net_amount (summable, averagable)
The net amount paid by the customer, after all redemptions, and before taxes

Fees

terms (averagable)
The term percentage for this engagement, as a percentage of the net amount

rental_fee (summable, averagable)
The total fee accumulated for this box office week, as before any retention fees are applied, and is either the flat fee or the term percentage of the net amount

retention_fee (averagable)
The total retention fee for this box office week, as a percentage of the rental fee

amount_due (summable, averagable)
The total amount due for this box office week, given the rental fee and retention fee, and the deposit paid

retention_due (summable, averagable)
The total retention amount due for this box office week, given the retention fee and the deposit paid

invoice_amount (summable, averagable)
The total amount invoiced for this box office week

remaining_due (summable, averagable)
The remaining amount due for this box office week, which is the amount due minus deposit paid and invoice amount, this will reflect a change if the term percentage is updated

Source Only Fields

showing_time

date_and_time

id

Box Office Settlements, used to track rental fees payable to studios.

Groupable Fields

Movie

movie (groupable, filterable)
The movie title

studio (groupable, filterable)
The studio that distributed the movie

movie_term (groupable, filterable)
The specific studio reporting term, usually associated with a format or language (e.g. 2D, 3D, IMAX, Spanish Subtitled, etc.)

Box Office Settlements

studio_settlement (groupable, filterable)
The batched settlement for a group of Box Office Settlements to be paid out in a single invoice

identifier (groupable, filterable)
The identifier for the Studio Settlement, e.g. SONY-0001, representing a unique invoice number

rental_source (groupable, filterable)
The source of the rental fee, e.g. Percentage, Flat Fee, Minimum Guarantee, etc.

submitted_at (groupable, filterable)
When the Box Office Settlement was submitted

finalized_at (groupable, filterable)
When the Box Office Settlement was finalized

Report Timing

week_of (groupable, filterable)
The weekly date for the Box Office Week, matching the typical first day of the week

week_number (groupable, filterable)
Sequence of play week

start_date (groupable, filterable)
Start date of reporting period

end_date (groupable, filterable)
End date of reporting period

Main

site (groupable, filterable)
The site

type (groupable, filterable)
The type of record or transaction

Transfer Details

state (groupable, filterable)
The state of the transfer

Timing

paid_at (groupable, filterable)
Date and time when the order was paid

voided_at (groupable, filterable)
Date and time when the order was voided

date (groupable, filterable)
Effective date of the data

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

Statistics and Metrics

count (summable)
Count of entries

Source Only Fields

rental_value

date_and_time

id

Showing data aligned with Box Office Report play weeks.

Groupable Fields

Timing

end_time (groupable, filterable)
End time of the showing

date (groupable, filterable)
Date of the showing

time_slot (groupable, filterable)
Time slot of the showing, e.g. Morning, Matinee, Evening, Late Night, as defined by the circuit

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Main

site (groupable, filterable)
The site

Movie

movie (groupable, filterable)
The movie title

studio (groupable, filterable)
The studio that distributed the movie

genre (groupable, filterable)
The genre of the movie

rating (groupable, filterable)
The rating of the movie (For everyone, PG, PG-13, R, etc.)

screen (groupable, filterable)
The screen where the movie was shown

showing_badges (groupable, filterable)
Additional information about the showing such as if it is a 3D showing, IMAX, etc.

title_class (groupable, filterable)
All movies have exactly one title class, used for grouping movies together for reporting purposes, and for controlling applicability of discounts and vouchers (e.g. Fathom Events, Virtual Reality, Event Cinema, etc.)

Box Office Report

box_office_week (groupable, filterable)
The Box Office Reporting week, independent of the actual day of the start of the reporting period, this will always resolve to the first day of the week

week_number (groupable, filterable)
Sequence of play week

Output Fields

Movie

showing_count (summable)
Number of showings

terms (averagable)
Terms of the showing agreement as a percentage

average_terms (averagable)
Average terms across showings

Statistics and Metrics

share (summable)
Percentage share of all entries

group_share (summable)
Percentage share of subgroup

Performance Metrics

tickets_sold (summable)
Number of tickets sold

seat_count (summable)
Total number of seats available at that time (i.e. broken seats are not included)

empty_count (summable)
Number of showings with no tickets sold

complimentary_count (summable)
Number of complimentary tickets sold (any ticket that was $0 for any reason, including free tickets, use of vouchers, 100% discounts, etc.)

refund_count (summable)
Number of tickets refunded

orders_with_concessions_count (summable)
Number of orders that include concession items

orders_with_tickets_count (summable)
Number of orders that include tickets

orders_with_tickets_and_concessions_count (summable)
Number of orders that include both tickets and concessions

total_orders_count (summable)
Total number of orders (tickets, concessions, or both)

Profit and Loss - Revenue

revenue (summable)
The sum of box office and concession net revenue

box_office_revenue (summable)
Total box office net revenue

concession_revenue (summable)
Total concession net revenue

concession_count (summable)
Number of concession items sold

Box Office Paid

box_office_retail_net (summable)
Net retail amount of the tickets sold at box office (the net price before any redemptions or taxes)

box_office_gross_paid (summable)
Total gross amount paid at box office after redemptions and after taxes, the amount the customer paid including taxes

box_office_tax_paid (summable)
Total tax paid at box office

box_office_net_paid (summable)
Total net amount paid at box office after redemptions and before taxes

Box Office Reported

box_office_net_reported (summable)
Net amount reported to the studio for box office sales

box_office_gross_reported (summable)
Gross amount reported to the studio for box office sales

Profit and Loss - Cost of Goods Sold

box_office_cost (summable)
Rental fee paid, calculated as box office net reported times the terms for this Box Office Report engagement (with fallback value of 60% terms if no terms were provided)

concession_cost (summable)
Cost of all concession items and modifiers sold (with fallback value of 70% profit margin, configurable at the circuit level if no cost was provided for the item or modifier)

cost (summable)
The sum of box office cost and concession cost

Profit and Loss - Gross Profit

gross_profit (summable)
The sum of box office gross profit and concession gross profit

gross_profit_share (summable)
Share of total gross profit

box_office_gross_profit (summable)
Gross profit from box office sales

concession_gross_profit (summable)
Gross profit from concession sales

Profit and Loss - Overhead and Margins

variable_overhead_cost (summable)
Variable overhead costs

variable_cost (summable)
Total variable costs

fixed_overhead_cost (summable)
Fixed overhead costs

contribution_margin (summable)
Contribution margin (revenue minus variable costs)

operating_profit (summable)
Operating profit (profit after all costs)

Timing

duration_hours (summable)
Duration of showing in hours

average_duration_hours (summable)
Average duration per showing in hours

Profit and Loss - Labor

allocated_labor_hours (summable)
Allocated labor hours

average_labor_hours (summable)
Average labor hours per showing

labor_hours (summable)
Total labor hours

allocated_labor_cost (summable)
Allocated cost of labor

average_labor_cost (summable)
Average labor cost per showing

labor_cost (summable)
Total labor cost

post_labor_profit (summable)
Profit after accounting for labor costs

Other Fields

Performance Metrics

occupancy
The number of tickets sold divided by the number of available seats at that time (i.e. broken seats are not included)

empty_percent
Percentage of showings with no tickets sold

strike_rate_per_ticket
Percentage of tickets that resulted in concession purchases (Count of orders with concessions / count of tickets sold)

strike_rate_per_ticket_order
Percentage of ticket orders that also included concessions (Count of orders with concessions / count of orders with tickets)

concession_items_per_ticket
Average number of concession items sold per ticket

Box Office Paid

average_box_office_retail_net
Average net retail amount per ticket sold at box office (the net price before any redemptions or taxes)

average_box_office_revenue
Average net box office revenue per ticket sold at box office (the net price before any redemptions or taxes)

average_box_office_gross_paid
Average gross amount paid per ticket sold at box office after redemptions and after taxes

average_box_office_net_paid
Average net amount paid per ticket sold at box office after redemptions and before taxes

Box Office Reported

average_box_office_net_reported
Average net reported amount per ticket sold at box office

average_box_office_gross_reported
Average gross amount reported to the studio per ticket sold at box office

Profit and Loss - Gross Profit

profit_margin
The profit margin calculated as a percentage of net revenue

box_office_profit_margin
Profit margin percentage for box office sales

concession_profit_margin
Profit margin percentage for concession sales

Statistics and Metrics

concession_per_cap
Average concession spending per ticket

average_revenue
Average revenue per ticket across all sources

average_cost
Average cost per ticket

average_gross_profit
Average gross profit per ticket

average_contribution_margin
Average contribution margin per ticket

Profit and Loss - Overhead and Margins

contribution_profit_margin
Contribution margin as a percentage of revenue

operating_profit_margin
Operating profit as a percentage of revenue

Profit and Loss - Labor

labor_cost_percentage
Labor cost as a percentage of total revenue

labor_hours_per_ticket
Number of labor hours per ticket sold

labor_cost_per_ticket
Labor cost per ticket sold

tickets_per_labor_hour
Number of tickets sold per labor hour

concessions_per_labor_hour
Number of concession items sold per labor hour

revenue_per_labor_hour
Total revenue generated per labor hour

box_office_revenue_per_labor_hour
Box office revenue generated per labor hour

concession_revenue_per_labor_hour
Concession revenue generated per labor hour

post_labor_profit_margin
Profit margin after labor costs

Source Only Fields

date_and_time

id

Ticket sales by Box Office Report play weeks.

Groupable Fields

User Activity

user_class (groupable, filterable)
Class of user

Main

site (groupable, filterable)
The site

Identifiers

site_identifier (groupable, filterable)
Unique identifier for a site

Movie

movie (groupable, filterable)
The movie title

studio (groupable, filterable)
The studio that distributed the movie

showing (groupable, filterable)
The showing of the movie

screen (groupable, filterable)
The screen where the movie was shown

showing_badges (groupable, filterable)
Additional information about the showing such as if it is a 3D showing, IMAX, etc.

title_class (groupable, filterable)
All movies have exactly one title class, used for grouping movies together for reporting purposes, and for controlling applicability of discounts and vouchers (e.g. Fathom Events, Virtual Reality, Event Cinema, etc.)

Timing

paid_at (groupable, filterable)
Date and time when the order was paid

date (groupable, filterable)
Effective date of entry

date_of_first_showing (groupable, filterable)
Date of the first showing of the movie

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Box Office

box_office_week (groupable, filterable)
The Box Office Reporting week, independent of the actual day of the start of the reporting period, this will always resolve to the first day of the week

Performance Metrics

seat_count (groupable, filterable)
Total number of seats available at that time (i.e. broken seats are not included)

Tickets

ticket_type (groupable, filterable)
The internal name of the type of the type of ticket (e.g. Adult After Price Change etc.)

ticket_type_display_name (groupable, filterable)
Display name for the ticket type as shown to customers (e.g. Adult, Child, Senior, etc.)

ticket_type_reporting_name (groupable, filterable)
Reporting name for the ticket type as a special reporting control to group tickets together, for example you might use Adult where the the ticket display name is Adult IMAX but you want to report on all adult tickets regardless of the format

box_office_reporting_name (groupable, filterable)
Box Office Reporting name for the ticket as reported to the stuido in the Box Office Report

seat_name (groupable, filterable)
Name or identifier of the seat, e.g. 1A or 10B

group_size (groupable, filterable)
Size of the group for group tickets

price_card (groupable, filterable)
New name of the collections of tickets available for the showing, e.g. Matinee, Evening, etc.

Vouchers and Discounts

voucher_type (groupable, filterable)
Type of voucher used

discount (groupable, filterable)
Type of discount applied

Membership Details

membership_owner_type (groupable, filterable)
Type of membership the owner has

order_user_membership_type (groupable, filterable)
Type of membership the ordering user has

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

Purchase Analytics

relative_purchase_time (groupable, filterable)
Time of purchase relative to showing or effective time

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

taxable (groupable, filterable)
Whether the item is subject to tax

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Ticket Counts

void_count (summable)
Number of tickets voided

Statistics and Metrics

count (summable)
Count of entries

share (summable)
Percentage share of all entries

group_share (summable)
Percentage share of subgroup

paid_count (summable)
Number of entries paid

showings_count (summable)
Number of showings

gross_reported (summable)
Gross amount reported

Performance Metrics

complimentary_count (summable)
Number of complimentary tickets sold (any ticket that was $0 for any reason, including free tickets, use of vouchers, 100% discounts, etc.)

collected_count (summable)
Number of tickets collected

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

net_paid (summable)
The amount paid by the customer, after all redemptions, and before taxes

gross_paid (summable)
The total amount paid by the customer, including taxes

retail_net (summable)
The retail price before any redemptions or taxes

net_reported (summable)
The net amount reported to the studio

tax_reported (summable)
The amount of tax reported

tax_paid (summable)
The amount of tax paid

Vouchers and Discounts

redeemed_voucher_value (summable, averagable)
Value of the redeemed voucher

discount_amount (summable, averagable)
Amount of discount applied in cents

recognized_voucher_revenue (summable, averagable)
Recognized revenue from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_tax (summable, averagable)
Recognized tax amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

Loyalty and Points

points_used (summable, averagable)
Number of loyalty points used in transaction

points_earned (summable, averagable)
Number of loyalty points earned from transaction

Tickets

booking_fee (summable)
Ticket booking fee

Movie

terms (averagable)
Terms of the showing agreement as a percentage

Profit and Loss - Cost of Goods Sold

cost (summable)
The sum of box office cost and concession cost

Profit

profit (summable)
The profit calculated as revenue minus cost

Other Fields

Statistics and Metrics

average_net_paid
Average net amount paid per entry

average_gross_paid
Average gross amount paid per entry

average_retail_net_paid
Average net retail amount paid per entry

average_net_reported
Average net amount reported per entry

average_gross_reported
Average gross amount reported per entry

Profit

profit_margin
The profit margin calculated as a percentage of net revenue

Source Only Fields

description

user_email

showing_time

created_at

placed_at

voided_at

effective_at

collected_at

date_and_time

state

user

id

order_id

user_id

Concession item customizations and add-ons.

Groupable Fields

Main

site (groupable, filterable)
The site

item (groupable, filterable)
The item being sold, such as popcorn, soda, etc.

item_variation (groupable, filterable)
The specific variation of an item such as the size of popcorn or type of drink. There is always exactly one item variation per item. When there is no need for a variation, the item variation is named Regular.

Items and Inventory

modifier (groupable, filterable)
Add-ons or adjustments to an item such as extra butter on popcorn, or a specific topping on a pizza. There can be multiple item modifiers per item.

modifier_set (groupable, filterable)
Sets of modifiers that are applicable on an item.

item_class (groupable, filterable)
Item class of the inventory item

Identifiers

order_id (groupable)
The unique identifier for the order

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Packages and Products

item_package (groupable, filterable)
Packages that can be used to sell combinations of tickets, concessions, etc.

Time and Attendance

employee (groupable, filterable)
The employee that handled the transaction

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Vouchers and Discounts

discount (groupable, filterable)
Type of discount applied

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

taxable (groupable, filterable)
Whether the item is subject to tax

Output Fields

Statistics and Metrics

count (summable, averagable)
Count of entries

share (summable)
Percentage share of all entries

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

group_count (summable)
Percentage of count within group

group_amount (summable)
Percentage of total amount within group

Order Items

modifier_amount (summable, averagable)
Amount of the modifier applied to an item

Other Fields

Statistics and Metrics

average_amount_cents
Average amount in cents

Source Only Fields

created_at

placed_at

paid_at

voided_at

effective_at

collected_at

prepared_at

delivered_at

date_and_time

id

Non-standard and promotional item sales.

Groupable Fields

Main

site (groupable, filterable)
The site

order_item_type (groupable, filterable)
The type of item in the order (ticket, concession, membership, etc.)

description (groupable, filterable)
Detailed description of the record

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

Invoice

company_name (groupable, filterable)
Name of company for business transactions

invoice (groupable, filterable)
Whether the order was invoiced

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

taxable (groupable, filterable)
Whether the item is subject to tax

Time and Attendance

employee (groupable, filterable)
The employee that handled the transaction

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Timing

date (groupable, filterable)
Effective date of the data

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

net (summable, averagable)
The amount paid by the customer, after all redemptions, and before taxes

gross (summable, averagable)
The total amount paid by the customer, including taxes

tax (summable, averagable)
The amount of tax applied to the item

Other Fields

Statistics and Metrics

average_amount_cents
Average amount in cents

Source Only Fields

user_email

created_at

placed_at

paid_at

voided_at

effective_at

date_and_time

state

user

id

order_id

user_id

Customer feedback on service aspects.

Groupable Fields

Main

site (groupable, filterable)
The site

Identifiers

site_id (groupable, filterable)
ID of the site

Movie

movie (groupable, filterable)
The movie title

movie_rating (groupable, filterable)
Rating given to the movie by customers

Visit Reviews

comments (groupable, filterable)
Review comment left by the user

Tickets

seat_name (groupable, filterable)
Name or identifier of the seat, e.g. 1A or 10B

Users

user (groupable, filterable)
User associated with the record

age_range (groupable, filterable)
Age range of user

Membership

membership_type (groupable, filterable)
Type of membership

Details

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

box_office_sale (groupable, filterable)
Whether the sale was made at the box office through a kiosk or register

online_sale (groupable, filterable)
Whether the sale was made online

Time and Attendance

employee (groupable, filterable)
The employee that handled the transaction

Timing

created_at (groupable, filterable)
Date and time when the record was created

date (groupable, filterable)
Date of the showing

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Statistics and Metrics

movie_rating_value (summable, averagable)
Rating value for movie

staff_rating_value (summable, averagable)
Rating value for staff

staff_rating_value (summable, averagable)
Rating value for staff

staff_rating_number (summable, averagable)
Numeric rating for staff

cleanliness_rating_value (summable, averagable)
Rating value for cleanliness

cleanliness_rating_value (summable, averagable)
Rating value for cleanliness

cleanliness_rating_number (summable, averagable)
Numeric rating for cleanliness

overall_rating_value (summable, averagable)
Rating value for overall

overall_rating_value (summable, averagable)
Rating value for overall

overall_rating_number (summable, averagable)
Numeric rating for overall

count_of_movie_ratings (summable, averagable)
Number of movie ratings

count_of_staff_ratings (summable, averagable)
Number of staff ratings

count_of_staff_ratings (summable, averagable)
Number of staff ratings

count_of_cleanliness_ratings (summable, averagable)
Number of cleanliness ratings

count_of_cleanliness_ratings (summable, averagable)
Number of cleanliness ratings

count_of_overall_ratings (summable, averagable)
Number of overall ratings

count_of_overall_ratings (summable, averagable)
Number of overall ratings

Users

age (averagable)
Age of user

Other Fields

Statistics and Metrics

average_staff_rating
The average rating of staff members from 1-4 represented by a smiley icon

average_cleanliness_rating
The average rating of theater cleanliness from 1-4 represented by a smiley icon

average_overall_rating
The average rating of the movie from 1-4 represented by a smiley icon

movie_rating_number
Numeric rating for movie

Source Only Fields

user_email

date_and_time

Website traffic patterns and user behavior.

Groupable Fields

Details

page_name (groupable, filterable)
Name of the page on the website

os (groupable, filterable)
Operating system

device_type (groupable, filterable)
Type of device

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Membership program transactions and changes.

Groupable Fields

Main

site (groupable, filterable)
The site

Membership

membership_type (groupable, filterable)
Type of membership

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

taxable (groupable, filterable)
Whether the item is subject to tax

Time and Attendance

employee (groupable, filterable)
The employee that handled the transaction

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Timing

date (groupable, filterable)
Effective date of the data

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

net (summable, averagable)
The amount paid by the customer, after all redemptions, and before taxes

gross (summable, averagable)
The total amount paid by the customer, including taxes

tax (summable, averagable)
The amount of tax applied to the item

Vouchers and Discounts

discount_amount (summable, averagable)
Amount of discount applied in cents

Other Fields

Statistics and Metrics

average_amount_cents
Average amount in cents

Source Only Fields

description

detail

created_at

placed_at

paid_at

voided_at

effective_at

date_and_time

state

user

id

order_id

user_id

Member interactions and benefit usage.

Groupable Fields

Main

site (groupable, filterable)
The site

User Activity

logged_in (groupable, filterable)
Whether user is logged in

user_class (groupable, filterable)
Class of user

relative_date_of_last_order (groupable, filterable)
Days since last order

Membership

membership_type (groupable, filterable)
Type of membership

membership_tier (groupable, filterable)
Tier of membership

membership_state (groupable, filterable)
State of membership

membership_renewing (groupable, filterable)
Whether membership is renewing

Output Fields

User Activity

order_count (summable)
Number of orders

order_amount (summable)
Total amount of orders

user_count (summable)
Number of users

Other Fields

Statistics and Metrics

average_order_amount
Average amount per order

average_user_amount
Average amount per user

Long-term membership performance metrics.

Groupable Fields

Packages and Products

preferred_site (groupable, filterable)
Preferred site for the customer

Membership

membership_type (groupable, filterable)
Type of membership

Timing

date (groupable, filterable)
Effective date of entry

Output Fields

Membership

new_members (summable)
Count of new members

renewed_members (summable)
Count of renewed members

resurrected_members (summable)
Count of resurrected members

upgraded_members (summable)
Count of upgraded members

downgraded_members (summable)
Count of downgraded members

canceled_members (summable)
Count of canceled members

lapsed_members (summable)
Count of lapsed members

active_members (summable)
Count of active members

Daily deposits across payment methods.

Groupable Fields

Identifiers

id (groupable)
The unique identifier for the entry

Transfer Details

state (groupable, filterable)
The state of the transfer

business_date (groupable, filterable)
The business date for this transfer

executed_date (groupable, filterable)
The date the transfer was executed

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Credit Card Reconciliation

credit_card_deposit_arrival_dates (groupable, filterable)
Credit Card Deposit Arrival Dates

credit_card_deposits (groupable)
Credit Card Deposits

Disputes and Deposits

external_ticketing_deposit_arrival_date (groupable, filterable)
The arrival date for the external ticketing deposit

Output Fields

Payment Processing

credit_card_payment (summable, averagable)
Amount paid by credit card

credit_card_refund (summable, averagable)
Amount refunded to credit card

credit_card_net (summable, averagable)
Net credit card transaction amount

credit_card_net_minus_fees (summable, averagable)
Net credit card amount after fees

windcave_payment (summable, averagable)
Amount processed through Windcave

windcave_refund (summable, averagable)
Amount refunded through Windcave

windcave_net (summable, averagable)
Net Windcave transaction amount

Credit Card Reconciliation

stripe_fee (summable, averagable)
Total amount of Stripe fees, including tax and net

stripe_fee_tax (summable, averagable)
Total amount of Stripe fees taxes

stripe_fee_net (summable, averagable)
Total amount of Stripe fees net of taxes

indy_fee (summable, averagable)
Total amount of Indy fees

Disputes and Deposits

lost_dispute (summable, averagable)
The amount lost in disputes for this Box Office Report engagement

lost_dispute_fee (summable, averagable)
The fees from lost disputes for this Box Office Report engagement

lost_dispute_and_fee (summable, averagable)
The total of lost disputes and fees for this Box Office Report engagement

external_ticketing_deposit (summable, averagable)
The deposit from external ticketing systems for this Box Office Report engagement

deposit (summable, averagable)
The total deposit amount for this Box Office Report engagement

Cash Management

cash_payment (summable, averagable)
Amount paid in cash

cash_refund (summable, averagable)
Amount refunded in cash

cash_net (summable, averagable)
Net cash transaction amount

cash_deposit (summable, averagable)
Amount deposited in cash

cash_count_amount (summable, averagable)
Amount counted in cash

cash_over_under (summable, averagable)
Cash over/under amount

expected_cash_deposit (summable, averagable)
Expected cash deposit amount

cash_deposit_over_under (summable, averagable)
Difference between actual and expected cash deposit

Financial

net (summable, averagable)
The amount paid by the customer, after all redemptions, and before taxes

gross (summable, averagable)
The total amount paid by the customer, including taxes

tax (summable, averagable)
The amount of tax applied to the item

Source Only Fields

date_and_time

Financial transfers and status updates.

Groupable Fields

Transfer Details

payout_id (groupable, filterable)
The ID of the payout for this transfer

transfer_id (groupable, filterable)
The ID of the transfer for this payout

payout_type (groupable, filterable)
The type of payout for this transfer

computed_at (groupable, filterable)
When the payout was computed

scheduled_start_date (groupable, filterable)
The scheduled start date for this transfer

transfered_at (groupable, filterable)
When the transfer occurred

arrival_date (groupable, filterable)
The expected arrival date for this transfer

payout_error (filterable)
Error in payout if any

descriptor (filterable)
The descriptor for this transfer that will appear on the recipient's bank statement

Main

site (groupable, filterable)
The site

status (groupable, filterable)
Status of the record

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Financial

amount (summable)
The retail price of the item or service before redemptions and taxes

Source Only Fields

date_and_time

id

Credit card reconciliation details.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

Output Fields

Credit Card Reconciliation

credit_card_payment_total (summable)
Total amount of credit card payments

credit_card_payment_count (summable)
Total count of credit card payments

credit_card_refund_total (summable)
Total amount of credit card refunds

credit_card_refund_count (summable)
Total count of credit card refunds

credit_card_count_net (summable)
Net count of credit card payments

stripe_fee (summable)
Total amount of Stripe fees, including tax and net

stripe_fee_tax (summable)
Total amount of Stripe fees taxes

stripe_fee_net (summable)
Total amount of Stripe fees net of taxes

indy_fee (summable)
Total amount of Indy fees

lost_disputes_net (summable)
Total amount of lost disputes net of taxes

prior_day_balance (summable)
The prior day balance

external_ticketing_payment_total (summable)
Total amount of external ticketing payments

external_ticketing_refund_total (summable)
Total amount of external ticketing refunds

Source Only Fields

id

Cash count details.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Cash Counts

cash_paid_count (summable)
Total count of cash paid

cash_paid (summable)
Total amount of cash paid

cash_refunded_count (summable)
Total count of cash refunded

cash_refunded (summable)
Total amount of cash refunded

net_received_count (summable)
Total count of net received

net_received (summable)
Total amount of net received

adjustment_count (summable)
Total count of adjustments

adjustment_amount (summable)
Total amount of adjustments

cash_count (summable)
Total amount of cash counted

over_under (summable)
Total amount of over or under

Source Only Fields

date_and_time

Double-entry financial transactions.

Groupable Fields

Main

site (groupable, filterable)
The site

type (groupable, filterable)
The type of record or transaction

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Accounting

cr_dt (groupable, filterable)
Credit/Debit indicator

account (groupable, filterable)
Account name

gl_code (groupable, filterable)
General ledger code

source (groupable, filterable)
Source of the transaction

contra (groupable, filterable)
Contra account indicator

detail (groupable, filterable)
The journal entry detail

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

tax_description (groupable, filterable)
Description of the tax applied

Output Fields

Financial

amount (summable)
The retail price of the item or service before redemptions and taxes

gross_amount (summable)
The total amount paid by the customer, including taxes

tax_amount (summable)
The amount of tax applied to the item

net_amount (summable)
The net amount paid by the customer, after all redemptions, and before taxes

Source Only Fields

date_and_time

id

Tax calculations by jurisdiction.

Groupable Fields

Identifiers

order_id (groupable)
The unique identifier for the order

Main

site (groupable, filterable)
The site

order_item_type (groupable, filterable)
The type of item in the order (ticket, concession, membership, etc.)

item (groupable, filterable)
The item being sold, such as popcorn, soda, etc.

item_variation (groupable, filterable)
The specific variation of an item such as the size of popcorn or type of drink. There is always exactly one item variation per item. When there is no need for a variation, the item variation is named Regular.

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

credit_sales (groupable, filterable)
Whether the transaction was a credit sale

Items and Inventory

item_class (groupable, filterable)
Item class of the inventory item

Packages and Products

item_package (groupable, filterable)
Packages that can be used to sell combinations of tickets, concessions, etc.

Tickets

ticket_type (groupable, filterable)
The internal name of the type of the type of ticket (e.g. Adult After Price Change etc.)

Vouchers and Discounts

voucher_purchase (groupable, filterable)
Type of voucher being purchased

voucher_package_purchase (groupable, filterable)
Package of vouchers being purchased

redeemed_voucher (groupable, filterable)
Whether a voucher was redeemed

redeemed_voucher_type (groupable, filterable)
Type of voucher that was redeemed

redeemed_discount (groupable, filterable)
Whether a discount was redeemed

discount (groupable, filterable)
Type of discount applied

Membership Details

membership_owner_type (groupable, filterable)
Type of membership the owner has

order_user_membership_type (groupable, filterable)
Type of membership the ordering user has

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

Invoice

company_name (groupable, filterable)
Name of company for business transactions

invoice (groupable, filterable)
Whether the order was invoiced

Purchase Analytics

relative_purchase_time (groupable, filterable)
Time of purchase relative to showing or effective time

Time and Attendance

employee (groupable, filterable)
The employee that handled the transaction

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Movie

showing_badges (groupable, filterable)
Additional information about the showing such as if it is a 3D showing, IMAX, etc.

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

tax (summable, averagable)
The amount of tax applied to the item

Source Only Fields

description

user_email

created_at

placed_at

paid_at

voided_at

effective_at

date_and_time

state

user

id

user_id

Outstanding gift card balances and usage.

Groupable Fields

Main

site (groupable, filterable)
The site

type (groupable, filterable)
The type of record or transaction

Timing

date (groupable, filterable)
Effective date of the data

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Output Fields

Statistics and Metrics

count (summable)
The count of gift card(s)

Financial

amount (summable)
The total value amount of gift card(s)

Other Fields

Statistics and Metrics

average_amount_cents
The average value amount of the gift card(s)

Source Only Fields

user_email

created_at

paid_at

date_and_time

state

user

id

user_id

Orders with processing anomalies.

Groupable Fields

Identifiers

id (groupable)
The unique identifier for the entry

Transfer Details

state (groupable)
The state of the transfer

Users

user (groupable)
User associated with the record

Details

remote_application (groupable)
Remote application identifier

collected (groupable)
Whether item was collected

delivery (groupable)
Delivery information

register_station (groupable)
The physical register station where the transaction occurred

Time and Attendance

employee (groupable)
The employee that handled the transaction

Timing

updated_at (groupable)
When record was last updated

Output Fields

Main

order_item_count (summable)
Number of items in an order

Order Items

total (summable)
Total amount for the order

Manual accounting adjustments and reasons.

Groupable Fields

Main

site (groupable, filterable)
The site

order_item_type (groupable, filterable)
The type of item in the order (ticket, concession, membership, etc.)

description (groupable, filterable)
Detailed description of the record

Details

register_station (groupable, filterable)
The physical register station where the transaction occurred

Invoice

company_name (groupable, filterable)
Name of company for business transactions

invoice (groupable, filterable)
Whether the order was invoiced

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

taxable (groupable, filterable)
Whether the item is subject to tax

Time and Attendance

employee (groupable, filterable)
The employee that handled the transaction

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

net (summable, averagable)
The amount paid by the customer, after all redemptions, and before taxes

gross (summable, averagable)
The total amount paid by the customer, including taxes

tax (summable, averagable)
The amount of tax applied to the item

Other Fields

Statistics and Metrics

average_amount_cents
Average amount in cents

Source Only Fields

created_at

placed_at

paid_at

voided_at

effective_at

state

user

id

order_id

user_id

Expected versus actual financial totals.

Groupable Fields

Main

site (groupable, filterable)
The site

type (groupable, filterable)
The type of record or transaction

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Accounting

cr_dt (groupable, filterable)
Credit/Debit indicator

account (groupable, filterable)
Account name

source (groupable, filterable)
Source of the transaction

detail (groupable, filterable)
The journal entry detail

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

amount (summable)
The retail price of the item or service before redemptions and taxes

Source Only Fields

date_and_time

Sales validation across channels.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Accounting

cr_dt (groupable, filterable)
Credit/Debit indicator

source (groupable, filterable)
Source of the transaction

detail (groupable, filterable)
The journal entry detail

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

amount (summable)
The retail price of the item or service before redemptions and taxes

Source Only Fields

date_and_time

Transaction timing for accounting.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Accounting

cr_dt (groupable, filterable)
Credit/Debit indicator

source (groupable, filterable)
Source of the transaction

detail (groupable, filterable)
The journal entry detail

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

amount (summable)
The retail price of the item or service before redemptions and taxes

Source Only Fields

date_and_time

Payment completion verification.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Accounting

cr_dt (groupable, filterable)
Credit/Debit indicator

source (groupable, filterable)
Source of the transaction

detail (groupable, filterable)
The journal entry detail

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

amount (summable)
The retail price of the item or service before redemptions and taxes

Source Only Fields

date_and_time

Ticket sales versus attendance.

Groupable Fields

Main

site (groupable, filterable)
The site

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Accounting

cr_dt (groupable, filterable)
Credit/Debit indicator

source (groupable, filterable)
Source of the transaction

detail (groupable, filterable)
The journal entry detail

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

Output Fields

Statistics and Metrics

count (summable)
Count of entries

Financial

amount (summable)
The retail price of the item or service before redemptions and taxes

Source Only Fields

date_and_time

Ticket usage versus attendance.

Groupable Fields

Main

type (groupable)
The type of record or transaction

Output Fields

Financial

net (summable)
The amount paid by the customer, after all redemptions, and before taxes

Ticket revenue across channels.

Groupable Fields

Main

type (groupable)
The type of record or transaction

Output Fields

Financial

net (summable)
The amount paid by the customer, after all redemptions, and before taxes

System settings and operational parameters.

Configuration changes and their authors.

Groupable Fields

Configuration

audit_name (groupable, filterable)
The name of the audit

level (groupable, filterable)
The audit level

messages (filterable)
The audit messages

suggested_changes (filterable)
The suggested configuration changes

configuration (groupable, filterable)
The configuration details

configuration_type (groupable, filterable)
Type of configuration

configuration_id (groupable, filterable)
Configuration identifier

suppressed (groupable, filterable)
Whether configuration is suppressed

Identical to Order Item Source, but computed daily instead of hourly, use for accounts receivable reporting.

Groupable Fields

Identifiers

order_id (groupable, filterable)
The unique identifier for the order

Main

site (groupable, filterable)
The site

order_item_type (groupable, filterable)
The type of item in the order (ticket, concession, membership, etc.)

item (groupable, filterable)
The item being sold, such as popcorn, soda, etc.

item_variation (groupable, filterable)
The specific variation of an item such as the size of popcorn or type of drink. There is always exactly one item variation per item. When there is no need for a variation, the item variation is named Regular.

item_variation_and_item (groupable, filterable)
The item variation with the item name, e.g. Popcorn (Item) - Large ( Item Variation).

Timing

date (groupable, filterable)
Effective date of entry

week (groupable, filterable)
Week number or identifier

day_of_week (groupable, filterable)
Day of the week

hour_of_day (groupable, filterable)
Hour of the day

time (groupable, filterable)
Specific time of the showing

year (groupable, filterable)
Year of the record or showing

quarter (groupable, filterable)
Quarter of the year (Q1, Q2, Q3, Q4)

month (groupable, filterable)
Month of the year

year_quarter (groupable, filterable)
Combined year and quarter (e.g. 2023 Q1)

year_month (groupable, filterable)
Combined year and month (e.g. March 2023)

Items and Inventory

item_class (groupable, filterable)
Item class of the inventory item

Packages and Products

item_package (groupable, filterable)
Packages that can be used to sell combinations of tickets, concessions, etc.

gift_card_amount (groupable, filterable)
Amount on gift card ($5, $10, $20, $50, $100, or custom)

Tickets

ticket_type (groupable, filterable)
The internal name of the type of the type of ticket (e.g. Adult After Price Change etc.)

Movie

movie (groupable, filterable)
The movie title

genre (groupable, filterable)
The genre of the movie

rating (groupable, filterable)
The rating of the movie (For everyone, PG, PG-13, R, etc.)

showing_badges (groupable, filterable)
Additional information about the showing such as if it is a 3D showing, IMAX, etc.

Purchase Analytics

relative_purchase_time (groupable, filterable)
Time of purchase relative to showing or effective time

showing_hour_of_day (groupable, filterable)
Hour of day when showing occurs

Payment Processing

payment_type (groupable, filterable)
The type of payment used (card, cash, gift card, etc.)

payment_subtype (groupable, filterable)
The specific subtype of payment used

Vouchers and Discounts

voucher_purchase (groupable, filterable)
Type of voucher being purchased

voucher_package_purchase (groupable, filterable)
Package of vouchers being purchased

redeemed_voucher (groupable, filterable)
Whether a voucher was redeemed

redeemed_voucher_type (groupable, filterable)
Type of voucher that was redeemed

redeemed_discount (groupable, filterable)
Whether a discount was redeemed

discount (groupable, filterable)
Type of discount applied

Membership Details

membership_owner_type (groupable, filterable)
Type of membership the owner has

order_user_membership_type (groupable, filterable)
Type of membership the ordering user has

Details

employee (groupable, filterable)
The employee that handled the order item purchase

register_station (groupable, filterable)
The physical register station where the transaction occurred

register_type (groupable, filterable)
The type of register (e.g., box office, concession)

delivery_type (groupable, filterable)
The method of delivery for the item

sales_channel (groupable, filterable)
The channel through which the sale was made (e.g. online, kiosk, register, qr code, etc.)

Invoice

company_name (groupable, filterable)
Name of company for business transactions

invoice (groupable, filterable)
Whether the order was invoiced

Financial

tax_type (groupable, filterable)
The type of tax applied to the item

tax_description (groupable, filterable)
Description of the tax applied

taxable (groupable, filterable)
Whether the item is subject to tax

credit_sales (groupable, filterable)
Whether the transaction was a credit sale

Advanced

void (groupable, filterable)
Whether the transaction was voided (note: this should be used with caution, use for isolating voided transactions, which is usually not necessary as these are already handled based on the effective type chosen)

showing_attribution_type (groupable, filterable)
How we determine the showing for the line item

Output Fields

Main

net (summable, averagable)
The amount paid by the customer, after all redemptions, and before taxes

gross (summable, averagable)
The total amount paid by the customer, including taxes

tax (summable, averagable)
The amount of tax applied to the item

count (summable)
The number of order items

Financial

amount (summable, averagable)
The retail price of the item or service before redemptions and taxes

group_gross (summable)
Percentage of gross amount within group

group_count (summable)
Percentage of count within group

profit (summable, averagable)
The profit of the order item, calculated as the net revenue less the cost

cost (summable, averagable)
The cost of the order item, calculated from the item variation and modifier costs or the ticket rental fee

Vouchers and Discounts

redeemed_voucher_value (summable, averagable)
Value of the redeemed voucher

discount_amount (summable, averagable)
Amount of discount applied in cents

redeemed_voucher_net (summable, averagable)
Net amount of redeemed voucher before taxes

redeemed_voucher_tax (summable, averagable)
Tax amount of redeemed voucher

redeemed_voucher_gross (summable, averagable)
Gross amount of redeemed voucher after taxes

recognized_voucher_revenue (summable, averagable)
Recognized revenue from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_net (summable, averagable)
Recognized net amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_tax (summable, averagable)
Recognized tax amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

recognized_voucher_gross (summable, averagable)
Recognized gross amount from voucher based on the original purchase price of the voucher or the current price of the voucher if it was not purchased

Loyalty and Points

points_used (summable, averagable)
Number of loyalty points used in transaction

points_earned (summable, averagable)
Number of loyalty points earned from transaction

Statistics and Metrics

share (summable)
Percentage share of all entries

gross_share (summable)
Percentage share of gross revenue

profit_share (summable)
Percentage share of profit

Other Fields

Financial

profit_margin
The profit margin calculated as a percentage of net revenue

average_amount_cents
Average amount in cents

average_gross
Average gross per entry

average_profit
Average profit per entry

Source Only Fields

description

user_email

created_at

placed_at

paid_at

voided_at

effective_at

collected_at

prepared_at

delivered_at

date_and_time

state

user

id

user_id

​