What are the descriptions of the Action ID's in Clickstreams?

Environment:

Clickstreams Action ID

Resolution:

Important!

1. The clickstream action ID's are defined by a separate table called cs_actions and are different for every customer (except for action_id in (1,2)).

2. Oracle B2C Service does not advise running reports directly against clickstreams unless it includes a runtime or fixed filter on a well indexed column such as c_id.

3. On a large site, running a table scan on clickstreams is a very process intensive thing to do and should be avoided.

There are 3 types of actions that go into clickstreams table:

1)  Special Actions: Some client data is collected as SOURCE and SOURCE_CLIENT actions. This data is collected for each new visit.

2)  Page Actions: Actions that records page hits or page flips

3)  AJAX Actions: These are AJAX calls where there is no page flip.

Special Actions: Records the source of visit

Special Actions

Action	Description	context1	context2	context3
SOURCE	Click source	IP address	Referring site Ex: google.com	Referring page ex: /list/answers
SOURCE_CLIENT	Client Details	Client OS	Client browser	Full user agent string (as of 9.8)

Page Actions: Clickstream action for pages is driven by page metatag. For example, clickstream="answer_view" indicates the page is an answer view page.

Page Actions

Clickstream Action	Page metatag	Description	context1	context2	context3
/Home	home	Home Page Hit
/AnswerView	answer_view	Answer view on certain page or widget	answer id	Answer summary
/Relate/AnswerView	answer_view	Related Answer View	answer id	Answer summary
/Suggested/AnswerView	answer_preview	Answer Preview	answer id	Answer summary
/AnswerPrint	answer_print	Answer Print	answer id	Answer summary
/AnswerList	answer_list	Answer List page		Product hierarchy (Wireless/Billing) Changed to (2.20 level2 product id=20)	Category hierarchy (Wireless/Billing) Changed to (2.20 level2 product id=20)
/AccountCreate	account_create	Account create Page
/AccountLogin	account_login	Account Login page
/AccountUpdate	account_update	Account Update Page
/Ask	incident_create	Incident create page
/AskConfirm	incident_confirm	Incident confirm page	Incident id	Incident ref no
/IncidentView	incident_view	Incident view page	Incident id
/IncidentUpdate	incident_update	Incident Update page	Incident id
/IncidentPrint	incident_print	Incident Print page	Incident id
/QuestionList	incident_list	Incident List page
/ChatRequest	chat_request	Chat Request Page
/ChatLanding	chat_landing	Chat Landing Page
ALL OTHER PAGES
/tagx	clickstream="tagx"
/folder/page	No clickstream tag
<any page>/Search	N/A	There was a search on the page	keyword	Product hierarchy (Wireless/Billing) Changed to (2.20 level2 product id=20)	Category hierarchy (Wireless/Billing) Changed to (2.20 level2 product id=20)

 

 

 

 

AJAX Actions:

AJAX Actions

Action	AJAX Controller/Function	Description	context1	context2	context3
/ajaxRequest/Search	ajaxRequest/ getReportData	Submit Search	keyword	Product hierarchy	Category hierarchy
/ajaxRequest/Page	ajaxRequest/ getReportData	Submit Pagination (Next Page)	Page index
/ajaxRequest/Login	ajaxRequest/ doLogin	Submit User Login
/ajaxRequest/ Logout	ajaxRequest/ doLogout	Submit User Logout
/ajaxRequest/ SiteFeedback	ajaxRequest/ submitSiteFeedback	Submit Site Feedback
/ajaxRequest/AnswerFeedback	ajaxRequest/ submitAnswerFeedback	Submit Answer Feedback	answer id	Answer summary
/ajaxRequest/AnswerRating	ajaxRequest/ submitAnswerRating	Submit Answer Rating	answer id	Answer summary	rate
/ajaxRequest/ SiteFeedback	ajaxRequest/ submitFeedback	Submit Site Feedback
/ajaxRequest/formTokenUpdate	ajaxRequest/ getNewFormToken	Get New Form Token
/ajaxRequest/ IncidentCreate	ajaxRequest/ sendForm	Submit Incident Create	Incident id	1(if account create) 2 (if account update)
/ajaxRequest/ SAIncidentCreate	ajaxRequest/ sendForm	Submit Incident Create: Smart Assistant	Incident id	1(if account create) 2 (if account update)
/ajaxRequest/ AccountCreate	ajaxRequest/ sendForm	Submit Account Create
/ajaxRequest/AccountUpdate	ajaxRequest/ sendForm	Submit Account Update
/ajaxRequest/Notify	ajaxRequest/ answerNotification	Submit Answer Notification	answer id	Answer summary
/ajaxRequest/NotificationRenew	ajaxRequest/ answerNotification	Submit Answer Notification Renew
/ajaxRequest/ NotificationDelete	ajaxRequest/ answerNotification	Submit Answer Notification Delete
/ajaxRequest/Notify	ajaxRequest/ prodcatAddNotification	Product/Category Notification Submit	Product hierarchy	Category hierarchy
/ajaxRequest/NotificationRenew	ajaxRequest/ prodcatDeleteNotification	Product/Category Notification Delete	Product hierarchy	Category hierarchy
/ajaxRequest/ NotificationDelete	ajaxRequest/ prodcatRenewNotification	Product/Category Notification Renew	Product hierarchy	Category hierarchy
/ajaxRequest/ Email	ajaxRequest/ emailAnswer	Email An Answer	answer id	Answer summary	To: person to email
/AttachmentView	fattach/get	View Attachment	Attachment id	1(if redirected)
/AttachmentUpload	fattach/upload	Attachment Upload
/ SyndicatedDataService/<Search: if there is search>	syndicatedWidgetDataService	Syndicated Widgets Data Service requests		Widget type (1: PAC, 2: SPAC, 3: SKW)
/OpenSearch/Search	opensearch	Open Search Search submit	Keyword	Product Hierarchy	Category Hierarchy
/OpenSearch/Page	opensearch	Open Search Pagination	Keyword	Product Hierarchy	Category Hierarchy
/documents/<function>	documents/<function>	Outreach/Feedback document hits: view, submit, detail, etc.
ALL OTHER AJAX ACTIONS
<controller>/<method>	Any Other Ajax Request	Any other AJAX call