When PayPal declines spike, do we see Shopify/BC/Adobe checkout completion drop? If yes, declines are causing real revenue loss, not just buyer remorse.
At a glance
Cross-channel correlation card that overlays PayPal decline-rate spikes against the commerce platform’s checkout funnel completion. The “is this real or just blocked fraud?” filter on every PayPal decline alert. Fires only when BOTH signals move together (decline rate jumps > 5 percentage points AND checkout completion drops > 5 percentage points in the same 24-hour window).
| The formula | Two-axis dual signal: Δ(pp_decline_rate vs prior 24h) > +5pp AND Δ(commerce_checkout_completion_rate vs prior 24h) < -5pp. Both conditions must hold simultaneously for the alert to fire. |
| PayPal axis (decline) | T00xx events with status IN [D, F] divided by all T00xx attempts in the trailing 24 hours. Compared against the equivalent prior-24h baseline. |
| Commerce axis (funnel) | Checkout completion rate from the connected commerce platform (Shopify / BigCommerce / Adobe Commerce). Defined as orders_placed ÷ checkouts_started. Compared against the equivalent prior-24h baseline. |
| Why this card matters (the merchant insight) | A decline spike alone could mean (a) real customers being blocked from completing purchases (revenue loss) OR (b) fraud being blocked at the gate (good outcome, no real revenue loss). This card disambiguates: a simultaneous funnel drop confirms it’s hitting real customers; a flat funnel suggests the spike is blocked fraud and you can ignore it. |
| Refunds (T11) and disputes (T19) | NOT counted on the PayPal axis. This card is decline-stage only, post-success events have their own cards. |
| Pending status (P) handling | Pending payments are in the denominator on the PayPal axis (they were attempts) but not in the decline numerator. |
| Currency | n/a (rates only). Both axes are rates, currency-neutral. |
| What “checkout completion” means per platform | Shopify: Order.createdAt count ÷ Checkout.createdAt count for the window (uses Shopify’s checkout funnel data). BigCommerce: orders_placed ÷ checkouts_started from BC’s analytics. Adobe Commerce: quote_active → quote_converted ratio from the orders/quote indices. |
| Time alignment | Both axes use the same 24-hour rolling window in UTC. The commerce platform is the upstream signal (customer hits checkout); PayPal is downstream (customer attempts payment). A decline spike with no funnel drop means the customer reached checkout but their payment was blocked, on a percentage basis few customers (most checkouts didn’t even reach payment). A funnel drop without a decline spike usually means customers abandoned earlier (price shock, shipping cost, slow page). |
| Page cap (PayPal axis) | 10,000 transactions per call. 24-hour windows on stores doing > 10k attempts/day truncate. |
| Page cap (commerce axis) | Platform-specific. Shopify pagination on /orders is 250 per page; BC /orders is 250 per page; Adobe varies. |
| Time window | 24H (rolling 24 hours, both axes). |
| Alert trigger | decline > +5pp AND funnel drop > 5pp (both must be true simultaneously). |
| Roles | owner, finance, marketing |
Calculation
Calculated automatically from your PayPal data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US-based fashion brand on Shopify, with PayPal Express as a checkout option alongside Shop Pay (Stripe). The 24-hour window is 12 Apr 26. Scenario A: real revenue loss (alert fires) Prior 24h baseline:| Metric | Value |
|---|---|
| PayPal decline rate (PP axis) | 5.2% |
| Shopify checkout completion (commerce axis) | 68.4% |
| Metric | Value |
|---|---|
| PayPal decline rate | 11.8% |
| Shopify checkout completion | 61.2% |
payer_authentication_required dominates, the 3DS provider has an outage and a chunk of legitimate customers can’t complete; (c) if denied_by_risk dominates AND the decline pattern looks normal-customer-not-fraud, PayPal Risk has tightened a rule that’s catching legitimate buyers; (d) consider showing customers a “try Shop Pay or Apple Pay instead” offer at the PayPal-decline page to recover the funnel.
Scenario B: blocked fraud (alert does NOT fire)
Prior 24h baseline:
| Metric | Value |
|---|---|
| PayPal decline rate | 5.2% |
| Shopify checkout completion | 68.4% |
| Metric | Value |
|---|---|
| PayPal decline rate | 14.1% |
| Shopify checkout completion | 67.9% |
| Metric | Value |
|---|---|
| PayPal decline rate | 5.2% |
| Shopify checkout completion | 68.4% |
| Metric | Value |
|---|---|
| PayPal decline rate | 5.4% |
| Shopify checkout completion | 60.1% |
Sibling cards merchants should reference together
| Card | Why pair it with PP XC Decline vs Funnel |
|---|---|
| PP Decline Rate | The PayPal-side absolute view. This card adds the cross-channel correlation. |
| PP Alert Decline Spike | The PayPal-only spike alert. This card is the “is the spike real?” filter. |
| PP Revenue at Risk (live) | The dollar-weighted live signal. This card confirms the dollars are real customer loss not blocked fraud. |
| PP Fraud Velocity | When the alert DOESN’T fire (decline spike + flat funnel), this card surfaces the fraud attack signature. |
| PP Decline Event Codes | When the alert DOES fire, first card to drill into. Tells you what’s blocking real customers. |
| Shopify Conversion Rate | The Shopify-side funnel signal. This card uses checkout completion specifically; conversion rate is broader. |
| BigCommerce Conversion Rate | BC-side equivalent. |
| Adobe Commerce Conversion Rate | Adobe-side equivalent. |
| PP XC Recoverable Revenue | The 30-day forecast version of decline-driven loss. This card is “now”; that one is “month over month”. |
Reconciling against the vendor’s own dashboard
Where to look in PayPal Business and your commerce platform: This is a Vortex IQ-derived signal that combines two upstream sources, neither of which has a native equivalent. The closest comparable views per side: PayPal axis:- PayPal Business → Activity → All Transactions, filter by Status to get the decline rate.
- PayPal Business → Reports → Activity download for hourly granularity.
- Shopify: Analytics → Reports → “Online store conversion over time” or “Checkout funnel”. The “Reached checkout” → “Sessions converted” ratio.
- BigCommerce: Analytics → Conversions → “Abandoned cart” or “Checkout abandonment”.
- Adobe Commerce: Reports → Sales → “Abandoned carts” report.
- “Cart abandonment rate” includes pre-checkout abandons (cart → shipping); we focus on the checkout stage specifically (where payment actually happens).
- “Site conversion rate” includes session-level abandonment from the homepage onwards; we focus on the bottom-of-funnel where PayPal is involved.
- PayPal’s own “Approval rate” looks similar to decline rate but uses a different denominator (only authorised vs only attempted).
| Reason | Direction of divergence | What to do |
|---|---|---|
| Time alignment. PayPal axis uses UTC; commerce platform uses store timezone. Boundary days may shift one axis vs the other. | Boundary effects | Align both views to the same UTC window for verification. |
| Funnel definition. We use “checkouts started → orders placed” but each commerce platform has its own definition of “checkout started” (cart filled vs payment-screen reached). | Platform-specific drift | Verify the commerce platform’s funnel definition matches our usage. |
| PayPal-only attribution. The decline axis tracks only PayPal declines, the funnel axis tracks ALL checkouts (Stripe, Shop Pay, Apple Pay, manual transfer, gift cards). On stores where PayPal is a small share of checkout, a PayPal decline spike may not move the overall funnel meaningfully even when it’s real. | Vortex IQ may under-fire on PayPal-minority stores | Use PP Alert Decline Spike for the PayPal-isolated view. |
| Refresh lag. Both sides refresh independently; the cross-correlation is computed from the most recent values, which may be 5-15 minutes apart. | Tiny | Wait for next refresh. |
| Page caps. PayPal axis caps at 10k transactions per call; commerce axis caps at 250 per page on Shopify / BC. Heavy-volume stores may see truncation on either axis. | Either direction | Use shorter windows. |
| Comparison | Expected relationship | When divergence is legitimate |
|---|---|---|
pp_xc_decline_vs_funnel ↔ stripe.stripe_xc_decline_vs_funnel | The Stripe twin. Different traffic lanes; can fire independently. | A PayPal-only fire usually means PayPal-side issue (Risk rule, eCheque, PayPal-traffic ad campaign). A both-fire usually means upstream (3DS network outage, your checkout deploy). |
pp_xc_decline_vs_funnel ↔ commerce platform funnel | This card USES the commerce funnel as its commerce axis. Internal identity. | If the commerce funnel signal is broken or stale, this card is unreliable. |
pp_xc_decline_vs_funnel ↔ pp_revenue_at_risk_live | When XC fires, Revenue at Risk should also be elevated (real customer loss has real dollar exposure). | Revenue at Risk fires more sensitively than XC; it’s normal for Revenue at Risk to fire alone (small-volume hours where the funnel signal is too noisy). |