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

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