{"metadata":{"image":[],"title":"","description":""},"api":{"url":"","auth":"required","params":[],"results":{"codes":[]},"settings":""},"next":{"description":"","pages":[]},"title":"CSV Export","type":"basic","slug":"csv-export","excerpt":"","body":"In sonar, you can export your customer information and all of your messages. Please see below for details on what the export includes. The data in the CSV export is in PST time. \n[block:callout]\n{\n  \"type\": \"info\",\n  \"title\": \"Log In First\",\n  \"body\": \"This information is only accessible to admins for a given company. Make sure you're logged into Sonar before trying to access any of the data below.\"\n}\n[/block]\nThe CSV Export can be found by going to the Menu bar, clicking the ****Tools**** tab, choosing ****Export****, then selecting *Messages* or *Customers*. \n\n## **Customer Export**\n\nThe following information is included in a Customers Export:\n* Created_at - when the customer was first created in Sonar \n* Customer_phone_number\n* First_name\n* Last_name\n* Email\n* Subscribed - True or False\n* Last_active_at - the last time the customer sent a message to you\n* Any properties that you added\n* [Double Opt-In](doc:double-opt-in) \n\n## **Messages Export**\n\nThe following information is included in a Messages Export:\n* User_email\n* Text\n* Direction - sent or received\n* To_phone_number - your customer's phone number\n* From_phone_number - your Sonar number\n* Media_url\n* Away_message - True or False\n* Type - SMS or MMS message","updates":[],"order":12,"isReference":true,"hidden":false,"sync_unique":"","link_url":"","link_external":false,"_id":"5638e41e3539050d0008205f","category":{"sync":{"isSync":false,"url":""},"pages":["55496509c634cf2d0012507c","5549650ecd09b317005f8f4e","55496535a5ecbc1900321683","5549654dcd09b317005f8f53","55496557c634cf2d0012507e","55496563cd09b317005f8f55","55496673a5ecbc190032168a","55496682cd09b317005f8f5e","5549668da5ecbc190032168c","55497c3ea5ecbc19003216bd","55c1047d81dc010d00d50678","55c3cad1b0778d2100a7ebd8","5638e41e3539050d0008205f","563a2ac1f0c29b1700daaf98","563a2b7ef0c29b1700daafa2","563a2d83d25e8919005f3f05"],"title":"Features","slug":"features","order":2,"from_sync":false,"reference":true,"_id":"55494bc1ee219b0d001743cc","project":"55208137623ff50d009b2bec","version":"55208137623ff50d009b2bef","__v":16,"createdAt":"2015-05-05T23:01:21.408Z"},"parentDoc":null,"githubsync":"","version":{"version":"1.0","version_clean":"1.0.0","codename":"","is_stable":true,"is_beta":true,"is_hidden":false,"is_deprecated":false,"categories":["55208138623ff50d009b2bf0","55494a226a82a10d00817ae5","55494ba7ee219b0d001743c8","55494bc1ee219b0d001743cc","56ead8c1df765617008bccaf","573a2073dd007d1700cf288f","579695b1f64c9f0e007cd76c","57969e3dfa1ff60e006a1274","579a4592fd9f3c0e008e4f4a","57ab9afe54fa780e006c5430","57b784f5b7ebd60e009cb4a6","58f686818193090f008cec76","59e79fbd4cf31900341d50c6","5b2436973fd93f0003dcf99d","5d824fb2ce98a801366098a2"],"_id":"55208137623ff50d009b2bef","createdAt":"2015-04-05T00:26:31.564Z","releaseDate":"2015-04-05T00:26:31.563Z","__v":15,"project":"55208137623ff50d009b2bec"},"project":"55208137623ff50d009b2bec","__v":8,"createdAt":"2015-11-03T16:43:10.634Z","user":"554966ffcd09b317005f8f61"}
In sonar, you can export your customer information and all of your messages. Please see below for details on what the export includes. The data in the CSV export is in PST time. [block:callout] { "type": "info", "title": "Log In First", "body": "This information is only accessible to admins for a given company. Make sure you're logged into Sonar before trying to access any of the data below." } [/block] The CSV Export can be found by going to the Menu bar, clicking the ****Tools**** tab, choosing ****Export****, then selecting *Messages* or *Customers*. ## **Customer Export** The following information is included in a Customers Export: * Created_at - when the customer was first created in Sonar * Customer_phone_number * First_name * Last_name * Email * Subscribed - True or False * Last_active_at - the last time the customer sent a message to you * Any properties that you added * [Double Opt-In](doc:double-opt-in) ## **Messages Export** The following information is included in a Messages Export: * User_email * Text * Direction - sent or received * To_phone_number - your customer's phone number * From_phone_number - your Sonar number * Media_url * Away_message - True or False * Type - SMS or MMS message