Lucen

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;

Integration page