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

Visualize Tray Data in Klipfolio for Smarter Decisions

Kondado helps business teams replicate their Tray store data directly into Klipfolio without writing code or managing complex infrastructure. Simply connect your Tray account as a data source, select the specific pipelines you want to visualize, and let Kondado handle the automated updates. Your Orders, Payments, and Customer information flow into Klipfolio on a configurable schedule, ready for immediate dashboard creation and business analysis without any manual exports or spreadsheet work.

Kondado provides a direct integration between Tray and Klipfolio with 14 available pipelines including Customers, Orders, Payments, and Products, updating automatically every 5 minutes to keep your ecommerce reports current.

Marketing and operations teams can finally track sales performance, monitor inventory levels, and analyze customer behavior patterns without waiting for IT support or technical assistance. With 328 fields available across pipelines like Sold Products, Order Details, and Discount Coupons, you gain complete visibility into your ecommerce operations to make faster, data-driven decisions that grow your business and improve customer satisfaction.

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

Combine your Tray Orders and Payments pipelines in Klipfolio to monitor cash flow trends and identify your best-selling products across different marketplaces. Track customer acquisition costs by analyzing Discount Coupons alongside Customer data to see which promotions actually drive repeat purchases and build long-term loyalty. With the Sold Products and Order Details pipelines, operations teams can spot fulfillment bottlenecks, track Mercado Livre performance specifically, and optimize inventory levels before stockouts impact your revenue streams. Business users gain immediate clarity on which products need restocking and which marketing campaigns deliver the highest return on investment.

Try out all the features for free for 14 days

Tray data available in Klipfolio

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 Klipfolio

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

1
Connect Tray as your data source

Add Tray to your Kondado account by entering your store credentials and selecting the specific pipelines you want to replicate, such as Orders, Customers, or Products.

2
Select Klipfolio as destination

Choose Klipfolio from the available destinations to receive your Tray data, or alternatively send data to Power BI, Google Sheets, or BigQuery for different reporting needs.

3
Build dashboards and set refresh schedule

Create custom reports in Klipfolio using your replicated data and configure automated updates every 5 minutes, hourly, or daily to keep your ecommerce insights current without manual work.

Access Tray data in Klipfolio 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 Klipfolio automatically

How do I connect my Tray store to Klipfolio using Kondado?
Start by adding Tray as a data source in your Kondado account and authenticate with your store credentials. Then select Klipfolio as your destination and choose which pipelines like Orders, Customers, or Products you want to replicate. Kondado handles the connection automatically without requiring any database setup or coding knowledge.
What ecommerce KPIs can I track in Klipfolio with Tray data?
You can monitor essential metrics including conversion rates from Orders data, customer lifetime value using the Customers pipeline, and campaign performance through Discount Coupons analysis. Track payment success rates with the Payments pipeline and analyze product performance across variants using Sold Products data to optimize your catalog strategy.
How often does my Tray data update in Klipfolio?
You configure the update frequency based on your business needs, choosing from every 5 minutes, 15 minutes, hourly, or daily refresh schedules. This ensures your dashboards reflect recent sales activity and inventory changes without manual intervention, keeping your team aligned with current performance data.
Can I share Tray dashboards with my marketing team in Klipfolio?
Yes, once you build reports in Klipfolio using your replicated Tray data, you can share them with team members through Klipfolio's native sharing features. Marketing teams can view campaign results, operations can monitor fulfillment, and executives can track revenue without accessing your Tray admin panel directly.
Do you offer pre-built report templates for Tray data in Klipfolio?
While we do not provide pre-built templates for this specific combination, you can easily create custom dashboards tailored to your business needs using the 14 available pipelines. Build visualizations that match your specific workflow, whether tracking Mercado Livre sales or analyzing newsletter subscription trends alongside purchase behavior.
Can I send Tray data to other tools besides Klipfolio?
Absolutely, Kondado supports multiple destinations including Power BI, Google Sheets, Looker Studio, and BigQuery. You can also replicate data to PostgreSQL, MySQL, Excel, Redshift, SQL Server, or Amazon S3 depending on your reporting infrastructure needs.
What specific Tray information can I visualize about my Mercado Livre sales?
The Order Details: Mercado Livre pipeline provides specific data including customer IDs, estimated delivery dates, and detailed product information for marketplace transactions. Combine this with the main Orders pipeline to compare your direct sales performance against marketplace channels and optimize your multi-channel strategy accordingly.

Try out all the features for free for 14 days