How do I set up the Tray connection on Kondado?

Log into Kondado, select Tray as your data source, and enter your API credentials. The setup takes less than five minutes and requires no advanced technical knowledge.

What dashboards can I build with Tray data in Redash?

You can create sales tracking panels, customer behavior analysis, inventory monitoring, and discount coupon performance dashboards. Each dashboard is customized to match your specific business requirements.

How frequently is Tray data updated in Redash?

The schedule is configurable: choose updates every 5 minutes, 15 minutes, hourly, or daily. Kondado replicates data automatically according to your chosen timeline.

Which e-commerce KPIs should I track in Redash?

Monitor conversion rates, average order value, customer acquisition cost, best-selling products, and average delivery time. These metrics help marketing teams optimize campaigns and sales leaders increase revenue.

Are there pre-built dashboard templates for Tray in Redash?

We do not offer pre-built templates, but you can easily create custom dashboards. Tray's data structure is organized to facilitate the creation of sales, customer, and product reports in Redash.

How do I share Tray dashboards with my team in Redash?

After creating your dashboards in Redash, use the tool's native sharing features. Your operations team accesses the visualizations that update automatically based on the schedule configured in Kondado.

Can I send Tray data to tools other than Redash?

Yes, besides Redash, you can send data to Power BI , Looker Studio , Google Sheets , or BigQuery .

Which Tray pipelines are available on Kondado?

There are 14 pipelines including Orders, Customers, Products, Payments, Discount Coupons, Order Details, Order Invoices, and Order Transactions, totaling 328 fields available for analysis.

Connect Tray to Redash: 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 Redash with Kondado

Connect your Tray store to Redash in minutes using Kondado. Our platform replicates your e-commerce data automatically so you can visualize sales, customer, and inventory information directly in Redash. Configure the update frequency to match your business needs: every 5 minutes, 15 minutes, hourly, or daily, ensuring your analyses are always current.

With Kondado, marketing managers and data analysts create custom dashboards without technical expertise. Track campaign performance, analyze customer behavior, and monitor your sales funnel with automated updates on a configurable schedule. Your operations team views important metrics in just a few clicks, facilitating data-driven decisions based on concrete information from your online store.

Kondado connects Tray to Redash through a direct connection with no intermediate databases or complex setup, enabling operations teams to view automatically updated data for fast business decisions.

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

Combine Orders, Customers, and Sold Products data to create comprehensive analyses in Redash. Sales leaders track metrics like average order value, conversion rates, and top-selling products on intuitive dashboards that facilitate daily operations management. The Tray to Redash connection lets you cross-reference Discount Coupons with sales volume to optimize marketing campaigns and identify which strategies drive the most revenue. With these visualizations, your team spots growth opportunities and adjusts campaigns in a timely manner.

Try out all the features for free for 14 days

Tray data available in Redash

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