Events by Industry – eCommerce

Below you can find a catalog of events and their properties, specially designed to track the actions eCommerce customers take during their shopping journey. Tracking them will cover most of the events that you will need to use for your given industry.

Event: ‘page_load’

Use to collect basic data during page load.

PropertyExample ValueDescription
user_id15e7a61137553b-09451a8fc6d1d2-e313761-100200-15e7a611379e2bThe unique ID that identifies the user.
page_urlhttp://go.lightsaber.com/free-demo
The page URL of the viewed page
referring_urlhttp://go.lightsaber.com/The previous page that linked to the current page
page_titleThank You for Downloading Behavioral AnalyticsThe page title
session_duaMozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/60.0.3112.113 Safari/537.36The directory user agent. Refers to a web browser telling a website information about the browser and operating system.
session_platformWin32The platform the user is operating from (Windows, iOS, Android etc.)
event_namepage_loadThe name of the event
session_ip174.19.217.119The ip from which the call originated
referring_domaingo.lightsaber.comThe domain that referred to the current page

For more information see the Cooladata JS tracker.

Relevant reports:

Event: ‘page_load_enrich’

Use to enrich the page_load data in the cart, checkout and thank you pages.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
item_nameLight saberThe name of the product in the catalog
item_id22529378The unique ID of the product in the catalog
item_categoryToysThe category the product belongs to
item_quantity2The quantity of products (of same type) that were added to the cart
item_discount49.5The discount the product received
item_discount_typeBuy one get oneThe type of discount that was applied to this product
total_discount49.5The total discount for the current purchase
item_catalog_price99Product price before product customization or discount
item_price 49.5Actual product price in catalog
currencyUSDThe currency in which the product was purchased in
number_of_items5The number of purchased item for the current purchase
order_total189The total order amount for the current purchase

Event tracking code:

Relevant reports:

Event: ‘user_search’

Use to capture a search action by the user.

PropertyExample ValueDescription
search_results[green light-saber, purple light-saber, red light-saber]The search results the query returned
search_results_count10The number of search results the query returned
search_term"villains' light sword" The search term used by the user for the search
current_page_number2The number of results page (INT, 1 if NULL)
items_per_page20How many items per page were presented to the user (INT, 0 if NULL)

Event tracking code:

Relevant reports:

Event: ‘log_in’

Use to capture the customer’s log-in data.

PropertyValue TypeDescription
user_alternative_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user on the platform.
user_emailjake.land@jakeland.ioThe email used by the user to log into the system
login_successtrueWas the log-in successful?
login_errorEmail address invalid, please try againAny error that is presented to the user during the log-in process

Event tracking code:

Relevant reports:

Event: ‘add_to_cart’

Use to capture data when the customer adds a product to the cart.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
item_nameLight saberThe name of the product in the catalog
item_id22529378The unique ID of the product in the catalog
item_categoryToysThe category the product belongs to
item_quantity2The quantity of products (of same type) that were added to the cart
item_discount49.5The discount the product received
item_discount_typeBuy one get oneThe type of discount that was applied to this product
item_catalog_price99Product price before product customization or discount
item_price 49.5Actual product price in catalog
currencyUSDThe currency in which the product was purchased in
item_genderUnisexThe gender the product is meant for (clothing & jewelry specific)
item_colorSilverThe color/colors of the product
item_stylecrossguard Any styles related to the product
item_descriptionThe perfect villain gift: the crossguard lightsaberPartial/full description of the product

Event tracking code:

Relevant reports:

Event ‘add_to_wish_list’

Use to capture data when the customer adds a product to the wish list.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
item_nameLight saberThe name of the product in the catalog
item_id22529378The unique ID of the product in the catalog
item_categoryToysThe category the product belongs to
item_quantity2The quantity of products (of same type) that were added to the cart
item_discount49.5The discount the product received
item_discount_typeBuy one get oneThe type of discount that was applied to this product
item_catalog_price99Product price before product customization or discount
item_price 49.5Actual product price in catalog
currencyUSDThe currency in which the product was purchased in
item_genderUnisexThe gender the product is meant for (clothing & jewelry specific)
item_colorSilverThe color/colors of the product
item_styleCrossguard Any styles related to the product
item_descriptionThe perfect villain gift: the crossguard lightsaberPartial/full description of the product

