מתי להשתמש
"Reverse ETL", "Hightouch", "Census", "Data Activation", "Operational Analytics", "Sync Snowflake to Salesforce".
הוראות עבודה
1. מה זה Reverse ETL
ETL רגיל = OLTP → Warehouse. Reverse ETL = Warehouse → SaaS Tools (CRM, Marketing, Support).
זה הופך data מ-"analytics asset" ל-"operational asset". ה-warehouse הוא single source of truth, וה-tools מקבלים live data.
2. למה צריך Reverse ETL
בלי Reverse ETL
- Sales ב-Salesforce לא יודע שלקוח השתמש 50% פחות החודש (data ב-warehouse).
- Marketing ב-HubSpot שולח email גנרי במקום מבוסס behavior.
- Support ב-Zendesk לא רואה LTV של לקוח.
עם Reverse ETL
- כל tool מקבל computed fields מה-warehouse.
- 1 source of truth = consistency cross-team.
3. Hightouch vs Census — Overview
| Feature | Hightouch | Census |
|---|---|---|
| Founded | 2018 | 2018 |
| Funding | Series B+ ($150M+) | Series B+ ($83M+) |
| Connectors | 200+ | 200+ |
| Audience builder | ★★★★★ | ★★★★ |
| AI Decisioning | ★★★★ (2024+) | ★★★ |
| Customer Studio | ★★★★★ | ★★★ |
| Pricing model | Tiered + audience-based | Per-destination + rows |
4. Hightouch — Highlights
- Customer Studio — visual audience builder ל-marketers.
- AI Decisioning (2024+) — AI מציע best audience/timing.
- Identity Resolution — match users cross-channels.
- Metrics layer — built-in.
- Strong ב-marketing/CDP use cases.
5. Census — Highlights
- dbt-native — uses dbt models directly.
- Live sync — sub-minute latency on key destinations.
- Observability — sync history, debugging.
- Cohort syncs — incremental optimization.
- Strong ב-engineering teams.
6. Pricing 2026 — Hightouch
| Tier | Price | Features |
|---|---|---|
| Free | $0 | 1 source, 3 destinations, 5K rows/m |
| Starter | $450/m | 5 destinations, 50K rows |
| Pro | $800/m+ | Unlimited, Customer Studio |
| Business | Custom (~$2K-5K/m) | AI Decisioning, advanced |
| Enterprise | $50K+/y | Identity Resolution, SOC 2 |
7. Pricing 2026 — Census
| Tier | Price | Features |
|---|---|---|
| Free | $0 | 1 source, 1 destination |
| Starter | $400/m | 3 destinations, 50K rows |
| Growth | $800/m | More destinations, audience |
| Platform | Custom | Live sync, observability |
| Enterprise | $40K+/y | Identity, SLA |
8. Use Cases — Common Syncs
Sync 1 — Salesforce Account Enrichment
Source: Snowflake "fct_account_health" (computed)
↓
Destination: Salesforce Account custom fields
- Health Score
- MRR
- Last Login
- Usage Trend
↓
Frequency: Hourly
Sync 2 — HubSpot Audience Sync
Source: warehouse "high_intent_leads" (filtered by behavior)
↓
Destination: HubSpot List "Hot Leads Q2"
↓
Marketer triggers nurture campaign
Sync 3 — Iterable / Klaviyo Personalization
Source: warehouse "user_360" (LTV, segments, propensity)
↓
Destination: Iterable user attributes
↓
Email campaign with dynamic content
Sync 4 — Zendesk Customer Context
Source: warehouse "customer_context"
↓
Destination: Zendesk user fields
↓
Support agent sees LTV, plan, recent usage
9. Architecture עם Reverse ETL
[Production DBs / SaaS APIs]
↓ (Fivetran/Airbyte)
[Snowflake / BigQuery]
↓ (dbt)
[Models: customer_360, account_health, etc.]
↓ (Hightouch / Census — Reverse ETL)
[Salesforce / HubSpot / Iterable / Zendesk / Slack]
10. Audience Builder vs Direct Sync
Direct Sync
- Engineer בונה SQL model ב-dbt.
- מסנכרן ל-destination.
- מתאים ל-data team.
Audience Builder (Hightouch Customer Studio)
- Marketer בונה audience visually.
- "Users who logged in 3+ times AND haven't purchased AND in US".
- מתאים ל-non-tech.
Hightouch מנצח כאן. Census פונה יותר ל-engineering.
11. Connectors — Coverage
חוזקים בשניהם
- Salesforce, HubSpot, Marketo, Iterable, Klaviyo, Braze, Segment, Mixpanel.
- Slack, Notion, Google Ads, Facebook Ads.
- Zendesk, Intercom, Front.
Long-tail
- Hightouch קצת מקדים ב-marketing tools חדשים.
- Census קצת מקדים ב-data destinations (S3, GCS).
12. Israeli Context
- שני הכלים זמינים בישראל, no regional issues.
- Israeli SaaS שמשתמש: Hippo Insurance, AppsFlyer, Walkme.
- Local integrators: יש שותפים ל-implementation.
- Latency: cloud regions ב-EU/US — 100-200ms tolerable.
13. מתי לבחור מי
Hightouch
- כן — Marketing-led organization, רוצה audience builder, AI Decisioning.
- לא — Engineering-only, dbt-heavy, רוצה native dbt integration.
Census
- כן — Engineering-led, dbt-native, רוצה observability.
- לא — Marketing wants self-serve audience building.
14. Hightouch vs Census vs CDP (Segment)
CDP (Segment, mParticle)
- Source-of-truth = Segment.
- Tracks events from web/mobile.
- $$$$.
Reverse ETL (Hightouch/Census)
- Source-of-truth = Warehouse.
- Activates batch + incremental syncs.
- $-$$.
2026 trend: Composable CDP = Warehouse + Reverse ETL replaces traditional CDP. חיסכון של 60-80%.
קלט נדרש
| פריט | תיאור |
|---|---|
| Warehouse | Snowflake/BigQuery/Redshift |
| Destinations | רשימת SaaS tools |
| Audience builder needed? | yes/no |
| Volume | rows/m |
| Team | data eng / marketing / both |
פלט צפוי
| רכיב | תיאור |
|---|---|
| Tool | Hightouch / Census |
| Sync architecture | source → dest |
| Cost | $/month |
| Audience strategy | אם רלוונטי |
| ROI | vs CDP / manual |
כללי עבודה
- פלט בעברית, מונחים מקצועיים באנגלית
- מטבע: $ + ₪
- pricing 2026 + cost transparency
- הזכר Composable CDP אם רלוונטי
דגלים אדומים
- 🚨 No data warehouse — Reverse ETL לא רלוונטי. בנה Warehouse קודם.
- 🚨 No dbt models — תקבלו chaos. בנה models קודם.
- 🚨 Sync 100M rows hourly — costs יתפוצצו. השתמש incremental.
- ⚠️ No naming convention ב-warehouse — destinations יתבלבלו.
הערות חשובות
- Composable CDP = הטרנד החם של 2026. ראה: a16z reports.
- Hightouch Series C ($45M+) ו-Census הם הליגה הבכירה.
- Cheaper alternatives: Polytomic, RudderStack (open source).
- בישראל: רוב חברות data-mature מאמצות. כדאי הקדם.
- Identity resolution = הצעד הבא — match users cross-channels.
פרומפט לדוגמה
Snowflake → Salesforce + HubSpot. Hightouch או Census?
בונה Customer Studio ל-marketers. דוגמה לaudience.
Composable CDP ל-startup B2C. תכנון.
© 2026 Automation Expert Pro | גרסה 1.1.0