Tiago Soromenho
posted this on October 21, 2009 03:38 pm
Question:
When I import my customers from one campaign into another new campaign, out of the 30,000 from the first campaign, only a few show up in the new campaign. What's wrong or what am I doing wrong?
Answer:
The main issue, I believe, is this: Customers don't belong separately to different campaigns.
Hence, there's no need to import a list of customers that already exist. If you do import existing customers, and if you did not check the box "Duplicates? [ ] Overwrite", then only those customers with different unique ID (Card #s) will be imported (and "added") to the campaign you selected.
Here some details on how that works:
So in your case, what you have is an existing list of customers in the Customers table in our database, and in the Transactions table, one or more entries for each customer id (card #) with their transaction details. Hence when first importing new customers into a campaign, you need to create two sets of data to import:
To create a new campaign, then, all you have to do is use the "Import Customer Transactions" functionality to import the list of unique IDs (card #s) and the transactions that each should have (like their current balance to be transferred, for example). If you want a blank campaign, you can use a balance of 0 (zero) and put in the description "Account Activated" or "Welcome" or some other description. This will be recorded as a transaction for that customer in that campaign, and thus counted in the summary count on the control panel, and will also thus allow you to "go into a campaign" and lookup that customer by any of their known information (name, email, address, etc.)