Purpose:

The script updates the ‘Campaign CPA This Quarter’ column with the current quarter’s CPA values for each campaign.

To Elaborate

The Python script is designed to manage and update campaign-level cost-per-acquisition (CPA) data for the current quarter. It takes the CPA values from a specified column in the input data and sets these values in the ‘Campaign CPA This Quarter’ column. This process ensures that the campaign’s performance metrics are accurately reflected for the current quarter, allowing for better budget allocation and performance tracking. The script is part of a larger system that likely involves regular updates and adjustments to campaign data, ensuring that the most recent and relevant information is available for decision-making.

Walking Through the Code

1. Data Source Initialization: The script begins by defining the primary data source, inputDf, which contains the campaign data. This data is accessed from a dictionary, dataSourceDict, using a specific key.

2. Column Definitions: Several constants are defined to represent the names of the columns used in the script. These include columns for campaign, account, and CPA values.

3. Data Copying: The script creates a copy of the input data, outputDf, to ensure that the original data remains unchanged while modifications are made to the copy.

4. CPA Value Assignment: The script assigns the CPA values from the ‘All - Complete Registration - CPA’ column in the input data to the ‘Campaign CPA This Quarter’ column in the output data. This step updates the CPA values for the current quarter.

5. Output Display: Finally, the script prints a formatted version of the output DataFrame, allowing users to review the updated data.

Vitals

• Script ID : 1065
• Client ID / Customer ID: 1306927809 / 60270355
• Action Type: Bulk Upload
• Item Changed: Campaign
• Output Columns: Account, Campaign, Campaign CPA This Quarter
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Grégory Pantaine (gpantaine@marinsoftware.com)
• Created by Grégory Pantaine on 2024-05-10 15:36
• Last Updated by Grégory Pantaine on 2024-05-15 12:24

> 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
## name: Script - Campaign - CPA This Quarter - Set
##
## description: Take CPA for this Quarter and set the value in the 'Campaign CPA This Quarter' column.
## Copied & adjusted by Grég P.
## created: 2024-05-10

# Primary data source and columns
inputDf = dataSourceDict["1"]

# Output columns and initial values
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_COMPLETE_REGISTRATION_CPA = 'All - Complete Registration - CPA'
RPT_COL_CAMPAIGN_CPA_QUARTER = 'Campaign CPA This Quarter'
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_CAMPAIGN_CPA_QUARTER = 'Campaign CPA This Quarter'

# Copy input data to output
outputDf = inputDf.copy()

# Copy values from 'Strategy' column to 'SBA Strategy' column
outputDf[RPT_COL_CAMPAIGN_CPA_QUARTER] = inputDf[RPT_COL_COMPLETE_REGISTRATION_CPA]

# Print the tableized version of the output DataFrame
print(tableize(outputDf))

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