Mountain View 1600, CA 94043
+1 650-253-0000
name@example.com
Web
Site
Search
Register
Login
DNN Home
Services
-
DotNetNuke Support
-
CRM Systems
DNN
-
DotNetNuke Modules
-
Module Downloads
-
Module Upgrade Policy
DNN Support
-
Module Update News
-
Knowledge Base
-
License Management
-
Invoice History
Module Downloads
Blog
Store
Contact Us
-
About Us
Search
Home
1
2
3
4
5
Home
Support
Bulk Emailer
SQL Queries to export campaign data
Previous
Next
2/24/2010 5:52 AM
Thomas Smith
Joined: 3/24/2009
Posts: 2
SQL Queries to export campaign data
(United States)
I have a hard time managing the data after a campaign has been sent (sent, read, read time, etc... ). I need some help with an sql query that I can use in SQL Express to export the data in a CSV file.
A rough example of what I am looking for:
SELECT [User_Email], [User_Name], [Read_DateTimeStamp]
FROM [Campaign_Table]
WHERE [Campaign_ID] = 1
AND [Email_Was_Read]
The query should render all the persons who read the email and the date/time when they read it. In SQL Express I can export the data to a CSV.
Anyone have any suggestions?
2/26/2010 12:55 AM
DNN Module Support
Joined: 8/28/2006
Posts: 2065
Re: SQL Queries to export campaign data
(Australia)
Are you trying to send a follow up message to everyone who opened a link? Because you can do that from within our module without the need to go to SQL.
Page 1 of 1
Previous
Next
Home
Support
Bulk Emailer
SQL Queries to export campaign data