Difference between revisions of "Mass Editing Your Campaign Subscriber Lists"

From TRWV Documentation Wiki
Jump to: navigation, search
(What you need to know about Re-Importing)
(What you need to know about Re-Importing)
 
(16 intermediate revisions by the same user not shown)
Line 1: Line 1:
There are dozens of reasons why you may need to edit a subscriber's information over time, particularly if you are using your TrafficWave.net system as a Customer Retention Manager (CRM). For example, a customer (subscriber) could have given you a new phone number, or moved to a new location.
+
There are dozens of reasons why you may need to edit a subscriber's information over time, particularly if you are using your TrafficWave.net system as a Customer Retention Manager (CRM -- See [[Contact Management Tools]]). For example, a customer (subscriber) could have given you a new phone number, or moved to a new location.
 
 
 
Editing a single subscriber is a relatively easy task. Using the Subscriber Manager, you can search for individuals by name, email, or other criteria. Once located, you can edit any of the available fields for this subscriber.  
 
Editing a single subscriber is a relatively easy task. Using the Subscriber Manager, you can search for individuals by name, email, or other criteria. Once located, you can edit any of the available fields for this subscriber.  
  
  
{{mbox | type = caution
+
{{mbox | type = warning
| text  = The only exception to mass editing is an email address. Since all email addresses initial require confirmation to join your Campaign list, if your subscriber changes email addresses, they will need to be added as a new subscriber.
+
| text  = The only exception to mass editing is an '''email address'''. Since all email addresses initially require owner confirmation to join your Campaign list, if your subscriber changes email addresses, they will need to be added as a new subscriber.
 
}}
 
}}
  
  
What may NOT be clear, however, is how to mass edit your Campaign Subscribers list. Again, there are a number of valid reasons for wanting to edit many subscribers at one time. Most common uses for mass editing are:
+
What may NOT be clear, however, is how to mass edit your Campaign subscribers list. Again, there are a number of valid reasons for wanting to edit many subscribers at one time. Most common uses for mass editing are:
  
 
'''Retroactive “Fixes”''':
 
'''Retroactive “Fixes”''':
Line 26: Line 26:
 
'''1) Export to your computer'''
 
'''1) Export to your computer'''
 
: Using the Subscriber Manager, export all or part of your Campaign List to your computer's desktop.
 
: Using the Subscriber Manager, export all or part of your Campaign List to your computer's desktop.
 +
 +
 +
[[File:SubscrMgr-export-tab.png]]
 +
 +
  
 
'''2) Edit your list with your favorite spreadsheet program'''
 
'''2) Edit your list with your favorite spreadsheet program'''
Line 36: Line 41:
  
 
'''3) Import the list BACK to your Campaign'''
 
'''3) Import the list BACK to your Campaign'''
: Using the Import Subscribers link, you can re-import this list BACK into your Campaign by copying the rows you have changed and pasting them into the box provided by Trafficwave.net
+
: Using the Import Subscribers link, you can re-import this list BACK into your Campaign by copying the rows you have changed and pasting them into the box provided by Trafficwave.net.
  
 +
 +
[[File:AR-camp-subscr-import-tab.png]]
  
  
Line 44: Line 51:
 
* Unlike a first-time import, if a Subscriber has already confirmed their email address for any of your Campaigns, they will NOT be asked for reconfirmation.
 
* Unlike a first-time import, if a Subscriber has already confirmed their email address for any of your Campaigns, they will NOT be asked for reconfirmation.
  
* Just like a first-time import, you are prompted to define each column of data that you are importing. This is important, because this is how mass Subscriber data is changed:
+
* Just like a first-time import, you are prompted to define each column of subscriber data that you are importing. '''Only columns that are identified here will be modified - any additional subscriber data will be left alone.'''
  
 
* If you define a field during this import, any subscriber data will be overwritten.
 
* If you define a field during this import, any subscriber data will be overwritten.
  
