# Детализация по клиентам

##### Роль: маркетолог, менеджер по программе лояльности  
Цель: аналитика эффективности каналов регистрации

##### Отчет показывает данные о клиентах выбранного источника регистрации за указанный период

##### Фильтры отчета:

- Источник регистрации
- Период

**Пример отчета:**

[![image-1735137147567.png](https://rzn-wb-02.1c-hosting.com/uploads/images/gallery/2024-12/scaled-1680-/image-1735137147567.png)](https://rzn-wb-02.1c-hosting.com/uploads/images/gallery/2024-12/image-1735137147567.png)

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%9A%D0%BB%D0%B8%D0%B5%D0%BD%D1%82-%D0%9D%D0%BE%D0%BC%D0%B5%D1%80-%D1%82%D0%B5%D0%BB%D0%B5%D1%84%D0%BE%D0%BD"><colgroup><col width="184"></col><col width="139"></col><col width="139"></col><col width="139"></col><col width="100"></col></colgroup><tbody><tr><td>Клиент</td><td>Номер телефона</td><td>Номер карты</td><td>Дата первой покупки</td><td>ТТ первой покупки</td></tr><tr><td>Иванов Иван Иванович</td><td>89009009191</td><td>123443212214</td><td>14.03.2024</td><td>Торговая точка1</td></tr></tbody></table>

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%A1%D1%83%D0%BC%D0%BC%D0%B0-%D0%BF%D0%BE%D0%BA%D1%83%D0%BF%D0%BE%D0%BA-%D0%91%D0%BE%D0%BD%D1%83%D1%81%D0%BD"><colgroup><col width="155"></col><col width="192"></col><col width="192"></col><col width="158"></col></colgroup><tbody><tr><td>Сумма покупок</td><td>Бонусный баланс</td><td>Списано бонусов</td><td>Сумма покупок с учётом скидки</td></tr><tr><td>3500</td><td>500</td><td>0</td><td>3500</td></tr></tbody></table>

##### Сортировка -  
Группировка -

##### **Расшифровка данных отчета:**

<table cellpadding="0" cellspacing="0" class="xslData;XLSY;v2;4311;BgaAAgAAB6ACAAAB8wcAAAI/DAAAA+UDAAAEDQQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEbAAAA+gMAAAAADAANAA4ADwD7AAcAAAD6EgAAAAD7AkABAAD6AA8AAAAeBEIERwQ1BEIEPQQ+BEEEQgRMBC4AeABsAHMAeAABFAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAF8ATQBBAE4AUwBLAFYAMQACKgAAABwEMAQ9BEEEOgQ4BDkEIAASBDAEOwQ1BEAEOAQ5BCAAKABNAEEATgBTAEsAVgApACAAKABtAGEAbgBzAGsAdgBAAHIAYQByAHUAcwAuAHIAdQApAAMCAAAAMgA4AAUUAAAAMgAwADIANAAtADEAMgAtADIANQBUADEANAA6ADMAMgA6ADQAOQBaAPsAWgAAAPoGDAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAAcIAAAAMgA2ADYAMQA3ADcANAA0AAkKAAAAMQAwADMAOQAwADQAMwA3ADYAMwALBAAAADEAMAA0ADkA+yQAAAAAAAAAAAELAAAAAgYAAAAABAAAAAADAAAAAA8AAAAAGwAAAADiAwAAAN0DAAABRQAAAAAGHgAAABAEPQQwBDsEOAQ3BCAAPgRCBEcENQRCBD4EMgQgAAEEAQAAAAIBAgMGEgAAAEEAMQA2ADQAOgBDADEANwAyAAK0AAAAAyIAAAAAAQECBAEAAAADBAEAAAAEBAEAAAAFBQAAAACAtlFABgEBAx8AAAACBAIAAAADBAIAAAAEBAIAAAAFBQAAAAAAkBxABgEBAx8AAAACBAMAAAADBAMAAAAEBAMAAAAFBQAAAAAAaWNABgEBAx8AAAACBAQAAAADBAQAAAAEBAEAAAAFBQAAAACABGZABgEBAxwAAAACBABAAAADBAUAAAAEBAEAAAAFBQAAAAAASCJAFjcAAAAXMgAAABQtAAAAAAgAAABBADEANgA0AAEEAAAAAAAAAAISAAAAQQAxADYANAA6AEMAMQA3ADIACwoAAAABBQAAAAAAgCxADjwAAAAABc3MzMzMzDFAAQWamZmZmRkzQAIFzczMzMzMMUADBZqZmZmZGTNABAV7FK5H4XoeQAUFexSuR+F6HkAPPwAAAAEBCQIBAAMBAAQEAQAAAAUBAAYBAAgEAQAAAAkEAQAAAAoEWAIAAAABAQsBAA8EZAAAABABABEBARIEWAIAABAGAAAAAAEAAQEACeYBAAAj4QEAAAIGAACRAQAAEaMAAAAAAAAAaAEAAAAAAAAABw4AAAAABAAAAAAAAAAAAAEKAQAAAAIAAAAAAAcOAgAAAAMAAAABAAAAAAAAEaQAAAAAAAAAaAEAAAAAAAAABw4AAAAABQAAAAIAAAAAAAcOAgAAAAYAAAADAAAAAAAAEaUAAAAAAAAAaAEAAAAAAAAABw4AAAAABQAAAAQAAAAAAAcOAgAAAAMAAAADAAAAAAAAEaYAAAAAAAAAaAEAAAAAAAAABw4AAAAABQAAAAUAAAAAAAcOAgAAAAMAAAAGAAAAAAAAEacAAAAAAAAAaAEAAAAAAAAABw4AAAAABwAAAAcAAAAAAAcOAgAAAAMAAAAIAAAAAAAAEagAAAAAAAAAaAEAAAAAAAAABw4AAAAABQAAAAkAAAAAAAcOAgAAAAMAAAAKAAAAAAAAEakAAAAAAAAAaAEAAAAAAAAABw4AAAAABQAAAAsAAAAAAAcOAgAAAAMAAAAMAAAAAAAAEaoAAAAAAAAAaAEAAAAAAAAABw4AAAAABQAAAA0AAAAAAAcOAgAAAAMAAAAOAAAAAAAAEasAAAAAAAAAaAEAAAAAAAAABw4AAAAABwAAAA8AAAAAAAcOAgAAAAMAAAAQAAAAAACSAQAFAAAAAAcAAAAADAAAAAAbAAAAAEgEAAAAEQAAAAMMAAAAGgQ7BDgENQQ9BEIEAFEAAAADTAAAACQEGAQeBCAAOgQ7BDgENQQ9BEIEMAQgAEMEOgQwBDcEMAQ9BD4EIAAyBCAAOgQwBEAEQgQ+BEcEOgQ1BCAAOgQ7BDgENQQ9BEIEMAQAIQAAAAMcAAAAHQQ+BDwENQRABCAAQgQ1BDsENQREBD4EPQQwBABPAAAAA0oAAAAYBD0ERAQ+BEAEPAQwBEYEOARPBCAAQwQ6BDAENwQwBD0EMAQgADIEIAA6BDAEQARCBD4ERwQ6BDUEIAA6BDsEOAQ1BD0EQgQwBAAbAAAAAxYAAAAdBD4EPAQ1BEAEIAA6BDAEQARCBEsEACsAAAADJgAAABQEMARCBDAEIAA/BDUEQAQyBD4EOQQgAD8EPgQ6BEMEPwQ6BDgEAE0AAAADSAAAABQEMARCBDAEIAA/BD4EOgRDBD8EOgQ4BCAANQRBBEIETAQgADIEIAA6BDAEQARCBD4ERwQ6BDUEIAA/BEAEPgQ0BDAENgQ4BAA/AAAAAzoAAAAiBD4EQAQzBD4EMgQwBE8EIABCBD4ERwQ6BDAEIAA/BDUEQAQyBD4EOQQgAD8EPgQ6BEMEPwQ6BDgEAEUAAAADQAAAAB0EMAQ3BDIEMAQ9BDgENQQgADwEMAQzBDAENwQ4BD0EMAQgAD8ENQRABDIEPgQ5BCAAPwQ+BDoEQwQ/BDoEOAQAHwAAAAMaAAAAIQRDBDwEPAQwBCAAPwQ+BDoEQwQ/BD4EOgQAPwAAAAM6AAAAIQRDBDwEPAQwBCAAPwQ+BDoEQwQ/BD4EOgQgADoEOwQ4BDUEPQRCBDAEIAA6BDsEOAQ1BD0EQgQwBAAjAAAAAx4AAAARBD4EPQRDBEEEPQRLBDkEIAAxBDAEOwQwBD0EQQQAYQAAAANcAAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgADEEPgQ9BEMEQQQ+BDIEIAA9BDAEIAA6BDAEQARCBDUEIAA7BD4ETwQ7BEwEPQQ+BEEEQgQ4BCAAOgQ7BDgENQQ9BEIEMAQAIwAAAAMeAAAAIQQ/BDgEQQQwBD0EPgQgADEEPgQ9BEMEQQQ+BDIEAGkAAAADZAAAACEEQwQ8BDwEMAQgAEEEPwQ4BEEEMAQ9BD0ESwRFBCAAMQQ+BD0EQwRBBD4EMgQgAEEEIAA6BDAEQARCBEsEIAA7BD4ETwQ7BEwEPQQ+BEEEQgQ4BCAAOgQ7BDgENQQ9BEIEMAQAPwAAAAM6AAAAIQRDBDwEPAQwBCAAPwQ+BDoEQwQ/BD4EOgQgAEEEIABDBEcEUQRCBD4EPAQgAEEEOgQ4BDQEOgQ4BABdAAAAA1gAAAAhBEMEPAQ8BDAEIAA/BD4EOgRDBD8EPgQ6BCAAOgQ7BDgENQQ9BEIEMAQgAEEEIAAyBEsERwQ1BEIEPgQ8BCAAQQRDBDwEPARLBCAAQQQ6BDgENAQ+BDoElAQAAADSAAAAASgAAAAAAwAAAAEBCgEDAAAAAQEKAgMAAAABAQoEAwAAAAEBCgUDAAAAAQEKAUwAAAAADAAAAAEBDQAGAwAAAAEBAAEDAAAAAQEKAgwAAAABAQ0ABgMAAAABAQAEDAAAAAEBDQAGAwAAAAEBAAUMAAAAAQENAAYDAAAAAQEAAU8AAAAADAAAAAEBDQAGAwAAAAEBAAEDAAAAAQEKAgwAAAABAQ0ABgMAAAABAQAEDwAAAAEBDQAGBgAAAAAEzMzMAAUMAAAAAQENAAYDAAAAAQEABFQAAAAFCwAAAAAGAAAAAgEAAAARBQsAAAAABgAAAAIBAAAACAUvAAAAACoAAAACAQAAABIDDQAAAAIBAAMFAAAAAAAAAAAEDQAAAAIBAAMFAAAAAAAAAAAGoQAAAAcqAAAAAQYDAAAAAgEBBAYOAAAAQwBhAGwAaQBiAHIAaQAJAQEGBQAAAAAAACZABzcAAAABBgMAAAACAQEEBh4AAABUAGkAbQBlAHMAIABOAGUAdwAgAFIAbwBtAGEAbgAGBQAAAAAAACxABzEAAAAAAQEBBgYAAAAABFCwAAAEBhIAAABPAHAAZQBuACAAUwBhAG4AcwAGBQAAAAAAAChADikAAAADJAAAAAEBAQYEAAAAAAIBAQcEAAAAAAMBAQgEAAAAAAQBAQkEAAAAAAKWAQAAAx4AAAAGBAAAAAAHBAAAAAAIBAAAAAAJBAAAAAAMBAAAAAADIQAAAAYEAAAAAAcEAAAAAAMBAQgEAQAAAAkEAAAAAAwEAAAAAAMtAAAABgQAAAAABwQAAAAAAwEBCAQBAAAACQQAAAAAAAEBDQYDAAAAAAEADAQAAAAAAy0AAAAGBAAAAAAHBAAAAAADAQEIBAEAAAAJBAAAAAAAAQENBgMAAAAAAQUMBAAAAAADNgAAAAEBAQYEAQAAAAcEAAAAAAMBAQgEAgAAAAkEAAAAAAABAQ0GCQAAAAABAAcBAQgBAQwEAAAAAAM2AAAAAQEBBgQCAAAABwQAAAAAAwEBCAQCAAAACQQAAAAAAAEBDQYJAAAAAAEABwEBCAEBDAQAAAAAAzAAAAAGBAAAAAACAQEHBAIAAAADAQEIBAEAAAAJBAAAAAAAAQENBgMAAAAAAQUMBAAAAAADOQAAAAEBAQYEAgAAAAIBAQcEAgAAAAMBAQgEAgAAAAkEAAAAAAABAQ0GCQAAAAABAAcBAQgBAQwEAAAAAA8oAAAAECMAAAAABAAAAAAAAAAEDAAAAE4AbwByAG0AYQBsAAUEAAAAAAAAAAxOAAAAACIAAABUAGEAYgBsAGUAUwB0AHkAbABlAE0AZQBkAGkAdQBtADIAASIAAABQAGkAdgBvAHQAUwB0AHkAbABlAEwAaQBnAGgAdAAxADYAETcAAAAAMgAAAPoAEQAAAFMAbABpAGMAZQByAFMAdAB5AGwAZQBMAGkAZwBoAHQAMQD7AAQAAAAAAAAACAAAAAATLwAAAAAqAAAAVABpAG0AZQBTAGwAaQBjAGUAcgBTAHQAeQBsAGUATABpAGcAaAB0ADEA" id="bkmrk-%D0%9A%D0%BB%D0%B8%D0%B5%D0%BD%D1%82-%D0%A4%D0%98%D0%9E-%D0%BA%D0%BB%D0%B8%D0%B5%D0%BD%D1%82%D0%B0-%D1%83" style="width: 597px;"><tbody><tr><td style="width: 224px;">Клиент</td><td style="width: 373px;">ФИО клиента указано в карточке клиента</td></tr><tr><td style="width: 224px;">Номер телефона</td><td style="width: 373px;">Информация указана в карточке клиента</td></tr><tr><td style="width: 224px;">Номер карты</td><td style="width: 373px;">Информация указана в карточке клиента</td></tr><tr><td style="width: 224px;">Дата первой покупки</td><td style="width: 373px;">Дата покупки есть в карточке продажи</td></tr><tr><td style="width: 224px;">Торговая точка первой покупки</td><td style="width: 373px;">Название магазина первой покупки</td></tr><tr><td style="width: 224px;">Сумма покупок</td><td style="width: 373px;">Сумма покупок клиента клиента</td></tr><tr><td style="width: 224px;">Бонусный баланс</td><td style="width: 373px;">Количество бонусов на карте лояльности клиента</td></tr><tr><td style="width: 224px;">Списано бонусов</td><td style="width: 373px;">Сумма списанных бонусов с карты лояльности клиента</td></tr><tr><td style="width: 224px;">Сумма покупок с учётом скидки</td><td style="width: 373px;">Сумма покупок клиента с вычетом суммы скидок</td></tr></tbody></table>