# Reports not showing data when setting filters

**URL:** <https://forum.mautic.org/t/reports-not-showing-data-when-setting-filters/19901>\
**Category:** Product Support\
**Created:** [June 17, 2021, 10:07pm UTC](https://forum.mautic.org/t/reports-not-showing-data-when-setting-filters/19901 "2021-06-17T22:07:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![eyervez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/eyervez/32/1847_2.png) [@eyervez](https://forum.mautic.org/u/eyervez)\
**Post date:** [June 17, 2021, 10:07pm UTC](https://forum.mautic.org/t/reports-not-showing-data-when-setting-filters/19901/1 "2021-06-17T22:07:13Z")

</div>

**Your software**  
My Mautic version is: v3.3.3  
My PHP version is: 7.4.20  
My Database type and version is: mysqlnd 7.4.20

**Your problem**  
My problem is: Hi!

I’m basically trying to create reports in Mautic. I want to track the deliverability of the emails I’ve set up under a certan category.

Data source: Emails  
Colums: Category ID, Category Name, Name, Sent count, Read count, Read ratio  
Filters: Column(Category ID) equals Value(CategoryID), Dynamic=Yes.

I set up the filters correctly but the reports won’t show data. I’ve tried to filter the data by Category ID, Category Name, Email Name (all the emails I want to track contain a common word) but I can’t seem to make it work.

These errors are showing in the log:  
[2021-06-17 15:25:52] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjU0Njt9Zjo4OiJmemJ2eSI7djo1Mzk7Zjo3OiJmZ2JnIjtmOjU1OiI5M2RjOTE2MzJiM2Q1MzkzNTkzMDE1IjtmOjc6InlmYmUiO2Y6ODoiMTg3MTciO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjUzOTt9fQ== {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:546;}f:8:“fzbvy”;v:539;f:7:“fgbg”;f:55:“93dc91632b3d5393593015”;f:7:“yfbe”;f:8:“18717”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:539;}} is not a serialized array at /var/www/vhosts/email.domainhidden.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}   
[2021-06-17 15:25:52] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjU0Njt9Zjo4OiJmemJ2eSI7djo1Mzk7Zjo3OiJmZ2JnIjtmOjU1OiI5M2RjOTE2MzJiM2Q1MzkzNTkzMDE1IjtmOjc6InlmYmUiO2Y6ODoiMTg3MTciO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjUzOTt9fQ== {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:546;}f:8:“fzbvy”;v:539;f:7:“fgbg”;f:55:“93dc91632b3d5393593015”;f:7:“yfbe”;f:8:“18717”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:539;}} is not a serialized array at /var/www/vhosts/email.domainhidden.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}   
[2021-06-17 15:25:53] mautic.ERROR: Invalid clickthrough value: Yjo4OntmOjk6ImZiaGVkZiI7Yjo1Ont2OjM7Zjo0NzoiZGJ6Y2J2dGEuZmlmYWciO3Y6NDt2OjU0Njt9Zjo4OiJmemJ2eSI7djo1Mzk7Zjo3OiJmZ2JnIjtmOjU1OiI5M2RjOTE2MzJiM2Q1MzkzNTkzMDE1IjtmOjc6InlmYmUiO2Y6ODoiMTg3MTciO2Y6MDoiZHViYWFmeSI7Yjo0OntmOjg6ImZ6YnZ5Ijt2OjUzOTt9fQ== {“exception”:"[object] (Mautic\CoreBundle\Exception\InvalidDecodedStringException(code: 0): The string b:8:{f:9:“fbhedf”;b:5:{v:3;f:47:“dbzcbvta.fifag”;v:4;v:546;}f:8:“fzbvy”;v:539;f:7:“fgbg”;f:55:“93dc91632b3d5393593015”;f:7:“yfbe”;f:8:“18717”;f:0:“dubaafy”;b:4:{f:8:“fzbvy”;v:539;}} is not a serialized array at /var/www/vhosts/email.domainhidden.com/httpdocs/app/bundles/CoreBundle/Helper/ClickthroughHelper.php:46)"}   
[2021-06-17 20:28:28] mautic.NOTICE: Symfony\Component\Console\Exception\RuntimeException: Too many arguments, expected arguments “command”. (uncaught exception) at /var/www/vhosts/email.domainhidden.com/httpdocs/vendor/symfony/console/Input/ArgvInput.php line 188 while running console command `mautic:reports:scheduler`    
[2021-06-17 20:28:28] mautic.WARNING: Command `mautic:reports:scheduler` exited with status code 1

Steps I have tried to fix the problem:

I’ve also tried:  
Filters: Column(Category Name) equals Value(Category Name), Dynamic=Yes.  
Filters: Column(Name) contains Value(Common word), Dynamic=Yes.

 ![1](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/1/1393c156521505753de7ab3fb15334fcb0f005d6.png)  
 ![2](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/d/d38b3b22d49a18996b69c769d56d819e6915248f.png)

If you’d be able to help me, that’d be very much appreciated!

---

<div class="post-metadata">

**Author:** ![bulgin](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/bulgin/32/1001_2.png) [@bulgin](https://forum.mautic.org/u/bulgin)\
**Post date:** [December 25, 2021, 2:15am UTC](https://forum.mautic.org/t/reports-not-showing-data-when-setting-filters/19901/2 "2021-12-25T02:15:47Z")

</div>

Same problem here with 4.1.1

No errors in log file.

Started when updating to 4.1.1

---

<div class="post-metadata">

**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\
**Post date:** [December 27, 2021, 1:31am UTC](https://forum.mautic.org/t/reports-not-showing-data-when-setting-filters/19901/3 "2021-12-27T01:31:38Z")

</div>

Your click through values look strange, it would typically contain email list id, lead id, etc… looking at your data above, you do not have the right keys in the variable (when value is decoded from base64).

I would check what is happening with those values by sending out some test emails (to yourself), then copy links from the email you got, extract ct variables (click through values).

Values are base64 encoded, so to see whats actually inside you will have to decode the value, once you do you (should) get serialized php array.

If you do not find stuff like lead, email, etc. in this array, something is wrong with link generation. And you have another issue.

Reports are not working because current values in serialized arrays have no meaning for mautic report functionality.

Regards, M.