Event tracking code:

Relevant reports:

Event: ‘remove_from_wish_list’

Use to capture data when the customer removes a product from the wish list.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775a
The unique ID that identifies the user.
item_nameLight saberThe name of the product in the catalog
item_id22529378The unique ID of the product in the catalog
item_categoryToysThe category the product belongs to
item_quantity2The quantity of products (of same type) that were added to the cart
item_discount49.5The discount the product received
item_discount_typeBuy one get oneThe type of discount that was applied to this product
item_catalog_price99Product price before product customization or discount
item_price 49.5Actual product price in catalog
currencyUSDThe currency in which the product was purchased in
item_genderUnisexThe gender the product is meant for (clothing & jewelry specific)
item_colorSilverThe color/colors of the product
item_styleCrossguard Any styles related to the product
item_descriptionThe perfect villain gift: the crossguard lightsaberPartial/full description of the product

Event tracking code:

Relevant reports:

Event: ‘cart_remove_item’

Use to capture data when the customer removes a product from the cart.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
item_nameLight saberThe name of the product in the catalog
item_id22529378The unique ID of the product in the catalog
item_categoryToysThe category the product belongs to
item_quantity2The quantity of products (of same type) that were added to the cart
item_discount49.5The discount the product received
item_discount_typeBuy one get oneThe type of discount that was applied to this product
item_catalog_price99Before product customization or discount
item_price 49.5Actual product price in catalog
currencyUSDThe currency in which the product was purchased in
order_total189The total order amount for the current purchase

Event tracking code:

Relevant reports:

Event: ‘checkout_form’

Use to capture data when the customer is submitting the checkout form.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
shipping_first_nameJakeThe first name of the recipient
shipping_last_nameLandThe last name of the recipient
shipping_street_nameMain St.The street name of the recipient
shipping_house_number35The house number of the recipient
shipping_postal_code94101The postal code of the recipient
shipping_citySan FranciscoThe city of the recipient
shipping_countryUSAThe country of the recipient
shipping_stateCAThe state of the recipient (if applicable)
shipping_phone_number(415) 765-77241The phone number of the recipient
shipping_methodUSPS Express MailPreferred shipping method by recipient
shipping_user_emailjake.land@jakeland.ioRecipient's email address
shipping_notification_optintrueDid the recipient opted-in for shipment/news notifications?
shipping_error_messageStreet name is missingWhat error messages were triggered during filling in the checkout form

Event tracking code:

Event: ‘newsletter’

Use to capture data when the customer is submitting the newsletter request.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
user_emailjake.land@jakeland.ioThe user's email address for sending the newsletter
email_errorPlease enter a valid email addressErrors while filling the newsletter form

Event tracking code:

Event ‘impression’

Use to capture data when a product is seen by the customer.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
item_nameLight saberThe name of the product in the catalog
item_id22529378The unique ID of the product in the catalog
item_categoryToysThe category the product belongs to
items_per_page10How many items are shown per single catalog page
item_page_position3Item position on the page
catalog_page_number1The number of page in the catalog the product was shown on

Event tracking code:

Event ‘click_item’

Use to capture data when a customer clicks a product.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
item_nameLight saberThe name of the product in the catalog
item_id22529378The unique ID of the product in the catalog
item_categoryToysThe category the product belongs to
items_per_page10How many items are shown per single catalog page
item_discount50The discount the product received
item_discount_typeBuy one get oneThe type of discount that was applied to this product
currencyUSDThe currency in which the product was purchased in
item_page_position3Item position on the page
catalog_page_number1The number of page in the catalog the product was shown on

Event tracking code:

Relevant reports:

Event ‘click_social’

Use to capture data when a customer clicks a social link.

PropertyExample ValueDescription
user_id6c84fb90-12c4-11e1-840d-7b25c5ee775aThe unique ID that identifies the user.
social_network_nameTwitterThe name of the social network
social_network_urlhttps://twitter.com/villainit?lang=enThe URL of the social network

Event tracking code:

Event: ‘redeem_coupon’

Use this event when the user redeems a coupon.

