[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_229":230,"_231":232},"routes/_app.x.$handle.$name",{"_104":103,"_32":49,"_112":91,"_27":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_21":-5,"_124":125,"_126":127,"_128":25,"_129":130,"_131":63,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_47":48,"_32":49,"_36":50,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",18,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","views","latestPath","fileId","bed97ec8-118f-4101-b178-7fd5ae6ec307","name","fileType","directory","content","createdAt",["D",1748961118991],"branchVersion","branchId","444f7c12-34ee-11f0-8f96-9e149126039e",{"_30":43,"_32":44,"_33":21,"_35":45,"_36":46,"_38":14,"_39":40,"_24":25},"views/index.html","81be53c6-4087-11f0-a981-76b3cceeab13","index.html","\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",["D",1748961118991],"id","444e22a4-34ee-11f0-8f96-9e149126039e","twitterCompetitorMonitoring",["D",1747685840126],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","it costs like $5k month for basic social listening tools lol","imageUrl","28a12253-d65d-490e-97f1-5c00c30f3c90","pinnedFileId","cd4e9818-34ee-11f0-95e5-9e149126039e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","de23cbae-f041-436a-b718-67f3be167b4d","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_111":107},"org",{"_104":103,"_105":-5,"_106":107,"_18":59,"_108":109,"_110":25},"branch",{"_13":90,"_32":91,"_47":40,"_92":48,"_93":94,"_95":96,"_97":54,"_98":99,"_100":69,"_101":49,"_102":103},"isOwned",26,"main","projectId","forkedBranchId","daad77e8-26db-11f0-a5b3-569c3dd06744","forkedBranchVersion",21,"forkedProjectPrivacy","forkedProjectId","daad27e8-26db-11f0-a5b3-569c3dd06744","forkedProjectOrgId","projectName","userHandle","jamiedubs","handle","displayName","avatar","https://avatars.githubusercontent.com/u/1903?v=4","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_32":49,"_36":225,"_51":-5,"_52":25,"_53":54,"_55":54,"_56":57,"_58":-5,"_18":59,"_60":61,"_62":63,"_64":63,"_65":-5,"_66":67,"_68":69,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":226,"_85":227,"_87":228,"_89":25},"tree",[199,201,202,203,204],"files",[199,200,201,202,203,204],"counts",{"_189":140,"_190":67,"_191":140,"_192":193,"_194":195},"contents",[145,146,147,148,149],"upstreamProject",{"_47":99,"_32":143,"_56":-5,"_58":-5,"_53":54,"_83":144},"upstreamBranch",{"_47":94,"_36":136,"_137":138,"_32":91,"_92":99,"_13":96,"_93":139,"_95":140,"_141":142,"_51":-5,"_89":25,"_53":54,"_102":103,"_68":69,"_101":143},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746138615693],"updatedAt",["D",1720551623846],"e1e91fbe-1ae0-11f0-bddc-569c3dd06744",0,"lockfileKey","1746138879370-esm.town_v_jamiedubs_twitterAlert@21-main","twitterAlert",{"_104":103,"_111":107},{"_47":186,"_32":28,"_30":31,"_153":-5,"_39":40,"_38":14,"_155":63,"_36":187,"_13":140,"_33":34,"_35":-5,"_24":25,"_160":-5,"_27":188},{"_47":178,"_32":179,"_30":180,"_153":-5,"_39":40,"_38":181,"_155":25,"_36":182,"_13":183,"_33":21,"_35":184,"_24":25,"_160":-5,"_27":185},{"_47":170,"_32":171,"_30":61,"_153":-5,"_39":40,"_38":172,"_155":25,"_36":173,"_13":174,"_33":175,"_35":176,"_24":25,"_160":-5,"_27":177},{"_47":162,"_32":163,"_30":164,"_153":-5,"_39":40,"_38":165,"_155":63,"_36":166,"_13":140,"_33":167,"_35":168,"_24":25,"_160":-5,"_27":169},{"_47":150,"_32":151,"_30":152,"_153":-5,"_39":40,"_38":154,"_155":25,"_36":156,"_13":157,"_33":158,"_35":159,"_24":25,"_160":-5,"_27":161},"8b61418c-3500-11f0-bb2c-9e149126039e","main.tsx","573aad4c-19b9-4099-aa1a-6ca58ff30ffe","parentId",14,"latest",["D",1747693690308],7,"interval","import { twitterSearch } from \"https://esm.town/v/stevekrouse/twitterSearch\";\nimport { initDb, storeTweet } from \"./db.ts\";\n\n// List of competitors to track\nconst COMPETITORS = [\n { name: \"poe\", url: \"poe.com\" },\n { name: \"shapes\", url: \"shapes.inc\" },\n { name: \"manus\", url: \"manus.im\" },\n { name: \"coze\", url: \"coze.com\" },\n { name: \"gumloop\", url: \"gumloop.com\" },\n { name: \"n8n\", url: \"n8n.io\" },\n { name: \"genspark\", url: \"genspark.ai\" },\n { name: \"pi\", url: \"pi.ai\" },\n { name: \"character\", url: \"character.ai\" },\n];\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 // Initialize the database\n await initDb();\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: { name: string; url: string }, lastRunAt: Date | undefined) {\n try {\n console.log(`Tracking tweets for ${competitor.name} (${competitor.url})`);\n\n // Create a query for this competitor\n const query = `\"${competitor.url}\" -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.name} since ${lastRunAt}`);\n return;\n }\n\n console.log(`Found ${results.length} tweets for ${competitor.name}`);\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.name,\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.name}`);\n } catch (error) {\n console.error(`Error tracking tweets for ${competitor.name}:`, error);\n }\n}","label",[151],"b1596ce6-34ee-11f0-ab9e-9e149126039e","db.ts","b1596dae-34ee-11f0-ab9e-9e149126039e",3,["D",1747686023074],"script","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}",[163],"675a9f4e-34f2-11f0-8276-9e149126039e","api.ts",9,["D",1747687616913],2,"http","import { getTotalTweetCounts, getTweetCountsByDay, initDb } from \"./db.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 the main HTML page\n return serveHtmlPage();\n}\n\nfunction serveHtmlPage() {\n const html = `\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`;\n\n return new Response(html, {\n headers: {\n \"Content-Type\": \"text/html\",\n \"Cache-Control\": \"no-cache\",\n },\n });\n}",[171],"2a4de7b4-4087-11f0-b1cc-76b3cceeab13","README.md","623a97b9-7fbb-4e77-b25c-572e68c9eb26",17,["D",1748960972291],5,"# Competitor Tweet Tracker\n\nThis Val Town project tracks tweets mentioning competitor URLs and visualizes the data in charts.\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 an HTML page with charts showing tweet counts per competitor per day.\n\n\n## How to Use\n\n1. Set up the `TWITTER_BEARER_TOKEN` environment variable with your Twitter API bearer token.\n2. The cron job will automatically run every hour to collect data.\n3. Visit the HTTP endpoint to view the charts showing tweet counts.\n\n## Features\n\n- Tracks tweets mentioning competitor URLs\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",[179],"81be5d76-4087-11f0-a981-76b3cceeab13",["D",1748961118991],[28],"pulls","branches","forks","envVars",{"_196":67,"_198":140},"connections",{"_196":140,"_197":140},"count","unfilledCount","emptyCount",{"_47":186,"_32":28,"_30":31,"_153":-5,"_39":40,"_38":14,"_155":63,"_36":222,"_13":140,"_33":34,"_35":-5,"_24":25,"_160":-5,"_206":223,"_27":224},{"_47":218,"_32":44,"_30":43,"_153":31,"_39":40,"_38":14,"_155":63,"_36":219,"_13":140,"_33":21,"_35":45,"_24":25,"_160":-5,"_206":220,"_27":221},{"_47":178,"_32":179,"_30":180,"_153":-5,"_39":40,"_38":181,"_155":25,"_36":215,"_13":183,"_33":21,"_35":184,"_24":25,"_160":-5,"_206":216,"_27":217},{"_47":170,"_32":171,"_30":61,"_153":-5,"_39":40,"_38":172,"_155":25,"_36":212,"_13":174,"_33":175,"_35":176,"_24":25,"_160":-5,"_206":213,"_27":214},{"_47":162,"_32":163,"_30":164,"_153":-5,"_39":40,"_38":165,"_155":63,"_36":209,"_13":140,"_33":167,"_35":168,"_24":25,"_160":-5,"_206":210,"_27":211},{"_47":150,"_32":151,"_30":152,"_153":-5,"_39":40,"_38":154,"_155":25,"_36":205,"_13":157,"_33":158,"_35":159,"_24":25,"_160":-5,"_206":207,"_27":208},["D",1747693690308],"children",[],[151],["D",1747686023074],[],[163],["D",1747687616913],[],[171],["D",1748960972291],[],[179],"81be52d6-4087-11f0-a981-76b3cceeab13",["D",1748961118991],[],[28,44],["D",1748961118991],[200],[28],["D",1747685840126],{"_104":103,"_111":107},{"_104":103,"_105":-5,"_106":107,"_18":59,"_108":109,"_110":25},{"_13":90,"_32":91,"_47":40,"_92":48,"_93":94,"_95":96,"_97":54,"_98":99,"_100":69,"_101":49,"_102":103},"ctx",{"_83":-5,"_133":262,"_263":264,"_265":266,"_267":25,"_268":25,"_269":25,"_270":63,"_271":-5,"_272":-7,"_273":-7,"_274":140,"_275":25,"_276":25,"_277":-5,"_278":25,"_279":25,"_280":25,"_281":-5},"ENV",{"_233":234,"_235":236,"_237":91,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","811aa22498c9b0b5a47e8d778de579cdb990f332","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 · v18