Purchases / Games
This data set provides a daily aggregation of each customer's activity in your products, as reported to Optimove and used for segmentation in Target Groups.
Use this data to reveal insights about customers' activity under each campaign.
Latest version view:
VW_TRANSACTIONS
Run this query to sample last 1000 records.
SELECT *
FROM [SHARED_DB].BI. VW_TRANSACTIONS
ORDER BY TRANSACTIONDATE DESC
LIMIT 1000
Each record represents a unique purchase or a game made by a customer, and contains all the relevant attributes available for segmentation.
Table Description
(This structure describes a typical data structure for Retail clients, might differ between clients)
| Field Name | Description | Data Type |
|---|---|---|
CUSTOMER_ID | Unique identifier for the customer | NUMBER(19,0) |
CLIENT_CUSTOMER_ID | Unique identifier for the client’s customer | TEXT(200) |
TRANSACTIONDATE | The date this transaction took place | DATE |
PRODUCTID | Product ID as provided by client | NUMBER(38,0) |
OPTIMOVE_PRODUCT_ID | Product ID generated by Optimove | NUMBER(38,0) |
OPTIMOVE_TRANSACTION_ID | Transaction ID generated by Optimove | NUMBER(10,0) |
ITEM_NAME | Item name as provided by client | TEXT(16777216) |
DEPARTMENT | Department value as provided by client | TEXT(16777216) |
CATEGORY | Item category as provided by client | TEXT(16777216) |
PRODUCTTYPEID | Product type ID, correlates with name | NUMBER(3,0) |
PRODUCTTYPENAME | Product Type as provided by client | TEXT(1000) |
BRAND | Brand value as provided by client | TEXT(16777216) |
ECOM_NUMBER_OF_ITEMS | Number of items of this type purchased in this transaction | NUMBER(19,4) |
ECOM_ITEM_PRICE | Single item price | NUMBER(19,4) |
ECOM_REFUND_AMOUNT | Amount in case of type 'refund' | NUMBER(19,4) |
ECOM_STORE_TYPE | Store type as provided by client | TEXT(16777216) |
ECOM_DISCOUNT | Discount given on this transaction | NUMBER(19,4) |
Updated 3 days ago