Feature Tour - eNewsletter

This module is used by Administrators and Member to manage the creation and distribution of eNewsletters. This Feature Tour uses the example of a Member sending out an eNewsletter to his/her Associates.

01
Member creates an eNewsletter with Wizard and easy-to-use eNewsletter templates and sends it out to his/her Associates.

VoterConnect Exclusive:

Member can use Jurisdiction filter to send eNewsletter only to associates in a defined district.

Feature Highlight:

Member can upload files as attachments to the eNewsletter and use merged fields to personalize the eNewsletter.
02
Member can run eNewsletter report showing bounce rate, open rate, forwarding rate and click-through rate.

(default) 14 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `admins`11111
2DESCRIBE `countries`771
3DESCRIBE `naadmins`52523
4DESCRIBE `states`10101
5DESCRIBE `plan_price_modules`12121
6DESCRIBE `plan_price_users`661
7DESCRIBE `naadmin_plans`21211
8DESCRIBE `naadmin_payments`23231
9DESCRIBE `naadmin_card_details`18181
10DESCRIBE `invite_users`441
11DESCRIBE `customize_member_sections`25251
12DESCRIBE `default_cms_pages`16161
13DESCRIBE `default_website_templates`60602
14DESCRIBE `customize_footer_logos`441
(test) 25 queries took 23 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `cms_pages`10101
2DESCRIBE `mail_templates`441
3DESCRIBE `mail_template_contents`881
4DESCRIBE `users`74742
5DESCRIBE `home_module_displays`11111
6DESCRIBE `communiques`37371
7DESCRIBE `articles`881
8DESCRIBE `polls`661
9DESCRIBE `poll_options`331
10DESCRIBE `poll_results`441
11DESCRIBE `private_members`73732
12DESCRIBE `communique_mores`551
13DESCRIBE `donations`30301
14DESCRIBE `donation_recognitions`771
15DESCRIBE `custom_front_styles`42422
16DESCRIBE `links`991
17DESCRIBE `sections`881
18DESCRIBE `customize_cms_pages`16161
19DESCRIBE `customize_websites`63632
20SELECT `CustomFrontStyle`.`id`, `CustomFrontStyle`.`created_by`, `CustomFrontStyle`.`table_name`, `CustomFrontStyle`.`template_format`, `CustomFrontStyle`.`logo_image`, `CustomFrontStyle`.`hide_logo`, `CustomFrontStyle`.`header_image`, `CustomFrontStyle`.`hide_header_image`, `CustomFrontStyle`.`hide_subpage_header_image`, `CustomFrontStyle`.`header_text`, `CustomFrontStyle`.`header_text_color`, `CustomFrontStyle`.`header_text_font`, `CustomFrontStyle`.`header_text_size`, `CustomFrontStyle`.`hide_header_text`, `CustomFrontStyle`.`body_text_color`, `CustomFrontStyle`.`body_text_font`, `CustomFrontStyle`.`body_text_size`, `CustomFrontStyle`.`body_background_color`, `CustomFrontStyle`.`body_background_image`, `CustomFrontStyle`.`hide_background_image`, `CustomFrontStyle`.`body_background_type`, `CustomFrontStyle`.`navigation_bar_color`, `CustomFrontStyle`.`navigation_text_hover_color`, `CustomFrontStyle`.`navigation_text_color`, `CustomFrontStyle`.`navigation_text_font`, `CustomFrontStyle`.`navigation_text_size`, `CustomFrontStyle`.`menu_text_color`, `CustomFrontStyle`.`menu_text_hover_color`, `CustomFrontStyle`.`menu_text_font`, `CustomFrontStyle`.`menu_text_size`, `CustomFrontStyle`.`button_color`, `CustomFrontStyle`.`button_hover_color`, `CustomFrontStyle`.`theme_color`, `CustomFrontStyle`.`text_color`, `CustomFrontStyle`.`theme_text_font`, `CustomFrontStyle`.`theme_text_size`, `CustomFrontStyle`.`link_color`, `CustomFrontStyle`.`heading_text_color`, `CustomFrontStyle`.`body_transparency`, `CustomFrontStyle`.`status`, `CustomFrontStyle`.`message_color`, `CustomFrontStyle`.`header_body_color` FROM `custom_front_styles` AS `CustomFrontStyle` WHERE 1 = 1 LIMIT 1110
21SELECT `CustomFrontStyle`.`id`, `CustomFrontStyle`.`created_by`, `CustomFrontStyle`.`table_name`, `CustomFrontStyle`.`template_format`, `CustomFrontStyle`.`logo_image`, `CustomFrontStyle`.`hide_logo`, `CustomFrontStyle`.`header_image`, `CustomFrontStyle`.`hide_header_image`, `CustomFrontStyle`.`hide_subpage_header_image`, `CustomFrontStyle`.`header_text`, `CustomFrontStyle`.`header_text_color`, `CustomFrontStyle`.`header_text_font`, `CustomFrontStyle`.`header_text_size`, `CustomFrontStyle`.`hide_header_text`, `CustomFrontStyle`.`body_text_color`, `CustomFrontStyle`.`body_text_font`, `CustomFrontStyle`.`body_text_size`, `CustomFrontStyle`.`body_background_color`, `CustomFrontStyle`.`body_background_image`, `CustomFrontStyle`.`hide_background_image`, `CustomFrontStyle`.`body_background_type`, `CustomFrontStyle`.`navigation_bar_color`, `CustomFrontStyle`.`navigation_text_hover_color`, `CustomFrontStyle`.`navigation_text_color`, `CustomFrontStyle`.`navigation_text_font`, `CustomFrontStyle`.`navigation_text_size`, `CustomFrontStyle`.`menu_text_color`, `CustomFrontStyle`.`menu_text_hover_color`, `CustomFrontStyle`.`menu_text_font`, `CustomFrontStyle`.`menu_text_size`, `CustomFrontStyle`.`button_color`, `CustomFrontStyle`.`button_hover_color`, `CustomFrontStyle`.`theme_color`, `CustomFrontStyle`.`text_color`, `CustomFrontStyle`.`theme_text_font`, `CustomFrontStyle`.`theme_text_size`, `CustomFrontStyle`.`link_color`, `CustomFrontStyle`.`heading_text_color`, `CustomFrontStyle`.`body_transparency`, `CustomFrontStyle`.`status`, `CustomFrontStyle`.`message_color`, `CustomFrontStyle`.`header_body_color` FROM `custom_front_styles` AS `CustomFrontStyle` WHERE 1 = 1 LIMIT 1110
22SELECT `Link`.`id`, `Link`.`created_by`, `Link`.`table_name`, `Link`.`title`, `Link`.`cms_page_id`, `Link`.`position`, `Link`.`order`, `Link`.`isblocked`, `Link`.`isdeleted`, `CmsPage`.`id`, `CmsPage`.`created_by`, `CmsPage`.`table_name`, `CmsPage`.`page_name`, `CmsPage`.`page_content`, `CmsPage`.`keyword`, `CmsPage`.`meta_description`, `CmsPage`.`type`, `CmsPage`.`isblocked`, `CmsPage`.`isdeleted` FROM `links` AS `Link` LEFT JOIN `cms_pages` AS `CmsPage` ON (`Link`.`cms_page_id` = `CmsPage`.`id`) WHERE `Link`.`isdeleted` = '0' AND `Link`.`isblocked` = '0' AND `Link`.`position` = 'H' order by `Link`.`order` 11110
23SELECT `Link`.`id`, `Link`.`created_by`, `Link`.`table_name`, `Link`.`title`, `Link`.`cms_page_id`, `Link`.`position`, `Link`.`order`, `Link`.`isblocked`, `Link`.`isdeleted`, `CmsPage`.`id`, `CmsPage`.`created_by`, `CmsPage`.`table_name`, `CmsPage`.`page_name`, `CmsPage`.`page_content`, `CmsPage`.`keyword`, `CmsPage`.`meta_description`, `CmsPage`.`type`, `CmsPage`.`isblocked`, `CmsPage`.`isdeleted` FROM `links` AS `Link` LEFT JOIN `cms_pages` AS `CmsPage` ON (`Link`.`cms_page_id` = `CmsPage`.`id`) WHERE `Link`.`isdeleted` = '0' AND `Link`.`isblocked` = '0' AND `Link`.`position` = 'L' order by `Link`.`order` 000
24SELECT `Link`.`id`, `Link`.`created_by`, `Link`.`table_name`, `Link`.`title`, `Link`.`cms_page_id`, `Link`.`position`, `Link`.`order`, `Link`.`isblocked`, `Link`.`isdeleted`, `CmsPage`.`id`, `CmsPage`.`created_by`, `CmsPage`.`table_name`, `CmsPage`.`page_name`, `CmsPage`.`page_content`, `CmsPage`.`keyword`, `CmsPage`.`meta_description`, `CmsPage`.`type`, `CmsPage`.`isblocked`, `CmsPage`.`isdeleted` FROM `links` AS `Link` LEFT JOIN `cms_pages` AS `CmsPage` ON (`Link`.`cms_page_id` = `CmsPage`.`id`) WHERE `Link`.`isdeleted` = '0' AND `Link`.`isblocked` = '0' AND `Link`.`position` = 'R' order by `Link`.`order` 000
25SELECT `Section`.`id`, `Section`.`created_by`, `Section`.`table_name`, `Section`.`title`, `Section`.`content`, `Section`.`position`, `Section`.`order`, `Section`.`isdeleted` FROM `sections` AS `Section` WHERE `Section`.`isdeleted` = '0' AND `Section`.`position` = 'R' order by `Section`.`order` 330