Purpose:

The script assigns the ‘Auto Pause Status’ of ‘traffic’ to new campaigns that are part of a strategy but have not yet been assigned this status.

To Elaborate

The Python script is designed to manage campaign statuses by automatically assigning an ‘Auto Pause Status’ of ‘traffic’ to campaigns that are newly assigned to a strategy. This ensures that these campaigns are correctly categorized and managed according to the business rules that require them to have this specific status. The script processes data from a primary data source, identifies relevant campaigns, and updates their status accordingly. This automation helps streamline campaign management and ensures consistency in how campaigns are handled within the system.

Walking Through the Code

1. Data Initialization: The script begins by defining the primary data source and the relevant columns needed for processing. It extracts data from a dictionary, dataSourceDict, which contains campaign information.

2. Output DataFrame Setup: An output DataFrame, outputDf, is initialized by copying specific columns from the input DataFrame. This includes the ‘Account’, ‘Campaign’, and ‘Campaign ID’ columns, which are essential for identifying and updating the campaigns.

3. Status Assignment: The script assigns the ‘Auto Pause Status’ of ‘traffic’ to all campaigns in the outputDf. This is a key business rule that ensures all new campaigns associated with a strategy are marked with this status.

4. Verification: Finally, the script prints the first few rows of the updated DataFrame to verify that the ‘Auto Pause Status’ has been correctly assigned to the campaigns.

Vitals

• Script ID : 1347
• Client ID / Customer ID: 1306927943 / 60270393
• Action Type: Bulk Upload (Preview)
• Item Changed: Campaign
• Output Columns: Account, Campaign, Auto Pause Status, Campaign ID
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: dwaidhas@marinsoftware.com (dwaidhas@marinsoftware.com)
• Created by dwaidhas@marinsoftware.com on 2024-08-27 19:42
• Last Updated by dwaidhas@marinsoftware.com on 2024-08-27 19:42

> 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
##
## name: Assign Campaigns with Auto Pause Status = traffic
## description:
##  Picks up all new campaigns that are assigned to a strategy and do not have the Auto Pause Status = Traffic Dimensions applied to them yet.
## 
## author: Dana Waidhas 
## created: 2024-08-27
## 

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

# primary data source and columns
inputDf = dataSourceDict["1"]
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_CAMPAIGN_ID = 'Campaign ID'
RPT_COL_CAMPAIGN_STATUS = 'Campaign Status'
RPT_COL_PUBLISHER = 'Publisher'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_STRATEGY = 'Strategy'
RPT_COL_AUTO_PAUSE_STATUS = 'Auto Pause Status'

# output columns and initial values
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_AUTO_PAUSE_STATUS = 'Auto Pause Status'
BULK_COL_CAMPAIGN_ID = 'Campaign ID'

# Initialize output dataframe from input dataframe
outputDf = inputDf[[RPT_COL_ACCOUNT, RPT_COL_CAMPAIGN, RPT_COL_CAMPAIGN_ID]].copy()

# Assign 'traffic' to 'Auto Pause Status' for all campaigns
outputDf[BULK_COL_AUTO_PAUSE_STATUS] = 'traffic'

# Print the resulting dataframe to verify the changes
print(tableize(outputDf.head()))

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