Script 1377: Target CPA Cap $1000

Purpose:

The Python script sets a Target CPA Cap of $1000 for all active strategies or campaigns where the current CPA exceeds this limit.

To Elaborate

The script is designed to enforce a Target Cost Per Acquisition (CPA) cap of $1000 on active advertising strategies or campaigns. It processes data from a primary source, identifying campaigns where the current CPA exceeds the specified cap. The script then adjusts the CPA to the cap value, ensuring that no campaign exceeds the $1000 limit. This helps in maintaining budget control and optimizing advertising spend across various campaigns. The script focuses on active strategies, ensuring that only relevant campaigns are considered for CPA adjustments. The final output highlights the campaigns where changes were made, providing a clear view of the adjustments applied.

Walking Through the Code

  1. Initialization:
    • The script begins by setting the current date using the client’s timezone.
    • It defines the primary data source and specifies the columns that will be used for processing, such as account, campaign, strategy, and CPA details.
  2. Data Preparation:
    • An output DataFrame is initialized by copying relevant columns from the input DataFrame. This includes account, campaign, campaign ID, and publisher target CPA.
  3. Applying CPA Cap Logic:
    • The script filters the output DataFrame to identify rows where the publisher’s target CPA exceeds $1000.
    • For these filtered rows, the CPA is capped at $1000, ensuring no campaign exceeds this limit.
  4. Output:
    • The script prints a table of the filtered DataFrame, showcasing only the campaigns where the CPA was adjusted to the cap.

Vitals

  • Script ID : 1377
  • Client ID / Customer ID: 1306926629 / 60270083
  • Action Type: Bulk Upload
  • Item Changed: Campaign
  • Output Columns: Account, Campaign, Publisher Target CPA, Campaign ID
  • Linked Datasource: M1 Report
  • Reference Datasource: None
  • Owner: dwaidhas@marinsoftware.com (dwaidhas@marinsoftware.com)
  • Created by dwaidhas@marinsoftware.com on 2024-09-06 16:51
  • Last Updated by dwaidhas@marinsoftware.com on 2024-09-12 18:53
> 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: TCPA Cap
## description:
##  This script helps us put a Target CPA Cap in place for all active Strategies / campaigns.
##
## author: Dana Waidhas
## created: 2024-09-06
##

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

# primary data source and columns
inputDf = dataSourceDict["1"]
RPT_COL_ACCOUNT = 'Account'
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_CAMPAIGN_STATUS = 'Campaign Status'
RPT_COL_PUBLISHER = 'Publisher'
RPT_COL_STRATEGY = 'Strategy'
RPT_COL_STRATEGY_TARGET = 'Strategy Target'
RPT_COL_PUBLISHER_BID_STRATEGY = 'Publisher Bid Strategy'
RPT_COL_PUBLISHER_TARGET_CPA = 'Publisher Target CPA'
RPT_COL_CAMPAIGN_ID = 'Campaign ID'
RPT_COL_CLICKS = 'Clicks'

# output columns and initial values
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_PUBLISHER_TARGET_CPA = 'Publisher Target CPA'
BULK_COL_CAMPAIGN_ID = 'Campaign ID'

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

# Apply TCPA cap logic and filter to show only changed rows
outputDf_filtered = outputDf[outputDf[RPT_COL_PUBLISHER_TARGET_CPA] > 1000].copy()
outputDf_filtered[BULK_COL_PUBLISHER_TARGET_CPA] = 1000

# Show only the campaigns where Target CPA was capped
print(tableize(outputDf_filtered.head()))

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

comments powered by Disqus