Public
Like
1
twitterCompetitorMonitoring
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.
Viewing readonly version of main branch: v15View latest version
This Val Town project tracks tweets mentioning competitor URLs and visualizes the data in charts.
-
Cron Job (
main.tsx): Runs hourly to search Twitter for mentions of competitor URLs and stores the results in a database. -
Database (
db.ts): Uses SQLite to store tweet data and provides functions to query the data. -
Web Interface (
api.ts): Serves an HTML page with charts showing tweet counts per competitor per day.
-
Set up the
TWITTER_BEARER_TOKENenvironment variable with your Twitter API bearer token. -
The cron job will automatically run every hour to collect data.
-
Visit the HTTP endpoint to view the charts showing tweet counts.
- Tracks tweets mentioning competitor URLs
- Avoids double-counting tweets by storing unique tweet IDs
- Visualizes data in daily trend charts and total count charts
- Automatically updates as new data is collected