Purpose:

The Python script processes input data to generate an output with specific default values for certain columns related to advertising campaigns.

To Elaborate

The Python script is designed to process a dataset related to advertising campaigns by copying specific columns from an input DataFrame to an output DataFrame and assigning default values to certain columns. The script focuses on setting up structured data for advertising purposes, ensuring that each campaign entry has predefined values for search bids, alternative product requirements, and custom parameters. This setup is crucial for maintaining consistency across advertising campaigns and ensuring that all necessary parameters are included for effective campaign management.

Walking Through the Code

1. Data Copying:
   • The script begins by copying specific columns from the input DataFrame (inputDf) to the output DataFrame (outputDf). These columns include ‘Account’, ‘Campaign’, and ‘Group’. This step ensures that the essential identifiers for each campaign are retained in the output.
2. Setting Default Values:
   • The script assigns default values to several columns in the outputDf:
     • ‘Search Bid’ is set to ‘0.5’, which likely represents a default bid amount for search advertising.
     • ‘altproducttag’ is set to ‘#pdpSection_PFProdSubstit’, indicating a tag used for alternative product sections.
     • ‘Alternative Product Required’ is set to “true”, suggesting that alternative products are necessary for the campaigns.
     • ‘Custom Parameters’ is set to ‘{_altproduct}=[altproducttag]’, which is a placeholder for custom parameters related to alternative products.
3. Output Preparation:
   • The script prepares the output DataFrame with the specified default values, ensuring that the data is structured and ready for further processing or analysis.

Vitals

• Script ID : 317
• Client ID / Customer ID: 1306923155 / 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-09-22 13:32
• 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