The Complete Guide to Shopify in 2026: Enterprise Architecture, Checkout Extensibility & GraphQL Scaling

Python SP-API Search Term Harvester & Negative Isolation

import requests
import json

def process_search_term_harvesting(
    api_endpoint: str,
    access_token: str,
    profile_id: str,
    auto_campaign_id: str,
    exact_campaign_id: str,
    exact_ad_group_id: str,
    conversion_threshold: int = 3,
    target_acos_limit: float = 0.30
):
    """
    Parses Amazon Ad API Search Term Reports.
    Promotes qualifying terms (Conversions >= Threshold & ACOS <= Limit) to Exact Match
    and applies Negative Exact Isolation to the source Auto Campaign.
    """
    headers = {
        "Authorization": f"Bearer {access_token}",
        "Amazon-Advertising-API-Scope": profile_id,
        "Content-Type": "application/json"
    }

    # Step 1: Query Search Term Report Data (Simulated Payload Parse)
    report_data = [
        {"query": "organic espresso beans 2lb", "clicks": 14, "orders": 4, "spend": 18.20, "sales": 80.00},
        {"query": "dark roast coffee whole bean", "clicks": 25, "orders": 1, "spend": 32.50, "sales": 20.00}
    ]

    for row in report_data:
        query = row["query"]
        orders = row["orders"]
        spend = row["spend"]
        sales = row["sales"]
        acos = spend / sales if sales > 0 else 999.0

        # Evaluate eligibility criteria
        if orders >= conversion_threshold and acos <= target_acos_limit:
            print(f"Harvesting Query: '{query}' (Orders: {orders}, ACOS: {acos:.2%})")

            # Step 2: Create Exact Match Target in Scaling Campaign
            exact_keyword_payload = {
                "keywords": [{
                    "campaignId": exact_campaign_id,
                    "adGroupId": exact_ad_group_id,
                    "state": "enabled",
                    "keywordText": query,
                    "matchType": "exact",
                    "bid": 1.85 # Initial scaling bid
                }]
            }
            res_exact = requests.post(
                f"{api_endpoint}/v2/sp/keywords", 
                headers=headers, 
                data=json.dumps(exact_keyword_payload)
            )
            
            # Step 3: Apply Negative Exact Isolation to Source Auto Campaign
            negative_payload = {
                "negativeKeywords": [{
                    "campaignId": auto_campaign_id,
                    "state": "enabled",
                    "keywordText": query,
                    "matchType": "negativeExact"
                }]
            }
            res_neg = requests.post(
                f"{api_endpoint}/v2/sp/negativeKeywords", 
                headers=headers, 
                data=json.dumps(negative_payload)
            )
            
            print(f"Successfully Promoted '{query}' & Isolated in Source Campaign.")

# Execute Pipeline
process_search_term_harvesting(
    api_endpoint="https://advertising-api.amazon.com",
    access_token="Atzr|IwEBI...",
    profile_id="12345678901234",
    auto_campaign_id="987654321",
    exact_campaign_id="456789123",
    exact_ad_group_id="11223344",
    conversion_threshold=3,
    target_acos_limit=0.30
)