Consumer Purchase Insights, Custom

Introduction:
Affinity Solutions’ Consumer Purchase Insights, Custom on Snowflake contains over 9 billion annual credit and debit card transactions from over 140MM cards. Transactions span over 4,200 merchant brands, online and offline channels, and all 50 states to accurately reflect U.S. consumer spend.

Data Source:
Data is fully permissioned and sourced from 3,000+ financial institution partners.
Why clients choose Affinity:
1. Deterministic Data - Card purchases are directly linked to an individual or household.
2. Data Recency - Purchase data is received and processed daily from 3,000+ financial institution partners.
3. Matchability - First and third-party data can be matched to purchase data for deeper insights.
4. Consent - Bank partners and their customers have given consent to use their data for insights and other marketing purposes.
5. Enrichment - Data is enriched with geographic and demographic data to enable deeper insights.

Purchase Graph Details:
Access the Affinity Purchase Graph via a set of standard or custom query templates to query debit and credit card transactions for anonymized individuals and households.
• Dataset Time Span: 3 – 5 years of historical data
• Data Refresh Cadence: Weekly

SAMPLE TABLES/COLUMNS:
- DEMOGRAPHICS: membccid,income,wealth,ethnicity,politics,adults_in_household,age,business_owner,children,homeowner_probability
- CARD: membccid,card_zip,cardtype
- BRAND_MAPPING: brand_id,brand_name,channel
- MERCHANT: mcc,merchcity,merchstate,merchzip
- STORE_LOCATION_MAPPING: locationid,address,city,state,zip,est_open_date,est_close_date
- TRANSACTION: trans_date,trans_amount

搜集汇总

背景与挑战

背景概述

该数据集包含美国140多张信用卡/借记卡的年交易记录，覆盖4200多个商户品牌和全美各州，提供人口统计、商户信息和交易明细等多维数据。数据具有确定性、每日更新和可匹配第三方数据等特点，包含3-5年历史记录并每周更新。