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?
|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.|
–- 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 7 months ago