Google BigQuery vs. Sitecore Digital Experience Platform

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).

Incentivized

Sitecore offers Content Hub with Product Content Management and Content Management Platform. The Digital Experience Platform and Content Hub can both host structured content and publish the finalized version to Experience Edge. Both platforms offer different ways to manage content. During a technical and business evaluation, the evaluation panel must understand the difference between a Content Modelling focused approach, or a layout management focused approach. Sitecore Digital Experience Platform is also best not to be used to host many files and images in the Media Library. That responsibility should be offloaded to a digital asset management company like Sitecore Content Hub DAM. The technology evaluation panel must also understand how to work with a Headless CMS, where the HEAD needs to be hosted, and the costs associated with the HEAD. Composable DXP is fantastic, but everyone must understand the various cost components. Marketers and the data team will need to go into the CDP and Personalize the platform with an excellent understanding of how a composable "installation" works. All the Martech vendors have similar challenges that data and development teams need to work through with a full experience. Any CDP/analytics platform will, at some stage, require further data enrichment from other sources. Understanding the Sitecore Search features and limitations is also essential.

Incentivized

• Realtime integration with Google Sheets.
• 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.

Incentivized

• Comprehensive Solution: Sitecore offers a fully integrated suite of products that cover the full spectrum of DXP capabilities, including search, personalization experimentation and more, delivering a complete composable DXP solution for customers.
• Beyond Headless: XM Cloud provides more than just headless capabilities, featuring in-built tools like authoring host, page editor, etc., enabling faster and more powerful implementations.
• Focus on AI: Sitecore has now got an excellent AI offering called Stream; it looks promising; however, it would be too early to give feedback on the same.
• Customization: Sitecore's backend is highly customizable, allowing for deep modifications through pipelines and patch configurations.

Incentivized

• 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.

Incentivized

• Experience Editor is a little old fashioned and sometimes slow to use.
• Bulk operations in the Content Editor
• Sitecore serialization is should be part of the Content Editor to provide visual reference for items which are serialized and will be overwritten by future deployments similar to what Unicorn does so well

Incentivized

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.

Incentivized

Sitecore has proven that it can deliver on its promise of a robust, reliable enterprise CMS solution with plenty of features. Also, they keep updating it with more and better features. Now that we are highly trained on it we have started on getting the most out of it and we plan to keep doing more of that in the future.

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.

Incentivized

Once you learn how to use the platform and can put a solid strategy in place to manage it long-term, it becomes a lot easier to use. The tricky part is working with resources who are familiar with the platform to navigate some of the common implementation and configuration pitfalls. Although Sitecore has worked very hard to overcome some of these from their earlier product versions by creating wizards and improving their support documentation, at the end of the day it is still a very complex and powerful system that needs to be implemented carefully in order to foster the best possible user experience for authors. So it could be rated very usable or not usable at all based on how much planning took place and the quality of the implementation.

Incentivized

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.

Incentivized

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.

Incentivized

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.

Incentivized

1. Customized software development & maintenance. 2. Technology Consulting - Consulting-based services for technology solutions data engineering or cloud solutions. 3. Used for tapping into multiple data sources such as CRM and marketing automation systems and, creating automated data extracts with a high-end visual representation of data. 4. Implemented for scheduling an existing report to automatically refresh and be delivered to specific users at a specific regular interval.

Incentivized

Sitecore captures and remembers every single interaction your customers and prospects have in any part of the system, allowing you to build comprehensive, ever-learning profiles of each individual. From email marketing, to social media, to online shopping, Sitecore remembers where each interaction left off so you can automatically continue the conversation. Sitecore helps you manage your content for each and every experience your customers enjoy. Customize what content you want and the system will take care of how it's displayed.

Make sure you work with a partner that can help you take advantage of the entire platform. Specifically we see a lot of customers not taking advantage of Sitecore DMS and thus missing a huge opportunity. Sitecore is a platform that is meant to be constantly optimized and improved upon.

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.

Incentivized

Sitefinity is improving but at the time of decision making it had nothing that could compare with the A/B testing and personalisation features that Sitecore offers. This was a key differentiator and ultimately ensured Sitecore was purchased. WordPress isn't really comparable and isn't within our technology stack, which is mostly Microsoft.

Incentivized

None so far. Very satisfied with the transparency on contract terms and pricing model.

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.

Incentivized

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.

Incentivized

• ROI depends on what features the customer wants to leverage from Sitecore. Sitecore is not just a CMS. It's CEP platform which comes with Analytics, Personalization, A/B Testing, and Email for marketers modules etc., out of the box.
• Based on my experience some of the customers lean towards third party services. This is primarily due to lack of the understanding of these features. If a customer leverages these out of the box features ROI will be high. It depends on how much is being [sent] to third parties services.
• Sitecore has very good accelerators in the market. These accelerators allows you to create response sites very quickly. If a simple campaign site takes 50K to build the site may save at least 50% of that cost. Examples of site accelerators are Brainjocks, Keystone, Cognifide etc.

Incentivized