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