if i want to extract all data for the purpose of putting into my own CRM, i know we should go for Data Feed, however it has limitation on number of Rows and limited to certain period of historical data, whats the other options i could have?
Data feeds should not have a limit in number of rows, only a limit on the space in your FTP site. They also go back up to 13 months. If you need to go back further, you can contact customer care, who might be able to help.
As others have mentioned, Data Warehouse might be a good option if you don't need raw clickstream data.