PGD Bogotá is the global HUB of Publicis Groupe Colombia, which specializes in providing support to the digital operations of large clients/companies on a global level. As part of our growth plan for 2021, we are diversifying our portfolio, seeking to integrate both the operational and strategic part, focusing on guaranteeing a 360º operation with our clients.

Job Description

Exact work/clients could change, and could be a mix of Digital, National Video, and Print.

Digital:

• Campaign upload prep: supplier and T&Cs checks, vendor/ad server mapping
• Campaign upload: check/troubleshoot upload doc, upload buy into Prisma
• Issue IOs to vendors: attach correct T&Cs and IO notes, send IOs to vendors, confirm vendor acceptance
• Push to traffic: confirm correct server/site location, work with Ad Tech to troubleshoot
• Campaign stewardship/revisions: work with Investment to make changes as needed, issue revised IOs to vendors for approval
• Billing verification: weekly and monthly checks, troubleshoot any variances
• Invoice reconciliation: complete AMPDs, work with Reconciliation team to resolve discrepancies, work with Investment and vendors to clear accurately
• Reporting: pull ad hoc reports, as needed
  National Video:
• Set up inventory in MBox: load estimates/packages/units manually and via Deal Exchange (cable); make changes as needed; ensure system is up-to-date
• Stewardship: monitor delivery; secure makegoods/ADUs for buys under-delivering
• Trafficking: ensure inventory is branded and confirm allocations to Traffic dept.
• Screen Program Content (if applicable for client): review screener reports and flag any concerns
• Post Buys: assemble performance/delivery data for a given quarter; compile into client deliverable
• Plan analysis: analyze vendor plans during negotiation/planning phase
• Billing verification: weekly and monthly checks, troubleshoot any variances
• Invoice reconciliation: assist Reconciliation team in resolving discrepancies
• Reporting: pull ad hoc reports, as needed
  Print:
• Buy loading (from Action memos): use excel file to create text file, and upload it to OX for new buys and any buy revisions. Troubleshooting any errors with the Investment team.
• Issue IOs to vendors (Activity Report): send IOs from OX, confirm vendor acceptance
• Maintain vendor contact info: update the vendor contact info in OX (changes come from either the reps or Investment team)
• Create new estimate numbers in OX: manually input data from excel file into OX to create the estimate
• Invoice reconciliation: work with Reconciliation team to clear invoices/resolve discrepancies, make any necessary revisions in OX to clear discrepant invoices

English C1, Excel proficiency, Media Buying Exposure