Has anyone use CC to create Summary Reports to mail to their customers?
I was considering using SSRS (SQL Server Reporting Services) to send the reports, but I'd need to send 10,000 emails. Given SSRS doesn't support trottling and 'Precedence: bulk', I'd simply be asking to be blacklisted.
So I called a CC this morning (7 AM mind you) and the customer rep was totally awesome helping me answer my questions.
Here's what I've worked out.
Here's where things get a little complicated.
This would mean everytime I update the report, I'd need to iterate through all the Contacts to update the Unique Fields. LOTS of Transactions.
Great product, and I hope to do business with y'all.
It is possible, using our API's, to create an automated process that bulk updates all contacts with new information. You would need to develop the mechanism that updates the contacts with the new information though.
If you were to update 10,000 contacts, it usually takes only a few minutes. This may give or take depending on server load at the time, but under normal circumstances we normally have under a one hour SLA for something of that size to finish, and usually it will only take a minute or two.
The only other way to do this would be to update the contacts by importing a spreadsheet with new information on the contacts every time you want to update the list. Also please keep in mind that when using the dynamic data, there is a character limit of 50 characters for each contact detail, and there are about 30 different contact fields.
If you have any further questions, please let me know!