Mode vs Piwik vs Snowplow

Overview

Mode

Stacks125

Followers227

Votes17

Piwik

Stacks1.4K

Followers512

Votes74

Snowplow

Stacks132

Followers174

Votes35

GitHub Stars7.0K

Forks1.2K

Share your Stack

Help developers discover the tools you use. Get visibility for your team's tech choices and contribute to the community's knowledge.

View Docs

CLI (Node.js)

Manual

Advice on Mode, Piwik, Snowplow

Wei

CTO at Flux Work

Jan 8, 2020

Decided

Very easy-to-use UI. Good way to make data available inside the company for analysis.

Has some built-in visualizations and can be easily integrated with other JS visualization libraries such as D3.

Can be embedded into product to provide reporting functions.

Support team are helpful.

The only complain I have is lack of API support. Hard to track changes as codes and automate report deployment.

230k views230k

Comments

Detailed Comparison

Mode	Piwik	Snowplow
Created by analysts, for analysts, Mode is a SQL-based analytics tool that connects directly to your database. Mode is designed to alleviate the bottlenecks in today's analytical workflow and drive collaboration around data projects.	Matomo (formerly Piwik) is a full-featured PHP MySQL software program that you download and install on your own webserver. At the end of the five-minute installation process, you will be given a JavaScript code.	Snowplow is a real-time event data pipeline that lets you track, contextualize, validate and model your customers’ behaviour across your entire digital estate.
Write, save, and share SQL queries with other analysts in your company; Empower non-technical folks to update queries on their own; Run queries on a schedule, create lists of related reports, and explore a project's history as it changes over time; Build reports using standard charting or create completely customer, interactive visuals with HTML, CSS, and Javascript;Database connectors for MySQL, Postgres, Redshift, Vertica, Hive, Heroku, Segment, BigQuery, Impala; Mode also offers SQL School (sqlschool.modeanalytics.com), a free, interactive SQL tutorial and the Mode Playbook.	Real time data updates;Customizable Dashboard;All Websites Dashboard;Analytics for e-commerce;Goal conversion tracking;Event Tracking;Site Search Analytics;Geolocation;Pages Transitions;Page Overlay;Site speed & pages speed reports;Track different user interactions	Track rich events from your websites, mobile apps, server-side systems, third party systems and any type of connected device, so that you have a record of what happened, when, and to whom;Load your data into your data warehouse of choice to power sophisticated analytics;Process your data including validating, enriching and modeling it;Your data is available in real-time via Amazon Kinesis, Google Pub/Sub and BigQuery to power real-time applications and reports;Your data pipeline is running in your cloud environment giving you full ownership and control of your data
Statistics
GitHub Stars -	GitHub Stars -	GitHub Stars 7.0K
GitHub Forks -	GitHub Forks -	GitHub Forks 1.2K
Stacks 125	Stacks 1.4K	Stacks 132
Followers 227	Followers 512	Followers 174
Votes 17	Votes 74	Votes 35
Pros & Cons
Pros 4 Empowering for SQL-first analysts 3 Easy report building 3 Collaborative query building 2 Awesome online and chat support 2 Integrated IDE with SQL + Python for analysis	Pros 35 It's good to have an alternative to google analytics 27 Self-hosted 10 Easy setup 2 Not blocked by Brave 0 Great customs Cons 2 Hard to export data	Pros 7 Can track any type of digital event 5 First-party tracking 5 Data quality 4 Real-time streams 4 Redshift integration
Integrations
Apache Hive Microsoft Azure Google BigQuery Apache Impala Amazon Redshift PostgreSQL Segment MySQL Microsoft SQL Server	No integrations available	Elasticsearch Microsoft Azure Amazon S3 PostgreSQL Amazon Redshift AzureDataStudio Google Cloud Storage Kafka Google BigQuery Apache Spark

What are some alternatives to Mode, Piwik, Snowplow?

Google Analytics

Google Analytics lets you measure your advertising ROI as well as track your Flash, video, and social networking sites and applications.

Mixpanel

Mixpanel helps companies build better products through data. With our powerful, self-serve product analytics solution, teams can easily analyze how and why people engage, convert, and retain to improve their user experience.

Metabase

It is an easy way to generate charts and dashboards, ask simple ad hoc queries without using SQL, and see detailed information about rows in your Database. You can set it up in under 5 minutes, and then give yourself and others a place to ask simple questions and understand the data your application is generating.

Keen

Keen is a powerful set of API's that allow you to stream, store, query, and visualize event-based data. Customer-facing metrics bring SaaS products to the next level with acquiring, engaging, and retaining customers.

Superset

Superset's main goal is to make it easy to slice, dice and visualize data. It empowers users to perform analytics at the speed of thought.

Cube

Cube: the universal semantic layer that makes it easy to connect BI silos, embed analytics, and power your data apps and AI with context.

Power BI

It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.

Clicky

Clicky Web Analytics gives bloggers and smaller web sites a more personal understanding of their visitors. Clicky has various features that helps stand it apart from the competition specifically Spy and RSS feeds that allow web site owners to get live information about their visitors.

Google Datastudio

It lets you create reports and data visualizations. Data Sources are reusable components that connect a report to your data, such as Google Analytics, Google Sheets, Google AdWords and so forth. You can unlock the power of your data with interactive dashboards and engaging reports that inspire smarter business decisions.