Error loading data. Please try again later.

';\n }\n}\n\n// Render daily tweet chart\nfunction renderDailyChart(dailyData) {\n if (!dailyData || dailyData.length === 0) {\n document.getElementById('dailyChart').parentNode.innerHTML = '

No data available yet.

';\n return;\n }\n \n // Process data for chart\n const days = [...new Set(dailyData.map(item => item.day))].sort();\n const competitors = [...new Set(dailyData.map(item => item.competitor))];\n const colors = generateColors(competitors.length);\n \n // Create datasets\n const datasets = competitors.map((competitor, index) => {\n const competitorData = days.map(day => {\n const match = dailyData.find(item => item.day === day && item.competitor === competitor);\n return match ? match.count : 0;\n });\n \n return {\n label: competitor,\n data: competitorData,\n backgroundColor: colors[index],\n borderColor: colors[index],\n borderWidth: 2,\n tension: 0.1,\n fill: false\n };\n });\n \n // Create chart\n new Chart(document.getElementById('dailyChart'), {\n type: 'line',\n data: {\n labels: days,\n datasets: datasets\n },\n options: {\n responsive: true,\n maintainAspectRatio: false,\n scales: {\n y: {\n beginAtZero: true,\n title: {\n display: true,\n text: 'Tweet Count'\n }\n },\n x: {\n title: {\n display: true,\n text: 'Date'\n }\n }\n },\n plugins: {\n legend: {\n position: 'top',\n },\n tooltip: {\n mode: 'index',\n intersect: false\n }\n }\n }\n });\n}\n\n// Render total tweet chart\nfunction renderTotalChart(totalData) {\n if (!totalData || totalData.length === 0) {\n document.getElementById('totalChart').parentNode.innerHTML = '

No data available yet.

';\n return;\n }\n \n // Sort by count descending\n totalData.sort((a, b) => b.count - a.count);\n \n const competitors = totalData.map(item => item.competitor);\n const counts = totalData.map(item => item.count);\n const colors = generateColors(competitors.length);\n \n // Create chart\n new Chart(document.getElementById('totalChart'), {\n type: 'bar',\n data: {\n labels: competitors,\n datasets: [{\n label: 'Total Tweets',\n data: counts,\n backgroundColor: colors,\n borderColor: colors,\n borderWidth: 1\n }]\n },\n options: {\n responsive: true,\n maintainAspectRatio: false,\n scales: {\n y: {\n beginAtZero: true,\n title: {\n display: true,\n text: 'Tweet Count'\n }\n },\n x: {\n title: {\n display: true,\n text: 'Competitor'\n }\n }\n },\n plugins: {\n legend: {\n display: false\n }\n }\n }\n });\n}\n\n// Initialize charts when page loads\ndocument.addEventListener('DOMContentLoaded', renderCharts);",[],[184,200],{"_102":208,"_95":209,"_156":210,"_158":185,"_159":138,"_160":186,"_162":163,"_104":211,"_99":32,"_165":194,"_167":212,"_168":22,"_169":-5,"_170":213,"_98":214},"81be52d6-4087-11f0-a981-76b3cceeab13","index.html","81be53c6-4087-11f0-a981-76b3cceeab13",["D",1748961118991],"\n\n\n \n \n Competitor Tweet Tracker\n \n \n \n\n\n

Competitor Tweet Tracker

\n \n

Daily Tweet Mentions

\n \n

Total Tweet Mentions

