STATSSTATS 

When I joined the web studio, everything was chaotic. Tasks, projects, deadlines, keyword data, reports, and payments were scattered across Excel files and separate services. There was no unified control system, no transparent analytics, and no clear link between the work completed and changes in a site's search rankings.

I decided to bring order to these processes and started building STATS.

STATS is an example of a product that grew out of a real internal pain point. The web studio needed to manage projects, tasks, SEO data, payments, reports, and access rights. Instead of a patchwork of Excel spreadsheets and disconnected services, I built a single platform that became the agency's operational backbone.

What was built:

• employee registration, roles and access rights, user groups
• client project cards
• invoices, completion acts, payment history
• website and page structure management
• keyword core uploads
• automated daily rank tracking by region and search engine
• competitor analysis
• keyword cleaning and enrichment tools
• Excel import and export
• report generation
• task management and work completion tracking
• linkage between completed work and ranking changes
• online chat
• secure client-site login without sharing passwords
• user action audit log

One particularly important feature: the unified client-site access system. A special module was installed on client websites that communicated with STATS. A team member could open a project card and log into the client's site without ever receiving the password. This improved security and enabled full control over user actions.

Stack: PHP, Yii2, MySQL, JavaScript, HTML/CSS, Linux.

A Yii2 monolith with modules for projects, finance, SEO analytics (daily rank parsers), tasks, and chat. A client-site agent module that communicates with the platform over a secured protocol.

• the agency eliminated its chaotic Excel spreadsheets
• processes became more transparent
• task and deadline control improved
• unified SEO project analytics became available
• security when working with client sites increased
• the system became the operational backbone of the web studio

Internal business pain is the best source of product ideas — a solution that grows from real-world processes gets adopted on its own, without being imposed from above.