{"_id":"5638e41e3539050d0008205f","category":{"_id":"55494bc1ee219b0d001743cc","pages":["55496509c634cf2d0012507c","5549650ecd09b317005f8f4e","55496535a5ecbc1900321683","5549654dcd09b317005f8f53","55496557c634cf2d0012507e","55496563cd09b317005f8f55","55496673a5ecbc190032168a","55496682cd09b317005f8f5e","5549668da5ecbc190032168c","55497c3ea5ecbc19003216bd","55c1047d81dc010d00d50678","55c3cad1b0778d2100a7ebd8","5638e41e3539050d0008205f","563a2ac1f0c29b1700daaf98","563a2b7ef0c29b1700daafa2","563a2d83d25e8919005f3f05"],"project":"55208137623ff50d009b2bec","version":"55208137623ff50d009b2bef","__v":16,"sync":{"url":"","isSync":false},"reference":true,"createdAt":"2015-05-05T23:01:21.408Z","from_sync":false,"order":3,"slug":"features","title":"Features"},"parentDoc":null,"githubsync":"","version":{"_id":"55208137623ff50d009b2bef","__v":14,"project":"55208137623ff50d009b2bec","createdAt":"2015-04-05T00:26:31.564Z","releaseDate":"2015-04-05T00:26:31.563Z","categories":["55208138623ff50d009b2bf0","55494a226a82a10d00817ae5","55494ba7ee219b0d001743c8","55494bc1ee219b0d001743cc","56ead8c1df765617008bccaf","573a2073dd007d1700cf288f","579695b1f64c9f0e007cd76c","57969e3dfa1ff60e006a1274","579a4592fd9f3c0e008e4f4a","57ab9afe54fa780e006c5430","57b784f5b7ebd60e009cb4a6","58f686818193090f008cec76","59e79fbd4cf31900341d50c6","5b2436973fd93f0003dcf99d"],"is_deprecated":false,"is_hidden":false,"is_beta":true,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"project":"55208137623ff50d009b2bec","__v":8,"user":"554966ffcd09b317005f8f61","updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-11-03T16:43:10.634Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":true,"order":10,"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 <a href=\"https://www.sendsonar.com/?modal=Export\">CSV Export</a> can be found by going to the Menu bar > Tools > Export > Select Messages or Customers. \n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Customers Export\"\n}\n[/block]\nThe following information is included in a Customers Export:\n* created_at - when the customer was first created in Sonar which can be done via API, CSV Import or if the customer messages you first.\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\nAlso, you can download by going here:\n[https://www.sendsonar.com/api/export/customers.csv](https://www.sendsonar.com/api/export/customers.csv)\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"Messages Export\"\n}\n[/block]\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","excerpt":"","slug":"csv-export","type":"basic","title":"CSV Export"}
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 <a href="https://www.sendsonar.com/?modal=Export">CSV Export</a> can be found by going to the Menu bar > Tools > Export > Select Messages or Customers. [block:api-header] { "type": "basic", "title": "Customers Export" } [/block] The following information is included in a Customers Export: * created_at - when the customer was first created in Sonar which can be done via API, CSV Import or if the customer messages you first. * 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. Also, you can download by going here: [https://www.sendsonar.com/api/export/customers.csv](https://www.sendsonar.com/api/export/customers.csv) [block:api-header] { "type": "basic", "title": "Messages Export" } [/block] 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