Finding Ad Impression

Redesigning a placement report for the Measurement Operations internal team to search for missing advertisement impressions.

2021 - 2022

Team

  • Kristine Huynh - Product Designer
  • Teresa Pesenti - Product Designer

Tools

  • Figma 
  • FigJam
  • Google Meets 
  • Google Sheets
  • Google Forms
  • Slack (communications)

Methods

  • Qualitative interviews
  • Quantitative survey 
  • Heuristic analysis
  • Ideation
  • UX / UI / IXD
  • Design prototyping
  • Concept testing

Process

  • Research 
    • Qualitative interviews: Interview the Measurement Operations about their pain point when building end-of-campaign reports.
    • User flow: Visual understanding of how the campaign process work.
  • Ideate and design
    • Heuristic Analysis: Review other products the Measurement Operations use on a daily basis and incorporate them into the design.
  • Iteration 
    • Concepting testing: QA testing on Measurement Operations users to see if the placement report product could be improved from the wireframing.

Overview

This project fine-tunes and updates ad team processes to expedite with the other companies’ ad teams. I interviewed and surveyed my company's team members to understand what processes would usually take a while to process. That would be email correspondence analyst reporting and the end-of-campaign report. 

I visualize how the ad team processes their work using a site map. 

Site Maps of Placement Report

Problems with validating reports 

Users are using the Data Uploader as an uploader and not validating their reports. 

Most users see this as an uploader.
Match Rate Metrics and Data Frames are difficult to read.
ID Combos in the Database defaults to highest to lowest.

Users' biases toward Google Excel  

The interviews show users use Google Excel sheets to validate their data. 

Example of Excel and Google Sheets templates for the final reports.

Current Campaign Ends User Flow 

I focus on the end of the campaign process.  

Current user flow for the uploading the placement reports.

Reviewing Opportunities Through User’s Interviews

The main issues with the recent Data Report Uploader are as follows: 

User's issues with uploader.

Populating Data to Review  

The Master Placement Report and Site ID Key function similarly to the Google Sheets framework in terms of data combination. Pixels will be extracted from the company’s data sets.

Excavating Missing Ad Data Dashboard 

The dashboard shows four different sections:

  • Updated metric (1)
  • Campaign health (2)
  • Missing impressions report (3)
  • Missing pixel errors (4)

Updated metric (1): This shows campaign report impressions, comparing the databases. A discrepancy section shows the differences between the two reports.

Campaign health (2): This chart shows the campaign's overall health based on duration.

Missing impressions report (3): The Excel sheet shows the numerical IDs not accounted for in the campaign report.

Missing pixel errors (4): The graph shows which affiliated sites that are part of the campaign are carrying the most egregious code implementation errors.

In retrospect 

The Master Placement Report helps me understand the UX process from a business standpoint and how it affects the company's internal team. I created a project proposal to advocate the MPR product to the internal company stakeholders to see if it would progress. 

In the future, I would expand the client-facing product because users dislike building the Master Placement Report manually. They also want to end the waiting period by receiving clients' emails to complete the Master Placement Report Excel file. The client-facing element would fast-track the campaign’s process and expedite the clients' tactical reports to gain more insight into their ad spending. 

Other projects: