Delivery Service Provider Credit and Debit Card Transaction Data

Overview

Aggregated consumer transaction data on 100M+ credit and debit cards, including 35M+ with activity in the past 12 months and 14M+ active monthly users. Capturing online, offline, and 3rd-party consumer spending on public and private companies, data covers 13K+ merchants.

Geared toward business research, data covers transactions in the consumer delivery services industry. Data is aggregated to company level, broken down by brand, and shows individual transaction by delivery distribution service and brand being distributed (e.g., restaurants or grocery stores).

NAICS Codes

NAICS Industries are delineated by US Government-defined 3-digit NAICS codes. NAICS codes are manually mapped to individual brands for transactions tagged to a main brand. For other transactions, MCC codes have been mapped to NAICS codes and then the transactions are mapped to NAICS codes via their MCC code where available.

Panel Information

The number of cards in the database is growing over time, both due to macro trends in credit card usage and due to bank-specific customer acquisition trends. In order to normalize for this card growth.

This panel goes back to 1/1/2015 for USA1 data; it goes back to 1/1/2018 for USA2 and Combined USA1-USA2 data.

Matching Merchant Descriptions to Brands:

• Merchant names in the raw data are matched to brands.
• Additional data like MCC codes (industry codes), transaction sizes, and proprietary fields are used to refine this matching.
• Exceptions are tracked to ensure that subsidiary brands are included while non-revenue transactions are excluded.

Handling Complex Scenarios:

Special cases like "store-within-a-store" setups are carefully managed to credit revenue accurately to the appropriate brand. This ensures proper revenue attribution to the brand benefiting from the transaction.

Channel Identification:

• Transactions are categorized as either ONLINE or OFFLINE/UNKNOWN based on tagging processes.
• Catalogue and call center purchases are included in the ONLINE category.
• If not all online transactions for a brand can be confidently identified, they are flagged as OFFLINE/UNKNOWN.
  If there’s insufficient confidence in the data, the channel is marked as NA.

Attributing Multi-Brand Transactions:

• A single transaction can relate to multiple brands. For example: "PayPal DoorDash Wendy’s" might tag Wendy’s as the Main brand, DoorDash as the Delivery brand, and PayPal as the Payment brand.
• Delivery brands’ revenue (e.g., fees and tips) is excluded from Main brand sales to avoid discrepancies caused by differing revenue capture rates.

Revenue Reporting for Delivery Brands:

Separate files (e.g., day_delivery and period_delivery) break out revenue related to Delivery brand transactions when a Main brand can be identified.