01 · Problem
High-volume launches, high error rates
Launching new campaigns at scale can be a highly manual and error-prone process. While creating a single campaign in-platform is manageable, building 50, 100, or more net-new campaigns becomes significantly more complex.
At TTD, campaign creation can happen either directly in the platform or through a bulk upload Excel file. Bulk uploads are critical for large-scale launches, but they require precise formatting, correct IDs, standardized naming conventions, accurate flight details, and platform-approved special characters.
Even small errors (incorrect formatting, missing IDs, naming inconsistencies, or typo-related issues) can cause upload rejections. Each rejection can add meaningful delays, forcing teams to troubleshoot, reformat, re-upload, and repeat the process. For advertisers with monthly launches or complex campaign structures, this can turn campaign setup into a full day or multi day workflow.
02 · Solution
One-click bulk uploads with platform rules baked in
I built an automated campaign builder workbook using Excel VBA macros and TTD's accepted formatting rules for bulk uploads. The workbook allows users to generate campaigns, ad groups, and flight rows with the click of a button.
Users only need to input the required advertiser-specific details, such as advertiser ID, audience IDs, tracking tag IDs, campaign settings, flight dates, budgets, and tactic information. From there, the workbook automatically creates the bulk upload structure in the correct platform-accepted format.
The tool also standardizes campaign taxonomy, naming conventions, tactic structures, and required setup fields across advertisers. This reduces the risk of human error while ensuring that campaigns are built consistently and ready for upload.
By embedding platform-specific requirements directly into the workbook, the campaign builder turns a manual trafficking process into a controlled, repeatable automation workflow.
03 · Impact
Speed, accuracy, and consistency at scale
What previously could take a full day or more of manual setup can now be generated in under five seconds. The tool dramatically improves speed, accuracy, and consistency for advertisers with recurring monthly launches or large-scale campaign builds.
The campaign builder reduces upload errors, minimizes rework, and allows teams to spend less time on repetitive trafficking tasks and more time on strategy, optimization, and client-facing work. For high-volume advertisers, it has become a major operational efficiency unlock.
