#603 - Newsletter tracking, include tracking code integration
-
By Chris Graham
- Added
- 6 views
| Identifier | #603 |
|---|---|
| Issue type | Feature request or suggestion |
| Title | Newsletter tracking, include tracking code integration |
| Status | Open |
| Tags |
Roadmap: Over the horizon (custom) Type: Avoiding e-mail spamblocks (custom) |
| Handling member | Deleted |
| Addon | newsletter |
| Description | Create new table, newsletter_receipt_tracking:
AUTO id // Randomised tracking ID, so cannot be easily guessed AUTO_LINK t_archive_id // This is the ID into the newsletter_archive table (which stores the text for a send) EMAIL t_email_address SHORT_TEXT t_forename SHORT_TEXT t_surname SHORT_TEXT t_secure_identifier TIME t_has_read TIME t_has_clicked NEWSLETTER LINK CLICKING TRACKING... This table is designed to record who has read a particular newsletter. Each recipient is given a row in this table. Automatically include the unique recipient tracking ID as a tracking parameter into all website URLs included in a newsletter. It would use the standardised '_t' tracking code system. However, it would be codified in such a way that the actual recorded tracking code will be based on the newsletter archive ID not the ID passed (as otherwise we'd have thousands of unique tracking codes in the system). For example, maybe we make a convention that a tracking code that looks like nr<number> is a newsletter recipient ID and processed as just described. Such codes would also cause the newsletter_receipt_tracking:has_clicked field to be updated too. NEWSLETTER READ TRACKING... New script to do read-tracking via embedded images, updating the newsletter_receipt_tracking:has_read field when it is hit. Automatically include this in the default template. New admin interface for showing the newsletter_receipt_tracking table against the archive of what was sent - gives general stats, and a CSV download link. Option to download aggregated CSV against all sendings, so you can see how many mails each recipient read. IMPROVED BOUNCE HANDLING... In addition to click and read tracking, one might also want to track bounces. Composr already has support for removing bounced addresses from newsletters. Allow this to also remove email addresses from member accounts. This will reduce the chance of spam blocks. Allow bounce handling to run in a Cron hook. Document the importance of newsletter cleansing: 1) We need to regularly delete subscribers who are stale, to avoid getting flagged as a spammer 2) We need to regularly delete subscribers who are stale, to reduce the cost/time for sending future newsletters 3) We want to be able to have focused lists of the most active readers |
| Steps to reproduce | |
| Related to | |
| Funded? | No |
The system will post a comment when this issue is modified (e.g., status changes). To be notified of this, click "Enable comment notifications".
Comments
There have been no comments yet