Script 867: Budget Capped Campaigns

Purpose:

The Python script identifies campaigns where the publisher cost for the prior day is at least 90% of the daily budget and flags them as “Budget Capped.”

To Elaborate

The script is designed to monitor advertising campaigns by analyzing their spending relative to their allocated daily budgets. Specifically, it identifies campaigns where the publisher’s cost for the previous day approaches or exceeds 90% of the daily budget. Additionally, it considers other factors such as the ‘iDNE’ value and ‘Lost Impression Share’ to determine if a campaign should be flagged with a “Budget Capped” alert. This alert helps in identifying campaigns that are at risk of exceeding their budget, allowing for timely adjustments to prevent overspending and optimize budget allocation.

Walking Through the Code

  1. Data Preparation:
    • The script begins by converting the ‘iDNE’ column to numeric values to ensure accurate calculations. This step handles any non-numeric data by coercing it into a numeric format, which is essential for subsequent operations.
  2. Calculation of Ratios:
    • It calculates the ratio of publisher cost to the daily budget for each campaign. This ratio helps in determining how close the spending is to the allocated budget.
  3. Setting Thresholds and Conditions:
    • A threshold of 90% is set, which can be adjusted by the user. Campaigns that meet or exceed this threshold and have an ‘iDNE’ value less than 1.5, along with a ‘Lost Impression Share’ greater than 10%, are flagged with a “Budget Capped” alert.
  4. Output Preparation:
    • The script filters the relevant columns and prepares the output DataFrame, which includes the account, campaign, and budget alert status, providing a clear view of campaigns that require attention.

Vitals

  • Script ID : 867
  • Client ID / Customer ID: 247885838 / 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:37
  • Last Updated by Stephen Malina on 2024-04-23 20:44
> 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

comments powered by Disqus