The challenge
Digital campaign data at ServiceNow lived in five places that did not talk to each other: Campaign Manager 360 and DV360 for the campaigns themselves, Snowflake holding the data, Power BI for reporting, and Marketo for email operations. Each had its own login, its own metrics and its own idea of what a dimension was.
For the AdTech team that was friction. For senior executives it was a wall — they had neither the access patterns nor the bandwidth to go platform by platform, so every question became a request routed to a person. A single query like "how did this campaign perform last quarter?" could take a week to come back, by which point the decision it was meant to inform had usually been made.
My role
I brought the idea from proposal to execution and supported it end to end. To be precise about the split: the engineering team built the platform. I defined what it needed to be.
- Wrote the PRD, and translated business requirements into technical concepts the engineers could build against.
- Ran the proof of concept and the initial user testing.
- Worked directly with the real users — APAC marketers and AdTech team members — to shape how the tool should behave, rather than deciding on their behalf.
- Made sure engineering had the resources and answers it needed to keep moving.
- Ran weekly office hours after launch: answering questions, supporting adoption, and carrying enhancement requests back to engineering to be deployed.
In practice that was a product management role in everything but title.
The approach
The obvious fix for scattered data is a unified dashboard, and it would have failed the same way the platforms did. A dashboard still requires you to know where to look, which view answers your question, and what each platform means by "impression". That is precisely the knowledge a C-suite executive does not have and should not need.
So the interface became the design decision. If the user can ask in plain English, they need no map of the systems underneath — the burden of knowing which platform holds the answer moves from the person to the software. That reframing is what made it useful to executives rather than to analysts.
The second decision was to talk to the actual users early and often. The people whose week it would save were APAC marketers and the AdTech team, so they shaped it during testing and kept shaping it through office hours after launch.
What we built
Before
Executive asks a question
→
Request queued with an analyst
→
Logs into CM360, DV360, Power BI, Snowflake
→
Stitches the numbers by hand
→
Answer, about a week later
After
Question typed in plain English
→
AI agent routes it to the right platform
→
Answer returned as a table, instantly
No logins. No knowing which system holds the answer.
The reporting stack, drawn. On a phone, scroll the diagram sideways.
A single conversational platform sitting over all five systems, built on ServiceNow's own LLM and AI agents. A user types a question — about a DV360 campaign, say — and the agent interprets it, fetches from the platform that holds the answer, and returns results as a table using that platform's own metrics and dimensions. It also reads historic data and trends to suggest how a campaign's efficiency could be improved.
What changed
- 100+ users across the Digital AdTech and MarTech teams could answer their own questions instead of filing requests.
- Quarterly business review reporting stopped being a week of manual assembly — managers pulled precise, actionable numbers when they needed them.
- Executives got answers at the speed they actually make decisions, rather than a week after asking.
- The analysts who had been pulling those reports got that week back.
- Campaign recommendations came with the data, so the tool suggested what to do next rather than only reporting what had happened.
What it taught me
Office hours turned out to matter as much as the PRD. Sitting with users every week surfaced the gap between what people said they wanted during testing and what they actually reached for once the tool was real — and that steady stream of small enhancement requests, fed back to engineering, is what moved it from a working system to one people chose to use.
It also taught me where my value sits on a project like this. I could not have built it. What I could do was hold the problem clearly enough that the people who could build it never had to guess what mattered.
ServiceNow LLMAI agents
Campaign Manager 360DV360
SnowflakePower BIMarketo
PRD & discoveryUser testing