Purpose:

The Python script processes input data to set specific parameters for product substitution in a marketing campaign.

To Elaborate

The Python script is designed to manage and update marketing campaign data by setting specific parameters related to product substitution. It takes input data, presumably from a marketing database or spreadsheet, and modifies certain fields to ensure that alternative products are highlighted when the original products are unavailable. This is crucial for maintaining campaign effectiveness and customer satisfaction by ensuring that potential buyers are always presented with viable product options. The script sets a fixed search bid, tags products for substitution, and marks the requirement for alternative products, thereby facilitating structured budget allocation (SBA) for marketing efforts.

Walking Through the Code

1. Data Copying and Initialization:
   • The script begins by copying relevant columns from the input data to the output data frame. This includes columns like ‘Account’, ‘Campaign’, and ‘Group’, which are essential for identifying and categorizing marketing efforts.
2. Parameter Setting:
   • The script sets a fixed search bid value of ‘0.5’, which likely represents the cost per click or bid amount for search engine marketing.
   • It assigns a specific tag ‘#pdpSection_PFProdSubstit’ to the ‘altproducttag’ column, indicating that these products are flagged for substitution.
   • The ‘Alternative Product Required’ column is set to “true”, signaling that alternative products should be considered when the primary product is unavailable.
   • Custom parameters are defined in the ‘Custom Parameters’ column, using a structured format to link alternative product tags with their respective identifiers.

These steps ensure that the marketing campaign data is prepared for scenarios where product substitution is necessary, optimizing the allocation of marketing resources.

Vitals

• Script ID : 307
• Client ID / Customer ID: 1306917943 / 64302
• Action Type: Bulk Upload
• Item Changed: AdGroup
• Output Columns: Account, Campaign, Group, Custom Parameters, altproducttag, Alternative Product Required
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Tom McCaughey (tmccaughey@marinsoftware.com)
• Created by Tom McCaughey on 2023-09-22 10:22
• Last Updated by Tom McCaughey 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
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_GROUP = 'Group'
BULK_COL_CUSTOM_PARAMETERS = 'Custom Parameters'
BULK_COL_ALTERNATIVE_PRODUCTREQUIRED = 'Alternative Product Required'
BULK_COL_ALTPRODUCTTAG = 'altproducttag'
BULk_COL_SEARCH_BID = 'Search Bid'

# copy all input rows to output
#outputDf = inputDf.copy()
outputDf[BULK_COL_ACCOUNT] = inputDf[BULK_COL_ACCOUNT]
outputDf[BULK_COL_CAMPAIGN] = inputDf[BULK_COL_CAMPAIGN]
outputDf[BULK_COL_GROUP] = inputDf[BULK_COL_GROUP]
outputDf[BULk_COL_SEARCH_BID] = '0.5'
outputDf[BULK_COL_ALTPRODUCTTAG] = '#pdpSection_PFProdSubstit'
outputDf[BULK_COL_ALTERNATIVE_PRODUCTREQUIRED] = "true"
outputDf[BULK_COL_CUSTOM_PARAMETERS] = '{_altproduct}=[altproducttag]'

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

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