How do I connect Tray to Data Studio using Kondado?

Start by adding Tray as a data source in your Kondado account and authenticate with your store credentials. Then choose Looker Studio as your destination and select which pipelines you want to replicate, such as Orders or Customers.

What types of dashboards can I build with Tray data in Data Studio?

You can create sales performance dashboards tracking revenue trends, marketing analytics showing discount coupon redemption rates, and operational reports monitoring inventory through Sold Products data. Combine multiple pipelines like Payments and Order Details to build comprehensive eCommerce command centers.

How often does Tray data update in my Data Studio reports?

You configure the update frequency based on your business needs, choosing from intervals as frequent as every 5 minutes or extending to daily updates. This keeps your reports current without manual refreshes while respecting your store's API limits.

Which KPIs should I track when visualizing Tray eCommerce data?

Monitor conversion rates by analyzing Orders against Customer data, track average order value using Order Details, and measure marketing ROI through Discount Coupons performance. Payment status metrics help you identify pending transactions requiring follow-up.

Can I share Tray Data Studio dashboards with my team?

Yes, once your data flows into Looker Studio , you can share reports with unlimited viewers or specific team members through Google's standard sharing features. Collaborators can view up-to-date metrics without needing access to your Kondado account.

Do I need technical skills to set up the Tray to Data Studio connection?

No coding or database knowledge is required. The setup process uses simple point-and-click configuration to authenticate your Tray account and select your pipelines. Business users can complete the entire process in under 10 minutes.

Can I combine Tray data with other sources in Data Studio?

Absolutely. Blend your Tray eCommerce data with information from Google Sheets , BigQuery , or other platforms to create unified reports. This allows you to compare store performance against advertising spend or inventory data from external systems.

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

How to visualize Tray data in Data Studio? Kondado provides a direct connection between your Tray eCommerce platform and Looker Studio without requiring technical setup or intermediate databases. Simply connect your Tray account as a data source, select Looker Studio as your destination, and start building visual reports within minutes. Your sales, customer, and product data flow automatically on a configurable schedule you control, keeping your dashboards current without manual exports.

Business teams can track eCommerce performance, monitor payment trends, and analyze customer behavior through interactive charts and tables that update automatically. No coding knowledge is required to transform raw store data into actionable visual insights.

Kondado replicates data from Tray to Data Studio via a direct connection, updating your reports every 5 minutes, hourly, or daily based on your business needs, with 14 available pipelines covering 328 fields including Orders, Payments, and Customer data.

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

Tray and Data Studio Use Cases

Combining Tray’s Orders and Payments pipelines in Looker Studio allows you to monitor cash flow alongside sales volume, identifying which payment methods drive the most revenue. Marketing teams can analyze Discount Coupons data to measure campaign effectiveness and customer acquisition costs, while operations managers track Sold Products and inventory trends to optimize stock levels. By connecting Customer data with Order Details, you gain complete visibility into purchase patterns and customer lifetime value, enabling data-driven decisions about product offerings and promotional strategies without waiting for manual reports.

Try out all the features for free for 14 days

Tray data available in Data Studio

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 Data Studio

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

Connect your Tray store

Authenticate your Tray account in Kondado by entering your API credentials and selecting which pipelines to replicate, such as Orders, Customers, or Products.

Choose Looker Studio destination

Select Looker Studio as your destination to send Tray data directly into Google's visualization platform without intermediate storage.

Create reports and set schedule

Design your dashboards using the replicated Tray data and configure your preferred update frequency, from every 5 minutes to daily, ensuring reports stay current automatically.