search
Dashboard

Edge Lake

The Edge Lake skill covers querying and analyzing your event data lake. Edge Lake stores all website and shop events in Cloudflare R2 and makes them queryable via SQL.

circle-info

Edge Lake requires the DataNexus Shopify apparrow-up-right to be installed.

hashtag
What it covers

  • SQL querying - Writing queries against the lake.events table with R2 SQL syntax and limitations

  • Event schema - Complete column reference for events, payloads, users, geolocation, attribution, and consent

  • Funnel analysis - Building conversion funnels (PageView -> AddToCart -> Checkout -> Purchase)

  • Attribution reporting - UTM source/medium/campaign analysis, first-click vs. last-click attribution

  • Revenue analysis - Daily/weekly/monthly revenue trends, average order values, top products

  • Traffic analysis - Browser, OS, device, and country breakdowns

  • Bot detection - Analyzing Cloudflare bot scores to identify automated traffic

  • WAF attack analysis - Understanding attack traffic patterns and classifications

hashtag
When it triggers

The skill activates automatically when you mention:

  • Edge Lake, event data lake, or R2 data lake

  • SQL events, funnel analysis, or attribution analysis

  • Bot score, WAF attack score, or traffic analysis

  • Revenue reporting, conversion funnel, or event analytics

  • lake.events, edgeLakeQuery, or edgeLakeCodeQuery

hashtag
Example prompts

  • "Build a conversion funnel for the last 7 days"

  • "What are our top UTM sources by revenue?"

  • "Show me daily purchase counts and revenue this month"

  • "How much bot traffic are we getting?"

  • "Which pages have the most AddToCart events?"

  • "Compare new vs. returning customer purchase rates"

PreviousConsentIQ

Last updated

Was this helpful?