AG

DO SANDBOX

Tools, Helpers and Automations for optimization team in AdTech Holding

‌
DO Sandbox

Background

The Optimization Department is all about refining workflows and boosting product efficiency. But behind the scenes, their daily grind often involves handling tedious and repetitive tasks that can sap time and energy.

One such task? Managing payout rates for conversions. This involves two key steps:

  • Communicating with managers to confirm updated payout rates.
  • Applying these updates into the system — a process that's as critical as it is monotonous.

While these steps ensure seamless operations, the routine nature of this work leaves little room for innovation and creativity.

Problem

Repetitive, manual processes take up significant time, hindering productivity.

Solution

Communication boilerplate

The communication boilerplate has predefined structure that makes it easy to grab necessary parts and work with them. Example:

Pub: clientEmail@gmail.com – 9876543
Offer 1234
ID
Please pause sources on zone 1234567: q7r8s9t0u1v2w3x, g3h4i5j6k7l8, w9x0y1z2a3b4c5d (69% of traffic)
or
1234 ID 0.5678 → 0.1234

CM
Please pause high CR sources on zone 1234567: a1b2c3d4e5f6g, q7r8s9t0u1v2w3
Please pause sources on zone 1234567: a6b7c8d9e0f1, g8h9i0j1k (59% of traffic)
or
1234 CM 0.4321 → 0.1234

Offer 5678
TH
Zone 8765432
5678 TH 0.9876 → 0.5432

Data Transformation Tools

A tool to convert data from the boilerplate into a CSV format, that is ready for system uploads

First Iteration
Simplifies workflow and generates CSV files
  • Removes unnecessary text from boilerplate
  • Generates CSV files for system uploads
  • Two-click process
View Tool
Second Iteration
Improved functionality with employee-only access
  • Faster processing: Instant CSV generation
  • Automated cleanup of irrelevant text
  • Keyboard shortcuts for quick actions
  • Instant output using shortcuts

The process looks the following way:

  • 1

    Past the data

  • 2

    Choose the date using shortcut

  • 3

    Download using shortcut

The video uses simulated data for demonstration purposes and does not include any actual figures to ensure confidentiality.

User can also just copy the transformed data

The video uses simulated data for demonstration purposes and does not include any actual figures to ensure confidentiality.

User can download separated CSVs by offer ID

Rarely used in favour of one CSV with all data

The video uses simulated data for demonstration purposes and does not include any actual figures to ensure confidentiality.

Impact

Dramatic reduction in processing time and increased productivity.

Processing Time Reduction

Before: 5 minutes

After: 10 seconds

98% faster
Increased Efficiency

Up to 1 hour saved daily

Freeing time for higher-priority tasks