Developer forum

jan@mediestunt.dk wrote:

Hey

 

Can I view someting like this but for all users at the same time. Or get data to excel.

 

http://manual.net.dynamicweb.dk/Default.aspx?ID=4078

 

 

Or can I make a module for my own. Does any know whith tables that are used.

 

 

You can not see it for all users - you can make you own report...

All links for a newsletter (Table: NewsletterExtended) can be found in table NewsletterExtendedStat with an ID. NewsletterExtendedStatHits contains all the hits on the different links based on UserID. Users can be found in NewsletterExtendedRecipient.

This will give you the raw data (128 to a newsletter ID that fits your needs.):

SELECT     NewsletterExtended.NewsletterID, NewsletterExtended.NewsletterName, NewsletterExtendedStat.NewsletterStatLink,

                      NewsletterExtendedStatHits.NewsletterStatHitsType, NewsletterExtendedStatHits.NewsletterStatHitsCreated, NewsletterExtendedStatHits.NewsletterStatHitsInfo,

                      NewsletterExtendedRecipient.NewsletterRecipientName

FROM         NewsletterExtended INNER JOIN

                      NewsletterExtendedStat INNER JOIN

                      NewsletterExtendedRecipient INNER JOIN

                      NewsletterExtendedStatHits ON NewsletterExtendedRecipient.NewsletterRecipientID = NewsletterExtendedStatHits.NewsletterStatHitsUserID ON

                      NewsletterExtendedStat.NewsletterStatID = NewsletterExtendedStatHits.NewsletterStatHitsStatID ON

                      NewsletterExtended.NewsletterID = NewsletterExtendedStat.NewsletterStatLetterID

WHERE     (NewsletterExtended.NewsletterID = 128)

ORDER BY NewsletterExtendedRecipient.NewsletterRecipientName

Thanks.

I will look in to it.

It has been most helpful.

Thanks again.