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)
Webtrends Analytics
Score3 out of 10
N/A
WebTrends provides an enterprise web analytics platform and, according to Forrester, has a strong focus on support for mobile and social channels and a very open platform. Webtrends competes directly with Adobe Site Catalyst, IBM Coremetrics. and comScore DigitalAnalytix.
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
Scenarios 1. If you want to use web server log files as input to your web analytics, then Webtrends will provides a good product, with great ease of implementation. Don't even think about being cheap on hardware, and make sure Webtrends runs on real servers, not in a VM environment. 2. If you want to use Data Tagging, similar to Google Analytics or Site Catalyst, Webtrends has a powerful product, just be prepared to pay. 3. If you are new to Web Analytics, but it is the strategic direction, start with Webtrends on Premises. Questions to Ask 1. What are you trying to accomplish? 2. Can you place a dollar value on the benefit that you expect/need from Webtrends? 3.Can you live with Webtrends running SaaS?
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
Control privacy, data sharing and competitive industrial knowledge using Webtrends on premises
Great control over custom reports, custom dimensions and metrics
Flexible tool which allows multiple methods of data capture. To my knowledge it was the first tool with a Tag Builder / Tag Management function built in via a supporting website.
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
The big downside, the elephant in the room, is that it does not (as of right now) have on-demand segmenting, drilldowns, etc. You have to think of what you want in advance and create those reports then analyze some data. This is huge. You can, of course, re-analyze old data after creating new reports but you still have to wait. (This deficiency may become obsolete with the release of Webtrends Explore later this month (May 2014).)
It has fewer mature integrations with other products and databases than competitors do, although I'm told it works with SharePoint better than anything else does.
Its attribution modeling capability is behind Google Analytics'. In my humble opinion, this could be changed quickly if Webtrends would make some tweaks to its standard visitor history files (i.e. preserve the order in which past visits were sourced beyond the single most recent one, rather than storing all those past sources as a randomized list).
It doesn't incorporate statistical tests, confidence intervals, or statistical associations. However, this same criticism can be applied to its competitors (other than A/B Testing products). It's a tabulation program, as they all are. In this respect, web analytics tools as a group are relatively primitive. Sorry to bring this up as a criticism of Webtrends but it's my pet peeve about the whole industry and I just have to say it. (p.s. take advantage of the heavy-duty Webtrends Scheduled Export functionality to get really granular data that you can feed to a stats program to get significances.)
Although the documentation, help screens, phone support and the knowledge base have improved tremendously in recent years, there is still a pretty steep learning curve because it is different from the tools that entry-level users may have already been exposed to. This can be a shock and many users are alienated at first because they just don't get some of the fundamentals at first. I'd like to see much better help screens that are thoroughly interlinked with the KB and documentation. Having superb online support would make a world of difference with the adoption of this basically powerful tool.
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
I would be willing to try Webtrends again AFTER some research from other users. I would need to see that users mention better and faster customer support on questions and issues that arise while using the software. The software is capable of vast and incredible things, but if it isnt properly set up and supported during use, it is just a big hassel and waste of everyones time and money.
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
If I could give it a 0, I would. Not having an intuitive user interface made it impossible to convince non-analytic business users to use the tool on their own. Even as a seasoned analyst, frequent calls were needed to get what should be simple tasks done. Account managers don't understand the tool either, and have to refer you to technical support
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
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
The v9 admin interface and v10 reporting interface work as well as expected, but have a tendency to be pokey, especially for bulky reports and whenever you're connected to wifi. I much prefer using the REST API for all reporting for this reason, which simply dumps out the data and doesn't bother with the user interface.
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
I once went on to Twitter to ask for help from my network of analytics people, and Webtrends themselves responded. They have been an excellent partner in making sure that their product is being used to the best of it's ability and I greatly appreciate that. Both Omniture and Google Analytics, do not have that level of support over social media
The in-person training was comprehensive enough to get you started, but I strongly recommend having a more experienced person when beginning with the tool.
Webtrends provides several free webinars over the course of the year, many of which I would expect to pay for. The people providing the webinars seem to have a good feel for real-world application of the product.
Careful planning and patience. Use a non-public test site to fine tune tags and reporting. Despite best laid plans, there will be surprises when you collect the data, run the analysis and begin generating reports using the tool. Perform a tag audit to ensure tags fire as desired.
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
Webtrends has its work cut out for itself considering you have the behemoth Google Analytics and Google Analytics Premium having a strong offering and brand recognition for the price of free. After reviewing the paid service I'd suggest you start off with GA as a cheaper alternative that is just as robust, if not much more flexible in regards to the reporting and goal tracking needs for our 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
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
Webtrends has had a positive impact on site visitation because it allowed us to understand the sources by domain for site traffic and find out ways to increase visits from those domains.
Webtrends has also allowed us to understand areas of optimization on the site, which has had a positive impact on the overall user journey on the site, likely leading to longer site duration and engagement.
