Purpose:

The script updates custom parameters for keywords with specific tags in the landing page result column.

To Elaborate

The Python script is designed to update custom parameters for keywords that contain specific tags such as NOLS, NOLM, or Backorder in the landing page result column. This is likely part of a larger process to manage and optimize keyword campaigns by ensuring that certain parameters are set correctly for specific conditions. The script modifies several columns in a dataset, including setting a fixed search bid, tagging alternative products, and marking whether an alternative product is required. These updates are crucial for maintaining the accuracy and effectiveness of keyword campaigns, particularly in scenarios where product availability or alternative options need to be communicated clearly.

Walking Through the Code

1. Initialization: The script begins by defining constants for column names, which are used to identify and manipulate specific columns in the dataset.

2. Data Copying: It copies relevant columns from the input dataset to the output dataset. This ensures that the output retains necessary information from the input while allowing for modifications.

3. Parameter Updates:
   • The search bid for each entry is set to a fixed value of ‘0.5’.
   • The alternative product tag is updated to a specific string, indicating a section for product substitution.
   • The script marks the ‘Alternative Product Required’ column as “true” to signify that an alternative product is necessary.
   • Custom parameters are updated to include a placeholder for alternative product tags.
4. Output Preparation: The script prepares the modified dataset for further processing or output, ensuring that all necessary updates are applied consistently across the dataset.

Vitals

• Script ID : 271
• Client ID / Customer ID: 1306917941 / 64302
• Action Type: Bulk Upload
• Item Changed: AdGroup
• Output Columns: Account, Campaign, Group, Custom Parameters, Alternative Product Required, altproducttag
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Tom McCaughey (tmccaughey@marinsoftware.com)
• Created by Tom McCaughey on 2023-08-03 10:04
• 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