Is there a way to export search parameters from the search log in any meaningful way?
Hey Low,
one of my clients asked about getting detailed search results out of the various search facilities on their site.
When I looked into the low search logs I can see the parameters that look like so:
result_page: dress-search/results
gownType: on
category: 3|2|1|4
child:bridal_color_search: 2575
child:sillouettes: 2179
child:neckline: 2234
child:waistlines: 2214
child:length: 2211
(These are all entry_Id's from playa fields) so I figured that with a bit of spreadsheet trickery it might be possible to collate these into meaningful data. but when I export the search log its pretty much useless (in this instance) as we dont use a keyword field at all and parameters are omitted from the export spreadsheet.
Is there a way to export this info with the parameters in separate spreadsheet columns (im open to phpMyAdmin based solutions if required). Any suggestions?
Thanks,
Neil
Replies
Low 10 Apr 2014 15:02
Right now that's tricky, because all the parameters are stored as a json string in the DB. So if you just straight out export it, I don't think you'll be able to do much with it, without decoding the json first.
But I'll put it on my todo list to investigate. It's tricky to export consistently, as the parameter keys can differ in between searches.
Andrew 10 Apr 2014 15:16
thanks Low, I've had a look at the data from the table exported out as is, and it might be feasible to build a little php app to process it (just for the searches configured on this site), but i doubt there's budget for this work at the moment.
If you do ever find a quicker way to extract the data please let me know.
Thanks,
Neil
ZenBug 16 Oct 2015 17:09
Just to clarify about this: So there's currently no way to show which categories - by category name instead of ID - were selected in a search?
Low 17 Oct 2015 07:58
Correct. Right now, I'm thinking it's beyond Low Search's scope.