I think I’m struggling with the setup of Data Sources -> ‘Experiment Assignment Queries’ . I have this query:

SELECT 
    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. 🙏

ah, looks like you might need to manually edit that query to replace that {{valueColum}} and insert the actual column name