From AppsFlyer PA (Protected Apps) CSV exports, filter by channel and generate a styled Excel report with all original fields + highlighted fraud reason columns.
| File Type | PA Category | Description |
|---|---|---|
| ----------- | ------------- | ------------- |
blocked-installs | Install PA | Blocked install attempts |
detection | Install/Event PA | Detected fraud (check Event Name field) |
blocked-in-app-events | Event PA | Blocked in-app events |
fraud-post-inapps | Event PA | Post-install fraud detection |
| Field Name | Description |
|---|---|
| ------------ | ------------- |
| Blocked Reason | Primary fraud category (bots, fake_location, etc.) |
| Blocked Reason Value | Specific value of the fraud reason |
| Blocked Reason Rule | Rule name that triggered the block |
| Blocked Sub Reason | Secondary fraud detail |
| Rejected Reason | Rejection cause (for in-app events) |
| Rejected Reason Value | Specific rejection value |
Styling: Orange header (#FF8C00) + Light yellow background (#FFFFCC) for data cells.
1. Identify target channel and App ID
2. Configure script: TARGET_CHANNEL, FILES_CONFIG
3. For each CSV file type:
a. Read CSV with encoding auto-detection
b. Filter rows by channel match
c. Move 6 fraud reason columns to the end
d. Apply orange+yellow styling to those columns
e. Auto-adjust column widths
4. Generate multi-sheet Excel (1 sheet per file type)
5. Deliver Excel file
Example App IDs (replace with your actual apps):
App_A_iOS: idXXXXXXXX
App_A_Android: com.example.appa
App_B_iOS: idXXXXXXXX
App_B_Android: com.example.appb
The following bundled scripts support this skill:
| Script | Purpose |
|---|---|
| -------- | --------- |
pa_export.py | Executable script |
pandas >= 1.5.0
openpyxl >= 3.1.0
共 1 个版本