Wallet Instance Data
This data set contains wallet install events associated with lists of the company's account.
How much data is retained?
This data set will contain 7 days’ worth of data starting from the most recent data refresh. Data is refreshed once per day. For example, if you are looking at the data set on 7/18, it will contain data from 7/11 to present.
What data can be pulled?
| Column Name | Type | Nullable | Default | Description |
|---|---|---|---|---|
| WALLET_ACTIVITY_NAME | VARCHAR(4000) | TRUE | NULL | The mobile wallet campaign associated with the instance |
| WALLET_ACTIVITY_UID | VARCHAR(255) | TRUE | NULL | Vibes UID for the mobile wallet campaign associated with the instance |
| COMPANY_UID | NUMBER(38,0) | TRUE | NULL | Vibes ID used to identify a company that is associated with the instance |
| CURRENT_FLAG | VARCHAR(8) | TRUE | NULL | It is True if the instance is currently registered, or False if the instance has been unregistered. |
| DW_CREATED_AT | TIMESTAMP_TZ(9) | TRUE | NULL | The date timestamp that indicates when the row was created in Vibes data warehouse. The time zone is central time for North America customers and UTC for European Customers |
| INSTANCE_EVENT | VARCHAR(255) | TRUE | NULL | Type of Wallet instance event. Valid values: Registered and Unregistered. |
| PLATFORM_NAME | VARCHAR(255) | TRUE | NULL | String for the specified device platform. Example: 'Android 7.1.1', 'iOS 10.3', and so on. |
| REGISTERED_AT_TTZ | TIMESTAMP_TZ(9) | TRUE | NULL | The date timestamp of when the instance was installed on the user's device. This timestamp will be in the time zone of the company. |
| SHARED_INSTANCE | VARCHAR(8) | TRUE | NULL | It is False if this the first installed instance for the Wallet object, or True otherwise. |
| TOKENS_JSON | VARIANT | TRUE | NULL | A field that contains data from fields associated with the instance |
| UNREGISTERED_AT_TTZ | TIMESTAMP_TZ(9) | TRUE | NULL | The date timestamp of when the instance was removed from the user's device. This timestamp will be in the time zone of the company. |
| UUID | VARCHAR(1000) | TRUE | NULL | This is a campaign-specific identifier that is used to identify wallet objects. This is generally customer defined, as it can be included in links and used before a wallet object is actually created. |
| WALLET_INSTANCE_UID | VARCHAR(255) | TRUE | NULL | Unique Vibes-specific identifier for each wallet instance that's been installed. |
| WALLET_OBJECT_UID | VARCHAR(1000) | TRUE | NULL | Unique identifier for the wallet object of this instance. |
| WALLET_PROVIDER_NAME | VARCHAR(255) | TRUE | NULL | String name for the installed provider. Valid values are Pass and Wallet. |
Sample Query
–- A query that will pull wallet installs from yesterday
SELECT
WALLET_ACTIVITY_NAME
,CURRENT_FLAG
,UUID
,TOKENS_JSON:loyalty_balance::STRING
,TOKENS_JSON:loyalty_tier::STRING
,INSTANCE_EVENT
,PLATFORM_NAME
,SHARED_INSTANCE
FROM WALLET_INSTANCE
WHERE CAST(DW_CREATED_AT AS DATE) >= CAST(DATEADD(day,-1, CURRENT_DATE()) AS DATE)
AND CAST(DW_CREATED_AT AS DATE) < CAST(CURRENT_DATE() AS DATE)
Updated over 1 year ago