📤 CRM Channel Extraction | 渠道 CRM 数据提取器

Extracts and filters channel-specific data from AppsFlyer CSV exports or CRM databases. Supports multiple filter conditions (channel name match, media source, date range, event type, attribution status) and outputs clean datasets.

Ameko2026

未分类 community v1.0.0 1 版本 100000 Key: 无需

★ 0

Stars

📥 61

下载

💾 0

安装

版本

#latest

概述

CRM Channel Extraction

渠道 CRM 数据提取器

Overview

From AppsFlyer CSV files or CRM data, extract all records matching a specific channel with flexible filtering.

Filter Conditions

Condition	Description	Example
-----------	-------------	---------
Channel match	Exact or fuzzy	`Channel == 'channel_a_mob'`
Media Source	By Media Source ID	`Media Source == 'xxx_int'`
Date range	Event Time in range	`2026-02-01` to `2026-02-28`
Event type	By event name	`Event Name == 'af_purchase'`
Primary only	First attribution only	`Is Primary Attribution == true`

Execution Flow

1. Read file (auto-detect encoding: utf-8-sig/gbk/latin-1)
2. Apply channel matching (exact -> fuzzy fallback)
3. Apply additional filters (AND logic)
4. Export Excel + summary report
5. Statistics: total records, unique users, event distribution

Output

File: Excel/CSV with filtered channel data
Report: Total count, unique users, event type distribution, date range

Script Usage

python3 scripts/extract_channel.py \
  --input data/appsflyer_export.csv \
  --channel channel_a_mob \
  --start-date 2026-02-01 \
  --end-date 2026-02-28 \
  --output output/channel_data.xlsx

Scripts

The following bundled scripts support this skill:

Script	Purpose
--------	---------
`extract_channel.py`	Executable script

Dependencies

pandas >= 1.5.0
openpyxl >= 3.1.0

版本历史

共 1 个版本

v1.0.0 Initial release 当前

2026-05-18 15:05 安全安全

安全检测

腾讯云安全 (Keen)

安全，无风险

查看报告

腾讯云安全 (Sanbu)

安全，无风险

查看报告

🔗 相关推荐

business-ops

💰 AI Budget Allocation Optimizer | AI 预算分配优化器

user_ede7f505

| AI 预算分配优化器

★ 0 📥 131

data-analysis

Data Analysis

ivangdavila

{"answer":"数据分析与可视化。查询数据库、生成报告、自动化电子表格，将原始数据转化为清晰可行的见解。适用于：(1) 您……"}

★ 211 📥 70,112

data-analysis

AdMapix

fly0pants

AdMapix 原始数据层，提供广告创意、应用、排名、下载/收入及市场元数据。返回 AdMapix API 的结构化 JSON；调用方...

★ 297 📥 142,025