Kissmetrics vs. SQL Server Integration Services (SSIS)

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

Incentivized

Independently Invited by TrustRadius

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

As I mentioned earlier SQL Server Integration Services is suitable if you want to manage data from different applications. It really helps in fetching the data and generating reports. Its automation make it very easy and time efficient. It works well with large database as well. But it doesn't work well with real time data, it will take some time to gather the real time data. I would not recommend using it in a real time/fast-paced environment.

Incentivized

Independently Invited by TrustRadius

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.
• Customer support!

• Standard ETL use cases for daily loads
• Loading incoming data from Vendors which is placed on FTP and adding them to the SQL Warehouse
• Creating outgoing data files and writing them to Vendor FTPs
• Easy Active Directory integration for seamless connections to SQL Server
• CI/CD by hosting the code on visualstudio.com

Incentivized

Independently Invited by TrustRadius

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.

Incentivized

Independently Invited by TrustRadius

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

• Connection managers for online data sources can be tricky to configure.
• Performance tuning is an art form and trialing different data flow task options can be cumbersome. SSIS can do a better job of providing performance data including historical for monitoring.
• Mapping destination using OLE DB command is difficult as destination columns are unnamed.
• Excel or flat file connections are limited by version and type.

Incentivized

Independently Invited by TrustRadius

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

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

Some features should be revised or improved, some tools (using it with Visual Studio) of the toolbox should be less schematic and somewhat more flexible. Using for example, the CSV data import is still very old-fashioned and if the data format changes it requires a bit of manual labor to accept the new data structure

Incentivized

Independently Invited by TrustRadius

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.

SSIS is a great tool for most ETL needs. It has the 90% (or more) use cases covered and even in many of the use cases where it is not ideal SSIS can be extended via a .NET language to do the job well in a supportable way for almost any performance workload.

Incentivized

Independently Invited by TrustRadius

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.

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.

SQL Server Integration Services performance is dependent directly upon the resources provided to the system. In our environment, we allocated 6 nodes of 4 CPUs, 64GB each, running in parallel. Unfortunately, we had to ramp-up to such a robust environment to get the performance to where we needed it. Most of the reports are completed in a reasonable timeframe. However, in the case of slow running reports, it is often difficult if not impossible to cancel the report without killing the report instance or stopping the service.

Incentivized

Independently Invited by TrustRadius

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.

The support, when necessary, is excellent. But beyond that, it is very rarely necessary because the user community is so large, vibrant and knowledgable, a simple Google query or forum question can answer almost everything you want to know. You can also get prewritten script tasks with a variety of functionality that saves a lot of time.

Incentivized

Independently Invited by TrustRadius

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

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

The implementation may be different in each case, it is important to properly analyze all the existing infrastructure to understand the kind of work needed, the type of software used and the compatibility between these, the features that you want to exploit, to understand what is possible and which ones require integration with third-party tools

Incentivized

Independently Invited by TrustRadius

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

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.

Incentivized

Independently Invited by TrustRadius

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 SQL Server Integration Services is better suited for on-premises data movement and ADF is more suited for the cloud. Though ADF has more connectors, SQL Server Integration Services is more robust and has better functionality just because it has been around much longer

Incentivized

Independently Invited by TrustRadius

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

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

Incentivized

Independently Invited by TrustRadius

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

• Without this, we would have to manually update a spreadsheet of our SQL Server inventory
• We would also have poor alerting; if an instance was down we wouldn't know until it was reported by a user
• We only have one other person who uses SQL Server Integration Services , he's the expert. It would fall to me without him and I would not enjoy being responsible for it.

Incentivized

Independently Invited by TrustRadius

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