Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. CKG Edit ===== Concept ===== The marketing module allows for the querying of data stored in the Cyrious SMS database. This how to will focus on exporting every email address from the database. ===== Cautions ===== None ===== Steps ===== - Open Cyrious SMS - Click on Marketing on the top menu and then select Marketing again. {{::marketing_1.png?nolink&|}} - Click on Contact Report {{::marketing_contactreport_1.png?nolink&|}} - In the right-most column click the arrow on the **INS** button and choose **Insert ALL (and)**. {{::marketing_contactreport_1a.png?nolink&|}} - In the left-most column, click the + sign to expand **Contact Criteria**. - Double click on **General Criteria** to expand the choices. * Double click to add **Contact is Active** * Double click to add **Contact has an Email address set** {{::marketing_contactreport_2.png?nolink&|}} - Verify the Report Criteria section resembles the example screenshot below. {{::marketing_contactreport_3.png?nolink&|}} - Click the Next Step button in the bottom right corner to proceed to step **4. Preview & Sort Results**. {{::marketing_contactreport_nextstep.png?nolink&|}} - Click the Next Step button in the bottom right corner to proceed to step **5. Format & Output Report**. {{::marketing_contactreport_nextstep.png?nolink&|}} - Click on the button **Save Data to File**. {{::marketing_contactreport_3b.png?nolink&|}} - Select any columns you desire to include in your export, be sure to include at a minimum **EmailAddress**. - Verify the **Export Format** is set to **Text File (comma delimited)**. - Click **Export Data** to export the list of emails. {{::marketing_contactreport_4.png?nolink&|}} - You can now open this file in excel or upload it to any other program and/or online service that accepts comma delimited files. ===== Source ===== Contributor: Brandon Readlinger, Cyrious Date: 3/31/2014 Version: SMS 8.6