Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
$6.25
per TiB (after the 1st 1 TiB per month, which is free)
Kissmetrics
Score9.6 out of 10
Mid-Size Companies (51-1,000 employees)
Kissmetrics is a customer engagement automation platform. This solution includes behavioral analytics, segmentation, and email campaign automation.
$150
per month
Pricing
Google BigQuery
Kissmetrics
Editions & Modules
Standard edition
$0.04 / slot hour
Enterprise edition
$0.06 / slot hour
Enterprise Plus edition
$0.10 / slot hour
Growth
$500
Monthly Tracked People
Power
$850
Monthly Tracked People
Enterprise
Custom
Monthly Tracked People
Offerings
Pricing Offerings
Google BigQuery
Kissmetrics
Free Trial
Yes
Yes
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
$1,500 per installation
Additional Details
—
What are Monthly Tracked People?
Monthly Tracked People are unique visitors that engage in an Event on your website or with your product, that gets tracked by you in Kissmetrics.
Monthly Tracked People can be anonymous or identified.
Event-based data can be captured seamlessly from our data layers (and exported to Google BigQuery). When events like page-views, clicks, add-to-cart are tracked, Google BigQuery can help efficiently with running queries to observe patterns in user behaviour. That intermediate step of trying to "untangle" event data is resolved by Google BigQuery. A scenario where it could possibly be less appropriate is when analysing "granular" details (like small changes to a database happening very frequently).
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
[Kissmetrics is well suited for the] abandon cart scenario to re-engage users on the purchase journey. Engaging users to personalized content using the visit metrics derived from the data captured at each digital touch points. [Implementing] website campaign and journey orchestration is easy. You get visitor profile to segment upon using different visit metrics and action.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
GSheet data can be linked to a BigQuery table and the data in that sheet is ingested in realtime into BigQuery. It's a live 'sync' which means it supports insertions, deletions, and alterations. The only limitation here is the schema'; this remains static once the table is created.
Seamless integration with other GCP products.
A simple pipeline might look like this:-
GForms -> GSheets -> BigQuery -> Looker
It all links up really well and with ease.
One instance holds many projects.
Separating data into datamarts or datameshes is really easy in BigQuery, since one BigQuery instance can hold multiple projects; which are isolated collections of datasets.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The more events you track and properties you send along, the more you can see how specific users use your product/service. The user based timeline gives you a perfect start point to get in touch with users, because you can see where they get stuck.
Tracking your traffic sources and how they influence conversions is awesome. You can get a perfect view of how much a traffic source contributes to revenue.
Funnel reports give you more insights into micro and macro conversion steps and give you actionable data to work with.
Please expand the availability of documentation, tutorials, and community forums to provide developers with comprehensive support and guidance on using Google BigQuery effectively for their projects.
If possible, simplify the pricing model and provide clearer cost breakdowns to help users understand and plan for expenses when using Google BigQuery. Also, some cost reduction is welcome.
It still misses the process of importing data into Google BigQuery. Probably, by improving compatibility with different data formats and sources and reducing the complexity of data ingestion workflows, it can be made to work.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Installing.... yes this is also a negative. While you can install and have the program running in minutes, if you use Unbounce, the form tracking process is quite complicated!
Updates... I feel like the product updates have slowed a lot lately. Thankfully, the product functionality is so amazing that it hasn't impeded the use of it. However, it is still disappointing to see less frequent software updates.
Occasionally clunky UI... there are a few reports that are really easy to mess up and leave you scratching your head on why it isn't showing you any data.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We have to use this product as its a 3rd party supplier choice to utilise this product for their data side backend so will not be likely we will move away from this product in the future unless the 3rd party supplier decides to change data vendors.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Price sensitivity and the different choices that now exist in the Analytics industry. I think it makes sense for us sometime this year to rethink our analytics strategy to see how we may leverage the best of GA (which has included lots of new features and updates the past years_, Kiss and other tools as need be
I think overall it is easy to use. I haven't done anything from the development side but an more of an end user of reporting tables built in Google BigQuery. I connect data visualization tools like Tableau or Power BI to the BigQuery reporting tables to analyze trends and create complex dashboards.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Right after login, you'll get to a dashboard which shows you a quick view on how your business is doing across the events you are tracking. There is no need to dig deeper than that unless you want to, in which case it's very easy to do so just by clicking on the metric on which you want more information. The interface is very intuitive.
I have never had any significant issues with Google Big Query. It always seems to be up and running properly when I need it. I cannot recall any times where I received any kind of application errors or unplanned outages. If there were any they were resolved quickly by my IT team so I didn't notice them.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
The application was very rarely down; during the period we used the application, I can think of only two or three occasions in which the site was down. Notably, at no time was the the performance of our own site compromised as a result.
I think Google Big Query's performance is in the acceptable range. Sometimes larger datasets are somewhat sluggish to load but for most of our applications it performs at a reasonable speed. We do have some reports that include a lot of complex calculations and others that run on granular store level data that so sometimes take a bit longer to load which can be frustrating.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Speed improved dramatically as the service matured. Early iterations of the publicly-released application would occasionally provide slow processing of results, but those delays became much rarer occurrences during the last year that we used KISSmetrics. One of the more impressive views (which started out feeling more like a toy) is the live view of visits. Knowing that you could see, in real time, what events a user triggered, was gratifying and instructive.
BigQuery can be difficult to support because it is so solid as a product. Many of the issues you will see are related to your own data sets, however you may see issues importing data and managing jobs. If this occurs, it can be a challenge to get to speak to the correct person who can help you.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Our front-line product support person (Mika) is great. She is responsive and great to work with.
However, the data accuracy issue described earlier is the reason for the low score here. This issue was escalated from front-line to support to level 2 technical support and then it disappeared into a black hole. Escalations, in general, do not go well. We get no response for days, or I have to chase things down. This is not acceptable. Marketing metrics are critically important to me and I need answers quickly. I cannot afford to wait around for days / weeks for a response.
Just to be clear, these comments only apply to escalated support issues.
Again, we were fortunate to work with KISSmetrics as they built their application, but Hiten, their CEO and founder, was incredibly helpful to me personally, and to our metrics-driven business as a whole, as we adopted their tool.
I loved this aspect of the product. It wasn't just that the documentation and online tutorials are great - which they are - the on-boarding process though was really stellar. Once you have set everything up, you get a welcome message followed by a step-by-step guide to get you started that is built right into the product interface. For example, the UI asks you to first do X, and then copy this code snippet and send it to your developer who will know what to do with it. When you come back after the first interaction with the product, it continues the process by explaining right in the UI how to track events etc. This kind of step-by-step approach is incredibly efficient. Although there are various forms of supporting documentation (PDFs videos etc) to support every step, you don't really need them. This approach means that you are up and running very quickly with virtually no training time or documentation consultation. Highly efficient process.
In order to build trackability down to revenue, there was quite a lot of work to integrate Kissmetrics with our software and internal process. We had to build the hooks so that Kissmetrics could call back into our software and billing system, etc.. However, we didn't need additional expertise to do this. Once you understand the API, and you own systems, making it work is not too difficult. We did not require an outside consultant or anything like that
PowerBI can connect to GA4 for example but the data processing is more complicated and it takes longer to create dashboards. Azure is great once the data import has been configured but it's not an easy task for small businesses as it is with BigQuery.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Kissmetrics is a next-level step up for people who are used to getting their tracking and reporting from Google Analytics or Shopify's CMS. While HubSpot arguably has a better user interface, Kissmetrics certainly has the power and usability necessary to track important conversion data and help you make better marketing decisions.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
We have continued to expand out use of Google Big Query over the years. I'd say its flexibility and scalability is actually quite good. It also integrates well with other tools like Tableau and Power BI. It has served the needs of multiple data sources across multiple departments within my company.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Google Support has kindly provide individual support and consultants to assist with the integration work. In the circumstance where the consultants are not present to support with the work, Google Support Helpline will always be available to answer to the queries without having to wait for more than 3 days.
Previously, running complex queries on our on-premise data warehouse could take hours. Google BigQuery processes the same queries in minutes. We estimate it saves our team at least 25% of their time.
We can target our marketing campaigns very easily and understand our customer behaviour. It lets us personalize marketing campaigns and product recommendations and experience at least a 20% improvement in overall campaign performance.
Now, we only pay for the resources we use. Saved $1 million annually on data infrastructure and data storage costs compared to our previous solution.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info
Unfortunately for this client (small business) the cost of Kissmetrics was just too prohibitive. But it's obvious that for a larger company that can afford it, the data would be invaluable to gain more insight in how to gain more active users and orders for a funnel.
The data provided really increases an understanding of how best to provide the right experience for the users...happy users equals increase in ROI.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