PropertyExample ValueDescription
coupon_id#7YA453The promo code ID redeemed by the user.
coupon_nameBlack Friday blitz!The name of the coupon.
coupon_descriptionUse this $100 rebate coupon on any electronics products in our store!The text description of the coupon.
reward_amount100The amount of the reward given in exchange for redeeming the promo code.
reward_currencyUSDThe currency of the reward given in exchange for redeeming the promo code.
creation_datetime2019-12-30 23:59:59The coupon creation datetime.
expiration_datetime9999-12-31 23:59:59The coupon expiration datetime.
redeeming_datetime2019-12-31 22:59:59The coupon redemption datetime.
notificationRedeeming coupon failed! This coupon was already used.Any system notification to the user during the process of redeeming the coupon.
statusfailThe status of trying to redeem the coupon: fail, success.

Event tracking code:

Print Friendly, PDF & Email

Events by Industry – Video Games

The basic concept of analytics is based on 5 types of measurements of user behaviour (known as AARRR):

  1. Acquisition – where / what channels do users come from?
  2. Activation – do users have a great first experience?
  3. Retention – do they come back & revisit over time?
  4. Referral – do they like it enough to tell their friends?
  5. Revenue – can you monetize any of this behavior?

Below you can find a catalog of events and their properties, specially designed to track the behavior of video games sites/apps. Tracking these events will cover most of the data that you will need. You can choose different properties and events with custom events.

 

Event: ‘player_joined’ (user scope)

Use this event when a new player registers to play a game. In case there is no need to register, the event should be triggered the first time a player opens a game. This event is the first event that is triggered by a user.

PropertyExample ValueDescription
device_platformweb
The first platform used to play the game like: Web, Mobile, Tablet, PC
login_successTRUERegisters if a login was successful
login_errorWrong user IDThe description of the log-in error if applicable

Event: ‘start_game’ (session scope)

Use this event when a user starts to play the game, trigger it on session start.

PropertyExample ValueDescription
game_idG15785209
The unique ID of the game
game_nameJake the villain hunterThe name of the game
game_categoryRPGPossible options (among others): Massively Multiplayer Online (MMO), Simulations, Adventure, Real-Time Strategy (RTS), Puzzle, Action, Stealth Shooter, Combat, First Person Shooters (FPS), Sports, Role-Playing (RPG), Educational
client_deviceSamsung 8 (G950U)The device the game is running on
app_platformwebPossible options (among others): Web, Mobile, Tablet, PC, Console

Event: ‘advance_level’ (event scope)

Use this event when a user reaches a new level in a game.

PropertyExample ValueDescription
level_idM15323747The unique ID of the level.
level_nameSnatch the EmperorThe name of the level.
level_order6The consecutive number of the level.
score13040The score the user had when starting the level.

Event: ‘make_transaction’ (event scope)

Use this event to track different kinds of transactions in a game. Implementing this event can be used to track In App Purchases, purchasing in-game items using virtual currencies, exchanging items to receive other items, auctions etc..

PropertyExample ValueDescription
directiongetDescribes the transaction direction from the user's point of view like: give or get
currencyImperial CreditThe currency used for the transaction.
number_of_units17The number of units involved in the transactions.
item_idBLSTR-07The unique ID of the item changing hands in the transaction.
item_nameGreen laser blasterThe name of the item changing hands in the transaction.
typein-app purchaseThe type of of transaction like: in-app purchase, barter, auction etc..

Event: ‘start_level’ (event scope)

Use this event when the user starts a new level.

PropertyExample ValueDescription
level_idM15323747The unique ID of the level started.
level_nameSnatch the EmperorThe name of the level started.
level_order6The consecutive number of the level.
score13040The score the user had when starting the level.

Event: ‘complete_level’  (event scope)

Use this event when a user completes a level.

PropertyExample ValueDescription
level_idM15323747The unique ID of the level completed.
level_nameSnatch the EmperorThe name of the level completed.
level_order6The consecutive number of the completed level.
score15021The score the user had when completing the level

Event: ‘fail_level’ (event level)

Use this event if a user failed to successfully complete a level.

