Integrated Management & Analytics System for Creators

We are looking for an experienced development team or a senior full-stack developer to build a comprehensive digital ecosystem The system aims to centralize operations, integrate multi-platform performance analytics, structure the content production pipeline, and provide a professional financial management and CRM module.

Budget: Open and unconstrained (depends on the quality of the proposed solution and expertise).

Core System Components

The project primarily consists of two main systems, encompassing 6 integrated sub-modules:

System 1: Data & Analytics Dashboard

The core objective is to create a "Single Source of Truth" for all performance metrics, utilizing a Tag-Based Architecture for high-level data filtering.

Feature
Details
Granular Tagging System
- Sponsor Tags: Tracking sponsors (e.g., Namaq, Al-Aseel).
- Creator Tags: Individual tracking for each of the ~14 clan members, plus a tag for the main account.
- Platform Tags: Categorization by social media channel.
Platform Integration (API)
- X (Twitter): Full API integration for automated data fetching across 14 accounts.
- TikTok: Full API integration for automated synchronization of views, engagement, and reach across 13 accounts.
- Instagram: Full API integration for automated tracking of Reels and post-performance across 13 accounts.
- Snapchat: Manual/CMS Entry (high-touch management where an admin logs metrics, assigns creators/sponsors, and attaches screenshots for verification).
- YouTube: Semi-Automated (to be finalized whether API-based or manual).
Reporting & Exports
- Data must be exportable as professional, branded Excel and PDF reports.
- Custom date-range filtering (Start Date to End Date).
Synchronization
- The dashboard must synchronize and update automatically on a daily basis (every 24 hours).




System 2: Content Management & Workflow (Kanban/Trello Style)

A robust content governance model and custom project management tool to move ideas from conception to production.

Phase
Description
Phase 1: Submission (Ideation)
Creators submit an "idea ticket" with three mandatory requirements: Video Title, Proposed Thumbnail/Sketch, and a Brief Concept Description.
Phase 2: Evaluation & Democracy
The Project Manager (PM) selects specific users or teams (e.g., Marketing, Production) to vote on the idea. Requires a role-based permission and voting mechanism.
Phase 3: PM Approval & Parallel Tasks
Once the PM provides final approval, the workflow triggers two parallel tasks:
1. Scriptwriting: A content writer is assigned for a detailed breakdown of the video.
2. Production Prep: The setup team lists all necessary equipment, props, and decor.
Phase 4: Filming
The final stage of the production pipeline (acts as a status marker that content is in production).




Additional Integrated Modules

1.Finance Module:

•Generate professional Invoices and Quotations featuring the

•Both must be downloadable as PDFs.

•A mini invoicing system with template design, dynamic fields (client name, items, amounts, dates, tax), and PDF generation.



2.Sponsor CRM:

•
A database of current and prospective sponsors.

•Track interaction history with each sponsor (meetings, emails, deals).

•Track financial history (what was invoiced, what was paid, outstanding amounts).

•A lightweight CRM for contact management, activity logging, and financial summaries per sponsor.



3.Centralized Calendar:

•A visual tool to manage tasks, deadlines, and project ownership.

•Connects with the Kanban pipeline so that when a video is approved, filming dates appear on the calendar automatically.



4.Task Management:

•Clear assignment of roles (who is responsible for what) across the entire production lifecycle (e.g., scriptwriter, cameraman, setup).



Technical Requirements & Open Questions

•Arabic RTL Support: The system must fully support Arabic (Right-to-Left) for both the UI and data, as sponsor names and users are Arabic-speaking.

•Role-Based Access Control (RBAC): Sophisticated permission management for various roles (PM, creators, marketing team, production team, sponsors).

•Responsiveness: The system must be fully mobile-responsive.

Required Skills

•extensive experience in complex Full-Stack Web Development.

•Proven track record of integrating social media APIs (Twitter, TikTok, Instagram, YouTube) and handling OAuth for multiple accounts.

•Experience building custom project management tools (Kanban) and CRM systems.

•Ability to generate dynamic PDF reports and invoices.

•Strong UI/UX design skills with expertise in RTL (Arabic) interfaces.

Note:The budget is open and will be based on the value and expertise provided. Show More