Event Schema

OWNLAY uses a canonical event schema to normalize data from all connected platforms.

Canonical Event Schema

{
  "event_id": "evt_123abc",
  "event_type": "conversion",
  "timestamp": "2024-12-12T14:30:00.000Z",
  "received_at": "2024-12-12T14:30:01.234Z",
  
  // User identification
  "user_id": "user_123",
  "anonymous_id": "anon_456",
  "session_id": "sess_789",
  
  // Source attribution
  "source": {
    "platform": "google_ads",
    "campaign_id": "camp_123",
    "ad_group_id": "ag_456",
    "ad_id": "ad_789",
    "keyword": "marketing software"
  },
  
  // UTM parameters
  "utm": {
    "source": "google",
    "medium": "cpc",
    "campaign": "q4_holiday",
    "content": "banner_a",
    "term": "marketing software"
  },
  
  // Event properties
  "properties": {
    "page_url": "https://example.com/checkout",
    "referrer": "https://google.com",
    "revenue": 99.99,
    "currency": "USD",
    "product_id": "prod_123",
    "quantity": 1
  },
  
  // Device & context
  "context": {
    "ip": "192.168.1.1",
    "user_agent": "Mozilla/5.0...",
    "locale": "en-US",
    "timezone": "America/New_York",
    "device": {
      "type": "desktop",
      "os": "Windows",
      "browser": "Chrome"
    },
    "geo": {
      "country": "US",
      "region": "NY",
      "city": "New York"
    }
  }
}

Event Types

Event Type Description Required Properties
page_view User views a page page_url
click User clicks on an ad or link click_url
form_submit User submits a form form_id
add_to_cart User adds item to cart product_id, quantity
purchase User completes purchase revenue, currency, order_id
conversion Generic conversion event conversion_type
lead New lead captured email or phone

Platform Connectors

Google Ads

  • • Campaigns, Ad Groups, Ads
  • • Impressions, Clicks, Conversions
  • • Cost, CPC, CPA metrics
  • • Keyword performance

Meta Ads

  • • Campaigns, Ad Sets, Ads
  • • Reach, Frequency, Engagement
  • • ROAS, Cost per Result
  • • Audience insights

Google Analytics 4

  • • Sessions, Users, Page Views
  • • Conversion events
  • • Traffic sources
  • • User behavior flows

Shopify

  • • Orders, Revenue
  • • Products, Inventory
  • • Customer data
  • • Cart events

Data Retention & Sync

Data Type Sync Cadence Retention (Raw) Retention (Aggregated)
Ad Platform Data Every 15 minutes 90 days Unlimited
Analytics Events Real-time 30 days 2 years
E-commerce Data Real-time webhooks 90 days Unlimited
Audit Logs Real-time 7 years 7 years

Data Warehouse Export

OWNLAY supports exporting data to your data warehouse for advanced analysis:

  • BigQuery - Direct streaming or scheduled exports
  • Snowflake - Scheduled exports via Snowpipe
  • Custom - Webhook-based exports to any destination