I’m trying to implement search results page analytics for my marketplace. Basically, whenever a visitor searches and then clicks on a listing, I want to increment the clicks count against the corresponding search term for that seller. (Database “things” are shown in italics).
I have a Seller as a database type, and each Seller has associated with their database entry, a list of search terms and the corresponding number of clicks for that term. The search terms entry is called search term and is type text, while the clicks is stored in count which is of type number.
I’m trying to do this using the Workflow called Make Changes to a Thing, but I’m not having much success. I can’t seem to find a simple way to increment the count by 1 whenever someone clicks on the corresponsing search result.