Email marketing

Hi Vendim,

Yes, if you send emails from Email marketing Kentico will automatically wrap all the URLs in the email for you and add a tracking. So SMTP relay should only send those prepared emails and tracking should be working. At least it was working for me with SendGrid SMTP.

No the Kentuco system will not pull back any analytical data MailJet. But as Dmitry stated if you use the newsletter/email marketing features of Kentico you can get a lot of those from there.

thanks Both for you answers. so its that advisable to get the data from mailjet ( or any other provider) and insert back to Kentico Tracking table? Also what table in the database Kentico store all those emails tracking analytics?

I think you're misunderstanding what we both said Vendim. NO, out of the box, you cannot get the analytical data from MailJet (or any other provider) and insert it back into Kentico. If you want to do something like this you'd need to create your own module and display options around the aggregated data you get from your custom code or 3rd party service.

On the other hand, Kentico does offer email tracking out of the box with the EMS license using Email Marketing. It does not have as robust of a tracking system as some of the SMTP providers do but it does provide some good email analytics.

Thanks Brenden yes we do have EMS license for email marketing and I do see that it tracks only if the email is set up as Newsletter or Campaign type. I was just wondering in regards to custom module for getting the data from the 3rd party is that advised to use the Kentico existing table/objects to insert the analytics or create a custom module/Table to store all those Analytics?

To be consistent and utilise other online-marketing features (like reports, web analytics, marketing automation and so on) you would need to use out-of-the-box Kentico activity types:

But it wouldn't be considered a good practice to add those activities directly in the database. You should use Kentico API to log thos activities. Ideally, it can be Kentico task which can pull activities from MailJet via their API and log them into Kentico as standard activities.

If Kentico has the existing tables for email analytics then why not use Kentico? Maybe I'm not following what you want. For instance, with SendGrid, I can see some similar things like I can see in Kentico:

• Email opens
• Link clicks
• Unsubscribes

In SendGrid, I can see the following (but not all in Kentico):

• Global Stats
• Category Stats
• Category Comparison
• Subuser Stats
• Subuser Comparison
• Geographical
• Email Clients & Devices
• Mailbox Provider Stats
• Mailbox Provider Comparison
• Browser Stats
• Browser Comparison

Plus these:

But as I mentioned, Kentico doesn't have all of this so you'd have to create custom module classes to store this data (if you're able to get it out of your SMTP provider) and write it in those tables. Not sure why you'd want to do this vs. use the UI that is already available but to each their own.

HI all I know my initial question was answer but I have a quick one.I am tracking the SQL that get executed when an email campaign is scheduled to send emails out. I am looking to retrieve @IssueID which is a field on Newsletter_NewsletterIssue. is there a way to capture that via KEntico API or other way in the code? below is the query that gets executed when email is getting created and also it get executed when it scheduled or send. I want to get the IssueDisplayName from that PArameter to pass it to an external email Provider via API.

DECLARE @IssueID int = 9;

SELECT TOP 1 * FROM Newsletter_NewsletterIssue WHERE [IssueID] = @IssueID

Ask your question in a new post.