Panel Details & Columns Flashcards
When did the C Panel start?
How many US cobrands does it contain?
1/1/2011
40 Cobrands (“Open Panel”)
How many users are in US cobrand universe?
As of Dec 2022 - 57 cobrands
77MM Users. (“50 Million + Users”)
15MM Active (“Monthly”), Min 10MM
How is X Panel different from C Panel?
Both started 1/1/2011
X is a subset of C (X Prime is another derivation, all the legacy cobrands are gone, only active) X has 5 cobrands.
69MM Users.
9.5MM Active, Min 8MM
What are key features of RTP Panel?
Started Sept 2020
Bank and Card delivered hourly. Just incremental. Go forward, no history.
How are X Panel files accessible?
The X Panel files are available in both text and parquet formats for bank and card
transactions. S3 & Amazon Redshift
What UVS compound score is considered “Stable”?
Compound scores are ranked 1-10, 10 being the best users. A score of 6.5 and above is considered of strong stability.
[X PANEL COLUMNS]
What is UNIQUE_MEM_ID?
What is LENGTH_OF_HISTORY?
What is AVG_TRANSACTION_VOLUME?
UNIQUE_MEM_ID is a unique ID for the user across the panel.
LENGTH_OF_HISTORY is # of years where a unique_mem_id has transacted in the panel.
AVG_TRANSACTION_VOLUME is the average number of debit transactions (i.e., excluding refunds or deposits) over the prior 24-month period
[X PANEL COLUMNS]
What is CONSISTENCY?
What is VOLATILITY?
What is DISTINCT_MERCHANT_COUNT?
CONSISTENCY is a binary flag. A value of 1 means that a user has had a minimum of 15
transactions per month in at least 18 of the previous 24 months.
VOLATILITY is categorization of users into low/medium/high volatility based on the
number of transactions and dollar amounts.
DISTINCT_MERCHANT_COUNT is the number of unique merchants at which a user has transacted during the previous 24 months.
[X PANEL COLUMNS]
What is DISTINCT_MERCHANT_COUNT?
What is LATEST_TRANSACTION_DATE?
What is SHARE_OF_WALLET?
DISTINCT_MERCHANT_COUNT - The number of unique merchants at which a user has transacted during the previous 24 months.
LATEST_TRANSACTION_DATE - Corresponds to the latest optimized_transaction_date in Yodlee panels for a given user in the past 24 months.
SHARE_OF_WALLET - Value from 0-1, representing the percentage of a given user’s financial transactions that are captured in Yodlee data.
[X PANEL COLUMNS]
What does a SHARE_OF_WALLET value of 0.31 mean?
31% of a given user’s financial
transactions that are captured in Yodlee data.
[X PANEL COLUMNS]
A user has a CONSISTENCY value of 1. What does that mean about the user?
It means the user has had a minimum of 15 transactions per month in at least 18 of the previous 24 months.
[X PANEL COLUMNS]
What does a DISTINCT_MERCHANT_COUNT value of 35 mean?
The User transacted with 35 unique merchants during the previous 24 months
[X PANEL COLUMNS]
What does a LENGTH_OF_HISTORY value of 4 mean?
The User transacted in the panel for 4 years under its unique ID
[X PANEL COLUMNS]
What is CARD_ACCOUNT_COUNT?
What is BANK_ACCOUNT_COUNT?
What is LAG?
CARD_ACCOUNT_COUNT is the # of unique accounts in the credit card panels observed during the previous 24 months for a given user.
BANK_ACCOUNT_COUNT is the is the # of unique accounts in the bank panels observed during the previous 24 months for a given user.
LAG is the median transaction lag for a user in the previous 24 months.
[X PANEL COLUMNS]
How many months is the look-back for CARD_ACCOUNT_COUNT and BANK_ACCOUNT_COUNT datapoints?
24 Months
[X PANEL COLUMNS]
How many months is the look-back for VG_TRANSACTION_VOLUME and DISTINCT_MERCHANT_COUNT datapoints?
24 Months
[X PANEL COLUMNS]
What is HIGH_VALUE_TRANSACTION_
COUNT?
What is COMPOUND_SCORE?
What is AS_OF_DATE?
What is PANEL_FILE_CREATED_DATE?
HIGH_VALUE_TRANSACTION_
COUNT is # of transactions over USD $10,000 in the previous 84 months
COMPOUND_SCORE UVS from 0 -10, where 10 represents the best users.
AS_OF_DATE is until when data is being considered for generating the score.
PANEL_FILE_CREATED_DATE is when UVS was made available
What are the two types of Geo Data available?
Household Geo & Monthly Geo
What is the difference between Household Geo and Monthly Geo?
Household geo module identifies where the user lives by weighting transactions in
certain categories higher. (Rent, Utilities, Mgt)
vs.
Monthly is non-weighted, the module looks at the last 30 days of transactions together and identifies the most likely location of the user based on this data.
What are the 7 Tiers of User Income Class?
1 $0 - 25k
2 $25 - 45k
3 $45 - 60k
4 $60 - 75k
5 $75k - 100k
6 $100 - 150k
7 $150k+
What figures used to categorize User Income Class?
Spends, Payroll, Deposits, etc.
What is the difference between Active and Lineage Files?
Active files only have active users, where an active user is defined as having at least 1 transaction during the period.
Lineage files include changes from previous files. USER_DEMO_RECORD_STATUS column will indicate:
N: new record
U: updated user record
D: deleted record
[AGGREGATE PAYROLL]
When does the aggregate payroll historically start?
1/1/2016
[AGGREGATE PAYROLL]
What do the following column headers describe?
ticker, periodicity, employees, deposit, panel_active_users
ticker- Stock ticker to which a given employer belongs.
periodicity- Cadence of payrolls received (weekly, bi-weekly, bi-monthly, monthly…)
employees- The total number of employees receiving paychecks
deposit- The total $ amount of paychecks deposited.
panel_active_users - The total number of employees (users) in the base panel during period
In the Aggregate Payroll Product, what are some KPI’s to help identify change?
- New and existing employee counts,
- New and existing deposit amounts,
- Employee churn.
What are examples of “Enrichment”?
Geography, Sales Channel
[AGGREGATE PRODUCT]
How are brands & tickers mapped in the aggregate product?
Most tickers available in the Aggregate Product are US-listed (on the NYSE, NASDAQ, etc.) and have alphabetical one to four-letter ticker symbols (e.g., A, GOOG, WMT). At the same time, some are non-US listed and have numerical ticker symbols (e.g., 1910, 9983, etc.)
[AGGREGATE PRODUCT]
What are the types of Aggregate Files?
- “Brand-level” files – This aggregate files contain the brand-level aggregate metrics.
The brands are also mapped to their corresponding tickers - “Ticker-level” files – Transactions for all brands within a ticker are rolled up as
aggregates into constituent tickers and are not aggregated separately. For example,
GAP (ticker: GPS) also owns Banana Republic, Old Navy, and other brands. The ticker level aggregate files will have all brands’ metrics rolled under the GPS ticker. - “User count” files – User counts are provided at the panel level in this file. These counts are provided so that a customer can perform a custom normalization of spends or
transactions at the ticker or brand-level.
