We are using Exact Target for our email marketing system. We have some batch processes to send our user data to exact target on daily basis. We send data using ET SOAP api. To be specific, we send createRequestDocument object to ET; that document contains subscriber information. The subscribers are either created or updated if the request is successful.
In near future, the data that we will be sending to exact target is going to grow exponentially. We will be sending about 500,000 subscribers to ET almost daily. So, the SOAP API approach is not going to be efficient for that much amount of data.
Question:
Is there a way for ET to update data from an FTP file that will be sent daily?
Best Answer
This may help. It is how we get data into Data Extensions from an FTP site. So long as all your logic is done on your side to generate a CSV, this would work. The steps would be (from within your ET account) 1. Create a File Transfer activity to bring the file into our data warehouse. 2. Create an Import Activity to import said file into your data extension of choice. 3. Create an Automation from with AutomationStudio to run 1&2 sequentially, either at set times or by an API trigger.
See http://help.exacttarget.com/en/documentation/exacttarget/interactions/activities/file_transfer_activity/
And
http://help.exacttarget.com/en/documentation/exacttarget/interactions/activities/import_activity/
Hope this helps... Good luck!