Columns references (idlink_va)

i recently worked with piwik but i found the column “idlink_va” in log_link_visit_action table is not connected with the column “idlink_va” in log_conversion table.
what i mean is that the column in converion table is always null

can any one explain to me why? or if there is wrong in my DB

Hi there
the idlink_va should be set to the idlink_va value that triggered the Goal (for “Goals where URL matches XYZ” it would contain the idlink_va for this Pageview url.

if you find that the value is not set correctly feel free to create a bug report on our tracker: Issues · matomo-org/piwik · GitHub