# Отчет по каналам регистрации

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

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

- Период

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

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

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%9A%D0%B0%D0%BD%D0%B0%D0%BB-%D1%80%D0%B5%D0%B3%D0%B8%D1%81%D1%82%D1%80%D0%B0%D1%86%D0%B8%D0%B8-%D0%9A%D0%BE"><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>Telegram</td><td>10</td><td>20</td><td>120000</td><td>6000</td></tr></tbody></table>

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%A7%D0%B0%D1%81%D1%82%D0%BE%D1%82%D0%B0-%D0%BF%D0%BE%D0%BA%D1%83%D0%BF%D0%BE%D0%BA-%D0%B7%D0%B0-%D0%BF"><colgroup><col width="155"></col><col width="192"></col><col width="192"></col><col width="158"></col><col width="140"></col></colgroup><tbody><tr><td>Частота покупок за период</td><td>Бонусный баланс</td><td>Списано бонусов за покупки</td><td>Списано акционных бонусов</td><td>Сумма покупок с учётом скидки</td></tr><tr><td>2</td><td>6000</td><td>1000</td><td>1000</td><td>118000</td></tr></tbody></table>

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

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

<table cellpadding="0" cellspacing="0" class="xslData;XLSY;v2;5974;BgaAAgAAB6ACAAABuggAAAKKEQAAA+UDAAAEDQQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEbAAAA+gMAAAAADAANAA4ADwD7AAcAAAD6EgAAAAD7AkABAAD6AA8AAAAeBEIERwQ1BEIEPQQ+BEEEQgRMBC4AeABsAHMAeAABFAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAF8ATQBBAE4AUwBLAFYAMQACKgAAABwEMAQ9BEEEOgQ4BDkEIAASBDAEOwQ1BEAEOAQ5BCAAKABNAEEATgBTAEsAVgApACAAKABtAGEAbgBzAGsAdgBAAHIAYQByAHUAcwAuAHIAdQApAAMCAAAAMgA4AAUUAAAAMgAwADIANAAtADEAMgAtADIANQBUADEANAA6ADMAMAA6ADEAMQBaAPsAWgAAAPoGDAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAAcIAAAAMgA2ADYAMQA3ADcANAA0AAkKAAAAMQAwADMAOQAwADQAMwA3ADYAMwALBAAAADEAMAA0ADkA+yQAAAAAAAAAAAELAAAAAgYAAAAABAAAAAADAAAAAA8AAAAAGwAAAACpBAAAAKQEAAABRQAAAAAGHgAAABAEPQQwBDsEOAQ3BCAAPgRCBEcENQRCBD4EMgQgAAEEAQAAAAIBAgMGEgAAAEEAMQA1ADEAOgBDADEANgAwAAK0AAAAAyIAAAAAAQECBAEAAAADBAEAAAAEBAEAAAAFBQAAAACAtlFABgEBAx8AAAACBAIAAAADBAIAAAAEBAIAAAAFBQAAAAAAkBxABgEBAx8AAAACBAMAAAADBAMAAAAEBAMAAAAFBQAAAAAAaWNABgEBAx8AAAACBAQAAAADBAQAAAAEBAEAAAAFBQAAAACABGZABgEBAxwAAAACBABAAAADBAUAAAAEBAEAAAAFBQAAAAAASCJAFjcAAAAXMgAAABQtAAAAAAgAAABBADEANQAxAAEEAAAAAAAAAAISAAAAQQAxADUAMQA6AEMAMQA2ADAACwoAAAABBQAAAAAAgCxADjwAAAAABc3MzMzMzDFAAQWamZmZmRkzQAIFzczMzMzMMUADBZqZmZmZGTNABAV7FK5H4XoeQAUFexSuR+F6HkAPPwAAAAEBCQIBAAMBAAQEAQAAAAUBAAYBAAgEAQAAAAkEAQAAAAoEWAIAAAABAQsBAA8EZAAAABABABEBARIEWAIAABAGAAAAAAEAAQEACa0CAAAjqAIAAAIGAACRAQAAEZYAAAAAAAAAWQEAAAAAAAAABw4AAAAABAAAAAAAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAAAgAAAAAAABGXAAAAAAAAAFkBAAAAAAAAAAcOAAAAAAUAAAADAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAQAAAAAAAARmAAAAAAAAABZAQAAAAAAAAAHDgAAAAAFAAAABQAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAAGAAAAAAAAEZkAAAAAAAAAWQEAAAAAAAAABw4AAAAABQAAAAcAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAACAAAAAAAABGaAAAAAAAAAFkBAAAAAAAAAAcOAAAAAAYAAAAJAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAoAAAAAAAARmwAAAAAAAABZAQAAAAAAAAAHDgAAAAAHAAAACwAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAAMAAAAAAAAEZwAAAAAAAAAWQEAAAAAAAAABw4AAAAACAAAAA0AAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAADgAAAAAAABGdAAAAAAAAAFkBAAAAAAAAAAcOAAAAAAUAAAAPAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAABAAAAAAAAARngAAAAAAAABZAQAAAAAAAAAHDgAAAAAFAAAAEQAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAASAAAAAAAAEZ8AAAAAAAAAWQEAAAAAAAAABw4AAAAABQAAABMAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAAFAAAAAAAkgEABQAAAAAHAAAAAAwAAAAAGwAAAADMCAAAAC0AAAADKAAAABgEQQRCBD4ERwQ9BDgEOgQgAEAENQQzBDgEQQRCBEAEMARGBDgEOAQABwAAAAMCAAAAKwAAjQAAAAOIAAAAGARBBEIEPgRHBD0EOAQ6BCwAIAA/BD4EIAA6BD4EQgQ+BEAEPgQ8BEMEIAA6BDsEOAQ1BD0EQgQgADcEMARABDUEMwQ4BEEEQgRABDgEQAQ+BDIEMAQ7BEEETwQgACgAVABlAGwAZQBnAHIAYQBtACwAIAAyBDUEMQQtAEQEPgRABDwEMAQpAAAxAAAAAywAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAQAQ1BDMEOARBBEIEQAQwBEYEOAQ5BACpAAAAA6QAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAOgQ7BDgENQQ9BEIEPgQyBCwAIAA3BDAEQAQ1BDMEOARBBEIEQAQ4BEAEPgQyBDAEPQQ9BEsERQQgAEEEIAA/BD4EPAQ+BEkETAROBCAAMgRLBDEEQAQwBD0EPQQ+BDMEPgQgADgEQQRCBD4ERwQ9BDgEOgQwBCAAQAQ1BDMEOARBBEIEQAQwBEYEOAQ4BAApAAAAAyQAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAPwQ+BDoEQwQ/BD4EOgQAfwAAAAN6AAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgAD8EQAQ+BDQEMAQ2BCAAQwQgADoEOwQ4BDUEPQRCBD4EMgQgADIESwQxBEAEMAQ9BD0EPgQzBD4EIAA4BEEEQgQ+BEcEPQQ4BDoEMAQgAEAENQQzBDgEQQRCBEAEMARGBDgEOAQAFQAAAAMQAAAAEgRLBEAEQwRHBDoEMAQgAACVAAAAA5AAAAAhBEMEPAQ8BDAEIAA/BEAEPgQ0BDAENgQgADoEOwQ4BDUEPQRCBD4EMgQgADIESwQxBEAEMAQ9BD0EPgQzBD4EIAA4BEEEQgQ+BEcEPQQ4BDoEMAQgAEAENQQzBDgEQQRCBEAEMARGBDgEOAQuACAAFAQ+BCAAMgRLBEcENQRCBDAEIABBBDoEOAQ0BD4EOgQAGwAAAAMWAAAAIQRABDUENAQ9BDgEOQQgAEcENQQ6BACvAAAAA6oAAAAhBEMEPAQ8BDAEIAA/BEAEPgQ0BDAENgQgADQENQQ7BDUEPQQ9BDAETwQgAD0EMAQgADoEPgQ7BDgERwQ1BEEEQgQyBD4EIAA/BD4EOgRDBD8EPgQ6BCAAOgQ7BDgENQQ9BEIEPgQyBCAAMgRLBDEEQAQwBD0EPQQ+BDMEPgQgADgEQQRCBD4ERwQ9BDgEOgQwBCAAQAQ1BDMEOARBBEIEQAQwBEYEOAQ4BAA3AAAAAzIAAAAnBDAEQQRCBD4EQgQwBCAAPwQ+BDoEQwQ/BD4EOgQgADcEMAQgAD8ENQRABDgEPgQ0BADbAAAAA9YAAAAgABoEPgQ7BDgERwQ1BEEEQgQyBD4EIAA/BD4EOgRDBD8EPgQ6BCAAPQQ+BDIESwRFBCAAOgQ7BDgENQQ9BEIEPgQyBCAAOARBBEIEPgRHBD0EOAQ6BDAEIABABDUEMwQ4BEEEQgRABDAERgQ4BDgEIAAvACAAOgQ+BDsEOARHBDUEQQRCBDIEPgQgAD0EPgQyBEsERQQgACAAOgQ7BDgENQQ9BEIEPgQyBCAAOARBBEIEPgRHBD0EOAQ6BDAEIABABDUEMwQ4BEEEQgRABDAERgQ4BDgEACMAAAADHgAAABEEPgQ9BEMEQQQ9BEsEOQQgADEEMAQ7BDAEPQRBBACXAAAAA5IAAAAhBEMEPAQ8BDAEIAAxBD4EPQRDBEEEPQRLBEUEIAAxBDAEOwQ7BD4EMgQgAD0EMAQgADoEMARABEIEMARFBCAAOgQ7BDgENQQ9BEIEPgQyBCAAMgRLBDEEQAQwBD0EPQQ+BDMEPgQgADgEQQRCBD4ERwQ9BDgEOgQwBCAAQAQ1BDMEOARBBEIEQAQwBEYEOAQ4BAA5AAAAAzQAAAAhBD8EOARBBDAEPQQ+BCAAMQQ+BD0EQwRBBD4EMgQgADcEMAQgAD8EPgQ6BEMEPwQ6BDgEAMkAAAADxAAAACEEQwQ8BDwEMAQgAEEEPwQ4BEEEMAQ9BD0ESwRFBCAAMQQ+BD0EQwRBBD0ESwRFBCAAMQQwBDsEOwQ+BDIELAAgAD8EPgQ7BEMERwQ1BD0EPQRLBEUEIAA3BDAEIAA/BEAEPgQ0BDAENgQ4BCAAQwQgADoEOwQ4BDUEPQRCBD4EMgQgADIESwQxBEAEMAQ9BD0EPgQzBD4EIAA4BEEEQgQ+BEcEPQQ4BDoEMAQgAEAENQQzBDgEQQRCBEAEMARGBDgEOAQANwAAAAMyAAAAIQQ/BDgEQQQwBD0EPgQgADAEOgRGBDgEPgQ9BD0ESwRFBCAAMQQ+BD0EQwRBBD4EMgQAxQAAAAPAAAAAIQRDBDwEPAQwBCAAQQQ/BDgEQQQwBD0EPQRLBEUEIAAxBD4EPQRDBEEEPQRLBEUEIAAxBDAEOwQ7BD4EMgQsACAAPwQ+BDsEQwRHBDUEPQQ9BEsERQQgADcEMAQgADAEOgRGBDgEOAQgAEMEIAA6BDsEOAQ1BD0EQgQ+BDIEIAAyBEsEMQRABDAEPQQ9BD4EMwQ+BCAAOARBBEIEPgRHBD0EOAQ6BDAEIABABDUEMwQ4BEEEQgRABDAERgQ4BDgEAD8AAAADOgAAACEEQwQ8BDwEMAQgAD8EPgQ6BEMEPwQ+BDoEIABBBCAAQwRHBFEEQgQ+BDwEIABBBDoEOAQ0BDoEOAQAowAAAAOeAAAAIQRDBDwEPAQwBCAAPwRABD4ENAQwBDYEIAA/BD4EQQQ7BDUEIAAyBEsERwQ4BEIEMAQ9BDgETwQgAEEEOgQ4BDQEOgQ4BCAAQwQgADoEOwQ4BDUEPQRCBD4EMgQgADIESwQxBEAEMAQ9BD0EPgQzBD4EIAA4BEEEQgQ+BEcEPQQ4BDoEMAQgAEAENQQzBDgEQQRCBEAEMARGBDgEOATIBQAAALkBAAABKAAAAAADAAAAAQEKAQMAAAABAQoCAwAAAAEBCgQDAAAAAQEKBQMAAAABAQoBTAAAAAAMAAAAAQENAAYDAAAAAQEAAQMAAAABAQoCDAAAAAEBDQAGAwAAAAEBAAQMAAAAAQENAAYDAAAAAQEABQwAAAABAQ0ABgMAAAABAQABTwAAAAAMAAAAAQENAAYDAAAAAQEAAQMAAAABAQoCDAAAAAEBDQAGAwAAAAEBAAQPAAAAAQENAAYGAAAAAATMzMwABQwAAAABAQ0ABgMAAAABAQABRgAAAAADAAAAAQEKAQMAAAABAQoCDAAAAAEBDQAGAwAAAAEBAAQPAAAAAQENAAYGAAAAAATMzMwABQwAAAABAQ0ABgMAAAABAQABTAAAAAAMAAAAAQENAAYDAAAAAgEBAQMAAAABAQoCDAAAAAEBDQAGAwAAAAIBAQQMAAAAAQENAAYDAAAAAgEBBQwAAAABAQ0ABgMAAAACAQEBRgAAAAAMAAAAAQENAAYDAAAAAQEAAQMAAAABAQoCDAAAAAEBDQAGAwAAAAEBAAQPAAAAAQENAAYGAAAAAATMzMwABQMAAAABAQoEVAAAAAULAAAAAAYAAAACAQAAABEFCwAAAAAGAAAAAgEAAAAIBS8AAAAAKgAAAAIBAAAAEgMNAAAAAgEAAwUAAAAAAAAAAAQNAAAAAgEAAwUAAAAAAAAAAAatAAAAByoAAAABBgMAAAACAQEEBg4AAABDAGEAbABpAGIAcgBpAAkBAQYFAAAAAAAAJkAHNwAAAAEGAwAAAAIBAQQGHgAAAFQAaQBtAGUAcwAgAE4AZQB3ACAAUgBvAG0AYQBuAAYFAAAAAAAALEAHPQAAAAABAQEGBgAAAAAEULAAAAQGHgAAAFQAaQBtAGUAcwAgAE4AZQB3ACAAUgBvAG0AYQBuAAYFAAAAAAAALEAOKQAAAAMkAAAAAQEBBgQAAAAAAgEBBwQAAAAAAwEBCAQAAAAABAEBCQQAAAAAAtcBAAADHgAAAAYEAAAAAAcEAAAAAAgEAAAAAAkEAAAAAAwEAAAAAAMhAAAABgQAAAAABwQAAAAAAwEBCAQBAAAACQQAAAAADAQAAAAAAy0AAAAGBAAAAAAHBAAAAAADAQEIBAEAAAAJBAAAAAAAAQENBgMAAAAAAQAMBAAAAAADLQAAAAYEAAAAAAcEAAAAAAMBAQgEAQAAAAkEAAAAAAABAQ0GAwAAAAABBQwEAAAAAAM2AAAAAQEBBgQBAAAABwQAAAAAAwEBCAQCAAAACQQAAAAAAAEBDQYJAAAAAAEABwEBCAEBDAQAAAAAAzYAAAABAQEGBAIAAAAHBAAAAAADAQEIBAIAAAAJBAAAAAAAAQENBgkAAAAAAQAHAQEIAQEMBAAAAAADNgAAAAEBAQYEAwAAAAcEAAAAAAMBAQgEAgAAAAkEAAAAAAABAQ0GCQAAAAABAAcBAQgBAQwEAAAAAAM5AAAAAQEBBgQEAAAAAgEBBwQCAAAAAwEBCAQCAAAACQQAAAAAAAEBDQYJAAAAAAEABwEBCAEBDAQAAAAAAzYAAAABAQEGBAUAAAAHBAAAAAADAQEIBAIAAAAJBAAAAAAAAQENBgkAAAAAAQAHAQEIAQEMBAAAAAAPKAAAABAjAAAAAAQAAAAAAAAABAwAAABOAG8AcgBtAGEAbAAFBAAAAAAAAAAMTgAAAAAiAAAAVABhAGIAbABlAFMAdAB5AGwAZQBNAGUAZABpAHUAbQAyAAEiAAAAUABpAHYAbwB0AFMAdAB5AGwAZQBMAGkAZwBoAHQAMQA2ABE3AAAAADIAAAD6ABEAAABTAGwAaQBjAGUAcgBTAHQAeQBsAGUATABpAGcAaAB0ADEA+wAEAAAAAAAAAAgAAAAAEy8AAAAAKgAAAFQAaQBtAGUAUwBsAGkAYwBlAHIAUwB0AHkAbABlAEwAaQBnAGgAdAAxAA==" id="bkmrk-%D0%98%D1%81%D1%82%D0%BE%D1%87%D0%BD%D0%B8%D0%BA-%D1%80%D0%B5%D0%B3%D0%B8%D1%81%D1%82%D1%80%D0%B0%D1%86%D0%B8%D0%B8" style="width: 809px;"><tbody><tr><td style="width: 187px;">Источник регистрации</td><td style="width: 622px;">Источник, по которому клиент зарегистрировался (Telegram, веб-форма)</td></tr><tr><td style="width: 187px;">Количество регистраций</td><td style="width: 622px;">Количество клиентов, зарегистрированных с помощью выбранного источника регистрации</td></tr><tr><td style="width: 187px;">Количество покупок</td><td style="width: 622px;">Количество продаж у клиентов выбранного источника регистрации</td></tr><tr><td style="width: 187px;">Выручка</td><td style="width: 622px;">Сумма продаж клиентов выбранного источника регистрации. До вычета скидок</td></tr><tr><td style="width: 187px;">Средний чек</td><td style="width: 622px;">Сумма продаж деленная на количество покупок клиентов выбранного источника регистрации</td></tr><tr><td style="width: 187px;">Частота покупок за период</td><td style="width: 622px;">Количество покупок новых клиентов источника регистрации / количество новых клиентов источника регистрации</td></tr><tr><td style="width: 187px;">Бонусный баланс</td><td style="width: 622px;">Сумма бонусных баллов на картах клиентов выбранного источника регистрации</td></tr><tr><td style="width: 187px;">Списано бонусов за покупки</td><td style="width: 622px;">Сумма списанных бонусных баллов, полученных за продажи у клиентов выбранного источника регистрации</td></tr><tr><td style="width: 187px;">Списано акционных бонусов</td><td style="width: 622px;">Сумма списанных бонусных баллов, полученных за акции у клиентов выбранного источника регистрации</td></tr><tr><td style="width: 187px;">Сумма покупок с учётом скидки</td><td style="width: 622px;">Сумма продаж после вычитания скидки у клиентов выбранного источника регистрации</td></tr></tbody></table>