Look through the source code of the Fundraising Operation Center for the words tracking, campaign and keyword. Look if the campaign and keyword comes from the database ($data[tracking] or unserializing $row[data] is a good indicator) and note down the class where it is used / queried. Create a ticket for each route or command line tool where these classes are used.

The found classes will be used as a basis to replace the complex iteration code for PHP that checks if the tracking matches with an SQL JOIN to the donation_tracking table introduced in T328075: Move tracking out of donation data blob

Acceptance Criteria

• This ticket has child tickets listing the classes we need to touch that use the new donation_tracking table.

Details

• All occurrences of conditions and loops using this field need a child ticket.