Tienda Nube data reference
E-commerce
8 tables
280 columns
Lucen syncs your Tienda Nube data (E-commerce) to your warehouse and models it into the tables below. You connect Tienda Nube with one OAuth sign-in. By default your data refreshes every day at 06:00 Buenos Aires time (UTC-3). Your plan sets how many times a day it can sync, and you can choose the times, see pricing.
Your plan sets how much history the first sync loads, see pricing.
Send Tienda Nube data to
Tables
gold_tiendanube_attribution_daily
- Grain
- day / source
- Use for
- Last-click style daily attribution
gold_tiendanube_coupon_performance
- Grain
- coupon
- Use for
- Coupon usage
gold_tiendanube_customer_ltv
- Grain
- customer
- Use for
- Lifetime value. Not summable as unique customers across filters without care
gold_tiendanube_funnel_daily
- Grain
- day
- Use for
- Store funnel
gold_tiendanube_order_lifecycle
- Grain
- order
- Use for
- Status timeline
gold_tiendanube_orders
- Grain
- order
- Use for
- Order-level fact
gold_tiendanube_orders_daily
- Grain
- day
- Use for
- Daily order / revenue totals
gold_tiendanube_product_performance
- Grain
- product
- Use for
- Product sales
Columns
Column names match your warehouse exactly. Descriptions come from dbt.
gold_tiendanube_attribution_daily columns
17
gold_tiendanube_coupon_performance columns
24
gold_tiendanube_customer_ltv columns
28
gold_tiendanube_funnel_daily columns
19
gold_tiendanube_order_lifecycle columns
23
gold_tiendanube_orders columns
88
gold_tiendanube_orders_daily columns
46
gold_tiendanube_product_performance columns
35
Typical questions
Prompt to try
Revenue this month
gold_tiendanube_orders_daily
Prompt to try
Best products
gold_tiendanube_product_performance
Prompt to try
Coupon lift
gold_tiendanube_coupon_performance
Starter queries
sql
SELECT order_date, store_id, currency, is_zero_filled, orders_count
FROM `your-project.your_org_gold.gold_tiendanube_orders_daily`
WHERE order_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY order_date DESC
LIMIT 100;sql
SELECT order_date, store_id, order_id, order_number, token
FROM `your-project.your_org_gold.gold_tiendanube_orders`
WHERE order_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY order_date DESC
LIMIT 100;sql
SELECT order_date, store_id, currency, utm_source, utm_medium
FROM `your-project.your_org_gold.gold_tiendanube_attribution_daily`
WHERE order_date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
ORDER BY order_date DESC
LIMIT 100;sql
SELECT store_id, customer_id, email, name, phone
FROM `your-project.your_org_gold.gold_tiendanube_customer_ltv`
LIMIT 100;