How do I connect Tray to Looker using Kondado?

Start by adding Tray as a data source in your Kondado account and authenticate with your store credentials. Then select Looker as your destination and choose which pipelines you want to replicate, such as Orders, Customers, or Products. Your data begins flowing immediately after configuration, with updates happening automatically on your chosen schedule.

What kind of dashboards can I build with Tray data in Looker?

You can create comprehensive eCommerce analytics dashboards showing sales performance, customer lifetime value, and product profitability using data from the Orders, Customers, and Sold Products pipelines. Marketing teams build campaign attribution reports by combining Discount Coupons data with transaction information, while operations teams visualize fulfillment metrics using Order Details and Order Invoices. These custom reports help you spot trends and make informed business decisions quickly.

How often does Tray data update in Looker?

Kondado updates your Tray data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. You select the frequency based on your business needs, whether you need near-real-time monitoring for high-volume sales periods or daily summaries for regular reporting. This automation ensures your Looker dashboards always reflect current information without manual refreshes.

Which KPIs should I track for my Tray store in Looker?

Essential metrics include conversion rates from the Orders pipeline, customer acquisition costs using Customers and Payments data, and inventory turnover from Sold Products and Products pipelines. You should also monitor discount effectiveness through the Discount Coupons pipeline and track newsletter engagement via the Newsletters data. These KPIs provide a complete picture of your store's health and growth opportunities.

Can I share Tray dashboards with my team in Looker?

Yes, once you build your dashboards in Looker, you can share them with colleagues, stakeholders, or clients who need visibility into your Tray store performance. Team members access the same current data you see, ensuring everyone works from unified metrics. You can also send data to Google Sheets or Power BI if colleagues prefer those platforms.

Do you offer pre-built report templates for Tray and Looker?

Kondado does not provide pre-built report templates for this combination, allowing you complete flexibility to design dashboards that match your specific business needs. You build custom reports in Looker using the 14 available pipelines, focusing on the metrics that matter most to your operations. This approach ensures your visualizations align perfectly with your unique eCommerce workflows and reporting requirements.

What specific Tray data can I analyze in Looker?

You can access 14 different pipelines including Orders, Customers, Payments, Products, Sold Products, Order Details, and Discount Coupons, covering 328 total fields. This includes transaction values, customer contact information, product variants, invoice details, and coupon usage data. The breadth of available information lets you analyze everything from individual product performance to overall store profitability.

Connect Tray to Looker: 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 Looker for Business Insights

Kondado makes it simple to visualize your Tray eCommerce data directly in Looker without writing code or managing complex infrastructure. You connect your Tray store as a data source, select Looker as your destination, and start building insightful reports within minutes. Your sales, customer, and product information flows automatically on a schedule you configure, keeping your dashboards current and reliable.

Business teams use these visualizations to track revenue trends, monitor inventory performance, and understand customer behavior without waiting for technical resources. The connection requires no intermediate databases or manual exports, so you spend time analyzing data rather than preparing it. Marketing and operations teams gain immediate visibility into campaign performance and fulfillment metrics.

Kondado connects Tray and Looker with 14 available pipelines covering 328 fields including Orders, Customers, Payments, and Products, enabling automated data replication on a configurable schedule of every 5 minutes to daily.

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

Combining Tray data with Looker visualization capabilities helps you understand the complete customer journey from first visit to purchase. By analyzing the Orders pipeline alongside the Customers and Sold Products pipelines, you can identify which customer segments drive the most revenue and which products perform best across different channels. Operations teams monitor fulfillment efficiency using Order Details and Order Invoices data, while marketing teams track campaign effectiveness by connecting Discount Coupons usage with actual sales conversions in unified dashboards. These insights enable data-driven decisions about inventory planning, promotional strategies, and customer retention programs without technical complexity.

Try out all the features for free for 14 days

Tray data available in Looker

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 Looker

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

Connect Tray as data source

Log into Kondado and add Tray as a new data source by entering your store credentials and selecting which pipelines you need, such as Orders or Customers.

Select Looker destination

Choose Looker from the available destinations and configure your connection settings to establish the direct link between your Tray store and your visualization environment.

Build dashboards and schedule

Create custom reports in Looker using your Tray data and set your preferred update frequency, from every 5 minutes to daily, to keep insights current automatically.