Wallet Page View Data

This data set contains wallet page view 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 NameTypeNullableDefaultComment
WALLET_ACTIVITY_NAMEVARCHAR(4000)TRUENULLThe name of the mobile wallet campaign associated with the view
WALLET_ACTIVITY_UIDVARCHAR(255)TRUENULLVibes UID for the mobile wallet campaign associated with the view
COMPANY_UIDNUMBER(38,0)TRUENULLVibes ID used to identify a company that is associated with the view
DW_CREATED_ATTIMESTAMP_TZ(9)TRUENULLThe 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
PLATFORM_NAMEVARCHAR(255)TRUENULLString for the specified device platform. Example: 'Android 7.1.1', 'iOS 10.3', and so on.
USER_AGENTVARCHAR(16777216)TRUENULLThe first 255 characters of the browser user-agent header value.
UUIDVARCHAR(1000)TRUENULLThis 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.
VIEW_UIDVARCHAR(255)TRUENULLUnique Vibes-specific identifier for each view
VIEWED_AT_TTZTIMESTAMP_TZ(9)TRUENULLThe date timestamp of when the view occurred. This timestamp will be in the time zone of the company.
WALLET_PAGE_TYPEVARCHAR(255)TRUENULLKey value indicating the specific page/flow that was viewed. These will map to the various pages in the specific campaign flow. Valid values include: UNKNOWN, smartlink, location_selector, passbook.

Sample Query

–- A query that will pull wallet page views from yesterday
SELECT
WALLET_ACTIVITY_NAME
,PLATFORM_NAME
,UUID
,DW_CREATED_AT
,VIEWED_AT_TTZ
FROM WALLET_PAGE_VIEW
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)