TrackPro v5 Intelligence Debug
==================================================

1. DB Connection... OK
2. visitor_profiles table... OK
3. identity_graph table... OK
4. visitor_identities... 3 visitors found
5. visitor_sessions... Testing visitor ID: 3
   Sessions for this visitor: 1

6. Testing table data for session 7:
   device_data: 45 columns OK
   browser_data: 39 columns OK
   network_data: 36 columns OK
   location_data: 22 columns OK
   risk_data: 16 columns OK
   fingerprint_data: 13 columns OK
   behavioral_data: 7 columns OK

7. visitor_profiles columns:
   id (bigint(20) unsigned) [PRI]
   visitor_id (bigint(20) unsigned) [UNI]
   device_tier (enum('budget','mid','premium','ultra')) [MUL]
   device_tier_score (tinyint(3) unsigned)
   device_tier_signals (text)
   tech_level (enum('novice','basic','intermediate','advanced','expert')) [MUL]
   tech_level_score (tinyint(3) unsigned)
   tech_level_signals (text)
   intent (enum('casual','researching','comparing','ready_to_act','returning','automated')) [MUL]
   intent_score (tinyint(3) unsigned)
   intent_signals (text)
   engagement_level (enum('bounce','glance','reader','engaged','power_user'))
   engagement_score (tinyint(3) unsigned)
   visit_pattern (enum('one_time','occasional','regular','frequent','obsessive'))
   active_hours (varchar(48))
   avg_session_duration (int(10) unsigned)
   total_interactions (int(10) unsigned)
   privacy_consciousness (enum('none','low','moderate','high','paranoid'))
   privacy_score (tinyint(3) unsigned)
   privacy_signals (text)
   primary_ecosystem (enum('google','apple','microsoft','meta','other','mixed'))
   ecosystem_signals (text)
   interest_tags (text)
   likely_age_range (varchar(16))
   likely_profession (varchar(64))
   confidence_score (tinyint(3) unsigned)
   data_points_used (int(10) unsigned)
   last_profiled (datetime)
   created_at (datetime)
   updated_at (datetime)

8. Loading intelligence_engine.php... OK
9. Running profiler on visitor 3... OK!

Profile result:
   visitor_id: 3
   data_points_used: 7
   device_tier: premium
   device_tier_score: 75
   device_tier_signals: ["RAM:8GB(mid-high)","Screen:HD-","Retina:2x","HDR","CPU:8cores","NFC","BT"]
   tech_level: advanced
   tech_level_score: 75
   tech_level_signals: ["VPN","Tor","tz-mismatch"]
   intent: casual
   intent_score: 10
   intent_signals: ["engaged:119s"]
   engagement_level: glance
   engagement_score: 24
   avg_session_duration: 119
   total_interactions: 0
   privacy_consciousness: high
   privacy_score: 53
   privacy_signals: ["VPN","Tor"]
   primary_ecosystem: google
   ecosystem_signals: ["OS:Android"]
   visit_pattern: one_time
   active_hours: [0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
   likely_age_range: 25-34
   likely_profession: general
   interest_tags: []
   confidence_score: 62

10. Running correlator... OK!
   Clusters: 0, Linked: 0

==================================================
DELETE THIS FILE