Below is a schema of the data we take from the IdoSell platform, which feeds the eCommerce Engine report.
Data directly from the eCommerce platform is the most valuable because it is based on data collected directly from the system, making it more accurate and reliable. External tools, such as Google Ads and Google Analytics 4, can retrieve data with a slight delay and are sometimes subject to integration errors, which can lead to inconsistencies in the data.
pole | typ | opis |
order_type | STRING | Order type |
order_number | STRING | The unique identification number of the order.
|
order_date | DATE | Date the order was placed. |
client_id | STRING | The unique identifier of the customer in the system. |
client_delivery_address_zip_code | STRING | The postal code of the customer's delivery address. |
order_confirmation | STRING | The order confirmation status, e.g. confirmed, pending. |
order_source | STRING | The source of the order, e.g. shop, panel, api. |
order_source_type | STRING | Order source type, e.g. shop, search engine, price comparison system. |
order_source_name | STRING | Order source name. |
order_status | STRING | Current order status, e.g. ready, finished, canceled. |
billing_currency | STRING | The currency in which the order was settled. |
item_id | STRING | Unique identifier of the product in the order. |
variant_item_id | STRING | Unique identifier of the product variant. |
item_name | STRING | Name of the product ordered by the customer. |
price_brutto | FLOAT | Gross price (with tax) per unit of the product. |
price_netto | FLOAT | Net price (without tax) per unit of the product. |
item_quantity | FLOAT | The number of ordered units of the product. |
item_order_brutto_value | FLOAT | Total gross value (with tax) of the ordered products. |
item_order_netto_value | FLOAT | Total net value (without tax) of the ordered products. |