Domain: tasks.date • DOOH Inventory & Invoicing
Master view of campaign screening slots across all screens for the selected month.
Master booking orders containing client campaigns and invoice reminders.
Configure master booking details, video campaigns, screens, and invoice milestones.
Cross-regional screen revenue monitoring, client portfolios, sales PIC achievement, and master audit ledger.
Click on chart slices or bars to instantly filter overview records
LED Digital vs Static vs Tempboard
Monthly revenue trend across confirmed bookings
Click a screen bar to inspect its booking orders
Click slice to filter territory
Detailed revenue generated per screen location, booking frequency, and contribution share.
| # | Screen Location & Code | Region | Board Type & Assignment | Bookings Count | Total Revenue (RM) | % Contribution | Top Client Booked | Action |
|---|
| # | Media Agency | Total Orders | Key Brands / Clients Handled | Total Spend (RM) | Action |
|---|
| # | Client / Brand | Agency | Industry Category | Total Deals | Total Booked Value (RM) | Action |
|---|
Breakdown of booking orders closed and revenue generated by each Sales PIC.
Comprehensive row-and-column ledger. Click on any row to open the complete campaign details, Gantt schedule, and COC reminders.
| # | BO Number | Client / Brand | Agency | Industry Category | Screening Dates | Screens Booked | Booking Value (RM) | Sales PIC | Status | Action |
|---|
Track scheduled invoice issuance dates by month & week to secure sales income milestones
Showing invoices due to be sent for selected period
| # | Send Due Date | BO Number & Client | Media Agency | Screen Campaigns | Invoice Amount (RM) | Sales PIC | Status | Action |
|---|
Manage screens inventory grouped by region, DOOH industry classifications, and media agencies.
Digital LED screens and static billboards with coordinates and Telegram topic routing.
Add, edit, or remove industry categories and group headers used for booking orders and slot compliance.
| # | Industry Category | Guide / Examples / Scope | Actions |
|---|
Media agencies that book screens on behalf of clients.
Configure designated storage destinations with privacy isolation between Management and Field Operations.
Independent storage isolation: Management Drive (Invoices & BO) vs. Operations Field Drive (COC Verifications).
Copy the Google Cloud Service Account robot email below. In both your Google Drive accounts (Management & Operations), open each Master Folder, click Share, paste this email, and grant role as Editor.
Under Management email. Stores client invoices, signed booking orders, and DBP approval certificates.
Under Operations email. Subfolders are generated per milestone date and dispatched directly to Telegram.
Option A (Automatic): You can link your top-level Root Master Folder. The Google Cloud Robot will automatically create and organize folders by year (2026, 2027, etc.) without you having to update links each year.
Option B (Dedicated Year Folder): You can create your 2026 folder directly in Drive and paste its link above. Subfolders ([Agency] / [BO# Client]) will be created directly inside that year.
COC advance notices, Telegram message formats & robot automation credentials.
Days before screening end date to trigger the upcoming COC verification notification.
Grace period days after screening ends before marking verification as critically overdue.
Days before send invoice date to remind sales PIC personally via Telegram (also reminds on send date).
• [DATE] - Target Date
• [LOCATION] - Target Location
• [VIDEOS], [LOOP], [SPOT], [CROWD] - Specs
• [LINK] - Drive/WA link (Upload Msg)
• [FOLDER] - Drive folder link (COC Msg)
• [STATUS] - Done Status
• [BRAND], [THEME] - Client & Campaign Info
• [START], [END] - Run Dates
• [PIC] - Sales PIC
• [BO_NUMBER], [INV_NO], [AMOUNT], [DUE_DATE] - Invoice Tags
• [NOTES_BLOCK] - 'Notes: XYZ' (COC Msg)
• [CHANGES] - Edits Alert
• [LIST] - Auto-generated list (Masterlist & Daily Reminder)
Control bot token, group destination, and topic thread ID directly without hardcoding.
Created via @BotFather on Telegram.
Target company Telegram group chat ID.
Thread ID for supergroups with forum topics enabled.
Open @BotFather on Telegram, send /newbot, name your bot, and copy the API HTTP token.
Add the bot into your 3Media Operations Telegram Group and grant it Admin rights (permission to post messages).
Add @userinfobot or @RawDataBot into the group to obtain the Chat ID (starts with -100...).
If using Telegram Topics, right-click any message in that topic and click "Copy Link". The final digits are your Topic ID.
Project: Portal File Integration (Account: aimpressor@gmail.com)
Operations and client share designated Google Drive folders to this robot email with Editor permission.
Stored securely in D1 database for backend automated uploads.
Company Super Admin can manage members and reset credentials.
Add or manage categories without losing your active booking form.
Scheduled invoice billing dates, due dates, and attached PDF documents.
Click on any date block to set Certificate of Campaign (COC) reminder dates.
Configure verification date(s) with dedicated notes and screen scope per date.
Configure screen name, region group, board type, coordinates, and Telegram routing.
Register a new user account for your organization.
Configure what this user can view or edit.
Upload or update signed document for this campaign.
1.2 MB • Ready & stored
Click to browse or drag & drop PDF file here
Standard PDF documents up to 15MB