Analyst - Digital Media Planner

Publicis Global Delivery (PGD); Gurugram District; On-site; INR 450,000 - 900,000; Full time

Job summary

Publicis Global Delivery (PGD) is seeking a junior Media Planning Executive in India to support planning and reporting tasks. You will help build media plans, manage budgets and tracking, and ensure data accuracy across dashboards and reports.

The role focuses on number-crunching, reconciliation, and documentation to support the Planning Manager and Media Director, with coordination across digital channels and vendors.

Qualifications

• 0.6 months–6 years of experience in media planning, digital marketing, or analytics.
• Strong comfort with numbers and spreadsheets (Excel/Google Sheets).
• Basic understanding of digital channels and metrics (impressions, clicks, CTR, CPM, CPC, CPA, reach, frequency).
• High attention to detail and accuracy; enjoys reconciling numbers and fixing inconsistencies.
• Good written and verbal communication; able to clearly document work and follow instructions.
• Proactive, organised, and comfortable handling multiple small tasks in parallel with tight deadlines.
• Available to work full-time in India hours (9 AM–5 PM IST) to align with the PGD and India hub teams.

Responsibilities

• Assist in building media plans and flowcharts across digital channels (social, programmatic, video, display, etc.).
• Populate planning sheets with budgets, impressions, CPx metrics, and flighting details based on guidance from the manager/director.
• Help prepare plan decks and summaries for internal and client reviews, ensuring all numbers match the underlying Excel files.
• Reconcile plans vs. actuals: compare planned vs. booked vs. delivered data and flag variances (budget, pacing, impressions, clicks, etc.).
• Regularly update tracking sheets, campaign calendars, and status documents so stakeholders see the latest view.
• Run basic QA checks on media plans, IOs, and reports (totals, dates, targeting, naming conventions) to catch errors early.
• Maintain organized records of approvals, screenshots, invoices, and partner reports in shared folders.
• Pull performance data from dashboards into centralized templates.
• Help build weekly/monthly reports and dashboards with clean, consistent data (no missing fields, correct formulas).
• Support the manager/director in creating simple charts and tables that show trends and highlight key outcomes.
• Assist with filling in and updating CDDs/approval documents with correct media details.
• Support coordination with channel teams and vendors by sharing briefs, collecting confirmations, and tracking deliverables.
• Take meeting notes, capture action items, and follow up on pending tasks across the team.
• Contribute to process documents, checklists, and best‑practice libraries as they evolve.

Skills

Attention to detail

Analytical thinking

Communication skills

Organized

Tools

Excel/Google Sheets

Job description

Publicis Global Delivery (PGD); Publicis Groupe’s industry leading globally connected capability platform. Where talent, technology & operations combine to delivery amazing solutions for our clients. Expertise across Media, Data, Technology, Commerce & Production in all regions of the world. PGD is comprised of the best talent, and ways-of-working, which enables global scale, innovation and transformation, each day. Culture, growth and wellbeing underline all aspects of Publicis Global Delivery

Please note : This role is open for Gurgaon, Bangalore, Mumbai, Pune and Hyderabad

Role Summary

We are looking for a Media Planning Executive who will function as a junior planner, focused on data accuracy, reconciliation, and day‑to‑day support for the Planning Manager and Media Director. This role is heavily hands‑on with numbers, sheets, and documentation, ensuring that plans, buys, and reports are complete, consistent, and ready for client use.

What You’ll Do

Planning Support

• Assist in building media plans and flowcharts across digital channels (social, programmatic, video, display, etc.) using standard templates.
• Populate planning sheets with budgets, impressions, CPx metrics, and flighting details based on guidance from the manager/director.
• Help prepare plan decks and summaries for internal and client reviews, ensuring all numbers match the underlying Excel files.
• Reconcile plans vs. actuals: compare planned vs. booked vs. delivered data and flag variances (budget, pacing, impressions, clicks, etc.).
• Regularly update tracking sheets, campaign calendars, and status documents so stakeholders see the latest view.
• Run basic QA checks on media plans, IOs, and reports (totals, dates, targeting, naming conventions) to catch errors early.
• Maintain organized records of approvals, screenshots, invoices, and partner reports in shared folders.

Reporting & Performance Tracking

• Pull performance data from dashboards into centralized templates.
• Help build weekly/monthly reports and dashboards with clean, consistent data (no missing fields, correct formulas).
• Support the manager/director in creating simple charts and tables that show trends and highlight key outcomes.

Operational & Administrative Support

• Assist with filling in and updating CDDs/approval documents with correct media details.
• Support coordination with channel teams and vendors by sharing briefs, collecting confirmations, and tracking deliverables.
• Take meeting notes, capture action items, and follow up on pending tasks across the team.
• Contribute to process documents, checklists, and best‑practice libraries as they evolve.

Requirements

• 0.6 months–6 years of experience in media planning, digital marketing, or analytics; internships/trainee roles also considered.
• Strong comfort with numbers and spreadsheets; good working knowledge of Excel/Google Sheets (sumifs, vlookup/xlookup, pivot tables are a plus).
• Basic understanding of digital channels and metrics (impressions, clicks, CTR, CPM, CPC, CPA, reach, frequency) or willingness to learn quickly.
• High attention to detail and accuracy; enjoys reconciling numbers and fixing inconsistencies.
• Good written and verbal communication; able to clearly document work and follow instructions.
• Proactive, organised, and comfortable handling multiple small tasks in parallel with tight deadlines.
• Available to work full‑time in India hours (9 AM–5 PM IST) to align with the PGD and India hub teams.

Core Competencies

• Detail orientation and data discipline
• Ownership of routine tasks and follow‑through
• Curiosity and willingness to learn planning concepts