Dashboards in minutes

Connect Tray to BIMachine: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Connect Tray to BIMachine

Tray

BIMachine

Connecting your Tray store to BIMachine gives you powerful visual insights into your eCommerce performance without any technical complexity. Kondado creates a direct integration between Tray and BIMachine, allowing you to replicate order details, customer information, and payment data on a configurable schedule. Business teams can monitor sales trends, track inventory movement, and analyze customer behavior through intuitive dashboards that update automatically.

available pipelines

328

extractable fields

✓No code, no spreadsheets
✓Auto-refreshed data
✓14-day free trial

Connect Tray now →

Try out all the features for free for 14 days

Kondado connects Tray to BIMachine via a direct integration with no intermediate databases required, replicating 14 data pipelines including Orders, Customers, and Payments on schedules ranging from every 5 minutes to daily, enabling near-real-time business intelligence for non-technical users.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Try out all the features for free for 14 days

Available data

Tray data available in BIMachine

Each item below is automatically replicated by Kondado from Tray into BIMachine — no schema setup, no manual mapping.

available pipelines

328

extractable fields

∞

Auto-refresh

Available integrations

Customers

Includes information such as name, email, and registration date, along with modification date and last visit.

Discount Coupons

Contains details such as coupon code, creation date, and discount value, along with usage restrictions.

Newsletters

Presents information about the customer's email, newsletter status, and creation and modification dates.

Payments

Includes data on payment methods, status, and values of transactions made by customers.

Orders

Provides information such as order ID, order date, and delivery status, along with customer details.

Order Details

Includes detailed information such as order ID, billing address, and additional cart values.

Order Details: Mercado Livre

Presents data such as customer ID, estimated delivery date, and information about the purchased product.

Additional Product Information for Orders

Contains additional information such as product ID and product name related to each order.

Order Invoices

Includes data such as invoice ID and product CFOP, essential for accounting.

Order Transactions

Provides information on transaction status and values associated with each order made.

Products

Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.

Products (Kits)

Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.

Sold Products

Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.

Products: Variants

Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

Full docs on the wiki → Start free trial →

Try out all the features for free for 14 days

With your Tray data flowing into BIMachine, you can combine information from the Orders and Sold Products pipelines to identify your best-performing items and seasonal demand patterns. Marketing teams benefit from analyzing the Customers pipeline alongside Discount Coupons to measure campaign effectiveness and customer acquisition costs. This unified view transforms raw transaction data into actionable business intelligence for optimizing your store performance.

Try out all the features for free for 14 days

How to create Tray dashboards in BIMachine

Visualize your data automatically — no spreadsheet exports or custom scripts.

Add Tray as Your Data Source

Log into Kondado and select Tray from the available data sources, then authenticate your store credentials to establish the connection.

Choose BIMachine as Destination

Select BIMachine as your destination platform and configure which pipelines you want to replicate, such as Orders, Customers, or Payments.

Build Dashboards and Set Schedule

Design your custom reports in BIMachine using the replicated data and configure your preferred update frequency to keep insights current automatically.

Access Tray data in BIMachine and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

55pbx

ActiveCampaign

Google Ads

Amazon S3

api4com

Apple App Store

ASAAS

AWS CloudWatch Metrics

Azure Table Storage

BigQuery

Bing

Bitrix24 CRM

Bling!

Blip (take)

ClickUp

Clockify

ContaAzul

Criteo

E-goi

EADBOX

Exact Sales

Facebook Ads

Facebook

Fatura Simples

Freshdesk

FTP

Google Analytics GA4

Google Cloud Storage

Google Play Store

Google Search Console

Google Sheets

Granatum

Hi Platform

Hotmart

Hubspot

Huggy

InfluxDB v1

Infusionsoft (Keap)

Instagram Ads

Instagram

Jira

Loja Integrada

MailChimp

Mandrill

Mautic

Meetime

Mercado Libre

Meta Ads

Microsoft Ads

Microsoft Advertising

Mixpanel

monday.com

MongoDB

Movidesk

MySQL (& MariaDB)

NectarCRM

Notion

Nuvemshop (Tiendanube)

Olist Tiny

Omie

Oracle

Pagar.me

Pinterest Ads

Pipedrive

Pipefy

PipeRun

Ploomes

PostgreSQL

Pushwoosh

RDStation CRM

RDStation

Recruiterbox

Salesforce Marketing Cloud (Exact Target)

Salesforce

SenseData

Shopify

SQLServer

Stilingue

Superlogica

Sympla

Taboola

Tangerino

TikTok Ads

TikTok Organic

Tiny ERP

Toggl

Tray

Trello

Twilio

VNDA

VTEX

Wake Commerce

Webhook

Wootric

WordPress

X Ads

YouTube

