Excel4apps vs. Google Analytics

We have to calculate most all Lab / Pilot / Proposals sizing and results. The automated calculations in [Excel4apps] is awesome, as once you are familiar with them, it is easy to quickly implement them when needed.

Incentivized

Google Analytics is particularly well suited for tracking and analyzing customer behavior on a grocery e-commerce platform. It provides a wealth of information about customer behavior, including what products are most popular, what pages are visited the most, and where customers are coming from. This information can help the platform optimize its website for better customer engagement and conversion rates. However, Google Analytics may not be the best tool for more advanced, granular analysis of customer behavior, such as tracking individual customer journeys or understanding customer motivations. In these cases, it may be more appropriate to use additional tools or solutions that provide deeper insights into customer behavior.

• Easy to install and maintain. After the initial installation, there is little involvement by the technical administrators.
• Cloning production to a test environment does not require any additional setups unlike Oracle EBS which does.
• Loading data and reporting on this data is handled via EXCEL spreadsheets which is the "language" of our financial users.

Incentivized

• Multiple reports to see website use and behavior
• Allows you to customize reports with days, weeks, months, and years
• You can build out a dashboard to easily view stats from multiple websites in one place
• You can share analytics reports via the dashboard, automatically emailed PDFs or in other formats

Incentivized

• It is possible but difficult to retrieve data or set criteria from different module into a single report or retrieve. If it is more user friendly instead of having to create a complex formula to retrieve the data, this function will be utilized more often.
• It will be nice to have visual (graphs, etc.) report template available
• It is helpful if we can retrieve data for a range of date, instead of just YTD, PTD etc. and multi-year data all at once for comparison too.

Incentivized

• Data sampling is somewhat inaccurate on the free tier - this is addressed in premium but is expensive.
• Some of the UI is very similar in naming when presenting different data, some in-situ information might be useful.
• Gotchas around filtering and data validation.
• Implementation can be tricky, it can take a lot of time and expertise to get a full, accurate picture of your metrics.

Incentivized

We will continue to use Google Analytics for several reasons. It is free, which is a huge selling point. It houses all of our ecommerce stores' data, and though it can't account for refunds or fraud orders, gives us and our clients directional, real time information on individual and group store performance.

Incentivized

I am not a power user of Excel. So I find Exel4apps a friendlier version of the things that I could do on Excel and making it easier with a magic wand.

Incentivized

Google Analytics provides a wealth of data, down to minute levels. That is it's greatest detriment: find the right information when you need it can be a cumbersome task. You are able to create shortcuts, however, so it can mitigate some of this problem. Google is continually refining Analytics, so I do not doubt there will be improvements

We all know Google is at top when it comes to availability. We have never faced any such instances where I can suggest otherwise. All you need is a Google account, a device and internet connection to use this super powerful tool for reporting and visualising your site data, traffic, events, etc. that too in real time.

This has been a catalyst for improving our site's traffic handling capabilities. We were able to identify exit% from our sites through it and we used recommendations to handle and implement the same in our sites. We have been increasing the usage of Google Analytics in our sites and never had any performance related issues if we used Analytics

I have not needed support yet

Incentivized

The Google reps respond very quickly. However, sometimes they can overly call you to set up an apportionment. I'm very proficient and sometimes when I talk to reps, they give beginner tutorials and insights that are a waste of time. I wish Google would understand my level of expertise and assign me to a rep (long-term) that doesn't have to walk me through the basics.

Incentivized

love the product and training they provide for businesses of all sizes. The following list of links will help you get started with Google Analytics from setup to understanding what data is being presented by Google Analytics.

1. How to Use Google Analytics for Beginners – Mahalo’s how-to guide for beginners.
2. A beginner’s guide to Google Analytics – A free eBook walking you through Google Analytics from setup to understanding what data is being presented.
3. Getting to Know Your Google Analytics Dashboard – The title says it all! This is a brief post with one goal: to introduce you to the Google Analytics dashboard.
4. Google Analytics for Beginners: How to Make the Most of Your Traffic Reports– This guide doesn’t cover setup, but it does a great job of helping you to better understand the data being presented.
5. Google Analytics Video Tutorial 1: Setup – A video presentation that walks you through Google Analytics setup.
6. Google Analytics Video Tutorial 2: Essential Stats – A video presentation that introduces you to some of the most important data being presented in Google Analytics.

I think my biggest take away from the Google Analytics implementation was that there needs to be a clear understanding of what you want to achieve and how you want to achieve it before you start. Originally the analytics were added to track visitors, but as we became more savvy with the product, we began adding more and more functionality, and defining guidelines as we went along. While not detrimental to our success, this lack of an overarching goal resulted in some minor setbacks in implementation and the collection of some messy data that is unusable.

Excel4apps is more user friendly and can retrieve data much easier and in a nicer format than Jaspersoft. Qlik Sense is useful and have more visual reporting and dashboard. However, it is usually used for higher level of analyses and review. Yardi is used for specific purpose, which is different than Excel4apps. Excel4apps can pull all the financial data from Oracle, including billing and collections.

Incentivized

I have not used Adobe Analytics as much, but I know they offer something called customer journey analytics, which we are evaluating now. I have used Semrush, and I find them much better than Google Analytics. I feel a fairly nontechnical person could learn Semrush in about a month. They also offer features like competitive analysis (on content, keywords, traffic, etc.), which is very useful. If you have to choose one among Semrush and Google Analytics, I would say go for Semrush.

Incentivized

Google Analytics is currently handling the reporting and tracking of near about 80 sites in our project. And I am not talking about the sites from different projects. They may have way more accounts than that. Never ever felt a performance issue from Google's end while generating or customising reports or tracking custom events or creating custom dimensions

• Increase team transparency
• Increased reporting

Incentivized

• It has helped us gain understanding of what is going on on our website.
• It has helped us determine areas that need fixing (i.e. pages with extremely high bounce rates may need to be redone).
• It has helped us understand our biggest avenues for bringing traffic to the website and business in general.
• It has helped guide our website redesign.

Incentivized