慣性聚合 高效追讀感興趣之博客、新聞、科技資訊
閱原文 以慣性聚合開啟

推薦訂閱源

博客园 - 司徒正美
V
V2EX
T
Tailwind CSS Blog
有赞技术团队
有赞技术团队
aimingoo的专栏
aimingoo的专栏
Apple Machine Learning Research
Apple Machine Learning Research
IT之家
IT之家
Blog — PlanetScale
Blog — PlanetScale
A
About on SuperTechFans
月光博客
月光博客
T
The Blog of Author Tim Ferriss
宝玉的分享
宝玉的分享
Martin Fowler
Martin Fowler
博客园 - 聂微东
The GitHub Blog
The GitHub Blog
V
Visual Studio Blog
WordPress大学
WordPress大学
酷 壳 – CoolShell
酷 壳 – CoolShell
Engineering at Meta
Engineering at Meta
GbyAI
GbyAI

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant Common SOC 2 Failures (Real World) Stop Vibe-Checking Your AI App: A Practical Guide to Evals How to Use SonarQube and SonarScanner Locally to Level Up Your Code Quality Your Next To-Do App Is Dead — I Replaced Mine with an OpenClaw AI Sign a Nostr event in 60 lines of Python using coincurve — no nostr-sdk, no nbxplorer, no rust toolchain ITGC Audit Explained Like You’re in Big 4 Patch Tuesday abril 2026: Microsoft parcha 163 vulnerabilidades y un zero-day en SharePoint Stop scraping everything: a better way to track competitor price changes Listing on MCPize + the Official MCP Registry while routing payments OUTSIDE the marketplace — how I kept 100% of my x402 revenue Building an AI-Powered Risk Intelligence System Using Serverless Architecture Why We Ripped Function Overloading Out of Our AI Toolchain Testing AI-Generated Code: How to Actually Know If It Works SaaS Churn Is Killing Your Business. Here Is What to Do About It (Without a Support Team) The Speed of AI Is No Longer Linear - And Self-Improving Models Are Why How to Implement RBAC for MCP Tools: A Practical Guide for Engineering Teams From Standard Quote to Persuasive Proposal: AI Automation for Arborists I built a CLI that scaffolds complete multi-tenant SaaS apps Axios CVE-2025–62718: The Silent SSRF Bug That Could Be Hiding in Your Node.js App Right Now The dashboard that ended our friendship Data Pipelines Explained Simply (and How to Build Them with Python)
观听者之筑与数据之筛:何器何时用?
SapotaCorp · 2026-05-24 · via DEV Community

区段简述:吾等汉内店五里之内所有订阅者。数据过滤器无地理半径选项。欲用SQL查询,先察看受众构建器是否涵盖之——此常然,且构建乃点选而非编码.

此乃吾等决择SFMC区段之具也.

数据过滤器

点选即用,无需SQL。依DE或资料字段之属性值,筛选订阅者。

Examples Data Filter handles:
- MemberTier = "Gold"
- BirthMonth = 3   (March birthdays)
- LoyaltyPoints >= 500
- City = "Hanoi"

入全景模式 出全屏模式

其所不能为者:

  • 地纬半径(距某地X公里之内)
  • 复数之算或派生之域
  • 合多DE
  • 阅文追迹之数(启,点)

输出:一过滤组(当应用于列表时)或过滤DE(当应用于DE时).

观众构建器

较数据过滤器更进一步。增添:

  • 地理定位:距离某点X公里内的订阅者.
  • 衡量:依踪迹设筛,如阅函于卅日之内,或三月未点者。
  • :实时计数:建此段时,观何数阅者符之——于发前甚用。
  • :拖曳置设繁状,非数据筛所能达。

:为分群需地志、行迹或互动观者量者而设。

量度——此乃数据筛滤所不及之事

量度筛滤者,非但追踪行迹,亦非DE字段:

Examples:
- Opened at least one email in last 30 days
- Has not clicked any email in last 3 months
- Opened at least 5 emails last year

入全屏模式 出全屏模式

数据筛滤读DE列;追踪之数据存于数据视图中(_Open_Click_Sent)。量度无藉SQL,遂弥此隙。

若客求"唯在册者得",而难明"参与"为DE字段,则Audience Builder乃其器也。

决策表

以DE属性为滤

数据滤

以地缘半径为滤

受众构建器

以追踪行为为滤

观者筑基 (量度)

观建时实时计数

观者筑基

合多DE

SQL 查询(详见下文)

复数运算 / 推导

SQL查询

許可說明

观者筑基者也未载于每版SFMC可随营销云高级版、企业版2.0或作为附加模块获取。欲许地缘定向之区,须先审客户得否。

数据筛滤,悉附各版。

执其宜器

吾所循之规也

  1. 数据筛滤能之乎? → 数据筛滤。
  2. 若需地理信息、实时计数或追踪行为?→ 观众构建器.
  3. 若需联结或复杂逻辑?→ SQL查询(详述于后文).

每当可能,止于第一步,使构建于客户团队可调试。直入SQL而数据过滤器本可胜任,则徒增维护之累,非所愿.

近期工作之例

  • 段:"金级会员于岘港" → 数据筛滤(二属性条件)。
  • 段:"四十五日内启封任一电邮且居于旗舰店十公里内之订阅者" → 受众构筑(量度+地理)。
  • 段:"订阅者其末次购值>倍于其平均"→ SQL 查询(衍生计算,需聚合)。

便当

观者构建者,弥数据筛滤之简与SQL查询之繁之隙。地理定位、行迹追踪、实时计数者,乃推一区段自数据筛滤至观者构建之三征。SQL出,惟二者皆不能达其理时耳。


构建SFMC受众细分?吾Salesforce之众,于生产之务,为客定制其版次与事由相契之区隔之策。相接也>

睹吾全貌平台之务吾所论之栈也。