Last Updated: Tuesday, January 17, 2023
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 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 view |
WALLET_ACTIVITY_UID | VARCHAR(255) | TRUE | NULL | Vibes UID for the mobile wallet campaign associated with the view |
COMPANY_UID | NUMBER(38,0) | TRUE | NULL | Vibes ID used to identify a company that is associated with the view |
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 |
PLATFORM_NAME | VARCHAR(255) | TRUE | NULL | String for the specified device platform. Example: 'Android 7.1.1', 'iOS 10.3', and so on. |
USER_AGENT | VARCHAR(16777216) | TRUE | NULL | The first 255 characters of the browser User-Agent header value. |
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. |
VIEW_UID | VARCHAR(255) | TRUE | NULL | Unique Vibes-specific Identifier for each view |
VIEWED_AT_TTZ | TIMESTAMP_TZ(9) | TRUE | NULL | The date timestamp of when the view occured. This timestamp will be in the time zone of the company. |
WALLET_PAGE_TYPE | VARCHAR(255) | TRUE | NULL | Key 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. |
What are some sample queries to pull this data?
–- 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)
Overview
Content Tools