I am not seeing my metric in my experiment, the values stay zero even though the data is in the metrics tab. While debugging the SQL Statement I found this issue, but not sure on how to fix it, can anyone help me out or hop in a call to resolve this?

Can you share your metric SQL? If you're using GA4, you should just use

user_pseudo_id

in your metric SQL and in your Experiment Assignment Query (you can find this under your Datasources).

For others who are having this problem, we solved it by removing the GA1.1 from the beginning of the IDs with a simple string replace. We were not entirely sure why, but it seems that the id is different when firing the GA tracking callback from the server side,