Purpose:

The Python script automates the process of setting dimensions based on campaign names for marketing campaigns.

To Elaborate

The script is designed to automate the assignment of specific tactics to marketing campaigns based on the campaign names. It processes a dataset containing campaign information and updates the tactic field according to predefined rules. The script identifies campaigns with names containing specific keywords and assigns corresponding tactic labels. This automation helps streamline the process of categorizing campaigns, ensuring that each campaign is tagged with the appropriate tactic for reporting and analysis purposes. The script focuses on campaigns that have undergone changes in their strategy, ensuring that only those with updated tactics are included in the final output.

Walking Through the Code

1. Initialization and Setup
   • The script begins by defining constants for column names used in the input and output dataframes.
   • A temporary field is created to store new tactic values.
2. Processing Campaign Names
   • The script initializes the temporary field with NaN values.
   • It then checks each campaign name for specific keywords (e.g., ‘KW-Defense’, ‘PAT-Defense’) and assigns a corresponding tactic to the temporary field.
3. Updating and Filtering Data
   • The script updates the output dataframe with new tactic values from the temporary field.
   • It filters the output to include only campaigns with changed tactics, ensuring that only relevant updates are processed further.

Vitals

• Script ID : 739
• Client ID / Customer ID: 1306927405 / 60270279
• Action Type: Bulk Upload (Preview)
• Item Changed: Campaign
• Output Columns: Account, Campaign, Tactic
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Grégory Pantaine (gpantaine@marinsoftware.com)
• Created by Grégory Pantaine on 2024-03-04 15:29
• Last Updated by Grégory Pantaine on 2024-03-04 15:29

> 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
# Author: Gregory Pantaine
# Created: 2024-03-04
# Description: set dimensions based on campaign name
# Scripts name: Automate-Campaigns-DimensionTag-Tactic
# Report name (M1): Automate-Campaigns-SetDimensionTactic


RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_PUB_NAME = 'Publisher Name'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_TACTIC = 'Tactic'
BULK_COL_ACCOUNT = 'Account'
BULK_COL_PUB_NAME = 'Publisher Name'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_TACTIC = 'Tactic'

#outputDf[BULK_COL_TACTIC] = "<<YOUR VALUE>>"

today = datetime.datetime.now(CLIENT_TIMEZONE).date()
print(tableize(inputDf))



TMP_FIELD = BULK_COL_TACTIC + '_new'
# blank out tmp field
inputDf[TMP_FIELD] = numpy.nan
inputDf.loc[ (inputDf[RPT_COL_CAMPAIGN].str.contains('KW-Defense', case=False)) , TMP_FIELD ] = 'KW Defense'
inputDf.loc[ (inputDf[RPT_COL_CAMPAIGN].str.contains('PAT-Defense', case=False)) , TMP_FIELD ] = 'PAT Defense'
inputDf.loc[ (inputDf[RPT_COL_CAMPAIGN].str.contains('SBV-PAT-Defense', case=False)) , TMP_FIELD ] = 'SBV PAT Defense'
inputDf.loc[ (inputDf[RPT_COL_CAMPAIGN].str.contains('SD-Defense', case=False)) , TMP_FIELD ] = 'SD Defense'

print(tableize(inputDf))

print(inputDf.index.duplicated())

# copy new strategy to output
outputDf.loc[:,BULK_COL_TACTIC] = inputDf.loc[:, TMP_FIELD]

# only include campaigns with changed strategy in bulk file
outputDf = outputDf[ inputDf[TMP_FIELD].notnull() & (inputDf[BULK_COL_TACTIC] != inputDf[TMP_FIELD]) ]

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