* With the exception of Custom Tokens, your subscriber data is stored independently of a Campaign. This means that is you have changed a subscribers name from "Bob" to "Robert", this subscriber will appear as "Robert" in any Campaign to which he is subscribed.
+
* With the exception of [[ Letter Tokens | Custom Tokens]], your subscriber data is stored independently of a Campaign. This means that if you have changed a subscribers name from "Bob" to "Robert", this subscriber will appear as "Robert" in any Campaign to which he is subscribed.
  
 
* If you '''do not define''' a field during this import, any subscriber data will be left alone.
 
* If you '''do not define''' a field during this import, any subscriber data will be left alone.
Line 57: Line 64:
  
 
:: Conversely, if you wish to remove all data in a given field, simply assign that field to an empty column during this import (you may need to copy and paste extra columns from the end of your spreadsheet).
 
:: Conversely, if you wish to remove all data in a given field, simply assign that field to an empty column during this import (you may need to copy and paste extra columns from the end of your spreadsheet).
 +
 +
==''See Also''==
 +
[[ Managing Your Subscriber List | Using the Subscriber Manager ]]
 +
 +
[[Finding Subscribers]]
 +
 +
[[Contact Management Tools]]
 +
 +
[[Importing Subscribers]]
 +
 +
[[Tagging Subscribers]]
 +
 +
 +
 +
[[Category: AutoResponder]]

Latest revision as of 17:17, 2 February 2021

There are dozens of reasons why you may need to edit a subscriber's information over time, particularly if you are using your TrafficWave.net system as a Customer Retention Manager (CRM -- See Contact Management Tools). For example, a customer (subscriber) could have given you a new phone number, or moved to a new location.

Editing a single subscriber is a relatively easy task. Using the Subscriber Manager, you can search for individuals by name, email, or other criteria. Once located, you can edit any of the available fields for this subscriber.



What may NOT be clear, however, is how to mass edit your Campaign subscribers list. Again, there are a number of valid reasons for wanting to edit many subscribers at one time. Most common uses for mass editing are:

Retroactive “Fixes”:

  • You want to “clean up” the format of your list to remove improper capitalization or accidental misspellings.
  • You are now collecting additional data beyond name and email (e.g. Postal Addresses), and need to add this data to pre-existing subscribers.

Updating Current Information:


Mass Editing via Export/Import

The most convenient way to edit your subscriber list can be accomplished in three simple steps:

1) Export to your computer

Using the Subscriber Manager, export all or part of your Campaign List to your computer's desktop.


SubscrMgr-export-tab.png


2) Edit your list with your favorite spreadsheet program

This exported file is a tab delimited file that can be opened by most common spreadsheet programs. This will allow you the fastest editing method possible using software that you are already familiar.


3) Import the list BACK to your Campaign

Using the Import Subscribers link, you can re-import this list BACK into your Campaign by copying the rows you have changed and pasting them into the box provided by Trafficwave.net.


AR-camp-subscr-import-tab.png


What you need to know about Re-Importing

  • Unlike a first-time import, if a Subscriber has already confirmed their email address for any of your Campaigns, they will NOT be asked for reconfirmation.
  • Just like a first-time import, you are prompted to define each column of subscriber data that you are importing. Only columns that are identified here will be modified - any additional subscriber data will be left alone.
  • If you define a field during this import, any subscriber data will be overwritten.
  • With the exception of Custom Tokens, your subscriber data is stored independently of a Campaign. This means that if you have changed a subscribers name from "Bob" to "Robert", this subscriber will appear as "Robert" in any Campaign to which he is subscribed.
  • If you do not define a field during this import, any subscriber data will be left alone.
This can help speed up the process of only defining those that you are wanting to edit.
For example, if you have collected data for the Country field, but are NOT making any changes to this data during this import, simply do NOT assign any of the columns for this import. Any data currently stored will be left alone.
Conversely, if you wish to remove all data in a given field, simply assign that field to an empty column during this import (you may need to copy and paste extra columns from the end of your spreadsheet).

See Also

Using the Subscriber Manager

Finding Subscribers

Contact Management Tools

Importing Subscribers

Tagging Subscribers