GET https://api.scrunchai.com/v1/brands Authorization: Bearer YOUR_API_KEY

GET https://api.scrunchai.com/v1/{brand_id}/responses?limit=1000&offset=0&start_date=2025-10-20&end_date=2025-10-27

timestamp              : dateTime
_id                    : string        (required for ExperienceEvent)
eventType              : string        (e.g., "scrunch.ai.response")
aiPlatform             : string
promptId               : string
promptText             : string
personaName            : string
country                : string
brandPresencePct       : double
brandPositionScore     : double
brandSentimentScore    : double
responses              : long
```

**For Responses API integration, add these additional fields**:
```
responseId             : string
createdAt              : dateTime
brandPresent           : boolean
brandPosition          : string        (enum: Top, Middle, Bottom)
brandSentiment         : string        (enum: Positive, Mixed, Negative, None)
competitorsPresent     : string[]      (array of competitor names)
responseText           : string
citations              : object[]      (array of citation objects)
  ├─ url               : string
  ├─ title             : string
  ├─ snippet           : string
  ├─ sourceType        : string        (enum: Brand, Competitor, Other)
  └─ domain            : string

import requests
import json
import datetime

# Configuration
SCRUNCH_API_KEY = "YOUR_SCRUNCH_API_KEY"
SCRUNCH_BRAND_ID = "YOUR_BRAND_ID"  # Get from GET /v1/brands endpoint
AEP_INGEST_URL = "https://platform.adobe.io/data/foundation/import/batches"
AEP_DATASET_ID = "YOUR_AEP_DATASET_ID"

# Set date range (last 7 days)
# Note: API only retains last 90 days of data
end_date = datetime.date.today()
start_date = end_date - datetime.timedelta(days=7)

# 1. Fetch data from Scrunch Query API
# Must specify fields parameter for dimensions and metrics you want
resp = requests.get(
    f"https://api.scrunchai.com/v1/{SCRUNCH_BRAND_ID}/query",
    headers={"Authorization": f"Bearer {SCRUNCH_API_KEY}"},
    params={
        "start_date": start_date.strftime("%Y-%m-%d"),
        "end_date": end_date.strftime("%Y-%m-%d"),
        "fields": "date,ai_platform,prompt_id,prompt,persona_name,country,responses,brand_presence_percentage,brand_position_score,brand_sentiment_score"
    }
)

if resp.status_code != 200:
    print(f"Error fetching data: {resp.status_code}")
    print(resp.text)
    exit(1)

# Parse response - Query API returns array directly
data = resp.json()

# Verify data structure
if not isinstance(data, list):
    print(f"Unexpected response format: {type(data)}")
    print("Response:", json.dumps(data, indent=2)[:500])
    exit(1)

print(f"Retrieved {len(data)} records from Scrunch")

# 2. Transform to XDM ExperienceEvent format
events = []
for row in data:
    # Handle potential null values
    events.append({
        "timestamp": row.get("date"),
        "aiPlatform": row.get("ai_platform", "Unknown"),
        "promptId": str(row.get("prompt_id", "")),
        "promptText": row.get("prompt", ""),
        "personaName": row.get("persona_name"),
        "country": row.get("country"),
        "responses": int(row.get("responses", 0)),
        "brandPresencePct": float(row.get("brand_presence_percentage", 0)),
        "brandPositionScore": float(row.get("brand_position_score", 0)) if row.get("brand_position_score") is not None else None,
        "brandSentimentScore": float(row.get("brand_sentiment_score", 0)) if row.get("brand_sentiment_score") is not None else None
    })

# 3. Write to JSON file for batch upload
output_file = "scrunch_batch.json"
with open(output_file, "w") as f:
    json.dump(events, f, indent=2)

print(f"Successfully transformed {len(events)} records to {output_file}")

# 4. Upload to AEP batch ingestion endpoint
# (See Adobe's AEP Batch Ingestion API docs for authentication and upload syntax)
# You'll need to:
# - Create a batch
# - Upload the file
# - Signal batch completion

Date,AI Platform,Prompt ID,Country,Responses,Brand Presence %,Brand Position Score 2025-10-26,ChatGPT,12345,US,200,65,82

scrunch_adobe_integration/
│
├── etl.py                # Fetch + transform + upload
├── config.json           # API keys, dataset IDs
├── schemas/
│   └── scrunch_xdm.json  # XDM field definitions
├── outputs/
│   ├── scrunch_batch.json
│   └── scrunch_bdia.csv
└── README.md