Purpose:

The Python script identifies campaigns where the publisher’s cost for the previous day is at least 90% of the daily budget and flags them with a “Budget Capped” alert.

To Elaborate

The script is designed to monitor advertising campaigns by comparing the publisher’s cost against the daily budget. It flags campaigns as “Budget Capped” when the publisher’s cost reaches or exceeds 90% of the daily budget, provided certain conditions are met. Specifically, it checks if the ‘iDNE’ value is below 1.5 and the ‘Lost Impression Share’ is above 10%. This helps in identifying campaigns that are close to exhausting their budget, allowing for timely adjustments to avoid overspending or missing out on potential impressions. The script processes data from a report, performs calculations, and outputs a modified dataset highlighting campaigns that require attention due to budget constraints.

Walking Through the Code

1. Data Preparation
   • The script begins by converting the ‘iDNE’ column to numeric values to ensure accurate calculations.
   • It calculates the ratio of publisher cost to daily budget and stores it in a new column ‘Pub Cost / Budget’.
   • The ‘iDNE’ and ‘Lost Impression Share’ values are also extracted for further analysis.
2. Budget Cap Alert Logic
   • A threshold of 90% is set, which can be adjusted by the user to change the sensitivity of the alert.
   • The script checks if the ‘Pub Cost / Budget’ is below the threshold, clearing any existing alerts.
   • It then applies the “Budget Capped” alert to campaigns where the ‘Pub Cost / Budget’ meets or exceeds the threshold, ‘iDNE’ is less than 1.5, and ‘Lost Impression Share’ is greater than 10%.
3. Output
   • The modified DataFrame is printed, showing which campaigns have been flagged.
   • A subset of columns is selected for the final output, focusing on account, campaign, and budget alert status.

Vitals

• Script ID : 877
• Client ID / Customer ID: 1306912237 / 13095968
• Action Type: Bulk Upload
• Item Changed: Campaign
• Output Columns: Account, Campaign, Budget Alert
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: smalina@marinsoftware.com (smalina@marinsoftware.com)
• Created by Stephen Malina on 2024-03-29 16:50
• Last Updated by Stephen Malina on 2024-04-23 20:51

> See it in Action

Python Code

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
#
# Tag campaign if Pub Cost for prior day is 90% of Daily Budget
#
#
# Author: Stephen Malina
# Date: 2024-03-27

RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_PUBLISHER = 'Publisher'
RPT_COL_PUB_COST = 'Pub. Cost $'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_DAILY_BUDGET = 'Daily Budget'
RPT_COL_CAMPAIGN_STATUS = 'Campaign Status'
RPT_COL_BUDGET_ALERT = 'Budget Alert'
RPT_COL_iDNE = 'iDNE'
RPT_COL_LOST_IMP_SHARE = 'Lost Impr. Share (Budget) %'
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_BUDGET_ALERT = 'Budget Alert'

# Convert the 'iDNE' column to numeric values
inputDf[RPT_COL_iDNE] = pd.to_numeric(inputDf[RPT_COL_iDNE], errors='coerce')

# Calculate the difference between daily budget and pub cost, include iDNE for consideration
inputDf['Pub Cost / Budget'] = inputDf[RPT_COL_PUB_COST] / inputDf[RPT_COL_DAILY_BUDGET]
inputDf['iDNE'] = inputDf[RPT_COL_iDNE]
inputDf['Lost Imp Share'] = inputDf[RPT_COL_LOST_IMP_SHARE]

# Output a "Budget Cap Alert" where daily spend is greater than 90% of daily budget and iDNE is less than 1.5
threshold = 0.90  # Adjust this threshold as needed
inputDf.loc[inputDf['Pub Cost / Budget'] < threshold, BULK_COL_BUDGET_ALERT] = ""
inputDf.loc[(inputDf['Pub Cost / Budget'] >= threshold) & (inputDf['iDNE'] < 1.5) & (inputDf['Lost Imp Share'] > 10), BULK_COL_BUDGET_ALERT] = "Budget Capped"

# Print the modified inputDf
print(inputDf)
cols = [RPT_COL_ACCOUNT, RPT_COL_CAMPAIGN, BULK_COL_BUDGET_ALERT]
outputDf = inputDf[cols]

Post generated on 2025-03-11 01:25:51 GMT