PropertyExample ValueDescription
level_idM15323747The unique ID of the level failed.
level_nameSnatch the EmperorThe name of the level failed.
level_order6The consecutive number of the failed level.
score14751The score the user had when failing the level.

Event: ‘log_ui_interaction’ (event scope)

Use this event to log the game’s reaction info generated by users’ in-game behavior. You can use this event to log errors or any other data that is relevant to improving your game.

PropertyExample ValueDescription
x_position20.02302The x axis position of the user interaction.
y_position50.10396The y axis position of the user interaction.
z_position0The z axis position of the user interaction.
message_typeerrorThe type of message, like: info, debug, warning, error, critical
ui_idM15323747The unique ID of the screen where the interaction took place.
ui_nameThe emperor's chambersThe name of the screen where the interaction took place.
element_id1425643The UI element unique ID the user interacted with.
element_nameWeapons selectorThe name of the UI element the user interacted with.
user_actionclickThe UI interaction carried out by the user like: click, double-click, right-click, drag, scroll, type.
ui_reactionmenu openedThe reaction of the UI to the user interaction.

Event: ‘change_settings’ (event scope)

Use this event when the user changes the game settings.

PropertyExample ValueDescription
element_idA-2673BGThe unique ID of the settings element the user changed.
element_nameIncrease difficulty levelThe name of the settings element the user changed.
change_fromLowThe mode of the settings before the change.
change_toMediumThe mode of the settings after the change.

Event: ‘view_notification’ (event scope)

Use this event when a game push notification was viewed by the user.

PropertyExample ValueDescription
id137853267The unique ID of the notification.
typeBonus notificationThe type of the notification like: system notifications, team notifications etc.
subjectGet your 50K bonus!The subject of the notification.
bodyClick here to receive your bonusThe content of the notification.
Print Friendly, PDF & Email

Step 2 – Implement Cooladata

Sign up to Cooladata

  1. Go to http://app.cooladata.com.
  2. Click Sign up.
  3. Fill in the form and click Sign up
  4. Wait until you receive an email with a registration link to the email you signed up with, and click the link to log in.

 

Create a Project

To create a new project:

  1. In the top right corner, click the Create your first project button.
  2. Enter the name of the project.
  3. Click CREATE.

With CoolaData, you can put all your data into a single project or you can divide your data up among multiple projects – as you see fit.

Why create multiple projects? 

You control which dashboards, reports and publications users see. However, Admin users can access all the data in any project to which they are allowed access. To control the data that each CoolaData Admin users can access you can create multiple CoolaData projects.

For example, in an ecommerce site, you might have different stores – each belonging to a different company. Therefore, you might only want each company’s Admin user to see the data of their own company. In this case, you should create a project for each company, so that each Admin user can only access their own data in dashboards, publications and using the CoolaData API.

 

Track Events

To start tracking events using the Cooladata trackers:

  1. After creating a project, if the page shown is not already displayed, select Project – Tracking.
  2. Choose the required OS and follow the on-screen instruction.

See more details and implementation options in the Sending Data section.

 

Monitor Incoming Events

CoolaData enables you to monitor incoming events so that you can verify proper integration with your application/website, regardless of the type of Tracker you use to send events to CoolaData.

As each event is received by CoolaData, it is classified as either valid or invalid and is displayed in the Live Events window within approximately five minutes. Valid events undergo additional processing by CoolaData and within an hour or two after being received, may be reclassified as invalid. In order to investigate the reason for invalid events, CoolaData provides a details option in the Live Events window and enables you to query its database for invalid events. See Handling Invalid Events for more information.

The Live Events page is used to monitor your incoming events to CoolaData. Open the page from the main menu Project – Live Events.

Events are shown in near realtime – from the time you send an event it may take up to a minute to appear on this page. The page shows the 500 most recently received events, sorted by the time they were received, with the most recent events appearing first. Click any column title to sort the list.

Each row represents an event. Click a row to see the raw JSON format it was sent in.

You can search the list or specific columns in the list from the top left search box.

