Lidya Aprillia

Strategic Planner · Media & Broadcast Analytics

Lidya Aprillia

Data-driven planning professional turning campaign, cost, and broadcast performance data into clear decisions for SCTV & Indosiar's media & program planning.

“Work hard and enjoy the journey.”

Get in touch Download CV View experience
Portrait of Lidya Aprillia

01About

Data-driven planning professional with hands-on experience in media and program planning, budget/cost analysis, and performance reporting within Indonesia's broadcast advertising industry (SCTV/Indosiar). Skilled in reconciling large volumes of campaign and transactional data, translating cost and performance trends into clear reports for management and clients, and coordinating with marketing teams to build monthly media plans. Combines an accounting and audit foundation with data visualization (Power BI, Tableau) and research experience to support evidence-based strategic and media planning decisions.

02Experience

  1. Jan 2025 – Present Full-Time

    Cost Per Rating Program Planner

    PT Surya Citra Media Tbk

    • Input monthly briefs and purchase orders from the Sales division into the Gen21 system, generating media plans with program titles, number of spots, brands, advertisers, agencies, sales persons, and target audiences.
    • Perform post-buy analysis for each campaign to ensure KPI achievement such as GRP for Prime Time and Non-Prime Time in line with bilcom targets.
    • Monitor and evaluate Premium Position Allocation (PIB) to ensure KPI compliance across advertisers.
    • Manage Over-Delivery (OD) by updating bilcom data and synchronizing with initial purchase orders.
    • Maintain precision between planning calculations (PB, PT, PIB) and actual KPI performance from Nielsen data.
    • Generate custom performance reports for key clients (Mayora & Unilever) twice a week based on Nielsen data for PB, PT, and PIB progress tracking.
  2. Feb 2024 – Jun 2024 Internship · Kampus Merdeka

    Cost Per Rating Program Planner

    PT Surya Citra Media Tbk

    • Division Marketing Business in PT Surya Citra Media Tbk.
    • Input data for advertising spots on television (SCTV, Indosiar and Mentari TV).
    • Created a media plan for the month.
    • Pulled data in the Arianna Software and uploaded it to the SCTV or Indosiar portal.
  3. Jun 2024 – Aug 2024 Internship

    Accounting and Administration

    PT Indo Global Gemilang

    • Conducted customer data recapitulation using Microsoft Excel.
    • Evaluated and approved or rejected advertisements based on company criteria.
    • Assisted in adjusting advertisements to align with company revenue.
  4. 2023 Organization

    Project Officer, Accounting Building Career & Development Festival

    HIMA S1 Accounting, UPN Veteran Jakarta

    • Chief executive organizing a workshop and career talk held by HIMA S1 Accounting UPN Veteran Jakarta.
    • Career Talk theme: "The Importance of Understanding Data Analysis in The Auditing Career Path."
    • Workshop theme: "Build Personal Branding to Compete in the Career World."
    • Coordinated all divisions as project officer to help Bachelor of Accounting students grow through ABCD Fest 2023.
    Lihat Project

03Moments at Work

Lidya Aprillia with the team at Emtek Media office
With the team · Emtek Media office

04Projects & Research

LinkedIn · 2026

Beyond Cost Saving: A Multi-KPI Framework for AI Efficiency

Strategic & Data Analytics Commentary

  • Analyzed Klarna's AI chatbot case (2.3M conversations/month, 75% of customer chats across 23 countries) to evaluate the trade-off between cost efficiency and service quality.
  • Argued that measuring efficiency through a single cost-saving metric can mask real business impact on customer experience, loyalty, and brand trust.
  • Proposed a multi-KPI monitoring dashboard — CSAT, AI Escalation Rate, and Complaint Rate — with weekly operational review to rebalance AI-human composition based on performance data, not assumptions.
Lihat Post di LinkedIn
2026 – Present

Real-Time KPI Tracking Automation — Mayora Campaigns

Prefect · Tableau · Claude Skill Automation

Automated the Tableau-to-Prefect pipeline with a Claude skill that refreshes real-time KPI achievement data for Mayora campaigns three times a day (9 AM, 3 PM, 5 PM), saving roughly 33 hours of manual reporting a month while sharply improving data accuracy.

Mayora Daily Check dashboard showing automated %ACT campaign achievement tracking, with raw actual/estimate figures blurred
Live %ACT tracking output · raw figures blurred for client confidentiality
2026 – Present

PIB NPT Data Cleaning — Claude Skill

Tableau · Claude Skill

Built a Claude skill that cleans raw PIB NPT data pulled from Tableau on demand and outputs ready-to-use percentage estimates, cutting prep time by about 20 minutes per run so analysis can start faster.

Raw PIB NPT data pulled from Tableau, with product name, MO, and program name columns blurred
Raw input · product, MO & program columns blurred for confidentiality
Cleaned PIB NPT percentage result from the Claude skill, with product name and underlying figures blurred except the final percentage
Cleaned output · only the final % PIB estimate is left visible
Sep 2023 – Jun 2024

Journal Publication: Auditor Ethics

Published in SINTA 3 Indexed Journal

  • Wrote and examined the auditor's Machiavellian dimensions in ethical decision-making, reviewing 25+ academic references.
  • Interviewed an external auditor from a Big 4 public accounting firm as primary informant; published in a SINTA 3-indexed academic journal.
Lihat Project

05Skills & Tools

Core Skill

  • Media & Program Planning
  • Budget & Cost Analysis
  • Variance Analysis
  • Data Reconciliation & Validation

Soft Skill

  • Adaptability
  • Team Communication
  • Planning & Analysis
  • Team Work

Tools & Software

  • Microsoft Excel (Advanced)
  • Power BI
  • Tableau
  • SAP S4/HANA
  • Accurate Online
  • Zahir Accounting
  • PowerPoint
  • Word
  • Arianna Software

Zahir

Comfortable entering data for financial statements, making invoices, and recording company stock quickly, accurately, and efficiently.

Lihat Sertifikat & Project

Accurate

Quick at capturing sales, efficiently managing warehouse inventory, and accurate in producing comprehensive company reports.

Lihat Sertifikat & Project

Excel

Expert at processing data, active in using Excel formulas, and skilled at building worksheets that stay smooth, fast, and accurate.

Lihat Project

PowerPoint

Great at making PowerPoint presentations interactive, understandable, and targeted for report presentations.

Lihat Project

Word

Extensive experience writing scientific papers to competition-winning standard at the national level, and fast in writing.

Lihat Project

Tableau

Strong at processing and filtering data, building worksheets, and creating dashboards from the data presented.

Lihat Project

06Education

2021 – 2024

Bachelor of Accounting

Universitas Pembangunan Nasional “Veteran” Jakarta

Coursework: Auditing, Financial Management, Cost Accounting, Business Analysis

  • Organization: Himpunan Mahasiswa S1 Akuntansi (2023)
  • 1st Winner, National Investigative Audit Competition (2022), Universitas Kristen Duta Wacana Lihat Sertifikat
  • 2nd Winner, National Investigative & Forensic Audit Competition (2023), Universitas Trilogi Lihat Sertifikat
2019 – 2021

SMA Negeri 20 Jakarta

Social Sciences

07Certifications & Languages

  • Zahir User Certified (2023–2028)
  • Accurate Online (2023–2025)
  • Microsoft Office Specialist (2024)
  • TOEFL ELPT, UPN Veteran Jakarta (2024)
IndonesianNative
EnglishProfessional Working Proficiency

Let's talk planning & data

Open to strategic & media planning roles where data drives the decision.

Chat on WhatsApp Download CV