Purpose:

The Python script generates negative keywords for single keyword campaigns by cross-negating keywords within each account.

To Elaborate

The script addresses the need to optimize advertising campaigns by generating negative keywords for single keyword campaigns within each account. This process involves identifying keywords that should not trigger ads, thereby preventing unnecessary ad spend and improving targeting efficiency. The script groups data by account and iterates through each keyword, creating a list of negative keywords by excluding the current keyword from the list of all keywords within the same account. This ensures that ads are not shown for irrelevant searches, enhancing the overall performance of the campaign.

Walking Through the Code

1. Initialization: The script begins by defining column names for the report, which are used to access specific data fields in the input DataFrame.

2. Function Definition: The generate_negative_keywords function is defined to process the input DataFrame and generate negative keywords for each account. It initializes an empty list to store negative keywords.

3. Grouping Data: The input data is grouped by the account column, allowing the script to process each account separately.

4. Iterating Over Accounts: For each account, the script initializes a list to store negative keywords specific to that account. It then iterates over each keyword in the account.

5. Generating Negative Keywords: For each keyword, the script identifies all other keywords within the same account and appends them as negative keywords, ensuring they are marked with ‘Exact’ match type.

6. Compiling Results: The negative keywords for each account are compiled into a single list, which is returned by the function.

7. Output: The script prints the generated negative keywords, displaying relevant information such as account, campaign, group, and match type.

Vitals

• Script ID : 827
• Client ID / Customer ID: 1306922797 / 60269073
• Action Type: Bulk Upload (Preview)
• Item Changed: Keyword
• Output Columns: Account, Campaign, Group, Keyword, Match Type, Status
• Linked Datasource: M1 Report
• Reference Datasource: None
• Owner: Grégory Pantaine (gpantaine@marinsoftware.com)
• Created by Grégory Pantaine on 2024-03-20 12:07
• Last Updated by Grégory Pantaine on 2024-03-20 12:16

> 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
49
50
# Define report column names
RPT_COL_KEYWORD = 'Keyword'
RPT_COL_STATUS = 'Status'
RPT_COL_MATCH_TYPE = 'Match Type'
RPT_COL_ACCOUNT = 'Account'
RPT_COL_CAMPAIGN = 'Campaign'
RPT_COL_GROUP = 'Group'

# Function to generate negative keywords for each account
def generate_negative_keywords(input_df):
    # Initialize an empty list to store negative keywords for each account
    negative_keywords_by_account = []

    # Group data by account
    grouped_data = input_df.groupby(RPT_COL_ACCOUNT)
    
    # Iterate over each group (account)
    for account, group in grouped_data:
        # Initialize an empty list to store negative keywords for the current account
        negative_keywords_for_account = []

        # Iterate over each row in the group (account)
        for index, row in group.iterrows():
            # Get the current keyword
            current_keyword = row[RPT_COL_KEYWORD]

            # Get all other keywords in the account except the current one
            other_keywords = group[group[RPT_COL_KEYWORD] != current_keyword][RPT_COL_KEYWORD].unique()

            # Append other keywords as negative keywords for the current keyword
            for other_keyword in other_keywords:
                negative_keywords_for_account.append({
                    'Negative Keyword': other_keyword,
                    'Account': account,
                    'Campaign': row[RPT_COL_CAMPAIGN],
                    'Group': row[RPT_COL_GROUP],
                    'Match Type': 'Exact'
                })
        
        # Extend the list of negative keywords for the account
        negative_keywords_by_account.extend(negative_keywords_for_account)

    return negative_keywords_by_account

# Generate negative keywords for all accounts
all_negative_keywords = generate_negative_keywords(inputDf)

# Print the negative keywords
for keyword_info in all_negative_keywords:
    print(f"Negative Keyword: {keyword_info['Negative Keyword']}, Account: {keyword_info['Account']}, Campaign: {keyword_info['Campaign']}, Group: {keyword_info['Group']}, Match Type: {keyword_info['Match Type']}")

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