I have this general question. Talking about a regular Newsletter, send each week or so to all my subscribers. Not a welcome-campaign for new sumbscribers or so. I do it like this:
create the Mials
Create a Campain and add each Mail with its send-date to it
Add an “IF read THEN add a Point” to each mail-branch of the campaign.
I find this extreeeeemly time consuming, as I need to create a freakin campaign every some weeks
All
I have this general question. Talking about a regular Newsletter, send each week or so to all my subscribers. Not a welcome-campaign for new sumbscribers or so. I do it like this:
create the Mials
Create a Campain and add each Mail with its send-date to it
Add an “IF read THEN add a Point” to each mail-branch of the campaign.
I find this extreeeeemly time consuming, as I need to create a freakin campaign every some weeks
That lead me raising this question.
An excellent question right now I create the email each week since Mautic doesn’t have this feature already build.
Before I have Mautic + Mailchimp combination but I change to create and send the email each time using Mautic with this I get some features that you can have using Mautic + Mailchimp.
Since Mautic is integrated with Joomla and Wordpress, wouldn’t it make sense to be able to pull posts from these CMS to make regular scheduled newsletter as well? Creating new email every week is definitely a hassle.
Well you should be able to pull posts and make newsletters out of them.
E.g., if you have self-hosted both Mautic and WP instances, I don’t see any limitations why you could not pull WordPress posts from its DB like this:
[code]SELECT wp_posts.id as post_id,
wp_posts.post_date,
wp_posts.post_title,
wp_posts.post_content,
wp_posts.post_status,
(SELECT name FROM wp_terms WHERE term_id = (SELECT term_id FROM wp_term_taxonomy WHERE term_taxonomy_id=tti.term_taxonomy_id)) as post_category,
(SELECT slug FROM wp_terms WHERE term_id = (SELECT parent FROM wp_term_taxonomy WHERE term_taxonomy_id=tti.term_taxonomy_id)) as post_parent,
(SELECT display_name FROM wp_users WHERE ID=wp_posts.post_author) as post_author
FROM wp_posts
INNER JOIN
(
SELECT object_id, wp_term_relationships.term_taxonomy_id FROM wp_term_relationships
INNER JOIN
(SELECT wp_term_taxonomy.term_taxonomy_id FROM wp_term_taxonomy WHERE parent=INSERT_PARENT_ID_HERE OR parent=INSERT_ANOTHER_PARENT_ID_HERE) AS term_taxonomy
ON wp_term_relationships.term_taxonomy_id = term_taxonomy.term_taxonomy_id
) AS news_posts
ON wp_posts.id=news_posts.object_id
LEFT OUTER JOIN
(
SELECT term_taxonomy_id, object_id
FROM wp_term_relationships
) AS tti
ON tti.object_id = wp_posts.id
WHERE wp_posts.post_status = 'publish'
ORDER BY wp_posts.post_date DESC[/code]
and, then, process them and convert them into emails by pushing their HTML code into Mautic using its REST API.
So technically speaking, yes, you are able to do it.