Purpose:

Calculate the percentage difference between the current daily budget and the SBA recommended daily budget for campaigns.

To Elaborate

The Python script is designed to compute the percentage difference between the current daily budget and the SBA recommended daily budget for various campaigns. This calculation helps in understanding how much the current budget deviates from the recommended budget, expressed as a percentage. The script processes data from a primary data source, performs calculations, and formats the results for easy interpretation. The output includes essential columns such as account, campaign, SBA strategy, and the calculated percentage budget difference, which is rounded to two decimal places and appended with a ‘%’ sign for clarity.

Walking Through the Code

1. Data Preparation:
   • The script begins by accessing the primary data source, which contains information about campaigns, accounts, and budget details.
   • It identifies key columns such as ‘Campaign’, ‘Account’, ‘Rec. Daily Budget’, and ‘Current Daily Budget’.
2. Calculation of Percentage Budget Difference:
   • For each row in the data, the script calculates the percentage budget difference using the formula: (Budget Difference / Rec. Daily Budget) * 100.
   • The calculated values are rounded to two decimal places for precision.
3. Formatting and Output:
   • The percentage values are converted to strings and appended with a ‘%’ sign to indicate they are percentages.
   • The script selects specific columns for the output, ensuring that only relevant information is presented.
   • Finally, it renames the columns for consistency and prints the first few rows of the output DataFrame for verification.

Vitals

• Script ID : 985
• Client ID / Customer ID: 1306926629 / 60270083
• Action Type: Bulk Upload (Preview)
• Item Changed: Campaign
• Output Columns: Account, Campaign, Percentage Budget Difference
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: dwaidhas@marinsoftware.com (dwaidhas@marinsoftware.com)
• Created by dwaidhas@marinsoftware.com on 2024-04-18 20:48
• Last Updated by dwaidhas@marinsoftware.com on 2024-04-18 21:41

> 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
39
40
41
42
43
44
45
##
## name: Percentage Budget Difference CC
## description:
##  This Script helps us calculate the Percentage of the Budget Difference between Current Daily Budget and the SBA Recommended Daily Budget 
## 
## author: Dana Waidhas 
## created: 2024-04-18
## 

today = datetime.datetime.now(CLIENT_TIMEZONE).date()

# primary data source and columns
inputDf = dataSourceDict["1"]
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_CAMPAIGN_STATUS = 'Campaign Status'
RPT_COL_SBA_STRATEGY = 'SBA Strategy'
RPT_COL_REC_DAILY_BUDGET = 'Rec. Daily Budget'
RPT_COL_CURRENT_DAILY_BUDGET = 'Current Daily Budget'
RPT_COL_BUDGET_DIFFERENCE = 'Budget Difference'


# output columns and initial values
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE = 'Percentage Budget Difference'


# Calculate percentage budget difference for each row
inputDf[BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE] = (inputDf[RPT_COL_BUDGET_DIFFERENCE] / inputDf['Rec. Daily Budget']) * 100

# Round the percentage budget difference column to two decimal places
inputDf[BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE] = inputDf[BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE].round(2)

# Append '%' to the percentage budget difference values
inputDf[BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE] = inputDf[BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE].astype(str) + '%'

# Select required columns for output
outputDf = inputDf[[RPT_COL_ACCOUNT, RPT_COL_CAMPAIGN, RPT_COL_SBA_STRATEGY, BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE]]

# Rename columns
outputDf.columns = [BULK_COL_ACCOUNT, BULK_COL_CAMPAIGN, RPT_COL_SBA_STRATEGY, BULK_COL_PERCENTAGE_BUDGET_DIFFERENCE]

# Print output DataFrame
print(outputDf.head())

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