Blog
Practical guides on eCommerce, SEO, analytics and everyday web tools.
DAX SAMEPERIODLASTYEAR Returns Blank: Date Table Requirements and Fix
DAX SAMEPERIODLASTYEAR returns blank? Fix it with a contiguous marked date table, a one-to-many relationship, and a tested measure. M-code included.
Read article →
Flatten Nested JSON to CSV Without Losing or Duplicating Rows
Flatten nested JSON to CSV without dropping empty-array rows or double-counting totals. Includes validation and MySQL, PostgreSQL, SQL Server code.
Read article →
GA4 Custom Event Parameters Not Showing in Reports? Register Custom Dimensions (2026 Fix)
GA4 custom event parameters not showing in reports? Register them as event-scoped custom dimensions, validate the payload, and confirm in DebugView.
Read article →
Power Query Couldn't Convert to Number Error: Locale and Null Fixes
Fix the Power Query couldn't convert to number error: find bad rows with Keep Errors, set the right locale, and handle N/A or null values in M code.
Read article →
XLOOKUP Returns #N/A on Values That Look Identical: Hidden Characters and Type Mismatches
XLOOKUP returns #N/A but the value exists? Find hidden spaces, CHAR(160), and text-vs-number mismatches, then fix them with formulas or a VBA macro.
Read article →
Abandoned Cart Email Sequence Timing: Send Intervals, Discount Caps, and Subject Lines
Set abandoned cart email sequence timing, discount caps from contribution margin, and subject line tests for a three-email flow in Klaviyo or Shopify.
Read article →
Breakeven ROAS Calculation: Include COGS, Shipping and Fees
Breakeven ROAS calculation made exact: subtract your COGS, shipping, packaging and processor fees to find the ROAS below which every sale loses money.
Read article →
Return Policy Wording That Stops 'Item Not as Described' Chargebacks
Which return policy clauses reduce 'item not as described' chargebacks, where to place them, and how to organize evidence for dispute responses.
Read article →
Product Schema Missing Offers Field: Fix Offers, priceValidUntil & Availability Warnings
Product schema missing offers field? See which Product properties Google requires vs recommends, fix price and availability errors, and validate.
Read article → Product Schema Missing Offers Field: Fix Offers, priceValidUntil & Availability Warnings
Product schema missing offers field? See which Product properties Google requires vs recommends, fix price and availability errors, and validate.
Read article →