Calling all Excel Formula Wizards:
I'm trying to create a daily ad spend pacing spreadsheet. I want to know if, for example, I spent $226.42 of my $500 budget on the 19th of June, I need to crank up my daily adspend by $x amount for the 20th of June.

So I need formulas to calculate logic of Month = June, so I'll spit out 30 Days. Budget = $500, so I will tell you how much to spend daily to get to $500. And a manual section where I input that we spend $226.42 as of June 19th, and it will spit out a new daily ad spend to then be input into the ads channel.

I did this a few years ago and I need a refresher - no need to get complicated with a Google script to pull in the data automatically - for now :) Thanks in advance for the help!

Hi All - I am hoping someone here might be able to help me connect with someone at Netflix as I see they have a Senior Campaign Manager position available. I have over 10+ years of Ad Ops experience and think I would be a great fit for the role.

Any help would be greatly appreciated.

Is there a way to Boolean join segments from multiple data providers in liveramp’s marketplace? Cannot find anything in their documentation.

As a publisher, I need to contact SSPs about lots of things. 9/10 I have an AM that I can just email and get a response. With some, I have a Slack channel so we can ask quick things that don't necessarily need to be logged. It works well, but some insist on using this wretched "case" system which I believe is operated by Salesforce.

I don't have a specific AM I can talk to at OpenX anymore and both Xandr and Index Exchange (who I do have AMs with) insist I open up a "case" to deal with it through there. However, once you've submitted your case, you cannot see the information you've submitted. It disappears like a fart in the wind! You can click previous cases and get info such as 'case number' and 'who submitted it' (things useless to me), but not the actual information I sent in the first place.

If I am going to try anything new and need an SSP to contact, it won't be one of the ones using this system. I actually hate dealing with it.

/rant

Hello adops community, I have a client who's an investor and they are interested in acquiring a programmatic company that has seats with with various SSPs. Let me know if you or anyone you know might be interested. Please DM. Thank you!

Is it just me or does it come off as lazy when SSP partners ask for areas or ways to optimize?

As a publisher, we’re doing everything we can to optimize our stack performance; IDs, floors, signals, etc.

Our SSPs have access to the same data we do, minus competitor performance, but you can infer from reporting where to improve your bid rate, bid CPMs, etc of YOUR campaigns.

I have nothing to say other than, “increase your bid rates and/or CPMs where you want more inventory”…

Thanks

I’m considering sending IAB taxonomy (Both content and User) from my in-app to Google Ad Manager (GAM) and would love some insights from those who have done it before.

1. Is it worth it in terms of CPM uplift? Have you seen an impact on ad revenue by passing this data?

2. Which data should I send to GAM?

Hello adops community, I hope you are having a great weekend.

I'm interested in connecting with those that have O&O inventory for FAST and CTV. I have 100% direct to agency demand. Please DM! Thank you.

I'm doing some research and wondering how I could determine where an old CDC campaign ran. Any details about spend, channels, engagement, etc., would be helpful. Other than iSpot.tv, are there any tools or resources out there that could help? Asking for a friend 😏.

https://youtu.be/MmKgm--EQUU?si=IkNVSpiOpcJnet26

Is there a way to trigger Google test fluid ads? I'm testing a new format in the test environment (diferent domain) of my website, and I want to thoroughly check it before releasing it to production.

I work in sales for a travel company and we have recently launched native ads. One of our big selling points has always been O&D targeting down to the city level. This was fine when we were running smaller campaigns but now we are working with some major airlines and train companies and its becoming an issue. We don't have the ability to add 6,500 lines for differ routes manually. Does anyone have a recommendation for a system or platform that we can purchase to automate this? Thanks!

We want to use this thread to invite small pubs to ask any questions they may have about getting started in monetization

When trying to understand / evaluate as partners getting community feedback can be very helpful

Here are some suggested questions that we recommend:

What are the nuances of demand?

What percentage of your demand is unique?

What formats are supported, and how does performance compare?

What Verticals / Platforms and types of inventory perform well?

What KPIs (other than CPM) are important to monitor that you should be aiming to achieve?

What other sites does the partner work with?

Can they provide references? How long have they been in business?

We really want to encourage a healthy dialogue here as others are genuinely trying to learn.

Has anyone worked with this ad network before? any opinions? I'm skeptical about them for now

Vidverto | Video Ad Platform

Based on your day to day work and even previous experiences, what is your main pain in the adtech market? Or even things you have seen that don't impact your work..

I have a web application in a technical niche ( web dev, dba, online mktg type users ).

