Filtering specifically for charges made using Apple Pay or Google Pay is only available when using Stripe Sigma or Dashboard exports.
Using Sigma
To filter for charges created using Apple Pay or Google Pay, you will need to use the Charges table and filter by the card_tokenization_method column. That column contains apple_pay
for Apple Pay payments and android_pay
or google_pay
for Google Pay payments. A very simple SQL query to do this looks like:
SELECT id
FROM charges
WHERE card_tokenization_method = ’apple_pay’
ORDER BY created
Using Dashboard exports
To locate Apple Pay or Google Pay charges, you can export your payments from the Dashboard with the Card Tokenization Method column enabled. In the resulting export that column will contain apple_pay
for Apple Pay payments and android_pay
or google_pay
for Google Pay payments.