How to Track Unsubscribes with Mail Merge for Gmail

-

Mail Merge for Gmail gives you can easy option to add an “Unsubscribe” link to all your outgoing email campaigns. When an email recipient clicks the unsubscribe link, the status of their email address is set to UNSUBSCRIBED and you will not able to send email campaigns to unsubscribed users in your future mail merge campaigns.

You can also manually resubscribe any unsubscribed contact if they have unsubscribed from your campaigns by accident.

Inside your Google Sheet, go to Addons > Mail Merge with Attachments > Configure Mail Merge and expand the section that says “Enable Email Tracking”;

Provide a Campaign Name, check the option that says “Include an Unsubscribe Link” and also provide the text of the unsubscribe link.

Mail Merge Unsubscribe Link

How Unsubscribe Works in Mail Merge

When the unsubscribe option is checked, all outgoing emails sent through Gmail Mail merge will include a remove link in the message footer automatically.  The subscriber can click the link to opt-out of your future mailing lists.

When they click the unsubscribe link, they are taken to a special landing page confirming that their request for unsubscribing has been successfully recorded.

How to View Unsubscribed User Reports

Go to Add-ons > Mail Merge with Attachments > Campaign Reports > Open and Click Reports. This will open a list of email campaigns you’ve sent through Mail Merge. Click the Unsubscribe button in any specific campaign to generate a list of all email addresses that have unsubscribed from your mailing list via that particular campaign.

This will add a new “Unsubscribe Report” sheet in your Google Spreadsheet for Mail Merge. The report will include the following data to help you analyze the campaigns that resulted in the most unsubscribes:

  • Date when the message was sent to the user
  • Date when the user unsubscribed from the mailing list
  • Email address of the unsubscriber
  • Location / IP address from where the user unsubscribed
  • Web browser (or mobile browser) of the unsubscriber.

Here’s a sample unsubscribe report generated by Mail merge.

unsubscribe-report.png



source:https://ift.tt/2yVXYwe

Comments

Post a Comment

Popular posts from this blog

The 101 Most Useful Websites

-
Image
Presenting the 101 most useful websites on the internet. These sites, well most of them, solve at least one problem really well and they all have simple web addresses (URLs) that you can memorize thus saving you a trip to Google. The Most Useful Websites and Web Apps ctrlq.org/screenshots  – for capturing  screenshots of web pages  on mobile and desktops. dictation.io  – online voice recognition in the browser itself. zerodollarmovies.com  – find full-length movies on YouTube. screenr.com  – record movies of your desktop and send them straight to YouTube. goo.gl  – shorten long URLs and convert URLs into  QR codes . unfurlr.come  – find the original URL that’s hiding behind a short URL. qClock  – find the local time of a city using a  Google Map . copypastecharacter.com  – copy special characters that aren’t on your keyboard. postpost.com  – a better search engine for twitter. lovelycharts.com  – c...
Read more

Compare MacBook Prices Worldwide with Google Sheets

-
Image
Looking to buy the new Macbook Pro with M3 chips? Wondering if it would be cheaper to purchase a Macbook in your local Apple store, or ask a friend who is travelling from Singapore or Japan to bring one for you? Here’s a Google Sheet that can help you compare prices of MacBooks in different countries. It takes the current prices of MacBooks from Apple online stores in different countries and converts them to a common currency (US Dollars). The exchange rates are fetched directly from Google Finance so the prices will update automatically when the exchange rates change. How the Macbook Price Comparison Sheet Works I have written a Node.js script that fetches the current prices of MacBooks from the Apple website and writes them to Google Sheets. Here’s the code that scrapes the Apple website and parses the HTML to extract the prices. Get Macbook Prices from Apple Website Apple uses JSON-LD to embed structured pricing data in their web pages that can be easily parsed using che...
Read more

Interesting Websites to Visit When You’re Bored

-
The 15 Interesting Websites Dear Photograph  – The website features photographs of people holding up old pictures that were taken at the exact spot several years ago. Some of the best photographs are now compiled in a  book  (dearphotograph.me). Textastrophe  – This website is a reminder of why you shouldn’t post your cell phone number on public websites. The creator starts a text conversation with random numbers found on Craigslist ads and publishes the transcript on the internet. The chats are funny and I hope its real because  screenshots can be faked  too (textastrophe.com). Stratocam  – This is like an online self-running slideshow showcasing some of the best satellite images found on Google Maps. Run the website in full-screen mode (Ctrl+Shift+F) and you may discover pretty and unexpected place on our beautiful earth (stratocam.com). Awkward Family Photos  – This is a place where people share embarrassing pictures of their loved ones i...
Read more