I need to extract a Data Extension of Contacts with several million lines in UTF8.
It works properly when I extract Sent, Open or Click data views but, here, I really can't figure out what is going on. The biggest difference I can see is that the Contacts DE is a Sendable DE...
I have only 1,2M lines in my extract when I use a Data Extract activity to convert in UTF8. When I don't do it, I have all my 8M lines available.
To give more details, I do : 1- SQL query to have all my contacts in a DE 2- Data extract to extract the DE 3- Data extract to convert in UTF8 4- File transfert to send to our FTP 5- Data extract to zip the file
I have all the needed lines when I dont run the conversion in UTF8. I tried to invert steps 3 and 4 but I have the same result.
Do you have any idea of what I can check ?