Although Explo can sit on top of almost any data model, here are a few tips to ensure better performance and ease of use when connecting to Explo.
customer_id
or
organization_name
can make it much easier and quicker to query and segment
your data.
However, if all your tables do not have a customer field, you can always join
tables in the Explo interface.
Table | Fields |
---|---|
Orders | order_status , SKU , quantity , shipping_cost , price , customer_id , seller_id , order_date |
Customers | customer_name , customer_id ,email , address , payment info |
Products | SKU , product_name , description , seller_id |
seller_id
would be used to segment the data for each
customer.
Because you can run aggregations and calculations in Explo, it is best not to
run these aggregations here, so you have the flexibility to do so in Explo.