The columns displayed in this list can be customized from the top right icon. The list of columns contains all available common properties in the project, as well as the following information:

  • raw_data: displays the original JSON sent (can also be seen by clicking the event).
  • Validity: an events can be valid – will be saved, invalid – will not be saved, or pending – a new event that will be saved if doesn’t conflict with other events in the project schema.
  • invalidComments: invalid events will specify the rejection reason in this column.
  • extraComments: pending events will specify the reason in this column.
Print Friendly, PDF & Email

R and Python Reports

Cooladata enables you to run R and Python script reports. This opens up a wide range of analysis and visualizations for your reports and dashboards. Run any script, plot any visualization and use it just like any other report, in Dashboards, Publications, and Embedded Reports.

Note: this feature is in beta – your feedback will be much appreciated!

Creating a new R/Python Report

  1. Click the New Report button at the top to open the reports gallery.
  2. From Scripts choose the desired report type: R or Python.
    The following will be shown:
  3. In the top section, indicated by Data (CQL), enter any query.
    You can query any data source in your project, including all tables and linked data sources. This will serve as the input for your script. The results are saved to “CQLQuery”, and can be used in your script.
    You can include “filters (context)” or “date_range (context)” in the query to use the report and dashboard controls, as in any CQL report.
    Note that “select * from cooladata” isn’t supported in R or Python reports.
  4. In the bottom section, indicated by Script (R/Python), enter your script. We recommend running your script in a dedicated R or Python IDE (preferably on Unix) and debugging it there before using it in Cooladata.
    Some libraries are pre-installed in your project and can be used. You can also add other libraries to run in this specific script from the “Additional libraries” field below the script.
    The script is expected to create a plot, which is displayed as an image. You can use any plot function in the script.

    • For R, the last plot in your script is saved to jpg. You can also use the GGsave function in R. Mark the “Use ggsave visualization” toggle in the report settings to use GGsave.
  5. Click Run to execute the query and script.
    Once the script is finished, an image should be shown.
    If no image is shown, check the log files for errors in the script (link shown next to the Run button).
Print Friendly, PDF & Email

KPI

CoolaData’s Key Performance Indicator (KPI) reports enable you to display discrete values, counting various events in your data. For example, how many users, sessions, events per country and so on. This data can be shown broken down per day, week, month and so on.

For a complete introduction to the KPI report please see the following video:

 

Creating a new KPI report

  1. Click the New Report button at the top to open the reports gallery.
  2. From Custom Reports, choose KPI.
    The following displays:
    6-3
  1. In the Enter Name field, type any name for the report.
  2. In the Choose KPI field, select one of the preset options, or custom – different fields are displayed accordingly. See more about the two types below.
    6-5
  3. To change the name of this KPI click edit:
    6-4
  4. To add conditions to this KPI, click the filter icon on the right – filter. The following displays – enter any conditions (up to 5 per KPI):

    6-62

  5. You can add an additional KPIs by clicking + Add KPI button.
  6. In the Breakdown by field (optional), select the Time or the Property option to break down the display of the KPIs.
    6-6

    • Time: Select hour, day, week, month or year to break down the report. The following is an example of a report with a time breakdown and without
    •  Property: Select a property by which to break down the report.
      6-8
  1. Define the report’s date range and filters.
  2. Click Run
  3. Configure the visualization
  4. Click Save.

 

Preset KPI

In the Choose KPI field, select one of the following options:

  • Users – The number of users that performed an event.
  • DAU – Daily Active Users – The average number of users who were active (sent an event) per day during the selected time period.
  • MAU – Monthly Active Users – The average number of users who were active (sent an event) per month in the last year.
  • Recency – The average amount of time elapsed between user sessions, meaning the average amount of time that it takes for a user to perform another event after a session has been completed.
  • Sessions – The number of user sessions.
  • Sessions Per User – The average number of sessions per user.
  • Sessions Per Day – The average number of sessions per day (for all users).
  • Sessions Duration (sec) – The average duration of each session, in seconds.
  • Events Per User – The average number of events per user.
  • Events Per Day – The average number of events per day.
  • Events per Session – The average number of events per session.

 

Custom KPI

When defining your KPI report, selecting Custom lets you define a function on a property to appear in the report. Select a function and property, and add any conditions you need. Note that the available functions depend on the property data type. If you selected an invalid function, it will be replaced.

6-65

Print Friendly, PDF & Email