Online Keyword Monitoring & Reporting Web Application (Please quote the original project cost only)

Project Overview
We require a freelancer to build a simple keyword monitoring web application using PHP + MySQL.
The system will track public online content (news/web sources) based on predefined keywords and present results in a client dashboard with basic reports.
The application will support multiple clients, each with restricted users and keyword limits, controlled by an admin.
This is an MVP project with a strict scope and limited budget.
User Roles
1. Admin (System Owner)
• Create / edit clients
• Set per-client limits:
o Number of users
o Number of keywords
• Enable / disable clients
• View basic system usage

2. Client Users (Max 3 per Client)
• Secure login
• Manage keywords (within assigned limit)
• View monitoring results
• Access reports
• Export data

Core Functional Features
Keyword Monitoring
• Keywords defined per client
• Scheduled background job (cron-based)
• Monitor public web / news sources only
• Store matched results with:
o Keyword
o Source
o Date/time
o URL
• Duplicate handling (basic)
Client Dashboard
• Total keywords monitored
• Total results found
• New results (last 24 hours / 7 days)
• Recent activity list
Client Reports (MVP Scope)
1. Keyword-wise Report
• Keyword name
• Total number of matches
• Latest occurrence date
• Filter by date range
2. Time-based Report
• Results grouped by:
o Day
o Week
• Date range filter (From – To)
3. Export
• Export filtered results to CSV
• Downloadable by client users
Technical Requirements
• Backend: PHP (no framework required)
• Database: MySQL / MariaDB
• Frontend: Basic HTML / CSS / JavaScript
• Hosting: Standard shared hosting
• Cron job for monitoring
• Simple authentication (no SSO)
Deliverables
• Fully working web application
• Source code
• Database schema
• Setup & deployment instructions
• Admin credentials
Out of Scope (Important – Not Included)
• Social media platform APIs (Facebook, Instagram, TikTok, X)
• Real-time streaming
• Sentiment analysis
• AI-based analysis
• Advanced analytics or charts
• PDF reports
• Mobile app
• Payment or subscription system
Any request outside this scope will be treated as additional work.

Timeline
• 1 to 2 weeks
Budget
• Fixed budget
• Please propose your best approach within a limited budget
Required Skills
• PHP & MySQL
• Cron jobs
• Data scraping or API consumption (public sources)
• Clean and simple coding practices
Nice to Have (Optional)
• Experience with public news APIs
• Experience building admin panels
Important Note
This project is intended as a Phase 1 MVP.
Future enhancements may be discussed after successful delivery.