Loading...
Loading...
Compare original and translation side by side
$autocaptureelements_chain$autocaptureposthog:read-data-schema$autocaptureelements_chain$autocaptureposthog:read-data-schemaevents| Column | Type | Description |
|---|---|---|
| String | Full semicolon-separated element chain (see format reference) |
| String | Last href value from the chain |
| Array(String) | All text values from elements |
| Array(String) | All id attribute values |
| Array(String) | Useful tag names: a, button, input, select, textarea, label |
events| 列名 | 类型 | 描述 |
|---|---|---|
| String | 完整的分号分隔元素链(参见格式参考) |
| String | 元素链中的最后一个href值 |
| Array(String) | 所有元素的文本值 |
| Array(String) | 所有id属性值 |
| Array(String) | 常用标签名:a、button、input、select、textarea、label |
$autocapture| Property | Examples | Notes |
|---|---|---|
| | the kind of interaction |
| | text of the clicked element |
| | page the interaction happened on |
| semicolon-separated chain | parsed via the |
$browser$os$device_type$autocapture| 属性名称 | 示例 | 说明 |
|---|---|---|
| | 交互类型 |
| | 被点击元素的文本 |
| | 交互发生的页面 |
| 分号分隔的元素链 | 通过上述 |
$browser$os$device_typeautocapture_opt_outinit()autocapture: falseSELECT count() as cnt
FROM events
WHERE event = '$autocapture'
AND timestamp > now() - INTERVAL 7 DAYautocapture_opt_outinit()autocapture: falseSELECT count() as cnt
FROM events
WHERE event = '$autocapture'
AND timestamp > now() - INTERVAL 7 DAYelements_chain_elementselements_chain_textselements_chain_hrefelements_chainproperties.$current_urlelements_chain_elementselements_chain_textselements_chain_hrefelements_chainproperties.$current_urldata-attrdata-*match(elements_chain, 'data-attr=')extractAllattr_idelements_chain_idsdata-attr[data-attr="value"]button[data-attr="value"]data-attrdata-*match(elements_chain, 'data-attr=')extractAllattr_idelements_chain_idsdata-attr[data-attr="value"]button[data-attr="value"]elements_chain =~elements_chain =~elements_chain_textsproperties.$current_urlelements_chain_hrefelements_chain_textsproperties.$current_urlelements_chain_hrefFunnelsQueryTrendsQueryEventsNodeActionsNodeevent: "$autocapture"propertiestypetype: "element"selectortag_nametexthrefelements_chainselectortag_nameexactis_notNotImplementedErrorposthog/hogql/property.pytexthrefexactis_noticontainsnot_icontainsregexnot_regexis_setis_not_settype: "event"$event_type$el_text$current_urlexacticontainsregex{
"kind": "FunnelsQuery",
"series": [
{
"kind": "EventsNode",
"event": "$autocapture",
"properties": [
{
"type": "element",
"key": "selector",
"value": ["[data-attr=\"autocapture-series-save-as-action-banner-shown\"]"],
"operator": "exact"
}
]
},
{
"kind": "EventsNode",
"event": "$autocapture",
"properties": [
{
"type": "element",
"key": "selector",
"value": ["[data-attr=\"autocapture-save-as-action\"]"],
"operator": "exact"
}
]
}
]
}value[data-attr="..."]ActionsNodetype: "element"type: "event"FunnelsQueryTrendsQueryEventsNodeActionsNodeevent: "$autocapture"propertiestypetype: "element"selectortag_nametexthrefelements_chainselectortag_nameexactis_notNotImplementedErrorposthog/hogql/property.pytexthrefexactis_noticontainsnot_icontainsregexnot_regexis_setis_not_settype: "event"$event_type$el_text$current_urlexacticontainsregex{
"kind": "FunnelsQuery",
"series": [
{
"kind": "EventsNode",
"event": "$autocapture",
"properties": [
{
"type": "element",
"key": "selector",
"value": ["[data-attr=\"autocapture-series-save-as-action-banner-shown\"]"],
"operator": "exact"
}
]
},
{
"kind": "EventsNode",
"event": "$autocapture",
"properties": [
{
"type": "element",
"key": "selector",
"value": ["[data-attr=\"autocapture-save-as-action\"]"],
"operator": "exact"
}
]
}
]
}value[data-attr="..."]ActionsNodetype: "element"type: "event"SELECT
toStartOfDay(timestamp) as day,
count() as clicks
FROM events
WHERE event = '$autocapture'
AND timestamp > now() - INTERVAL 14 DAY
AND elements_chain =~ '(^|;)button.*?data-attr="checkout"'
GROUP BY day
ORDER BY daySELECT
person_id,
first_pageview,
first_click_after
FROM (
SELECT
p.person_id,
p.pageview_time as first_pageview,
min(c.click_time) as first_click_after
FROM (
SELECT person_id, min(timestamp) as pageview_time
FROM events
WHERE event = '$pageview'
AND timestamp > now() - INTERVAL 14 DAY
AND properties.$current_url ILIKE '%/pricing%'
GROUP BY person_id
) p
INNER JOIN (
SELECT person_id, timestamp as click_time
FROM events
WHERE event = '$autocapture'
AND timestamp > now() - INTERVAL 14 DAY
AND elements_chain =~ '(^|;)button.*?data-attr="signup"'
) c ON p.person_id = c.person_id AND c.click_time > p.pageview_time
GROUP BY p.person_id, p.pageview_time
)posthog:query-trendsposthog:query-funnelSELECT
toStartOfDay(timestamp) as day,
count() as clicks
FROM events
WHERE event = '$autocapture'
AND timestamp > now() - INTERVAL 14 DAY
AND elements_chain =~ '(^|;)button.*?data-attr="checkout"'
GROUP BY day
ORDER BY daySELECT
person_id,
first_pageview,
first_click_after
FROM (
SELECT
p.person_id,
p.pageview_time as first_pageview,
min(c.click_time) as first_click_after
FROM (
SELECT person_id, min(timestamp) as pageview_time
FROM events
WHERE event = '$pageview'
AND timestamp > now() - INTERVAL 14 DAY
AND properties.$current_url ILIKE '%/pricing%'
GROUP BY person_id
) p
INNER JOIN (
SELECT person_id, timestamp as click_time
FROM events
WHERE event = '$autocapture'
AND timestamp > now() - INTERVAL 14 DAY
AND elements_chain =~ '(^|;)button.*?data-attr="signup"'
) c ON p.person_id = c.person_id AND c.click_time > p.pageview_time
GROUP BY p.person_id, p.pageview_time
)posthog:query-trendsposthog:query-funnelposthog:action-create{
"name": "Clicked checkout button",
"steps": [
{
"event": "$autocapture",
"selector": "button[data-attr='checkout']",
"text": "Complete Purchase",
"text_matching": "exact",
"url": "/checkout",
"url_matching": "contains"
}
]
}$autocaptureselectorbutton[data-attr='checkout']tag_namebuttonainputtexttext_matchingexactcontainsregexhrefhref_matchingexactcontainsregexurlurl_matchingexactcontainsregexmatchesAction()SELECT count() as matching_events
FROM events
WHERE matchesAction('Clicked checkout button')
AND timestamp > now() - INTERVAL 7 DAYposthog:action-create{
"name": "Clicked checkout button",
"steps": [
{
"event": "$autocapture",
"selector": "button[data-attr='checkout']",
"text": "Complete Purchase",
"text_matching": "exact",
"url": "/checkout",
"url_matching": "contains"
}
]
}$autocaptureselectorbutton[data-attr='checkout']tag_namebuttonainputtexttext_matchingexactcontainsregexhrefhref_matchingexactcontainsregexurlurl_matchingexactcontainsregexmatchesAction()SELECT count() as matching_events
FROM events
WHERE matchesAction('Clicked checkout button')
AND timestamp > now() - INTERVAL 7 DAY$autocaptureLIMITelements_chainelements_chain =~$autocaptureelements_chainLIMITelements_chain =~