​
How reporting works in Togai?

Togai has an extensive reporting capability that allows you to create reports and report templates. These can be used to generate ad hoc one-time reports for download or pushed to an external data source. Customers can also set up scheduled reports that can be auto-generated hourly, daily or monthly and exported or sent to an external data source.

How reports work in Togai

​
Tables and entities

​
Accounts

Field NameTypeDescription
account_idStringThe unique identifier of the account.
customer_idStringThe unique identifier of the customer.
nameStringThe name of the account.
created_atLocalDateTimeThe date and time when the account was created.
invoice_currencyStringThe currency of the account.
primary_emailStringThe primary email of the account.
tagsString[]The tags of the account.

​
Customers

Field NameTypeDescription
idStringThe unique identifier of the customer.
nameStringThe name of the customer.

​
Events

Field NameTypeDescription
event_idStringThe unique identifier of the event.
account_idStringThe unique identifier of the account.
customer_idStringThe unique identifier of the customer.
event_source_timeLocalDateTimeThe date and time when the event occurred.
ingestion_statusStringThe ingestion status of the event.

​
Invoices

Field NameTypeDescription
idStringThe unique identifier of the invoice.
owner_idStringThe unique identifier of the owner.
total_amountNumberThe total amount of the invoice.
statusStringThe status of the invoice.
due_dateLocalDateTimeThe date and time when the invoice is due.
classStringThe class of the invoice.
created_atLocalDateTimeThe date and time when the invoice was created.

​
License Entries

Field NameTypeDescription
account_idStringThe unique identifier of the account.
license_idStringThe unique identifier of the license.
effective_fromLocalDateTimeThe date and time when the license became effective.
quantityBigDecimalThe quantity of the license.
created_atLocalDateTimeThe date and time when the license was created.

​
Usage

Field NameTypeDescription
account_idStringThe unique identifier of the account.
customer_idStringThe unique identifier of the customer.
billable_idStringThe unique identifier of the billable.
event_timeLocalDateTimeThe date and time when the usage event occurred.
usage_unitsStringThe usage units of the usage event.

​
Revenue

Field NameTypeDescription
account_idStringThe unique identifier of the account.
customer_idStringThe unique identifier of the customer.
revenue_timeLocalDateTimeThe date and time when the revenue occurred.
revenue_invoice_currencyStringThe currency of the revenue.
billable_idStringThe unique identifier of the billable.
revenue_base_currencyStringThe base currency of the revenue.

​
Supported functions

DateTruncate - "date_trunc"
ABS - "abs"`

​
Supported aggregations

Sum - "sum"
Count - "count"
Avg - "avg"
Min - "min"
Max - "max"

​
Supported relative operators

> - "gt"
< - "lt"
>= - "gte"
<= - "lte"
== - "eq"
!= - "neq"
In - "in"
Not In - "nin"

​
Report templates

Togai also provides an on-demand reporting template option which can be used to create a custom dashboard with various drag & drop widgets that can be used for business analytics to take data driven decisions around pricing.

Report templates and dashboard