Purpose:

The Python script categorizes PPC scores into letter grades ranging from A to D based on predefined score ranges.

To Elaborate

The script is designed to categorize Pay-Per-Click (PPC) scores into letter grades from A to D. This categorization is based on specific score ranges, which are used to evaluate the effectiveness of PPC campaigns. The script processes a dataset containing PPC scores and assigns a corresponding letter grade to each score. This grading system helps in quickly assessing the performance of various campaigns, allowing for easier analysis and decision-making. The script takes input data, applies a grading function, and outputs the results with the assigned grades.

Walking Through the Code

1. Data Preparation:
   • The script begins by defining the primary data source and relevant columns, such as ‘Campaign’, ‘Account’, ‘Campaign ID’, and ‘PPC Score’.
2. Define Grading Function:
   • A function get_bulk_col_ppc_grade is defined to categorize PPC scores into grades A, B, C, or D based on specific score ranges.
   • The function checks the score and returns the corresponding grade.
3. Apply Grading Function:
   • The script applies the grading function to the ‘PPC Score’ column of the input DataFrame, creating a new column ‘PPC Grade’ with the assigned grades.
4. Prepare Output:
   • The script selects the necessary columns for the output, including ‘Account’, ‘Campaign’, ‘Campaign ID’, and ‘PPC Grade’.
   • It renames the columns to ensure consistency and clarity in the output DataFrame.
5. Display Results:
   • Finally, the script prints the first few rows of the output DataFrame to display the results of the grading process.

Vitals

• Script ID : 1345
• Client ID / Customer ID: 1306926629 / 60270083
• Action Type: Bulk Upload
• Item Changed: Campaign
• Output Columns: Account, Campaign, Campaign ID, PPC Grade
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: ascott@marinsoftware.com (ascott@marinsoftware.com)
• Created by ascott@marinsoftware.com on 2024-08-23 13:01
• Last Updated by ascott@marinsoftware.com on 2024-09-06 19:17

> 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
41
42
43
44
45
46
47
48
## name: Set PPC Rank
## description:
##  This Script categorizes PPC scores into letter scores A - D
## 
## author: Adam Scott
## created: 8/22/2024
## 

today = datetime.datetime.now(CLIENT_TIMEZONE).date()

# primary data source and columns
inputDf = dataSourceDict["1"]
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_CAMPAIGN_ID = 'Campaign ID'
RPT_COL_PPC_SCORE = 'PPC Score'

# output columns and initial values
BULK_COL_ACCOUNT = 'Account'
BULK_COL_CAMPAIGN = 'Campaign'
BULK_COL_CAMPAIGN_ID = 'Campaign ID'
BULK_COL_PPC_GRADE = 'PPC Grade'

# Caclcuate PPC Rank based on PPC Score
def get_bulk_col_ppc_grade(rpt_col_ppc_score):
    if 4 <= rpt_col_ppc_score <= 12:
        return "A"
    elif 13 <= rpt_col_ppc_score <= 18:
        return "B"
    elif 19 <= rpt_col_ppc_score <= 22:
        return "C"
    elif 23 <= rpt_col_ppc_score <= 28:
        return "D"
    else:
        return ""

# Apply the function to calculate PPC Rank
inputDf[BULK_COL_PPC_GRADE] = inputDf[RPT_COL_PPC_SCORE].apply(get_bulk_col_ppc_grade)

# Select required columns for output
outputDf = inputDf[[RPT_COL_ACCOUNT, RPT_COL_CAMPAIGN, RPT_COL_CAMPAIGN_ID, BULK_COL_PPC_GRADE]]

# Rename columns
outputDf.columns = [BULK_COL_ACCOUNT, BULK_COL_CAMPAIGN, BULK_COL_CAMPAIGN_ID, BULK_COL_PPC_GRADE]

# Print output DataFrame
print(outputDf.head())

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