Problem

There is no mechanism in place to track advertising makegoods. This means that it is difficult to determine how many makegoods are being issued, who is receiving them, and whether or not they are makegood are approved or rejected. The cost of makegoods can be significant, and the lack of a tracking mechanism makes it difficult to determine how much is being spent on them.

The lack of an automated system for notifying process owners of makegood requests is causing a number of problems, including poor advertiser experience, increased costs, and reduced efficiency. Makegood requests can often sit pending for long periods of time, eroding advertiser experience and leading to increased costs for the company.

Solution

To solve the problem of tracking advertising makegoods, we implemented a QuickSight dashboard that provides insights into the number of makegoods issued, who has received them, and whether or not they have been approved or rejected. This dashboard helps reduce costs by providing information that can be used to negotiate better rates with media companies. It also increases effectiveness by providing insights into the effectiveness of makegoods that can be used to improve advertising campaigns. Finally, it improves relationships between advertisers and media companies by providing a transparent way to track makegoods.

To solve the problem of notifying process owners of makegood requests, we implemented an automated system that sends email notifications to responsible process owners as soon as a request is submitted. These notifications include all relevant information about the request and provide process owners with the option to approve or reject the request directly from the email notification. This solution improves advertiser experience by notifying them more quickly about their requests, reduces costs by saving money on unused advertising space due to pending requests, and increases efficiency by reducing manual tracking of request status.

Impact

Reduced costs by X%
Increased efficiency and productivity
Improved advertiser experience and relationships with media companies

This had saved 2000

Team

Team Member #1 - Software Engineer
- Oversaw the implementation of the QuickSight dashboard for tracking advertising makegoods
- Collaborated with data analysts to ensure accurate data reporting in the dashboard
Team Member #2 - Project Manager
- Led the implementation of the automated system for notifying process owners of makegood requests
- Collaborated with stakeholders to define requirements and ensure successful implementation and adoption of the system

Tracking Ad Makegoods with QuickSight Dashboard