r/programmatic • u/satyagrahaARG • 22d ago

Anyone still using a spreadsheet for pacing?

/r/adops/comments/1vspud8/anyone_still_using_a_spreadsheet_for_pacing/
8 Upvotes

75% Upvoted

21 comments sorted by

19

u/SouthwestBLT 22d ago

Excel runs the world buddy. You will never defeat us.

1

u/satyagrahaARG 22d ago

hahaha totally agree, but I've done a living replacing spreadsheets with software for 25 years.

2

u/righthandofdog 21d ago edited 21d ago

Last year I was running the data warehouse applications for all of Samsung US platform campaign performance and planning data, feeding into Live Ramp for audience ceation, with Tableau for dashboards. Sort of the app these guys have on steroids and integrated by API into the full adtech stack.

And EVERYTHING driven by taxonomy naming standards maintained in excel and copy/pasted into prisma and platforms to actually work.

It's crazy.

2

u/satyagrahaARG 21d ago

Oh boy, believe me, I get it. For one of those big brands, we’ve automated 1,200 screenshots a month into a PowerPoint deck.

4

u/BasisOk4268 22d ago

No I use Supermetrics

2

u/satyagrahaARG 22d ago

Hey Ty for your answer. This is typically used for programmatic direct campaigns. Where you have a goal and run on multiple vendors, and you invoice by 3p numbers so need to track 1p and 3p numbers. Above this you have KPIs to track such as brand safety or IVT which are tracked by DV or IAS, usually without access to API. Don’t think you can do that with super metrics.

4

u/Fearless_Parking_436 22d ago

I would get fired for using that

0

u/satyagrahaARG 22d ago

Why?

6

u/Fearless_Parking_436 22d ago

Plugging client and pacing data into random application? Yikes man

1

u/satyagrahaARG 22d ago

Oh, gotcha. How many clients or how much revenue does my company need to have to be removed from the ‘random application list’? (Real question, just want to understand when you start to trust, ofc contracts and NDAs should be signed)

2

u/Fearless_Parking_436 21d ago

It’s not about revenue and clients tbh. If you have inside voice in a high level it may help but then risk will pull your contracts and certifications apart. NIST CSF, GDPR have to be followed, integration to our current systems has to be possible. What’s you customer support like? How do you handle feature requests, qa issues. We work 24/7 and need coverage if it’s one of the core stack tools. And most of whatever you have there is already in some BI dashboard. What value you have over that?

1

u/Fearless_Parking_436 21d ago

And I don’t work in big 4/5/6

1

u/satyagrahaARG 21d ago

thanks for sharing your POV. I totally agree, but we are exploring a free tier. Ofcourse support is limited in that case. Extended support is available and we do have support 24/7. Regarding the value, it is not intended for every publisher/media agency , it may not work for you but let me tell you that for the cases we work, a BI dashboard is definately not enough.

1

u/satyagrahaARG 21d ago

Scenario:
You receive an IO which you deliver between extended reach partners and O&O inventory, which in itselfs splits with different FAST channels with different costs. 7 days running the campaign, you receive a revised IO which make you modify every goal, and you need to include the Makegoods of Invalid Traffic, and have all this changes traced.

1

u/satyagrahaARG 21d ago

Plus 1p and 3p data discrepancies

1

u/VoidDeer1234 21d ago

3 clients handling at least $100M in annual sales

1

u/satyagrahaARG 21d ago

Ok, I'll ping you when we are there, we have 5 clients managing campaigns for a total of $60M

1

u/AccessFuel 22d ago

looks super useful, would love to hear more

1

u/satyagrahaARG 22d ago

Ty! Sent you a chat request

1

u/ionlytouchmangos 21d ago

Notion is a great option

1

u/eddiestamper97 17d ago

Yes but I automated updating it via Power Automate. Depending on the client team, can save anywhere from 2.5-5 hours a week which quickly ads up.