\n\n \n\n",[],[184,209],[184],{"_102":217,"_95":191,"_156":218,"_158":-5,"_159":138,"_160":219,"_162":163,"_104":220,"_99":221,"_165":194,"_167":222,"_168":22,"_169":-5,"_170":223,"_98":224},"c85bd01a-4087-11f0-98e8-76b3cceeab13","623a97b9-7fbb-4e77-b25c-572e68c9eb26",25,["D",1748961237459],6,"# Competitor Tweet Tracker\n\nThis Val Town project tracks tweets mentioning competitor URLs and visualizes the data in charts.\n\n## Project Structure\n\n```\n├── main.tsx (cron) # Hourly cron job to collect tweet data\n├── api.ts (http) # HTTP API and static file server\n├── db.ts # Database operations and schema\n├── utils/\n│ └── competitors.ts # Competitor configuration utilities\n└── views/\n ├── index.html # Main HTML template\n └── charts.js # Chart rendering JavaScript\n```\n\n## Environment Variables\n\n### Required\n\n- **`TWITTER_BEARER_TOKEN`**: Your Twitter API bearer token for searching tweets\n\n### Optional\n\n- **`COMPETITORS`**: Comma-separated list of competitor hostnames to track (default: `val.town`)\n \n Examples:\n - `val.town` (default)\n - `val.town,poe.com,shapes.inc`\n - `poe.com,character.ai,pi.ai,coze.com,gumloop.com,n8n.io`\n\n## Popular Competitor Suggestions\n\nHere are some popular competitors you might want to track:\n```\nval.town,poe.com,character.ai,pi.ai,coze.com,gumloop.com,n8n.io,shapes.inc,manus.im,genspark.ai\n```\n\n## Components\n\n1. **Cron Job** (`main.tsx`): Runs hourly to search Twitter for mentions of competitor URLs and stores the results in a database.\n2. **Database** (`db.ts`): Uses SQLite to store tweet data and provides functions to query the data.\n3. **Web Interface** (`api.ts`): Serves the HTML page and provides API endpoints for chart data.\n4. **Views** (`views/`): Contains the HTML template and JavaScript for rendering charts.\n\n## How to Use\n\n1. Set up the `TWITTER_BEARER_TOKEN` environment variable with your Twitter API bearer token.\n2. Optionally set the `COMPETITORS` environment variable with your list of competitors to track.\n3. The cron job will automatically run every hour to collect data.\n4. Visit the HTTP endpoint to view the charts showing tweet counts.\n\n## Features\n\n- Tracks tweets mentioning competitor URLs\n- Configurable competitor list via environment variables\n- Avoids double-counting tweets by storing unique tweet IDs\n- Visualizes data in daily trend charts and total count charts\n- Automatically updates as new data is collected\n- Separated HTML/CSS/JS from API logic for better maintainability",[],[191],{"_102":226,"_95":227,"_156":228,"_158":-5,"_159":138,"_160":229,"_162":163,"_104":230,"_99":231,"_165":232,"_167":233,"_168":22,"_169":-5,"_170":234,"_98":235},"acb8e50a-4087-11f0-90dc-76b3cceeab13","api.ts","cd4e9818-34ee-11f0-95e5-9e149126039e",22,["D",1748961191095],4,"http","import { getTotalTweetCounts, getTweetCountsByDay, initDb } from \"./db.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\n\nexport default async function(req: Request) {\n // Initialize the database\n await initDb();\n\n const url = new URL(req.url);\n\n // API endpoint to get tweet data as JSON\n if (url.pathname === \"/api/data\") {\n const dailyCounts = await getTweetCountsByDay();\n const totalCounts = await getTotalTweetCounts();\n\n return new Response(\n JSON.stringify({ dailyCounts, totalCounts }),\n {\n headers: {\n \"Content-Type\": \"application/json\",\n \"Cache-Control\": \"no-cache\",\n },\n },\n );\n }\n\n // Serve static files from views directory\n if (url.pathname.startsWith(\"/views/\")) {\n try {\n const filePath = url.pathname;\n const fileContent = await readFile(filePath, import.meta.url);\n \n // Determine content type based on file extension\n const contentType = filePath.endsWith(\".js\") ? \"application/javascript\" : \n filePath.endsWith(\".css\") ? \"text/css\" : \n \"text/plain\";\n \n return new Response(fileContent, {\n headers: {\n \"Content-Type\": contentType,\n \"Cache-Control\": \"public, max-age=3600\", // Cache static files for 1 hour\n },\n });\n } catch (error) {\n return new Response(\"File not found\", { status: 404 });\n }\n }\n\n // Serve the main HTML page\n return serveHtmlPage();\n}\n\nasync function serveHtmlPage() {\n try {\n const html = await readFile(\"/views/index.html\", import.meta.url);\n \n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html\",\n \"Cache-Control\": \"no-cache\",\n },\n });\n } catch (error) {\n console.error(\"Error serving HTML page:\", error);\n return new Response(\"Error loading page\", { status: 500 });\n }\n}",[],[227],{"_102":237,"_95":238,"_156":239,"_158":-5,"_159":138,"_160":240,"_162":163,"_104":241,"_99":32,"_165":177,"_167":242,"_168":22,"_169":-5,"_170":243,"_98":244},"b1596ce6-34ee-11f0-ab9e-9e149126039e","db.ts","b1596dae-34ee-11f0-ab9e-9e149126039e",3,["D",1747686023074],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table to store tweets mentioning competitors\nconst TWEETS_TABLE = 'competitor_tweets';\n\n// Initialize the database\nexport async function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TWEETS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n tweet_id TEXT UNIQUE NOT NULL,\n competitor TEXT NOT NULL,\n author_username TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n}\n\n// Store a tweet in the database\nexport async function storeTweet(tweet: {\n id: string;\n competitor: string;\n author_username: string;\n created_at: string;\n}) {\n try {\n await sqlite.execute(\n `INSERT INTO ${TWEETS_TABLE} (tweet_id, competitor, author_username, created_at)\n VALUES (?, ?, ?, ?)`,\n [tweet.id, tweet.competitor, tweet.author_username, tweet.created_at]\n );\n return true;\n } catch (error) {\n // If the tweet already exists (due to UNIQUE constraint), this will fail silently\n if (error.message.includes('UNIQUE constraint failed')) {\n return false;\n }\n throw error;\n }\n}\n\n// Get tweet counts per competitor per day\nexport async function getTweetCountsByDay() {\n const result = await sqlite.execute(\n `SELECT \n competitor,\n date(created_at) as day,\n COUNT(DISTINCT tweet_id) as count\n FROM ${TWEETS_TABLE}\n GROUP BY competitor, day\n ORDER BY day DESC, count DESC`\n );\n \n return result;\n}\n\n// Get the total tweet count for each competitor\nexport async function getTotalTweetCounts() {\n const result = await sqlite.execute(\n `SELECT \n competitor,\n COUNT(DISTINCT tweet_id) as count\n FROM ${TWEETS_TABLE}\n GROUP BY competitor\n ORDER BY count DESC`\n );\n \n return result;\n}",[],[238],{"_102":246,"_95":247,"_156":248,"_158":-5,"_159":138,"_160":249,"_162":163,"_104":250,"_99":251,"_165":252,"_167":253,"_168":22,"_169":-5,"_170":254,"_98":255},"bd537f6a-4087-11f0-8fd7-76b3cceeab13","main.tsx","573aad4c-19b9-4099-aa1a-6ca58ff30ffe",24,["D",1748961218953],9,"interval","import { twitterSearch } from \"https://esm.town/v/stevekrouse/twitterSearch\";\nimport { initDb, storeTweet } from \"./db.ts\";\nimport { getCompetitors, validateCompetitors } from \"./utils/competitors.ts\";\n\n// This function runs every hour via cron\nexport default async function({ lastRunAt }: Interval) {\n console.log(`Starting competitor tweet tracking at ${new Date().toISOString()}`);\n\n // Validate environment variables\n validateCompetitors();\n\n // Initialize the database\n await initDb();\n\n // Get competitors from environment variable\n const competitors = getCompetitors();\n console.log(`Tracking ${competitors.length} competitors: ${competitors.join(\", \")}`);\n\n // Track tweets for each competitor\n for (const competitor of competitors) {\n await trackCompetitorTweets(competitor, lastRunAt);\n }\n\n console.log(`Completed competitor tweet tracking at ${new Date().toISOString()}`);\n}\n\nasync function trackCompetitorTweets(competitor: string, lastRunAt: Date | undefined) {\n try {\n console.log(`Tracking tweets for ${competitor}`);\n\n // Create a query for this competitor\n const query = `\"${competitor}\" -is:retweet`;\n\n // Search Twitter\n const bearerToken = Deno.env.get(\"TWITTER_BEARER_TOKEN\");\n if (!bearerToken) throw new Error(\"TWITTER_BEARER_TOKEN is required\");\n const results = await twitterSearch({\n query,\n start_time: lastRunAt,\n bearerToken,\n });\n\n if (!results.length) {\n console.debug(`No new tweets for ${competitor} since ${lastRunAt}`);\n return;\n }\n\n console.log(`Found ${results.length} tweets for ${competitor}`);\n\n // Store tweets in the database (filtering out retweets again just to be safe)\n let storedCount = 0;\n for (const tweet of results.filter(result => !result.is_retweet)) {\n const stored = await storeTweet({\n id: tweet.id,\n competitor: competitor,\n author_username: tweet.author_username,\n created_at: tweet!.created_at,\n });\n\n if (stored) storedCount++;\n }\n\n console.log(`Stored ${storedCount} new tweets for ${competitor}`);\n } catch (error) {\n console.error(`Error tracking tweets for ${competitor}:`, error);\n }\n}",[],[247],"files",[153,172,182,189,198,207,216,225,236,245],"counts",{"_260":32,"_261":118,"_262":32,"_263":264},"pulls","branches","forks","envVars",{"_265":118,"_266":32},"count","emptyCount","contents",[269,272,275,278,281,284],{"_102":154,"_95":155,"_156":157,"_158":-5,"_159":138,"_160":161,"_162":163,"_104":270,"_99":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_98":271},["D",1748961151227],[155],{"_102":183,"_95":184,"_156":185,"_158":-5,"_159":138,"_160":186,"_162":163,"_104":273,"_99":32,"_165":166,"_167":-5,"_168":22,"_169":-5,"_98":274},["D",1748961118991],[184],{"_102":217,"_95":191,"_156":218,"_158":-5,"_159":138,"_160":219,"_162":163,"_104":276,"_99":221,"_165":194,"_167":222,"_168":22,"_169":-5,"_98":277},["D",1748961237459],[191],{"_102":226,"_95":227,"_156":228,"_158":-5,"_159":138,"_160":229,"_162":163,"_104":279,"_99":231,"_165":232,"_167":233,"_168":22,"_169":-5,"_98":280},["D",1748961191095],[227],{"_102":237,"_95":238,"_156":239,"_158":-5,"_159":138,"_160":240,"_162":163,"_104":282,"_99":32,"_165":177,"_167":242,"_168":22,"_169":-5,"_98":283},["D",1747686023074],[238],{"_102":246,"_95":247,"_156":248,"_158":-5,"_159":138,"_160":249,"_162":163,"_104":285,"_99":251,"_165":252,"_167":253,"_168":22,"_169":-5,"_98":286},["D",1748961218953],[247],"upstreamProject",{"_102":146,"_95":289,"_110":-5,"_112":-5,"_108":109,"_23":290},"twitterAlert",{"_93":94,"_130":131},"upstreamBranch",{"_102":141,"_104":293,"_294":295,"_95":43,"_139":146,"_99":143,"_140":296,"_142":32,"_297":298,"_106":-5,"_150":22,"_108":109,"_149":94,"_16":119,"_148":289},["D",1746138615693],"updatedAt",["D",1720551623846],"e1e91fbe-1ae0-11f0-bddc-569c3dd06744","lockfileKey","1746138879370-esm.town_v_jamiedubs_twitterAlert@21-main","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.environment-variables",{"_93":94,"_95":96,"_100":305,"_263":310},{"_102":103,"_95":96,"_104":306,"_106":-5,"_107":22,"_108":109,"_110":111,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":118,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":307,"_132":308,"_135":309,"_150":22},["D",1747685840126],{"_93":94,"_130":131},{"_93":94,"_134":131,"_14":113},{"_99":137,"_95":43,"_102":138,"_139":103,"_140":141,"_142":143,"_144":109,"_145":146,"_147":119,"_148":96,"_149":94},[311],{"_312":313,"_104":314,"_294":315,"_110":72,"_316":22},"key","TWITTER_BEARER_TOKEN",["D",1747688096148],["D",1747697198993],"isEmpty","actionData","errors"]

jamiedubs

twitterCompetitorMonitoring

Environment variables