# Postprocessing emails from url

**URL:** <https://forum.mautic.org/t/postprocessing-emails-from-url/25126>\
**Category:** Product Support\
**Created:** [August 22, 2022, 12:31pm UTC](https://forum.mautic.org/t/postprocessing-emails-from-url/25126 "2022-08-22T12:31:42Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![elerion](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/elerion/32/1197_2.png) [@elerion](https://forum.mautic.org/u/elerion)\
**Post date:** [August 22, 2022, 12:31pm UTC](https://forum.mautic.org/t/postprocessing-emails-from-url/25126/1 "2022-08-22T12:31:42Z")

</div>

**Your software**  
My Mautic version is: 4.4.1  
My PHP version is: 8.0  
My Database type and version is: MariaDB

**Your problem**  
My problem is: I started using url tracking, but forgot to set “publicly updatable” flag to needed fields.  
Is there a way to post-process anonymous customers who visited url’s with tracking, but their details (email’s etc.) were not updated in Mautic database?

Thank you and best regards,  
E.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [August 22, 2022, 12:46pm UTC](https://forum.mautic.org/t/postprocessing-emails-from-url/25126/2 "2022-08-22T12:46:08Z")

</div>

What do you mean by details (email) not updated?  
Did you update it via GET, like:  
`page.com/thisismylanding?email=email@gmail.com ?`

---

<div class="post-metadata">

**Author:** ![elerion](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/elerion/32/1197_2.png) [@elerion](https://forum.mautic.org/u/elerion)\
**Post date:** [August 22, 2022, 12:51pm UTC](https://forum.mautic.org/t/postprocessing-emails-from-url/25126/3 "2022-08-22T12:51:57Z")

</div>

Yes. I used ?email=someone@example.com, and the hit is visible in anonymous customers history.

When I changed email “publicly updatable” flag, customers after clicking the link were identified by email.

My problem is there were 1000’s of customers who clicked the tracking link, but were not identified, because email field was not updatable at the time.  
I would like to reprocess these clicks, so these customers get identified. If this is possible.

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [August 23, 2022, 1:23pm UTC](https://forum.mautic.org/t/postprocessing-emails-from-url/25126/4 "2022-08-23T13:23:13Z")

</div>

Only with a script.

1. export URL hits
2. add email via api in a sequential script based on ID

Maybe someone has better idea using mysql magic and regex

---

<div class="post-metadata">

**Author:** ![elerion](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/elerion/32/1197_2.png) [@elerion](https://forum.mautic.org/u/elerion)\
**Post date:** [August 23, 2022, 1:53pm UTC](https://forum.mautic.org/t/postprocessing-emails-from-url/25126/5 "2022-08-23T13:53:43Z")

</div>

Exporting and reinporting would work just fine.  
I don’t know why I didn’t think of that!  
Thanks!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/1X/43c63600fe51440378769136903f1fa2a9a34102.png) [@system](https://forum.mautic.org/u/system)\
**Post date:** [August 25, 2022, 1:54am UTC](https://forum.mautic.org/t/postprocessing-emails-from-url/25126/6 "2022-08-25T01:54:21Z")

</div>

Closed on August 25, 2022, 1:54am UTC

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.