TrafficWatch

Back to Log
Session Details
Loading date...
Applied
Session ID
ses-U9fK7a-Q3pMz
Request ID
res-ACl4Qy-cN3bV
Request Text
Start data generation

Generation Request Summary
- Dataset Name: Online Touchpoints (user tracks)
- Tables:
  - Table: touchpoints
    - Fields:
      - user_id: integer, range 1..1000, not null
      - timestamp: datetime (ISO-8601, UTC), within last 90 days, not null
      - short_url: string, not null; patterns:
        - media touchpoint → https://t.example/ad/landing- or https://t.example/display/landing-
        - onsite/page → https://site.example/page/landing-
        - onsite/conversion → https://site.example/checkout/landing- or https://site.example/checkout/confirm
      - type: enum string in {media touchpoint, onsite/page, onsite/conversion}, not null
  - Relationships: single table; no foreign keys
- Row Counts:
  - Users: 1,000 distinct (1..1000)
  - Touchpoints per user: 1–20
  - Target total rows: ~10,000
- Uniqueness and Nullability:
  - No nulls in any field
  - No additional uniqueness constraints
- Distributions and Correlations:
  - Onsite touchpoints per user: 0–5
  - Conversions are rare (≈5–8% of onsite events) and occur only after at least one onsite/page for the same user
  - Media typically precedes onsite for ~80% of users
  - Within each user, events are chronologically ordered with realistic gaps (minutes to days)
- Date/Time Window and TZ:
  - Last 90 days from generation time
  - UTC; ISO-8601 format (e.g., 2025-09-12T14:05:00Z)
- Locale Realism:
  - Generic English-like URLs; no PII
- CSV Format:
  - Delimiter: comma
  - Quoting: minimal
  - Header: included
  - Encoding: UTF-8
- Random Seed:
  - None (non-reproducible run)
- Assumptions (confirmed):
  - Landing number  range is 1–999
  - Up to one onsite/conversion per user is allowed but not strictly capped unless specified
  - Timestamps distributed across the window with mild daytime clustering
  - Domains t.example and site.example are acceptable
Response Text
View Response Download Data