Skip to main content

Which Mariana Tek reports are used to pull data into Insights?

The specific Mariana Tek reports that are used for Insights data

Helen Kang avatar
Written by Helen Kang
Updated over a week ago

The data in Insights is pulled from your data in Mariana Tek. The chart below shows which reports populate data into your Insights dashboards.

Insights Dashboard Mariana Tek Report

Total Sales Summary

Rolled up view of the Sales > Orders report

Credit Sales Summary

Sales > Orders. Filter on Product Type for Credits

Membership Sales Summary

Sales > Orders. Filter on Product Type for Memberships

Services vs Products

Sales > Orders. Services are defined as Product Type = Credit or Membership, Products are all other Product Types not including Fees and “Custom”

Expiring Memberships

This is a custom report, not available in MT. Memberships that are expiring are aggregated by location.

Frozen Memberships

Marketing > Frozen Memberships

Single Visit Clients

Utilization > Reservations, filtered based on the calculated date range (30/60/90 days), where only one check in has occurred during that time frame

No Next Visit

Utilization > Reservations, filtered based on the last visit.

Visits Summary

Visits come from Utilization > Reservations, where the status is checked in.

New New Memberships

New Memberships comes from Marketing > Membership details, using the Purchase Date field (available only on the export)

Terminated/Canceled comes from Marketing > Membership details, using the “Cancel Initiated On” date field (available only on the export)

MT Report Base

Finance > Membership Recurring Fees Forecast - Details

Did this answer your question?