Zeeng

Zendesk Chat (Zopim)

Zendesk

Visualize Tray data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Tray > Airtable

Tray > Alteryx

Tray > Amazon Quicksight

Tray > BIMachine

Tray > Cortex

Tray > Data Studio

Tray > Geckoboard

Tray > Grafana

Tray > IBM Cognos Analytics

Tray > Klipfolio

Tray > Looker Studio

Tray > Looker

Tray > Looqbox

Tray > Metabase

Tray > Microstrategy

Tray > Pentaho

Tray > Power BI

Tray > Qlik Cloud Analytics

Tray > Qlik Sense

Tray > Qlik

Tray > QlikView

Tray > Redash

Tray > Superset

Tray > Tableau

Tray > BI TOTVS

Tray > Zoho Analytics

Related on Kondado

Hundreds of data-driven companies trust Kondado

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Frequently Asked Questions (FAQ)

Answers about visualizing Tray data in BIMachine automatically

How do I connect my Tray store to BIMachine using Kondado? ▼

Log into Kondado and add Tray as your data source, then select BIMachine as your destination platform. Choose which pipelines you want to replicate, such as Orders or Payments, and authenticate your store credentials to establish the connection. The setup requires no coding knowledge and takes just a few minutes to complete.

What Tray data can I visualize in BIMachine? ▼

You can access 14 pipelines covering Orders, Customers, Payments, Sold Products, and Discount Coupons. Each pipeline includes specific fields like order values, customer emails, payment statuses, and coupon usage details. This comprehensive data set allows you to build custom reports on sales performance, customer behavior, and inventory management.

How often does Tray data update in BIMachine dashboards? ▼

You configure the update frequency based on your business needs, choosing intervals from every 5 minutes to daily. This automated schedule keeps your BIMachine reports current without requiring manual data exports. Your dashboards will reflect recent transactions and inventory changes according to the timeline you select.

What KPIs should I track in BIMachine for my Tray store? ▼

Focus on metrics like average order value, customer lifetime value, conversion rates, and discount campaign ROI. Monitor payment approval rates from the Payments pipeline and delivery timelines from Order Details to optimize operations. These insights help marketing and operations teams identify growth opportunities and address fulfillment bottlenecks.

Can I share BIMachine dashboards with my team using Tray data? ▼

Yes, BIMachine allows you to share dashboards with team members and stakeholders through its native sharing features. Once your Tray data is replicated, anyone with access can view the reports without needing separate Tray login credentials. This keeps everyone aligned on sales performance and inventory status across your organization.

Do I need technical skills to set up Tray to BIMachine replication? ▼

No coding or database expertise is required to connect Tray to BIMachine through Kondado. The platform handles the technical setup using a direct integration approach that eliminates complex configurations. Business users can establish the connection and start building reports immediately without IT support.

Can I combine Tray data with other sources in BIMachine? ▼

Yes, you can blend Tray data with information from Google Sheets, BigQuery, or PostgreSQL within BIMachine. This allows you to analyze eCommerce performance alongside advertising data or financial records for comprehensive business intelligence. Kondado supports connections to 80+ sources for unified reporting.

Try out all the features for free for 14 days

Get started for free

Get started for free

Get started for free

Connect Tray to BIMachine: Dashboards in Minutes

Get started for free

Tray data available in BIMachine

Available integrations

How to create Tray dashboards in BIMachine

Add Tray as Your Data Source

Choose BIMachine as Destination

Build Dashboards and Set Schedule

Access Tray data in BIMachine and combine it with dozens of other data sources

55pbx

ActiveCampaign

Google Ads

Amazon S3

api4com

Apple App Store

ASAAS

AWS CloudWatch Metrics

Azure Table Storage

BigQuery

Bing

Bitrix24 CRM

Bling!

Blip (take)

ClickUp

Clockify

ContaAzul

Criteo

E-goi

EADBOX

Exact Sales

Facebook Ads

Facebook

Fatura Simples

Freshdesk

FTP

Google Analytics GA4

Google Cloud Storage

Google Play Store

Google Search Console

Google Sheets

Granatum

Hi Platform

Hotmart

Hubspot

Huggy

InfluxDB v1

Infusionsoft (Keap)

Instagram Ads

Instagram

Jira

Linkedin

Loja Integrada

MailChimp

Mandrill

Mautic

Meetime

Mercado Libre

Meta Ads

Microsoft Ads

Microsoft Advertising

Mixpanel

monday.com

MongoDB

Movidesk

MySQL (& MariaDB)

NectarCRM

Notion

Nuvemshop (Tiendanube)

Olist Tiny

Omie

Oracle

Pagar.me

Pinterest Ads

Pipedrive

Pipefy

PipeRun

Ploomes