# Структура бонусов не за покупки (акционные)

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

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

- Период

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

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

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%9D%D0%B0%D0%B8%D0%BC%D0%B5%D0%BD%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5-%D1%82%D0%B8%D0%BF%D0%B0-%D0%B1%D0%BE"><colgroup><col width="141"></col><col width="120"></col><col width="130"></col><col width="100"></col></colgroup><tbody><tr><td>Наименование типа бонуса</td><td>Срок действия</td><td>Источник начисления</td><td>Сумма начисления</td></tr><tr><td>Wellcome bonus</td><td>5 дней</td><td>Сценарий</td><td>100</td></tr><tr><td>Birthday bonus</td><td>6 дней</td><td>Сценарий</td><td>250</td></tr><tr><td>Двойной кешбек</td><td>7 дней</td><td>Акция</td><td> </td></tr></tbody></table>

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%9A%D0%BE%D0%BB%D0%B8%D1%87%D0%B5%D1%81%D1%82%D0%B2%D0%BE-%D1%83%D1%87%D0%B0%D1%81%D1%82%D0%BD%D0%B8%D0%BA%D0%BE" style="width: 400px;"><colgroup><col width="100"></col><col width="100"></col><col width="100"></col><col width="100"></col></colgroup><tbody><tr><td style="width: 100px;">Количество участников</td><td style="width: 100px;">Количество участников с покупками</td><td style="width: 100px;">Количество покупок</td><td style="width: 100px;">Сумма покупок</td></tr><tr><td style="width: 100px;">600</td><td style="width: 100px;">420</td><td style="width: 100px;">700</td><td style="width: 100px;">12 455 212,00</td></tr><tr><td style="width: 100px;">700</td><td style="width: 100px;">420</td><td style="width: 100px;">700</td><td style="width: 100px;">12 455 212,00</td></tr><tr><td style="width: 100px;">600</td><td style="width: 100px;">420</td><td style="width: 100px;">700</td><td style="width: 100px;">12 455 212,00</td></tr></tbody></table>

<table border="1" cellpadding="0" cellspacing="0" data-sheets-baot="1" data-sheets-root="1" dir="ltr" id="bkmrk-%D0%9D%D0%B0%D1%87%D0%B8%D1%81%D0%BB%D0%B5%D0%BD%D0%BE-%D0%A1%D0%BF%D0%B8%D1%81%D0%B0%D0%BD%D0%BE-%28%D1%81"><colgroup><col width="100"></col><col width="100"></col><col width="100"></col><col width="100"></col></colgroup><tbody><tr><td>Начислено</td><td>Списано (сумма)</td><td>Сгорело (сумма)</td><td>Остаток</td></tr><tr><td>60 000,00</td><td>1 245 625,00</td><td>252 623,00</td><td>125 426,00</td></tr><tr><td>175 000,00</td><td>1 245 625,00</td><td>252 623,00</td><td>125 426,00</td></tr><tr><td>1245521,20</td><td>1 195 521,20</td><td>50 000,00</td><td>0,00</td></tr></tbody></table>

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

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

