Amazon Connect Customer Profilesに登録された全顧客の一覧を取得する方法
2025.06.30こんにちは。
繁松です。
はじめに
Amazon Connect Customer Profiles には登録されている全顧客を一括表示する機能はありません。（2025年6月30日時点）
登録されている顧客情報を取得するには「名前・電話番号・プロファイル ID」など個別条件で検索をする必要があります。
顧客セグメントを利用することでCustomer Profilesに登録されている顧客情報をcsvで取得できるので紹介します。
やってみる
Amazon Connect コンソールから顧客セグメントを開き、「セグメントを作成する」を選択します。
セグメント名を入力し、オーディエンスグループは「Customer Profiles のすべてのプロファイル」を選択します。
作成した顧客セグメントを開くと「CSVをエクスポート」の項目があるので選択しエクスポートします。
エクスポートが完了するとcsvファイルのダウンロードが開始されます。
実際にエクスポートしたデータは以下です。
"ProfileId","AccountNumber","AdditionalInformation","PartyType","BusinessName","FirstName","MiddleName","LastName","BirthDate","Gender","PhoneNumber","MobilePhoneNumber","HomePhoneNumber","BusinessPhoneNumber","EmailAddress","PersonalEmailAddress","BusinessEmailAddress","Address.Address1","Address.Address2","Address.Address3","Address.Address4","Address.City","Address.County","Address.State","Address.Province","Address.Country","Address.PostalCode","ShippingAddress.Address1","ShippingAddress.Address2","ShippingAddress.Address3","ShippingAddress.Address4","ShippingAddress.City","ShippingAddress.County","ShippingAddress.State","ShippingAddress.Province","ShippingAddress.Country","ShippingAddress.PostalCode","MailingAddress.Address1","MailingAddress.Address2","MailingAddress.Address3","MailingAddress.Address4","MailingAddress.City","MailingAddress.County","MailingAddress.State","MailingAddress.Province","MailingAddress.Country","MailingAddress.PostalCode","BillingAddress.Address1","BillingAddress.Address2","BillingAddress.Address3","BillingAddress.Address4","BillingAddress.City","BillingAddress.County","BillingAddress.State","BillingAddress.Province","BillingAddress.Country","BillingAddress.PostalCode"
"4bfd4202d5284b04b16903e11e2aa7bf","","","","","昂大","","繁松","","","+815000000000","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
"e3a2474374274c6aa78f93ca0248fc87","","","","","","","","","","+815011111111","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""
csvのエクスポートを行うことでCustomer Profiles のすべてのプロファイルを確認することができます。
最大 350,000 個のプロファイルを含む顧客セグメントのエクスポートに対応しており、これを超える場合にはAPIを利用する必要があります。
さいごに
Amazon Connect Customer Profilesに登録された全顧客の一覧を取得する方法について紹介しました。
Customer Profilesの検索では名前・電話番号・プロファイル ID すべて「完全一致」検索しかできず、すべてのユーザー情報がわからなくなると検索することが難しくなりますが、一覧を取得することで検索しやすくなると思います。
次回以降で、APIを使ったエクスポートについても紹介したいと思います。
