Purpose:

The Python script ensures that the SBA Pause Date remains within one month of the current date to allow the tool to unpause it.

To Elaborate

The script is designed to maintain the SBA Pause Date within a specific timeframe, ensuring it is not older than one month from the current date. This is crucial for the functionality of a tool that requires the option to unpause certain budget allocations. The script processes data related to campaigns and accounts, specifically focusing on the pause and end dates of SBA buckets. It filters and updates these dates based on predefined conditions, such as whether the end date is still valid and if the pause date is populated. The script ultimately updates the pause date for eligible buckets, ensuring they remain within the allowable timeframe for unpausing.

Walking Through the Code

1. Initialization and Setup
   • The script begins by defining constants for column names related to campaigns, accounts, and SBA bucket details.
   • A temporary field is initialized to store new campaign data, and the current date is captured for calculations.
2. Data Preparation
   • The script converts relevant date columns to datetime format to facilitate date comparisons.
   • It extracts and processes the pause date to ensure it is in the correct format.
3. Filtering and Updating
   • The script filters the data to include only those buckets where the end date is valid (greater than or equal to today) and the pause date is populated.
   • It updates the pause date for buckets where the existing pause date is older than the calculated date threshold (one week before today).
4. Output Preparation
   • The script prepares the output data by including only those entries where the pause date has been updated.
   • It sets the new pause date in the output data, ensuring it reflects the updated values for eligible buckets.

Vitals

• Script ID : 227
• Client ID / Customer ID: 1306923673 / 60269245
• Action Type: Bulk Upload
• Item Changed: Campaign
• Output Columns: Account, Campaign, SBA Pause Date
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Jonathan Reichl (jreichl@marinsoftware.com)
• Created by Jonathan Reichl on 2023-06-29 14:03
• Last Updated by Jonathan Reichl on 2023-12-06 04:01

> 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
46
47
48
49
50
51
52
53
54
55
56
57
58
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_SBA_BUCKETNAME = 'SBA Bucket Name'
RPT_COL_SBA_PAUSEDATE = 'SBA Pause Date'
RPT_COL_SBA_BUCKET_END_DATE = 'SBA Bucket End Date'
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_SBA_PAUSEDATE = 'SBA Pause Date'

outputDf[BULK_COL_SBA_PAUSEDATE] = "<<YOUR VALUE>>"

TMP_FIELD = BULK_COL_CAMPAIGN + '_new'
# blank out tmp field
inputDf[TMP_FIELD] = np.nan

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

# Calculating the date threshold
date_threshold = today - datetime.timedelta(days=7)

print(tableize(inputDf))

# Convert 'RPT_COL_SBA_BUCKET_END_DATE' to date type
inputDf[RPT_COL_SBA_BUCKET_END_DATE] = pd.to_datetime(inputDf[RPT_COL_SBA_BUCKET_END_DATE])

# Extract first 10 characters from 'RPT_COL_SBA_PAUSEDATE'
inputDf[RPT_COL_SBA_PAUSEDATE] = inputDf[RPT_COL_SBA_PAUSEDATE].str[:10]

# Convert 'RPT_COL_SBA_PAUSEDATE' to datetime type
inputDf[RPT_COL_SBA_PAUSEDATE] = pd.to_datetime(inputDf[RPT_COL_SBA_PAUSEDATE])

column_types = inputDf.dtypes
print(column_types)

# Only update buckets where the end date is greater than or equal to today
inputDf = inputDf[inputDf[RPT_COL_SBA_BUCKET_END_DATE].dt.date >= today]

# Only update buckets where pause date is populated
inputDf = inputDf[inputDf[RPT_COL_SBA_PAUSEDATE].notna()]

# Update the pause date for buckets where the pause date is lessthan  than the date threshold
inputDf.loc[inputDf[RPT_COL_SBA_PAUSEDATE] < pd.Timestamp(date_threshold), TMP_FIELD] = today - datetime.timedelta(days=1)

print(column_types)
print(tableize(inputDf))




# only include where pasue date is updated 
outputDf = inputDf[ inputDf[TMP_FIELD].notnull() & (inputDf[RPT_COL_SBA_PAUSEDATE] != inputDf[TMP_FIELD]) ]

# set new pause date in output 
outputDf.loc[:,BULK_COL_SBA_PAUSEDATE] = inputDf.loc[:, TMP_FIELD]

print(column_types)
print(tableize(outputDf))

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