How do I connect my Tray store to Metabase without technical expertise?

You simply add Tray as a data source in Kondado using your store credentials, then select Metabase as your destination. The platform handles the data transfer automatically, requiring no API configuration or database management from your side. Within minutes, your Tray information becomes available as structured datasets ready for visualization.

What specific ecommerce dashboards can I build with Tray data in Metabase?

You can create comprehensive sales performance reports combining Orders, Sold Products, and Payments pipelines to track revenue trends and bestselling items. Marketing teams often build customer acquisition dashboards using the Customers and Newsletters data to analyze subscription conversion rates. Operations managers frequently visualize Order Details alongside Order Invoices to monitor fulfillment efficiency and accounting accuracy.

How frequently does my Tray data refresh in Metabase?

Kondado allows you to configure automatic updates on a schedule that fits your business needs, ranging from every 5 minutes to daily refreshes. You select the frequency during setup based on how quickly you need to see new orders, payments, or inventory changes. This ensures your reports always reflect current business conditions without manual data exports.

Which KPIs should I track when visualizing Tray data in Metabase?

Essential metrics include customer lifetime value from the Customers pipeline, conversion rates by traffic source when combined with marketing data, and average order value trends from Order Details. You should also monitor discount coupon redemption rates to measure promotion effectiveness and payment method distribution to optimize your financial operations. These insights help identify growth opportunities and operational bottlenecks.

Can I share Metabase dashboards with team members who don't have Tray access?

Yes, once you build reports in Metabase using replicated Tray data, you can share dashboards with stakeholders across your organization. Team members view the visualizations through Metabase without needing direct access to your Tray store backend. This makes it easy to distribute insights to executives, marketing agencies, or external partners while maintaining control over the underlying data source.

Is it possible to combine Tray data with other business platforms in Metabase?

Absolutely, you can replicate data from multiple sources into the same Metabase instance to create unified business views. For example, combine your Tray sales data with advertising spend from Google Sheets or customer service metrics from PostgreSQL . This cross-platform analysis reveals deeper insights about marketing ROI and customer journey touchpoints.

Do I need to set up a data warehouse before connecting Tray to Metabase?

No, Kondado eliminates the need for intermediate storage systems by connecting Tray directly to Metabase through the Via Kondado connection. Your data flows seamlessly between platforms without requiring you to manage databases, servers, or complex transfer processes. This approach saves significant setup time and reduces technical overhead for small and medium businesses.

Connect Tray to Metabase: 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

Visualize Tray Data in Metabase with Kondado

Connecting your Tray store to Metabase allows you to transform raw ecommerce information into clear visual insights without any technical complexity. Kondado provides a direct connection between Tray and Metabase, enabling business teams to replicate data on a configurable schedule and build comprehensive reports. You can track sales performance, customer behavior, and payment trends directly in Metabase using data that updates automatically.

Kondado connects Tray to Metabase through a direct connection that requires no intermediate databases or complex configuration, allowing you to visualize your ecommerce data on a configurable schedule ranging from every 5 minutes to daily updates.

This solution empowers marketing and operations teams to monitor key metrics without relying on developers. By replicating your Tray data into Metabase, you create a single source of truth for decision-making across your organization. The process requires no coding knowledge, making advanced business intelligence accessible to SMBs and agencies managing multiple stores.

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

With your Tray data available in Metabase, you can combine information from Orders, Payments, and Customers pipelines to uncover actionable business insights. Analyze which customer segments generate the highest value orders, track discount coupon effectiveness across different campaigns, or monitor payment method preferences to optimize your checkout experience. Marketing teams can visualize newsletter subscription trends alongside purchase history to identify your most engaged audiences, while operations managers track delivery status and invoice data to streamline fulfillment processes. This unified view helps you make faster decisions about inventory, promotions, and customer retention strategies without switching between platforms.

Try out all the features for free for 14 days

Tray data available in Metabase

available pipelines

328

extractable fields

Available integrations

Integration	Description
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.

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.

See all available data →

Try out all the features for free for 14 days

How to create Tray dashboards in Metabase

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

Connect Tray as Your Data Source

Add Tray as a data source by entering your store credentials and selecting which pipelines you want to replicate, such as Orders or Customers. Kondado will automatically structure your ecommerce data for immediate use in visualization tools.

Select Metabase as Destination

Choose Metabase from the available destinations to establish your direct connection without intermediate databases. You can also send data to Power BI, Google Sheets, or BigQuery if your team uses multiple platforms.

Build Dashboards and Set Refresh Schedule

Create your reports in Metabase using the replicated Tray data and configure how frequently the information updates, from every 5 minutes to daily intervals. Your dashboards will stay current automatically, enabling continuous monitoring of sales and customer metrics.