I have 1000s of advertising campaigns in which I have recorded hourly impressions, clicks, conversions and revenue for.
eCPM = revenue/impressions * 1000
eCPM is generally a figure used to gauge the performance of a campaign.
However, eCPM is greatly affected by impression amount. The higher the impressions, generally the lower the eCPM...in most cases. This is also the case with CTR, generally. It's an extremely rare occasion that eCPM isn't affected by an increase of traffic.
I started thinking that maybe there was a way to calculate a 'sweet spot' in which the perfect amount of impressions is delivered so the optimal eCPM is reached for the campaign. Likewise would occur with other campaigns.
This would then allow me to know how to distribute my impressions in the most optimised way.
Does anyone know a formula or process in which I can calculate the optimal traffic amount for a campaign?
Thanks in advance!