RB2B Lead Scorer

\n {leads.length} leads · {totalIdeal} ideal customers\n

\n\n {leads.length === 0\n ? (\n

\n No leads yet. Trigger the webhook to see results here.\n

\n )\n : (\n

\n {ideal.map((lead) => )}\n\n {nonIdeal.length > 0 && (\n

\n \n \n {nonIdeal.length} non-ideal{\" \"}\n {nonIdeal.length === 1 ? \"lead\" : \"leads\"}\n \n ▼\n \n

\n {nonIdeal.map((lead) => (\n \n ))}\n

\n )}\n\n {ideal.length === 0 && nonIdeal.length === 0 && (\n

\n No leads yet\n

\n )}\n

\n ,\n );\n});\n\n// View specific run details - uses blob\napp.get(\"/run/:runId\", async (c) => {\n const runId = c.req.param(\"runId\");\n\n const runData = await blob.getJSON(`rb2b-lead-scores/${runId}`);\n\n if (!runData) {\n return c.html(\n \n

Run Not Found

\n The requested run could not be found.\n

\n \n ← Back to dashboard\n \n

\n ,\n 404,\n );\n }\n\n // Get SQLite row if exists\n let sqlRow: Record | null = null;\n try {\n const sqlResult = await sqlite.execute(\n \"SELECT * FROM rb2b_leads_v2 WHERE run_id = ?\",\n [runId],\n );\n if (sqlResult.rows.length > 0) {\n const columns = sqlResult.columns;\n const row = sqlResult.rows[0];\n sqlRow = {};\n columns.forEach((col, idx) => {\n sqlRow![col] = row[idx];\n });\n }\n } catch (e) {\n // Table might not exist\n }\n\n const output = runData.finalOutput ? JSON.parse(runData.finalOutput) : null;\n const input = runData.input || {};\n\n return c.html(\n \n

\n \n ← Back to dashboard\n \n\n

\n {input[\"First Name\"] || sqlRow?.first_name || \"Unknown\"}{\" \"}\n {input[\"Last Name\"] || sqlRow?.last_name || \"\"}\n

\n {input[\"Title\"] || sqlRow?.title || \"Unknown\"} @{\" \"}\n {input[\"Company Name\"] || sqlRow?.company_name || \"Unknown\"}\n

\n {new Date(parseInt(runId)).toLocaleString()}\n

\n\n {/* Result Summary */}\n \n

\n \n \n {output?.idealCustomer ? \"Ideal Customer\" : \"Not Ideal Customer\"}\n \n

\n {output?.reasoning || \"No reasoning provided\"}\n

\n\n {/* Input Data */}\n

\n Input Data\n

\n \n \n {Object.entries(input).map(([key, value], idx) => (\n \n \n \n \n ))}\n \n

{key}

{String(value || \"\")}

\n\n {/* SQL Row if exists */}\n {sqlRow && (\n

\n SQLite Row\n

\n \n \n {Object.entries(sqlRow).map(([key, value], idx) => (\n \n \n \n \n ))}\n \n

{key}

\n {String(value ?? \"\")}\n

\n )}\n\n {/* Full Blob Data */}\n

\n Full Blob Data (debug)\n

\n            {JSON.stringify(runData, null, 2)}\n

\n \n ,\n );\n});\n\nexport default app.fetch;","deleted","label",[99],"permalink","https://www.val.town/x/templates/rb2b/code/dashboard.tsx","extension","actionData","errors"]