green-helicopter-75175
10/11/2023, 2:05 PMSELECT
idvisitor AS user_id,
server_time AS timestamp,
idaction_event_action AS experiment_id,
idaction_name AS variation_id
FROM
matomo_log_link_visit_action
WHERE
idsite = 8
But thinking it might be something wrong with it, since I’m not able to update the data from my running Experiment.
I’m getting this error when I try to update the results: Error compiling SQL template: You must set valueColumn first.
Which takes me to my Metric query:
SELECT
conv(hex(idvisitor), 16, 16) as anonymous_id,
server_time as timestamp,
{{valueColumn}} as value,
idvisitor AS user_id
FROM
matomo_log_link_visit_action
Would appreciate some help here. 🙏fresh-football-47124