SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.breadcrumb.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.contactoption.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.furthersupport_article.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.furthersupport_category.expanded' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.helptopics_topic.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.mainCTA.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
help.page.view event
Pushes a content_group to the dataLayer for GA4 content grouping.
This is a raw dataLayer push, not a ga_event.
Example
DataLayer Event example
{ content_group: 'Help_TopicPage' }
Remarks
This event is NOT tracked in STRUCTURED_EVENTS. It is a raw GA4 dataLayer push
and can be found in the GA4 BigQuery export under the content_group parameter.
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.related_topic.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.search.focus' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.search.submit' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.section_link.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.selfservice_category.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.subsection.expanded' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.tableofcontents_link.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'Help'AND se_action = 'help.webchat_button.clicked' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
SELECT * FROM LAMBDA_DB.CUSTOMER_JOURNEY_MODELLED.STRUCTURED_EVENTS WHERE se_category = 'WebChat'AND se_action = 'webchat.start' AND event_date BETWEEN CURRENT_DATE - 3AND CURRENT_DATE
List of help events