Skip to end of metadata
Go to start of metadata

Last Updated: Wednesday, June 19, 2019



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 previous day. For example, if you are looking at the data set today, 7/18/2019, it will contain data from 7/11/2019 to present.

What data is included?


Column Name

Type

Nullable

Default

Comment

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.


What are some sample queries to pull this data?

–- A query that will pull wallet installs from yesterday
SELECT
WALLET_ACTIVITY_NAME
,CURRENT_FLAG
,UUID
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)
  • No labels