endorsedOngoing

YouTube Media Catalog & Reporting Platform

Services Covered:

Website Development

Industry

Business Consulting & Services

Duration

116 months

Budget

10K - 49K

Start Date

1 December 2016

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

76/100

Good

Project Capability Score (PCS) estimates how capable Sundew is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

Mumbai, India

Project Summary

Sun Dew Solutions developed a PHP-based media catalog management and reporting platform, producing a detailed SRS and implementing robust reporting to handle millions of YouTube report line items. The system organizes over 2.5 million line items across about 50 clients and manages more than 20,000 core assets. The client praised Sun Dew’s responsiveness, attentiveness, and ability to deliver changes quickly within estimated timeframes.

Key Challenges

Need for developers to understand YouTube mechanics and automation
Handling the sheer volume of data (millions of line items) and correctly segregating them
Ensuring automation shows each client only their own information across 50+ clients

Project Deliverables

Detailed SRS document (10–15 pages)
PHP-based website built from scratch
Development and design of the site
Reporting system to process and present YouTube CSV data for clients

Project Solution

Sun Dew conducted discovery calls with executives and developers, produced a detailed 10–15 page SRS (revised multiple times), and built a new PHP-based web application from scratch. The vendor provided both development and design work, implemented backend automation to segregate and present YouTube CSV data properly per client, and delivered a systematic reporting interface to handle millions of line items.

Project Outcome

Implemented a reporting system that organizes and presents over 2.5 million YouTube line items across ~50 clients
Delivered the solution with no major bugs and only cosmetic adjustments
Responded to change requests promptly, often completing fixes within the same workday
Clients report the product is easy to use and are satisfied with feature delivery timeframes

Platforms

Tech Stack

PHP
Angular

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The streamlined solution coherently organizes over 2.5 million line items for 50 major clients, thanks to Sun Dew Solutions skillful programming. The team’s attentiveness, adaptability, and precise cost and scheduling estimates contribute to a productive partnership.”
Anonymous
CEO
Date: 05/23/2017