Constant Contact is a full-featured email marketing solution with capabilities such as social media integration, drag-and-drop editing, and real-time reporting. It is a bulk email tool designed for SMB customers. Since 2019, Constant Contact also offers marketing automation features, a website and landing page builder, and other tools to support midsize businesses.
$12
per month
SSIS
Score8 out of 10
N/A
Microsoft's SQL Server Integration Services (SSIS) is a data integration solution.
N/A
Pricing
Constant Contact
SSIS
Editions & Modules
Lite
Starting at $12.00
per month
Standard
Starting at $35.00
per month
Premium
Starting at $80.00
per month
No answers on this topic
Offerings
Pricing Offerings
Constant Contact
SSIS
Free Trial
Yes
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
The SMS Marketing tool can be added to any Standard or Premium Constant Contact account. SMS is only available in the US for Standard and Premium paid plans. SMS can be added when logged in to an account after purchase. Plans start at $10/month for up to 500 messages.
Constant Contact is an excellent tool for sending out flyers and newsletters. However, I feel the content's appearance is typically all the same. When I receive an email from Constant Contact, I can immediately identify it - the templates usually all look the same. When sending out communications with images, it is easy to use Constant Contact and link webpages. However, the email layout is always vertical and can get very lengthy. I prefer a more flip-book approach with options to flip the page.
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.
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
Market segmentation is great: my main segmentation is by region because that's how our sales team is divided.
Lists: making customized email lists is easy and intuitive; the custom fields allow some flexibility in case our fields don't exactly line up with Constant Contact's.
Campaigns: creating campaigns is quick and simple. I especially appreciate the 'resend to non-openers' option. I am constantly using this feature.
Subject line generator: I like using the recommended subject lines. I'm able to plug in their recommended ideas, or sometimes, this feature helps me generate my own ideas.
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
It would be nice if we had more customizable options for emails - like moving around pictures and text boxes, rather than a set spot for everything to go.
I would like it if multiple people could work on a document at one time. So if I'm in charge of graphics, I can get those updated while someone else is entering content, etc.
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.
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
There is no doubt that we are going to renew Constant Contact. We have not just invested a lot of time in learning and creating a great looking product but we have developed a strong database of information that allows us to track how we are doing for each newsletter. This supports our goals of creating products that residents desire and are excited to receive.
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
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
There is always room for improvement. I don't know how they test their systems, but they should invite not-so computer savvy people to test it. If I, as an expert have problems, they need to think like the technophobe. Since I've used Constant Contact in the past as part of my former employment, I have not viewed any of the tutorials and just jumped in to work on my client's newsletter. With that said, I found some areas easy and some a bit cumbersome
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.
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
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
The system seemed quite slow sometimes. Specifically, there was sometimes a delay in sends if it was during a high traffic period. There were time-outs when uploading new code for an email, and a lag in reporting analytics which was sometimes as long as 72 hours
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.
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 the overall support for Constant Contact has always been incredible; I have nothing negative to say. Our customer support representative was attentive, easy to understand, and very knowledgeable. I never felt like I wasn't a priority of his and my issues, while very small, were fixed in a very short time frame.
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.
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
Implementation is very easy for someone who wants to send out the “batch and blast” type newsletters. If you want to use their templates with no customizations, the product works fine. However, the more customizations you get into involving link color, etc, that’s where things can get tricky for someone who may not be familiar with coding
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
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
Constant Contact is much more intuitive for people who are not tech-savvy. Also, while sendgrid offered more options in it's drag and drop interface, it displayed differently across different email clients, which made it very cumbersome to use. It also took much longer to upload contact lists and it was harder to manage existing contacts. Performance in sendgrid was much slower as well, and the Preview feature was quite buggy. Our team initially chose sendgrid because of the integration options that it's API offered, but we ultimately switched to Constant Contact because it was much easier to build campaigns and better suited our requirements.
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
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
Very reliable in sending email campaigns and controlling the recipients so that no contact is sent the same email more than once, even if they are on a resent list
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 have had nothing but positive impacts from using Constant Contact.
The church is large, and there are many subgroups and axillary groups within the church. Setting up specific groups based on responsibility, interest, member goals, and service needs allows me to send information quickly, saving valuable time for other tasks.
Constant Contact allows leadership to stay personally engaged with the members I work with, without over-taxing my time. It feels so seamless.
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.
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
