Connect Tray to Cortex: Dashboards in Minutes

Get started for free

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

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

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

Tray
Cortex

Visualize Tray Data in Cortex with Kondado

Kondado provides a direct integration between your Tray store and Cortex, allowing you to transform raw eCommerce data into clear visual insights without any technical expertise. You can replicate data from your online store on a configurable schedule, ensuring your Cortex reports always reflect the latest sales, customer, and inventory information. This connection helps business teams track performance metrics, identify growth opportunities, and make informed decisions based on current data trends rather than outdated spreadsheets.

Setting up this connection takes just minutes through Kondado’s no-code interface, where you simply authenticate your Tray account and choose which data pipelines to activate for your reporting needs. Once configured, your information flows directly into Cortex where you can build custom reports showing order patterns, customer behavior, and revenue analysis across all your sales channels. The automated updates keep your visualizations current without manual exports or tedious spreadsheet maintenance, saving hours of preparation time each week.

Kondado connects Tray to Cortex through a “Via Kondado” direct integration that requires no intermediate databases or complex technical setup, offering 14 pipelines with 328 fields including Customers, Orders, Payments, and Products to power your business intelligence.

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

With Kondado, you can combine data from the Orders, Customers, and Sold Products pipelines to create comprehensive Cortex dashboards that reveal your most profitable product categories and identify loyal customer segments driving repeat business. Analyzing these connected datasets allows you to pinpoint which marketing campaigns generate actual revenue, understand seasonal purchase patterns, and optimize inventory levels based on historical transaction data rather than guesswork. Adding the Discount Coupons pipeline provides deeper insight into promotion effectiveness, enabling you to calculate true customer acquisition costs and determine which incentive strategies convert casual browsers into long-term buyers.

Try out all the features for free for 14 days

Tray data available in Cortex

14
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.

Try out all the features for free for 14 days

How to create Tray dashboards in Cortex

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

1
Connect Tray to Kondado

Log into Kondado and select Tray as your data source, then enter your store credentials to authenticate the connection. Choose which pipelines to activate, such as Orders, Customers, and Products, to begin replicating your eCommerce data.

2
Select Cortex as Destination

Select Cortex as your visualization destination from the available options, which include Power BI, Looker Studio, and Google Sheets. This establishes the direct flow of data from your Tray store into your chosen analytics environment.

3
Build Dashboards and Configure Refresh

Set your preferred update frequency in Kondado, choosing from intervals like every 5 minutes, hourly, or daily to keep your Cortex reports current. Once configured, build custom dashboards in Cortex using your replicated data to visualize sales trends and customer insights.

Access Tray data in Cortex 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!

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

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Tray data in Cortex automatically

How do I connect my Tray store to Cortex using Kondado?
Start by selecting Tray as your data source in the Kondado platform, then authenticate your store credentials to establish the connection. Choose Cortex as your destination and select which data pipelines you want to replicate, such as Orders or Customers, then set your preferred update schedule.
What kind of dashboards can I build with Tray data in Cortex?
You can create custom reports tracking sales performance, customer lifetime value, and product profitability by combining pipelines like Sold Products, Orders, and Customers. These visualizations help you identify top-performing products, monitor revenue trends, and analyze customer purchase patterns to optimize your marketing strategy.
How often does Tray data update in Cortex reports?
Kondado updates your data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals depending on your business needs. This ensures your Cortex visualizations reflect recent transactions and inventory changes without requiring manual data refreshes or exports.
Which KPIs should I track when visualizing Tray sales data?
Focus on metrics like average order value, conversion rates from Discount Coupons, repeat purchase rates from the Customers pipeline, and product performance from Sold Products data. These indicators help you understand customer behavior, measure marketing ROI, and identify which product variants drive the most revenue.
Can I share Cortex dashboards with my team using Tray data?
Yes, once you build reports in Cortex using your replicated Tray data, you can distribute insights to stakeholders across your organization. Team members can access visualizations showing current business performance without needing direct access to your Tray admin panel or Kondado account.
Do I need technical skills to set up the Tray to Cortex connection?
No coding or technical expertise is required to connect Tray to Cortex through Kondado's no-code interface. The setup process involves simple authentication and point-and-click selection of data pipelines, making it accessible for business users, marketers, and operations teams.
Can I send Tray data to other tools besides Cortex?
Yes, Kondado allows you to replicate your Tray data to multiple destinations simultaneously, including Power BI, Google Sheets, BigQuery, and PostgreSQL. This flexibility lets you maintain consistent data across your entire reporting ecosystem.

Try out all the features for free for 14 days