Purpose:

The Python script is designed to clear the ‘Conversion Influencers’ dimension values in a dataset.

To Elaborate

The script is intended to reset or clear the ‘Conversion Influencers’ dimension values in a given dataset. This is likely part of a larger process where the dataset is prepared for further analysis or processing, ensuring that only a specific number of keywords are labeled in subsequent operations. By clearing these values, the script ensures that the dataset is in a clean state, ready for the next day’s dimension script to run without any leftover data from previous operations. This is particularly useful in environments where data integrity and accuracy are critical, such as in marketing or advertising analytics, where conversion data needs to be accurately tracked and reported.

Walking Through the Code

1. Data Preparation:
   • The script begins by creating a copy of the input DataFrame (inputDf) to ensure that the original data remains unchanged. This is stored in outputDf.
2. Clearing Dimension Values:
   • The script then sets the ‘Conversion Influencers’ column in the outputDf DataFrame to an empty string. This effectively clears any existing values in this column, preparing it for new data.
3. Output:
   • Finally, the script prints the modified DataFrame (outputDf) to the console, allowing the user to verify that the ‘Conversion Influencers’ values have been successfully cleared.

Vitals

• Script ID : 331
• Client ID / Customer ID: 1306926109 / 60269815
• Action Type: Bulk Upload
• Item Changed: Keyword
• Output Columns: Account, Campaign, Group, Keyword, Match Type, Conversion Influencers
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Byron Porter (bporter@marinsoftware.com)
• Created by Byron Porter on 2023-10-04 23:27
• Last Updated by Byron Porter 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
22
23
RPT_COL_KEYWORD = 'Keyword'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_GROUP = 'Group'
RPT_COL_MATCH_TYPE = 'Match Type'
RPT_COL_CONVERSION_INFLUENCERS = 'Conversion Influencers'
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_GROUP = 'Group'
BULK_COL_KEYWORD = 'Keyword'
BULK_COL_MATCH_TYPE = 'Match Type'
BULK_COL_CONVERSION_INFLUENCERS = 'Conversion Influencers'


# Assign current date to a parameter
today = datetime.datetime.now(CLIENT_TIMEZONE).date()

# blank out existing dimension values so that there are only 10 keywords labeled once the next day's dimension script runs
outputDf = inputDf.copy()
outputDf[BULK_COL_CONVERSION_INFLUENCERS] = ""

print("outputDf", tableize(outputDf))

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