<table cellpadding="0" cellspacing="0" class="xslData;XLSY;v2;5435;BgaAAgAAB6ACAAABQAkAAAI+EQAAA+UDAAAEDQQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEbAAAA+gMAAAAADAANAA4ADwD7AAcAAAD6EgAAAAD7AkABAAD6AA8AAAAeBEIERwQ1BEIEPQQ+BEEEQgRMBC4AeABsAHMAeAABFAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAF8ATQBBAE4AUwBLAFYAMgACKgAAABwEMAQ9BEEEOgQ4BDkEIAASBDAEOwQ1BEAEOAQ5BCAAKABNAEEATgBTAEsAVgApACAAKABtAGEAbgBzAGsAdgBAAHIAYQByAHUAcwAuAHIAdQApAAMCAAAAMgA2AAUUAAAAMgAwADIANAAtADEAMgAtADIANABUADEAMgA6ADIAMAA6ADUAMQBaAPsAWgAAAPoGDAAAAG8AYwB1AGkAeQB1AGUAawBhAHQAOABqAAcIAAAAMgA2ADYAMQA3ADcANAA0AAkKAAAANAAxADQANQAwADYAOAAzADUAMAALBAAAADEAMAA0ADkA+yQAAAAAAAAAAAELAAAAAgYAAAAABAAAAAADAAAAAA8AAAAAGwAAAAAvBQAAACoFAAABRQAAAAAGHgAAABAEPQQwBDsEOAQ3BCAAPgRCBEcENQRCBD4EMgQgAAEEAQAAAAIBAgMGEgAAAEEAMQAxADgAOgBDADEAMgA5AAK0AAAAAyIAAAAAAQECBAEAAAADBAEAAAAEBAEAAAAFBQAAAACAtlFABgEBAx8AAAACBAIAAAADBAIAAAAEBAIAAAAFBQAAAAAAkBxABgEBAx8AAAACBAMAAAADBAMAAAAEBAMAAAAFBQAAAAAAaWNABgEBAx8AAAACBAQAAAADBAQAAAAEBAEAAAAFBQAAAACABGZABgEBAxwAAAACBABAAAADBAUAAAAEBAEAAAAFBQAAAAAASCJAFjcAAAAXMgAAABQtAAAAAAgAAABBADEAMQA4AAEEAAAAAAAAAAISAAAAQQAxADEAOAA6AEMAMQAyADkACwoAAAABBQAAAAAAgCxADjwAAAAABc3MzMzMzDFAAQWamZmZmRkzQAIFzczMzMzMMUADBZqZmZmZGTNABAV7FK5H4XoeQAUFexSuR+F6HkAPPwAAAAEBCQIBAAMBAAQEAQAAAAUBAAYBAAgEAQAAAAkEAQAAAAoEWAIAAAABAQsBAA8EZAAAABABABEBARIEWAIAABAGAAAAAAEAAQEACTMDAAAjLgMAAAIGAACRAQAAEXUAAAAAAAAAWQEAAAAAAAAABw4AAAAABAAAAAAAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAAAgAAAAAAABF2AAAAAAAAAFkBAAAAAAAAAAcOAAAAAAUAAAADAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAQAAAAAAAARdwAAAAAAAABZAQAAAAAAAAAHDgAAAAAFAAAABQAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAAGAAAAAAAAEXgAAAAAAAAAWQEAAAAAAAAABw4AAAAABQAAAAcAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAACAAAAAAAABF5AAAAAAAAAFkBAAAAAAAAAAcOAAAAAAUAAAAJAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAAAoAAAAAAAARegAAAAAAAABZAQAAAAAAAAAHDgAAAAAFAAAACwAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAAMAAAAAAAAEXsAAAAAAAAAWQEAAAAAAAAABw4AAAAABQAAAA0AAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAADgAAAAAAABF8AAAAAAAAAFkBAAAAAAAAAAcOAAAAAAUAAAAPAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAABAAAAAAAAARfQAAAAAAAABZAQAAAAAAAAAHDgAAAAAFAAAAEQAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAASAAAAAAAAEX4AAAAAAAAAWQEAAAAAAAAABw4AAAAABQAAABMAAAAAAAcOAQAAAAIAAAABAAAAAAAHDgIAAAADAAAAFAAAAAAAABF/AAAAAAAAAFkBAAAAAAAAAAcOAAAAAAUAAAAVAAAAAAAHDgEAAAACAAAAAQAAAAAABw4CAAAAAwAAABYAAAAAAAARgAAAAAAAAABZAQAAAAAAAAAHDgAAAAAFAAAAFwAAAAAABw4BAAAAAgAAAAEAAAAAAAcOAgAAAAMAAAAYAAAAAACSAQAFAAAAAAcAAAAADAAAAAAbAAAAAPoHAAAANQAAAAMwAAAAHQQwBDgEPAQ1BD0EPgQyBDAEPQQ4BDUEIABCBDgEPwQwBCAAMQQ+BD0EQwRBBDAEAAcAAAADAgAAACsAAJcAAAADkgAAAB0EMAQ3BDIEMAQ9BDgENQQgAEIEOAQ/BDAEIAAxBD4EPQRDBEEEMAQgADIEIAA6BDAEQARCBD4ERwQ6BDUEIAA0BD4EMQQwBDIEOwQ1BD0EOAQ4BCAAQQQ6BDgENAQ6BDgEIAA4BDsEOAQgADIEIABBBD4ENwQ0BDAEPQQ4BDgEIABBBEYENQQ9BDAEQAQ4BE8EAB8AAAADGgAAACEEQAQ+BDoEIAA0BDUEOQRBBEIEMgQ4BE8EAIMAAAADfgAAAB8ENQRABDgEPgQ0BCAANAQ1BDkEQQRCBDIEOARPBCAAQwQ6BDAENwQwBD0EIAAyBCAAOgQwBEAEQgQ+BEcEOgQ1BCAAMAQ6BEYEOAQ4BCAAOAQ7BDgEIAAyBCAAOgQwBEAEQgQ+BEcEOgQ1BCAAQQRGBDUEPQQwBEAEOARPBAArAAAAAyYAAAAYBEEEQgQ+BEcEPQQ4BDoEIAA9BDAERwQ4BEEEOwQ1BD0EOARPBABxAAAAA2wAAAAYBEEEQgQ+BEcEPQQ4BDoEIAA9BDAERwQ4BEEEOwQ1BD0EOARPBCAAMQQ+BD0EQwRBBD4EMgQgACgAQQRGBDUEPQQwBEAEOAQ5BCwAIAAwBDoERgQ4BE8ELAAgADIEQARDBEcEPQRDBE4EKQAAJQAAAAMgAAAAIQRDBDwEPAQwBCAAPQQwBEcEOARBBDsENQQ9BDgETwQAYwAAAANeAAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgAD0EMARHBDgEQQQ7BE8ENQQ8BEsERQQgADEEPgQ9BEMEQQQ+BDIEIAA+BDQEPQQ+BDwEQwQgAEMERwQwBEEEQgQ9BDgEOgRDBAAvAAAAAyoAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAQwRHBDAEQQRCBD0EOAQ6BD4EMgQAdwAAAANyAAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgADoEOwQ4BDUEPQRCBD4EMgQsACAAOgQ+BEIEPgRABEsEPAQgADEESwQ7BCAAPQQwBEcEOARBBDsENQQ9BCAAMgRLBDEEQAQwBD0EPQRLBDkEIAAxBD4EPQRDBEEEAEcAAAADQgAAABoEPgQ7BDgERwQ1BEEEQgQyBD4EIABDBEcEMARBBEIEPQQ4BDoEPgQyBCAAQQQgAD8EPgQ6BEMEPwQ6BDAEPAQ4BACnAAAAA6IAAAAaBD4EOwQ4BEcENQRBBEIEMgQ+BCAAOgQ7BDgENQQ9BEIEPgQyBCwAIAA6BD4EQgQ+BEAESwQ8BCAAMQRLBDsEIAA9BDAERwQ4BEEEOwQ1BD0EIAAyBEsEMQRABDAEPQQ9BEsEOQQgADEEPgQ9BEMEQQQgADgEIAA+BD0EOAQgAEEEPgQyBDUEQARIBDgEOwQ4BCAAPwQ+BDoEQwQ/BDoEQwQAKQAAAAMkAAAAGgQ+BDsEOARHBDUEQQRCBDIEPgQgAD8EPgQ6BEMEPwQ+BDoEAEsAAAADRgAAABoEPgQ7BDgERwQ1BEEEQgQyBD4EIAA/BD4EOgRDBD8EPgQ6BCAAQwRHBDAEQQRCBD0EOAQ6BD4EMgQgADAEOgRGBDgEOAQAHwAAAAMaAAAAIQRDBDwEPAQwBCAAPwQ+BDoEQwQ/BD4EOgQASwAAAANGAAAAIQRDBDwEPAQwBCAAMgRBBDUERQQgAD8EPgQ6BEMEPwQ+BDoEIABDBEcEMARBBEIEPQQ4BDoEPgQyBCAAMAQ6BEYEOAQ4BAAXAAAAAxIAAAAdBDAERwQ4BEEEOwQ1BD0EPgQAewAAAAN2AAAAHgQxBEkENQQ1BCAAOgQ+BDsEOARHBDUEQQRCBDIEPgQgADEEPgQ9BEMEQQQ+BDIELAAgAD0EMARHBDgEQQQ7BDUEPQQ9BEsERQQgADIEQQQ1BDwEIABDBEcEMARBBEIEPQQ4BDoEMAQ8BCAAMAQ6BEYEOAQ4BAAjAAAAAx4AAAAhBD8EOARBBDAEPQQ+BCAAKABBBEMEPAQ8BDAEKQAAYwAAAANeAAAAIQRDBDwEPAQwBCAAQQQ/BDgEQQQwBD0EPQRLBEUEIAAxBD4EPQRDBEEEPgQyBCAAMgRBBDUEPAQ4BCAAQwRHBDAEQQRCBD0EOAQ6BDAEPAQ4BCAAMAQ6BEYEOAQ4BAAjAAAAAx4AAAAhBDMEPgRABDUEOwQ+BCAAKABBBEMEPAQ8BDAEKQAAvwAAAAO6AAAAIQRDBDwEPAQwBCAAQQQzBD4EQAQ1BDIESAQ4BEUEIAAxBD4EPQRDBEEEPgQyBCAAQwQgADIEQQQ1BEUEIABDBEcEMARBBEIEPQQ4BDoEPgQyBCAAMAQ6BEYEOAQ4BCAAKABBBD8EOARBBDAEPQRLBCAAQQQgADoEMARABEIESwQgAD8EPgQgADgEQQRCBDUERwQ1BD0EOAROBCAAQQRABD4EOgQwBCAANAQ1BDkEQQRCBDIEOARPBCkAABMAAAADDgAAAB4EQQRCBDAEQgQ+BDoEAGUAAAADYAAAACEEQwQ8BDwEMAQgAD4EQQRCBDAEMgRIBDgERQRBBE8EIAAxBD4EPQRDBEEEPgQyBCAAQwQgADIEQQQ1BEUEIABDBEcEMARBBEIEPQQ4BDoEPgQyBCAAMAQ6BEYEOAQ4BPkDAAAA0gAAAAEoAAAAAAMAAAABAQoBAwAAAAEBCgIDAAAAAQEKBAMAAAABAQoFAwAAAAEBCgFMAAAAAAwAAAABAQ0ABgMAAAABAQABAwAAAAEBCgIMAAAAAQENAAYDAAAAAQEABAwAAAABAQ0ABgMAAAABAQAFDAAAAAEBDQAGAwAAAAEBAAFPAAAAAAwAAAABAQ0ABgMAAAABAQABAwAAAAEBCgIMAAAAAQENAAYDAAAAAQEABA8AAAABAQ0ABgYAAAAABMzMzAAFDAAAAAEBDQAGAwAAAAEBAAQgAAAABQsAAAAABgAAAAIBAAAAEQULAAAAAAYAAAACAQAAAAgGrQAAAAcqAAAAAQYDAAAAAgEBBAYOAAAAQwBhAGwAaQBiAHIAaQAJAQEGBQAAAAAAACZABzcAAAABBgMAAAACAQEEBh4AAABUAGkAbQBlAHMAIABOAGUAdwAgAFIAbwBtAGEAbgAGBQAAAAAAACxABz0AAAAAAQEBBgYAAAAABFCwAAAEBh4AAABUAGkAbQBlAHMAIABOAGUAdwAgAFIAbwBtAGEAbgAGBQAAAAAAACxADikAAAADJAAAAAEBAQYEAAAAAAIBAQcEAAAAAAMBAQgEAAAAAAQBAQkEAAAAAAIjAQAAAx4AAAAGBAAAAAAHBAAAAAAIBAAAAAAJBAAAAAAMBAAAAAADIQAAAAYEAAAAAAcEAAAAAAMBAQgEAQAAAAkEAAAAAAwEAAAAAAMtAAAABgQAAAAABwQAAAAAAwEBCAQBAAAACQQAAAAAAAEBDQYDAAAAAAEADAQAAAAAAy0AAAAGBAAAAAAHBAAAAAADAQEIBAEAAAAJBAAAAAAAAQENBgMAAAAAAQUMBAAAAAADNgAAAAEBAQYEAQAAAAcEAAAAAAMBAQgEAgAAAAkEAAAAAAABAQ0GCQAAAAABAAcBAQgBAQwEAAAAAAM2AAAAAQEBBgQCAAAABwQAAAAAAwEBCAQCAAAACQQAAAAAAAEBDQYJAAAAAAEABwEBCAEBDAQAAAAADygAAAAQIwAAAAAEAAAAAAAAAAQMAAAATgBvAHIAbQBhAGwABQQAAAAAAAAADE4AAAAAIgAAAFQAYQBiAGwAZQBTAHQAeQBsAGUATQBlAGQAaQB1AG0AMgABIgAAAFAAaQB2AG8AdABTAHQAeQBsAGUATABpAGcAaAB0ADEANgARNwAAAAAyAAAA+gARAAAAUwBsAGkAYwBlAHIAUwB0AHkAbABlAEwAaQBnAGgAdAAxAPsABAAAAAAAAAAIAAAAABMvAAAAACoAAABUAGkAbQBlAFMAbABpAGMAZQByAFMAdAB5AGwAZQBMAGkAZwBoAHQAMQA=" id="bkmrk-%D0%9D%D0%B0%D0%B8%D0%BC%D0%B5%D0%BD%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5-%D1%82%D0%B8%D0%BF%D0%B0-%D0%B1%D0%BE-0" style="height: 382px; width: 782px;"><tbody><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Наименование типа бонуса</td><td style="height: 29px; width: 565px;">Название типа бонуса в карточке добавлении скидки или в создании сценария</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Срок действия</td><td style="height: 29px; width: 565px;">Период действия указан в карточке акции или в карточке сценария</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Источник начисления</td><td style="height: 29px; width: 565px;">Источник начисления бонусов (сценарий, акция, вручную)</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Сумма начисления</td><td style="height: 29px; width: 565px;">Количество начисляемых бонусов одному участнику</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Количество участников</td><td style="height: 29px; width: 565px;">Количество клиентов, которым был начислен выбранный бонус</td></tr><tr style="height: 46px;"><td class="align-center" style="height: 46px; width: 217px;">Количество участников с покупками</td><td style="height: 46px; width: 565px;">Количество клиентов, которым был начислен выбранный бонус и они совершили покупку</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Количество покупок</td><td style="height: 29px; width: 565px;">Количество покупок участников акции</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Сумма покупок</td><td style="height: 29px; width: 565px;">Сумма всех покупок участников акции</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Начислено</td><td style="height: 29px; width: 565px;">Общее количество бонусов, начисленных всем участникам акции</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Списано (сумма)</td><td style="height: 29px; width: 565px;">Сумма списанных бонусов всеми участниками акции</td></tr><tr style="height: 46px;"><td class="align-center" style="height: 46px; width: 217px;">Сгорело (сумма)</td><td style="height: 46px; width: 565px;">Сумма сгоревших бонусов у всех участников акции (списаны с карты по истечению срока действия)</td></tr><tr style="height: 29px;"><td class="align-center" style="height: 29px; width: 217px;">Остаток</td><td style="height: 29px; width: 565px;">Сумма оставшихся бонусов у всех участников акции</td></tr></tbody></table>