Postprocessing emails from url

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,

What do you mean by details (email) not updated?
Did you update it via GET, like: ?

Yes. I used ?, 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.

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

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

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