It's relatively busy ( 10k+ daily, usually 500+ concurrent users ).

My user-base is global, but 70% of my ad revenue comes from only 20% of my users ( US ). Whereas India, for example, is 35% of my userbase, but only 6% of my revenue.

I'm in the middle of a re-build of my application to a more modern tech-stack, and I'm struggling a bit for how best to monetize non-US.

I've looked at ezoic, but they need all traffic, not just the non-US traffic.

I've reached out to a few others as well, such as RevBid - they said they likely can't beat adsense in US, but "worth a try" for non-US.. which is giving me limited confidence in the effort, though they don't have restrictions about running alongside adsense.

Any ideas for how best to monetize globally like this would be much appreciated!

Does anyone know the difference between Mediavine/PubNation/Journey (besides that they're all run by Mediavine)? I already have worked with Mediavine and AdThrive (Raptive) so I know them but I launched an additional site (in the news vertical) and I'm trying to decide whether to apply for PubNation, Journey or regular Mediavine.

I was looking into some other DSP options that have similar functionality of adding advertiser/account level markups as DV360 .

Hello good afternoon, what is the best site for PUSH ads with fresh traffic?

Hello AdOps,

I heard that some publishers profit from constantly replacing ad units with new ones because that way since bidders don't have information about this ad unit cpms usually are higher. This doesn't sound something legal, can you get policy violation from Google by constantly replacing ad units with new ones to get higher cpms?

I’m running ads on a platform (not programatic) that supports third-party impression tags but not the DV Display Blocking Parameter (all on the CM360 tag sheet). I’ve been wrapping the tags through DCM by linking the DV and providing the "Third-party Vendor Tracking Tag" with the blocking parameter at the end.

If the platform implements the entire DV tag, even without supporting blocking, will the tag still function properly? If not, what should I implement instead? Below is an example of a tag (not live) I’m currently using. Any and all help would be greatly appreciated.

(Sorry if this is a dumb question i'm very new to DV tags. Typically only work with normal Impression and Click tags).

Hey everyone,

I run a site that gets ~700k-1M views per month. Currently I've been using Freestar, but have been contacted by other networks like snack Media, Ezoic etc. I am in the sports niche so I could see a specialized partner like snack Media being worth my time. I was curious what I should be looking for when picking a partner?

I need a tool to share with clients so that they can test their creative before sending it to us. The tool is sunsetting in April and it's already been breaking for months now.

Does anyone have any external alternatives that doesn't require a google/cm360 account to test? Some of my clients do not have anything like that.

I was recently using Journey ads, but my site's RPM dropped significantly from $10+ to around $4–5. To mitigate this, I tried combining Journey ads with Adsterra ads. Unfortunately, this resulted in my site being terminated due to the following reasons: "pornographic content detected" and "low-value content" (I use AI-generated content).

Can you recommend any ad networks that don’t require Google approval? My site would likely be rejected because of the use of AI.

Currently, I’m using Netpubmedia, which offers a decent CPM of $1+ (better than Journey ads), but the fill rate is very low—only about 30–40%. I’ve also applied to Pubfuture, Pubpower, dotaudiences, and Pixfuture and am waiting for responses.

Note: I have used ChatGPT to refine my message, as English is not my first language.

https://imgur.com/a/m2ybH6e

Hey everyone after a long consideration I’m opening the door to new oportunities in case you are looking for an ad operations specialist or a social campaign implementation analyst, opening my services as contractor/ freelance with more that 10+ years of experience in the digital media arena.

Reach out and get to know more about my experience and career

I'm wondering if this community has any experience with either of these two commenting products as it relates to monetization.

Ai ai Ooooooh

I constantly hear about ai. My inbox / slack is often flooded with people wanting to send me their sales decks or schedule demos. (Which I do not do).

I’m curious how some of your companies are leveraging AI.

Are you using it to optimize targeting, improve creative, fraud, or something else?

Curious to hear about real-world use cases.

Ps: I may use this for a newsletter write up so it’s nice everyone’s anonymous and can be real about it

I’m planning to test ads in my app for the first time, but I’m worried about how my users will react. I want to keep the experience as smooth as possible while seeing what works.

How do you test ad placements or formats without upsetting your user base? Any tips for finding the balance?

Google Anchor Ads have a low CPM considering the visibility of the placement and its intrusiveness (sticky), even when compared to just a standard rectangle ad.

Has anyone here transitioned from Google Anchor Ads to their own sticky ad solution or used ready-made options from an ad network? I’d appreciate it if you could share your experiences.