[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_272":273,"_274":275},"routes/_app.x.$handle.$name",{"_97":96,"_32":45,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":123,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":68,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",39,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","iq-unlocked-export.ts","latestPath","fileId","7bef0eb4-ffd0-11f0-9e46-42dde27851f2","name","fileType","http","content","// Learn more: https://docs.val.town/vals/http/\nexport default async function (req: Request): Promise {\n return Response.json({ ok: true })\n}","// =============================================================================\n// VAL: iq-unlocked-export\n// PURPOSE: Export audience segments for lookalike audiences\n// =============================================================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nexport default async function handler(req: Request): Promise {\n const headers = {\n 'Access-Control-Allow-Origin': '*',\n 'Content-Type': 'application/json',\n };\n\n const url = new URL(req.url);\n const segment = url.searchParams.get('segment');\n const format = url.searchParams.get('format') || 'json';\n const limit = parseInt(url.searchParams.get('limit') || '10000');\n\n const segments: Record = {\n // High-value segments for lookalikes\n 'high-scorers': `\n SELECT DISTINCT user_email as email, anonymous_id\n FROM quiz_events \n WHERE event_type = 'quiz_completed' \n AND JSON_EXTRACT(payload, '$.percentile') >= 70\n AND user_email IS NOT NULL\n LIMIT ${limit}\n `,\n \n 'platinum-gold': `\n SELECT DISTINCT user_email as email, anonymous_id\n FROM quiz_events \n WHERE event_type = 'quiz_completed' \n AND JSON_EXTRACT(payload, '$.band') IN ('platinum', 'gold')\n AND user_email IS NOT NULL\n LIMIT ${limit}\n `,\n \n 'completers': `\n SELECT DISTINCT user_email as email, anonymous_id\n FROM quiz_events \n WHERE event_type = 'quiz_completed'\n AND user_email IS NOT NULL\n LIMIT ${limit}\n `,\n \n 'completers-no-purchase': `\n SELECT DISTINCT e.user_email as email, e.anonymous_id\n FROM quiz_events e\n WHERE e.event_type = 'quiz_completed'\n AND e.user_email IS NOT NULL\n AND NOT EXISTS (\n SELECT 1 FROM quiz_events c \n WHERE c.user_email = e.user_email \n AND c.event_type = 'conversion'\n )\n LIMIT ${limit}\n `,\n \n 'converters': `\n SELECT DISTINCT user_email as email, anonymous_id\n FROM quiz_events \n WHERE event_type = 'conversion'\n AND user_email IS NOT NULL\n LIMIT ${limit}\n `,\n \n 'abandoners': `\n SELECT DISTINCT anonymous_id, session_id\n FROM quiz_events \n WHERE event_type = 'quiz_started'\n AND session_id NOT IN (\n SELECT session_id FROM quiz_events WHERE event_type = 'quiz_completed'\n )\n LIMIT ${limit}\n `,\n \n 'engaged-20plus': `\n SELECT session_id, COUNT(*) as answers, MAX(user_email) as email, MAX(anonymous_id) as anonymous_id\n FROM quiz_events \n WHERE event_type = 'question_answered'\n GROUP BY session_id\n HAVING answers >= 20\n LIMIT ${limit}\n `,\n \n 'research-consent': `\n SELECT user_email as email\n FROM user_profiles\n WHERE research_consent = 1\n LIMIT ${limit}\n `,\n \n 'profile-complete': `\n SELECT user_email as email, occupation, industry, education_level\n FROM user_profiles\n WHERE profile_completed_at IS NOT NULL\n LIMIT ${limit}\n `,\n \n // Archetype-specific segments\n 'archetype-strategic-analyst': `\n SELECT DISTINCT user_email as email\n FROM quiz_events \n WHERE event_type = 'quiz_completed' \n AND JSON_EXTRACT(payload, '$.identity_type') LIKE '%Strategic%'\n AND user_email IS NOT NULL\n LIMIT ${limit}\n `,\n \n 'archetype-creative': `\n SELECT DISTINCT user_email as email\n FROM quiz_events \n WHERE event_type = 'quiz_completed' \n AND JSON_EXTRACT(payload, '$.identity_type') LIKE '%Creative%'\n AND user_email IS NOT NULL\n LIMIT ${limit}\n `,\n \n // Retest eligible\n 'retest-eligible-30day': `\n SELECT user_email as email, original_score, original_percentile, original_archetype\n FROM retest_tracking\n WHERE retest_30day_eligible_at <= datetime('now')\n AND retest_30day_completed_at IS NULL\n LIMIT ${limit}\n `,\n \n 'retest-completed': `\n SELECT user_email as email, original_score, retest_30day_score,\n (retest_30day_score - original_score) as score_change\n FROM retest_tracking\n WHERE retest_30day_completed_at IS NOT NULL\n LIMIT ${limit}\n `,\n };\n\n if (!segment || !segments[segment]) {\n return new Response(JSON.stringify({\n error: 'Invalid segment',\n available_segments: Object.keys(segments),\n }), { headers, status: 400 });\n }\n\n const results = await sqlite.execute(segments[segment]);\n\n if (format === 'csv') {\n const rows = results.rows as Record[];\n if (rows.length === 0) {\n return new Response('No data', { headers: { 'Content-Type': 'text/csv' } });\n }\n \n const columns = Object.keys(rows[0]);\n const csv = [\n columns.join(','),\n ...rows.map(row => columns.map(col => `\"${row[col] || ''}\"`).join(','))\n ].join('\\n');\n \n return new Response(csv, {\n headers: {\n 'Content-Type': 'text/csv',\n 'Content-Disposition': `attachment; filename=\"${segment}-${new Date().toISOString().split('T')[0]}.csv\"`,\n },\n });\n }\n\n return new Response(JSON.stringify({\n segment,\n count: results.rows.length,\n data: results.rows,\n }), { headers });\n}","createdAt",["D",1770426598498],"branchVersion","branchId","0b90b880-ffcf-11f0-9521-42dde27851f2","id","0b90011a-ffcf-11f0-9521-42dde27851f2","iqunlocked",["D",1769992516575],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","019b2fa0-8cd2-7233-9d9e-779b04475582","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019b2fa0-8cd2-7233-9d9e-788defd15540","tursoName","0b90011affcf11f0952142dde27851f2","tursoHostname","0b90011affcf11f0952142dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789518676100],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"isOwned",41,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","glacador","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zNzBDVDJVeE9UeVhIQzJmdFMxc1M2d3JyM3IifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":267,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":-5,"_56":25,"_57":-5,"_58":-5,"_59":60,"_61":62,"_63":64,"_65":66,"_67":268,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":269,"_81":270,"_83":271,"_85":25},"tree",[222,223,224,225,226,227,228,229,230,231,232],"files",[222,223,224,225,226,227,228,229,230,231,232],"counts",{"_212":60,"_213":152,"_214":60,"_215":216,"_217":218},"contents",[128,129,130,131,132,133,134,135,136,137,138],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles",true,"grants","orgs","customDomains",{},{"_43":205,"_32":206,"_30":207,"_142":-5,"_41":42,"_40":208,"_144":123,"_38":209,"_13":196,"_33":34,"_35":210,"_24":25,"_147":-5,"_27":211},{"_43":198,"_32":199,"_30":200,"_142":-5,"_41":42,"_40":201,"_144":123,"_38":202,"_13":160,"_33":146,"_35":203,"_24":25,"_147":-5,"_27":204},{"_43":194,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_144":123,"_38":195,"_13":196,"_33":34,"_35":37,"_24":25,"_147":-5,"_27":197},{"_43":188,"_32":189,"_30":190,"_142":-5,"_41":42,"_40":191,"_144":25,"_38":192,"_13":167,"_33":34,"_35":36,"_24":25,"_147":-5,"_27":193},{"_43":182,"_32":183,"_30":184,"_142":-5,"_41":42,"_40":185,"_144":123,"_38":186,"_13":160,"_33":34,"_35":106,"_24":25,"_147":-5,"_27":187},{"_43":176,"_32":177,"_30":178,"_142":-5,"_41":42,"_40":179,"_144":123,"_38":180,"_13":160,"_33":34,"_35":106,"_24":25,"_147":-5,"_27":181},{"_43":169,"_32":170,"_30":171,"_142":-5,"_41":42,"_40":172,"_144":123,"_38":173,"_13":174,"_33":34,"_35":106,"_24":25,"_147":-5,"_27":175},{"_43":162,"_32":163,"_30":164,"_142":-5,"_41":42,"_40":165,"_144":123,"_38":166,"_13":167,"_33":34,"_35":36,"_24":25,"_147":-5,"_27":168},{"_43":155,"_32":156,"_30":157,"_142":-5,"_41":42,"_40":158,"_144":123,"_38":159,"_13":160,"_33":34,"_35":106,"_24":25,"_147":-5,"_27":161},{"_43":149,"_32":150,"_30":151,"_142":-5,"_41":42,"_40":152,"_144":123,"_38":153,"_13":60,"_33":146,"_35":106,"_24":25,"_147":-5,"_27":154},{"_43":139,"_32":140,"_30":141,"_142":-5,"_41":42,"_40":143,"_144":25,"_38":145,"_13":60,"_33":146,"_35":106,"_24":25,"_147":-5,"_27":148},"c31c4784-ffd0-11f0-9e46-42dde27851f2","new-file-3378.ts","c31c4856-ffd0-11f0-9e46-42dde27851f2","parentId",20,"latest",["D",1769993253997],"script","label",[140],"0b92a2da-ffcf-11f0-9521-42dde27851f2","main.ts","0b92a38e-ffcf-11f0-9521-42dde27851f2",1,["D",1769992516589],[150],"7f447288-ffd1-11f0-b0c6-42dde27851f2","iq-unlocked-survey-check.ts","6e885162-ffd1-11f0-a600-42dde27851f2",30,["D",1769993569683],2,[156],"71c41a10-ffd0-11f0-8df7-42dde27851f2","iq-unlocked-stats.ts","524a70ee-ffd0-11f0-bea7-42dde27851f2",11,["D",1769993117530],3,[163],"6a0607ce-ffd1-11f0-a786-42dde27851f2","iq-unlocked-retest-check.ts","d1adf964-ffd0-11f0-922d-42dde27851f2",27,["D",1769993534040],6,[170],"af36d404-ffd1-11f0-9e46-42dde27851f2","iq-unlocked-profiles-export.ts","a63f0fc4-ffd1-11f0-9e46-42dde27851f2",36,["D",1769993650121],[177],"9d0632e8-ffd1-11f0-9c53-42dde27851f2","iq-unlocked-leaderboard.ts","8e38228a-ffd1-11f0-951b-42dde27851f2",33,["D",1769993619606],[183],"b5b6fa44-ffd0-11f0-9531-42dde27851f2","iq-unlocked-item-analysis.ts","a13b0cd6-ffd0-11f0-bea7-42dde27851f2",19,["D",1769993231531],[189],"b88f401a-03c1-11f1-b841-42dde27851f2",["D",1770426598498],4,[28],"b34dc11c-03c1-11f1-aaf1-42dde27851f2","iq-unlocked-db-init.ts","1eb66ac2-ffcf-11f0-a8ac-42dde27851f2",38,["D",1770426589681],"// =============================================================================\n// VAL: iq-unlocked-db-init\n// PURPOSE: Initialize SQLite database tables (run once)\n// =============================================================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Main quiz events table\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS quiz_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id TEXT UNIQUE,\n event_type TEXT NOT NULL,\n anonymous_id TEXT,\n session_id TEXT,\n user_email TEXT,\n quiz_type TEXT,\n payload TEXT,\n segments TEXT,\n utm_source TEXT,\n utm_medium TEXT,\n utm_campaign TEXT,\n utm_content TEXT,\n utm_term TEXT,\n fbclid TEXT,\n gclid TEXT,\n ttclid TEXT,\n user_agent TEXT,\n ip_address TEXT,\n country TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\n// XP transactions table (for gamification)\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS xp_events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n event_id TEXT UNIQUE,\n user_email TEXT NOT NULL,\n action_key TEXT NOT NULL,\n xp_earned INTEGER NOT NULL,\n multiplier REAL DEFAULT 1.0,\n final_xp INTEGER NOT NULL,\n metadata TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\n// Retest tracking table\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS retest_tracking (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n quiz_type TEXT NOT NULL,\n original_attempt_id TEXT,\n original_score INTEGER,\n original_percentile INTEGER,\n original_archetype TEXT,\n original_completed_at DATETIME,\n retest_30day_eligible_at DATETIME,\n retest_30day_completed_at DATETIME,\n retest_30day_score INTEGER,\n retest_60day_eligible_at DATETIME,\n retest_60day_completed_at DATETIME,\n retest_60day_score INTEGER,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n UNIQUE(user_email, quiz_type)\n )\n`);\n\n// Outcome surveys table\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS outcome_surveys (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n survey_id TEXT UNIQUE,\n user_email TEXT NOT NULL,\n survey_type TEXT NOT NULL,\n original_quiz_type TEXT,\n original_score INTEGER,\n original_percentile INTEGER,\n original_archetype TEXT,\n responses TEXT,\n days_since_assessment INTEGER,\n completed_at DATETIME,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\n// Item statistics table (for psychometric analysis)\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS item_statistics (\n quiz_type TEXT NOT NULL,\n question_id TEXT NOT NULL,\n total_attempts INTEGER DEFAULT 0,\n correct_count INTEGER DEFAULT 0,\n difficulty_index REAL,\n high_scorers_correct INTEGER DEFAULT 0,\n high_scorers_total INTEGER DEFAULT 0,\n low_scorers_correct INTEGER DEFAULT 0,\n low_scorers_total INTEGER DEFAULT 0,\n discrimination_index REAL,\n mean_time_ms INTEGER,\n answer_distribution TEXT,\n last_calculated_at DATETIME,\n PRIMARY KEY (quiz_type, question_id)\n )\n`);\n\n// User profiles for B2B data\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS user_profiles (\n user_email TEXT PRIMARY KEY,\n occupation TEXT,\n industry TEXT,\n education_level TEXT,\n birth_year INTEGER,\n company_size TEXT,\n years_experience INTEGER,\n country TEXT,\n research_consent INTEGER DEFAULT 0,\n research_consent_date DATETIME,\n profile_completed_at DATETIME,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n`);\n\n// Create indexes\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_events_type ON quiz_events(event_type)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_events_quiz ON quiz_events(quiz_type)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_events_session ON quiz_events(session_id)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_events_email ON quiz_events(user_email)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_events_created ON quiz_events(created_at)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_events_utm_source ON quiz_events(utm_source)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_xp_email ON xp_events(user_email)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_xp_action ON xp_events(action_key)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_retest_email ON retest_tracking(user_email)`);\nawait sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_surveys_email ON outcome_surveys(user_email)`);\n\nconsole.log(\"✅ All tables created successfully!\");\nconsole.log(\"Tables: quiz_events, xp_events, retest_tracking, outcome_surveys, item_statistics, user_profiles\");",[199],"934da3aa-03c1-11f1-b161-42dde27851f2","iq-unlocked-capture.ts","3a0f9982-ffd0-11f0-b199-42dde27851f2",37,["D",1770426535994],"// =============================================================================\n// VAL: iq-unlocked-capture\n// PURPOSE: Main event capture endpoint with platform fan-out\n// ENDPOINT: https://[username]-iq-unlocked-capture.web.val.run\n// =============================================================================\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Types\ninterface QuizEventPayload {\n event_id: string;\n event_type: 'quiz_started' | 'question_answered' | 'quiz_completed' | 'quiz_abandoned' | 'email_captured' | 'conversion' | 'xp_earned' | 'profile_updated' | 'retest_completed' | 'survey_completed';\n anonymous_id?: string;\n session_id: string;\n user_email?: string;\n quiz_type?: string;\n event_data: Record;\n segments?: Record;\n attribution: {\n utm_source?: string;\n utm_medium?: string;\n utm_campaign?: string;\n utm_content?: string;\n utm_term?: string;\n fbclid?: string;\n gclid?: string;\n ttclid?: string;\n landing_page?: string;\n referrer?: string;\n };\n device: {\n user_agent?: string;\n screen_width?: number;\n screen_height?: number;\n };\n timestamp: string;\n}\n\n// Platform configuration - toggle on/off\nconst CONFIG = {\n platforms: {\n meta: true,\n klaviyo: true,\n ga4: true,\n tiktok: false, // Enable when ready\n taboola: false, // Enable when ready\n outbrain: false,\n mgid: false,\n revcontent: false,\n x_ads: false,\n },\n logging: {\n enabled: true,\n verbose: false,\n }\n};\n\n// =============================================================================\n// MAIN HANDLER\n// =============================================================================\nexport default async function handler(req: Request): Promise {\n const headers = {\n 'Access-Control-Allow-Origin': '*',\n 'Access-Control-Allow-Methods': 'POST, OPTIONS',\n 'Access-Control-Allow-Headers': 'Content-Type',\n 'Content-Type': 'application/json',\n };\n\n if (req.method === 'OPTIONS') {\n return new Response(null, { headers, status: 204 });\n }\n\n if (req.method !== 'POST') {\n return new Response(JSON.stringify({ error: 'POST only' }), { headers, status: 405 });\n }\n\n try {\n const data: QuizEventPayload = await req.json();\n \n // 1. Store in SQLite (always)\n await storeEvent(data);\n \n // 2. Fan out to all enabled platforms (fire and forget)\n const platformPromises = [];\n \n if (CONFIG.platforms.meta) platformPromises.push(sendToMeta(data));\n if (CONFIG.platforms.klaviyo) platformPromises.push(sendToKlaviyo(data));\n if (CONFIG.platforms.ga4) platformPromises.push(sendToGA4(data));\n if (CONFIG.platforms.tiktok) platformPromises.push(sendToTikTok(data));\n if (CONFIG.platforms.taboola) platformPromises.push(sendToTaboola(data));\n if (CONFIG.platforms.outbrain) platformPromises.push(sendToOutbrain(data));\n if (CONFIG.platforms.mgid) platformPromises.push(sendToMGID(data));\n if (CONFIG.platforms.revcontent) platformPromises.push(sendToRevContent(data));\n if (CONFIG.platforms.x_ads) platformPromises.push(sendToXAds(data));\n \n await Promise.allSettled(platformPromises);\n\n return new Response(JSON.stringify({ \n success: true, \n event_id: data.event_id,\n platforms_notified: Object.entries(CONFIG.platforms).filter(([_, v]) => v).map(([k]) => k)\n }), { headers });\n \n } catch (error) {\n console.error('Handler error:', error);\n return new Response(JSON.stringify({ error: String(error) }), { headers, status: 500 });\n }\n}\n\n// =============================================================================\n// DATABASE STORAGE\n// =============================================================================\nasync function storeEvent(data: QuizEventPayload): Promise {\n await sqlite.execute(`\n INSERT INTO quiz_events (\n event_id, event_type, anonymous_id, session_id, user_email, quiz_type,\n payload, segments, utm_source, utm_medium, utm_campaign, utm_content,\n utm_term, fbclid, gclid, ttclid, user_agent\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n data.event_id,\n data.event_type,\n data.anonymous_id || null,\n data.session_id,\n data.user_email || null,\n data.quiz_type || null,\n JSON.stringify(data.event_data),\n JSON.stringify(data.segments || {}),\n data.attribution?.utm_source || null,\n data.attribution?.utm_medium || null,\n data.attribution?.utm_campaign || null,\n data.attribution?.utm_content || null,\n data.attribution?.utm_term || null,\n data.attribution?.fbclid || null,\n data.attribution?.gclid || null,\n data.attribution?.ttclid || null,\n data.device?.user_agent || null,\n ]);\n \n // Special handling for certain event types\n if (data.event_type === 'quiz_completed' && data.user_email) {\n await createRetestEligibility(data);\n }\n \n if (data.event_type === 'profile_updated' && data.user_email) {\n await updateUserProfile(data);\n }\n}\n\nasync function createRetestEligibility(data: QuizEventPayload): Promise {\n const now = new Date();\n const day30 = new Date(now.getTime() + 30 * 24 * 60 * 60 * 1000);\n const day60 = new Date(now.getTime() + 60 * 24 * 60 * 60 * 1000);\n \n await sqlite.execute(`\n INSERT OR REPLACE INTO retest_tracking (\n user_email, quiz_type, original_attempt_id, original_score, \n original_percentile, original_archetype, original_completed_at,\n retest_30day_eligible_at, retest_60day_eligible_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n data.user_email,\n data.quiz_type,\n data.event_id,\n data.event_data?.score,\n data.event_data?.percentile,\n data.event_data?.identity_type || data.event_data?.archetype,\n now.toISOString(),\n day30.toISOString(),\n day60.toISOString(),\n ]);\n}\n\nasync function updateUserProfile(data: QuizEventPayload): Promise {\n const profile = data.event_data;\n const now = new Date().toISOString();\n \n await sqlite.execute(`\n INSERT INTO user_profiles (\n user_email, occupation, industry, education_level, birth_year,\n company_size, years_experience, country, research_consent,\n research_consent_date, profile_completed_at, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(user_email) DO UPDATE SET\n occupation = COALESCE(excluded.occupation, occupation),\n industry = COALESCE(excluded.industry, industry),\n education_level = COALESCE(excluded.education_level, education_level),\n birth_year = COALESCE(excluded.birth_year, birth_year),\n company_size = COALESCE(excluded.company_size, company_size),\n years_experience = COALESCE(excluded.years_experience, years_experience),\n country = COALESCE(excluded.country, country),\n research_consent = COALESCE(excluded.research_consent, research_consent),\n research_consent_date = COALESCE(excluded.research_consent_date, research_consent_date),\n profile_completed_at = CASE WHEN excluded.profile_completed_at IS NOT NULL THEN excluded.profile_completed_at ELSE profile_completed_at END,\n updated_at = ?\n `, [\n data.user_email,\n profile.occupation || null,\n profile.industry || null,\n profile.education_level || null,\n profile.birth_year || null,\n profile.company_size || null,\n profile.years_experience || null,\n profile.country || null,\n profile.research_consent ? 1 : 0,\n profile.research_consent ? now : null,\n profile.profile_complete ? now : null,\n now,\n now,\n ]);\n}\n\n// =============================================================================\n// META CONVERSIONS API\n// =============================================================================\nasync function sendToMeta(data: QuizEventPayload): Promise {\n const pixelId = Deno.env.get('META_PIXEL_ID');\n const accessToken = Deno.env.get('META_ACCESS_TOKEN');\n \n if (!pixelId || !accessToken) {\n if (CONFIG.logging.verbose) console.log('Meta: Missing credentials');\n return;\n }\n\n const eventMap: Record = {\n 'quiz_started': 'ViewContent',\n 'quiz_completed': 'Lead',\n 'email_captured': 'CompleteRegistration',\n 'conversion': 'Purchase',\n 'retest_completed': 'Lead',\n 'survey_completed': 'SubmitApplication',\n };\n\n const eventName = eventMap[data.event_type] || 'ViewContent';\n\n const payload = {\n data: [{\n event_name: eventName,\n event_time: Math.floor(Date.now() / 1000),\n event_id: data.event_id,\n event_source_url: data.attribution?.landing_page,\n action_source: 'website',\n user_data: {\n em: data.user_email ? await hashSHA256(data.user_email.toLowerCase().trim()) : undefined,\n client_user_agent: data.device?.user_agent,\n fbc: data.attribution?.fbclid ? `fb.1.${Date.now()}.${data.attribution.fbclid}` : undefined,\n },\n custom_data: {\n quiz_type: data.quiz_type,\n score: data.event_data?.score,\n percentile: data.event_data?.percentile,\n band: data.event_data?.band,\n archetype: data.event_data?.identity_type,\n content_name: data.quiz_type ? `${data.quiz_type}_quiz` : undefined,\n value: data.event_data?.amount,\n currency: data.event_data?.currency || 'USD',\n },\n }],\n access_token: accessToken,\n };\n\n try {\n const res = await fetch(`https://graph.facebook.com/v19.0/${pixelId}/events`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(payload),\n });\n if (CONFIG.logging.verbose) console.log('Meta:', res.status);\n } catch (e) {\n console.error('Meta error:', e);\n }\n}\n\n// =============================================================================\n// KLAVIYO\n// =============================================================================\nasync function sendToKlaviyo(data: QuizEventPayload): Promise {\n const apiKey = Deno.env.get('KLAVIYO_PRIVATE_KEY');\n if (!apiKey || !data.user_email) return;\n\n const eventName = `IQ Unlocked ${data.event_type.split('_').map(w => w.charAt(0).toUpperCase() + w.slice(1)).join(' ')}`;\n\n // Track event\n try {\n await fetch('https://a.klaviyo.com/api/events/', {\n method: 'POST',\n headers: {\n 'Authorization': `Klaviyo-API-Key ${apiKey}`,\n 'Content-Type': 'application/json',\n 'revision': '2024-02-15',\n },\n body: JSON.stringify({\n data: {\n type: 'event',\n attributes: {\n profile: { $email: data.user_email },\n metric: { name: eventName },\n properties: {\n quiz_type: data.quiz_type,\n score: data.event_data?.score,\n percentile: data.event_data?.percentile,\n band: data.event_data?.band,\n archetype: data.event_data?.identity_type,\n ...data.event_data?.subscores,\n ...data.segments,\n },\n time: data.timestamp,\n },\n },\n }),\n });\n\n // Update profile on quiz completion\n if (data.event_type === 'quiz_completed') {\n await fetch('https://a.klaviyo.com/api/profiles/', {\n method: 'POST',\n headers: {\n 'Authorization': `Klaviyo-API-Key ${apiKey}`,\n 'Content-Type': 'application/json',\n 'revision': '2024-02-15',\n },\n body: JSON.stringify({\n data: {\n type: 'profile',\n attributes: {\n email: data.user_email,\n properties: {\n [`${data.quiz_type}_score`]: data.event_data?.score,\n [`${data.quiz_type}_percentile`]: data.event_data?.percentile,\n [`${data.quiz_type}_band`]: data.event_data?.band,\n [`${data.quiz_type}_archetype`]: data.event_data?.identity_type,\n last_quiz_type: data.quiz_type,\n last_quiz_date: data.timestamp,\n last_quiz_score: data.event_data?.score,\n },\n },\n },\n }),\n });\n }\n \n if (CONFIG.logging.verbose) console.log('Klaviyo: sent');\n } catch (e) {\n console.error('Klaviyo error:', e);\n }\n}\n\n// =============================================================================\n// GOOGLE ANALYTICS 4 (Measurement Protocol)\n// =============================================================================\nasync function sendToGA4(data: QuizEventPayload): Promise {\n const measurementId = Deno.env.get('GA4_MEASUREMENT_ID');\n const apiSecret = Deno.env.get('GA4_API_SECRET');\n \n if (!measurementId || !apiSecret) return;\n\n const eventMap: Record = {\n 'quiz_started': 'begin_quiz',\n 'quiz_completed': 'generate_lead',\n 'conversion': 'purchase',\n 'email_captured': 'sign_up',\n 'retest_completed': 'retest_complete',\n };\n\n const eventName = eventMap[data.event_type] || data.event_type;\n\n try {\n await fetch(`https://www.google-analytics.com/mp/collect?measurement_id=${measurementId}&api_secret=${apiSecret}`, {\n method: 'POST',\n body: JSON.stringify({\n client_id: data.anonymous_id || data.session_id,\n events: [{\n name: eventName,\n params: {\n quiz_type: data.quiz_type,\n score: data.event_data?.score,\n percentile: data.event_data?.percentile,\n band: data.event_data?.band,\n archetype: data.event_data?.identity_type,\n session_id: data.session_id,\n engagement_time_msec: data.event_data?.total_time_seconds ? data.event_data.total_time_seconds * 1000 : 100,\n },\n }],\n }),\n });\n if (CONFIG.logging.verbose) console.log('GA4: sent');\n } catch (e) {\n console.error('GA4 error:', e);\n }\n}\n\n// =============================================================================\n// TIKTOK EVENTS API\n// =============================================================================\nasync function sendToTikTok(data: QuizEventPayload): Promise {\n const pixelId = Deno.env.get('TIKTOK_PIXEL_ID');\n const accessToken = Deno.env.get('TIKTOK_ACCESS_TOKEN');\n \n if (!pixelId || !accessToken) return;\n\n const eventMap: Record = {\n 'quiz_started': 'ViewContent',\n 'quiz_completed': 'SubmitForm',\n 'conversion': 'CompletePayment',\n 'email_captured': 'CompleteRegistration',\n };\n\n const eventName = eventMap[data.event_type] || 'ViewContent';\n\n try {\n await fetch('https://business-api.tiktok.com/open_api/v1.3/event/track/', {\n method: 'POST',\n headers: {\n 'Access-Token': accessToken,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n pixel_code: pixelId,\n event: eventName,\n event_id: data.event_id,\n timestamp: new Date(data.timestamp).toISOString(),\n context: {\n user_agent: data.device?.user_agent,\n page: { url: data.attribution?.landing_page },\n },\n properties: {\n content_type: 'product',\n content_id: data.quiz_type,\n value: data.event_data?.amount,\n currency: data.event_data?.currency || 'USD',\n },\n }),\n });\n if (CONFIG.logging.verbose) console.log('TikTok: sent');\n } catch (e) {\n console.error('TikTok error:', e);\n }\n}\n\n// =============================================================================\n// TABOOLA (Server-Side)\n// =============================================================================\nasync function sendToTaboola(data: QuizEventPayload): Promise {\n const accountId = Deno.env.get('TABOOLA_ACCOUNT_ID');\n if (!accountId) return;\n\n const eventMap: Record = {\n 'quiz_completed': 'lead',\n 'conversion': 'purchase',\n 'email_captured': 'signup',\n };\n\n const eventName = eventMap[data.event_type];\n if (!eventName) return;\n\n try {\n await fetch(`https://trc.taboola.com/actions-handler/log/3/s2s-action`, {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n name: accountId,\n action: eventName,\n id: data.event_id,\n revenue: data.event_data?.amount || 0,\n currency: data.event_data?.currency || 'USD',\n click_id: data.attribution?.utm_content, // Taboola click ID often in utm_content\n }),\n });\n if (CONFIG.logging.verbose) console.log('Taboola: sent');\n } catch (e) {\n console.error('Taboola error:', e);\n }\n}\n\n// =============================================================================\n// OUTBRAIN (Server-Side)\n// =============================================================================\nasync function sendToOutbrain(data: QuizEventPayload): Promise {\n const accountId = Deno.env.get('OUTBRAIN_ACCOUNT_ID');\n if (!accountId) return;\n\n const eventMap: Record = {\n 'quiz_completed': 'lead',\n 'conversion': 'purchase',\n };\n\n const eventName = eventMap[data.event_type];\n if (!eventName) return;\n\n try {\n // Outbrain uses postback URLs - contact your rep for exact format\n await fetch(`https://tr.outbrain.com/pixel/s2s?ob_click_id=${data.attribution?.utm_content}&action=${eventName}&revenue=${data.event_data?.amount || 0}¤cy=${data.event_data?.currency || 'USD'}`);\n if (CONFIG.logging.verbose) console.log('Outbrain: sent');\n } catch (e) {\n console.error('Outbrain error:', e);\n }\n}\n\n// =============================================================================\n// MGID (Server-Side)\n// =============================================================================\nasync function sendToMGID(data: QuizEventPayload): Promise {\n const accountId = Deno.env.get('MGID_ACCOUNT_ID');\n if (!accountId) return;\n\n if (data.event_type !== 'conversion' && data.event_type !== 'quiz_completed') return;\n\n try {\n // MGID postback format - verify with your rep\n await fetch(`https://a.mgid.com/postback?c=${data.attribution?.utm_content}&sum=${data.event_data?.amount || 0}¤cy=${data.event_data?.currency || 'USD'}`);\n if (CONFIG.logging.verbose) console.log('MGID: sent');\n } catch (e) {\n console.error('MGID error:', e);\n }\n}\n\n// =============================================================================\n// REVCONTENT (Server-Side)\n// =============================================================================\nasync function sendToRevContent(data: QuizEventPayload): Promise {\n const widgetId = Deno.env.get('REVCONTENT_WIDGET_ID');\n if (!widgetId) return;\n\n if (data.event_type !== 'conversion' && data.event_type !== 'quiz_completed') return;\n\n try {\n // RevContent postback - verify with rep\n await fetch(`https://trends.revcontent.com/api/v1/conversion.php?widget_id=${widgetId}&click_id=${data.attribution?.utm_content}&revenue=${data.event_data?.amount || 0}`);\n if (CONFIG.logging.verbose) console.log('RevContent: sent');\n } catch (e) {\n console.error('RevContent error:', e);\n }\n}\n\n// =============================================================================\n// X (TWITTER) CONVERSION API\n// =============================================================================\nasync function sendToXAds(data: QuizEventPayload): Promise {\n const pixelId = Deno.env.get('X_PIXEL_ID');\n const accessToken = Deno.env.get('X_ACCESS_TOKEN');\n \n if (!pixelId || !accessToken) return;\n\n const eventMap: Record = {\n 'quiz_completed': 'tw-xxxxx-xxxxx', // Your conversion ID\n 'conversion': 'tw-xxxxx-xxxxx',\n };\n\n const conversionId = eventMap[data.event_type];\n if (!conversionId) return;\n\n try {\n await fetch('https://ads-api.twitter.com/12/measurement/conversions', {\n method: 'POST',\n headers: {\n 'Authorization': `Bearer ${accessToken}`,\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify({\n conversions: [{\n conversion_time: data.timestamp,\n event_id: data.event_id,\n identifiers: [{\n hashed_email: data.user_email ? await hashSHA256(data.user_email.toLowerCase().trim()) : undefined,\n }],\n conversion_id: conversionId,\n value: {\n amount: String(data.event_data?.amount || 0),\n currency: data.event_data?.currency || 'USD',\n },\n }],\n }),\n });\n if (CONFIG.logging.verbose) console.log('X Ads: sent');\n } catch (e) {\n console.error('X Ads error:', e);\n }\n}\n\n// =============================================================================\n// HELPERS\n// =============================================================================\nasync function hashSHA256(value: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(value);\n const hashBuffer = await crypto.subtle.digest('SHA-256', data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}",[206],"pulls","branches","forks","envVars",{"_219":60,"_221":60},"connections",{"_219":60,"_220":60},"count","unfilledCount","emptyCount",{"_43":205,"_32":206,"_30":207,"_142":-5,"_41":42,"_40":208,"_144":123,"_38":264,"_13":196,"_33":34,"_35":210,"_24":25,"_147":-5,"_234":265,"_27":266},{"_43":198,"_32":199,"_30":200,"_142":-5,"_41":42,"_40":201,"_144":123,"_38":261,"_13":160,"_33":146,"_35":203,"_24":25,"_147":-5,"_234":262,"_27":263},{"_43":194,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_144":123,"_38":258,"_13":196,"_33":34,"_35":37,"_24":25,"_147":-5,"_234":259,"_27":260},{"_43":188,"_32":189,"_30":190,"_142":-5,"_41":42,"_40":191,"_144":25,"_38":255,"_13":167,"_33":34,"_35":36,"_24":25,"_147":-5,"_234":256,"_27":257},{"_43":182,"_32":183,"_30":184,"_142":-5,"_41":42,"_40":185,"_144":123,"_38":252,"_13":160,"_33":34,"_35":106,"_24":25,"_147":-5,"_234":253,"_27":254},{"_43":176,"_32":177,"_30":178,"_142":-5,"_41":42,"_40":179,"_144":123,"_38":249,"_13":160,"_33":34,"_35":106,"_24":25,"_147":-5,"_234":250,"_27":251},{"_43":169,"_32":170,"_30":171,"_142":-5,"_41":42,"_40":172,"_144":123,"_38":246,"_13":174,"_33":34,"_35":106,"_24":25,"_147":-5,"_234":247,"_27":248},{"_43":162,"_32":163,"_30":164,"_142":-5,"_41":42,"_40":165,"_144":123,"_38":243,"_13":167,"_33":34,"_35":36,"_24":25,"_147":-5,"_234":244,"_27":245},{"_43":155,"_32":156,"_30":157,"_142":-5,"_41":42,"_40":158,"_144":123,"_38":240,"_13":160,"_33":34,"_35":106,"_24":25,"_147":-5,"_234":241,"_27":242},{"_43":149,"_32":150,"_30":151,"_142":-5,"_41":42,"_40":152,"_144":123,"_38":237,"_13":60,"_33":146,"_35":106,"_24":25,"_147":-5,"_234":238,"_27":239},{"_43":139,"_32":140,"_30":141,"_142":-5,"_41":42,"_40":143,"_144":25,"_38":233,"_13":60,"_33":146,"_35":106,"_24":25,"_147":-5,"_234":235,"_27":236},["D",1769993253997],"children",[],[140],["D",1769992516589],[],[150],["D",1769993569683],[],[156],["D",1769993117530],[],[163],["D",1769993534040],[],[170],["D",1769993650121],[],[177],["D",1769993619606],[],[183],["D",1769993231531],[],[189],["D",1770426598498],[],[28],["D",1770426589681],[],[199],["D",1770426535994],[],[206],["D",1769992516575],["D",1789518676100],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":54,"_101":102,"_103":25},{"_13":86,"_32":87,"_43":42,"_88":44,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":45,"_95":96},"ctx",{"_79":-5,"_125":305,"_306":307,"_308":309,"_310":25,"_311":25,"_312":25,"_313":123,"_314":-5,"_315":-7,"_316":-7,"_317":60,"_318":25,"_319":25,"_320":-5,"_321":25,"_322":25,"_323":25,"_324":-5},"ENV",{"_276":277,"_278":279,"_280":87,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294,"_295":296,"_297":298,"_299":300,"_301":302,"_303":304},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v39