Front reporting metrics definitions: New conversations, archived conversation

Hi! I am trying to re-create metrics for our own reporting in Tableau but I have a hard time with new and archived conversations. I went through the documentation, and timezone differences are excluded as an error too.

New conversations: (https://help.front.com/en/articles/2310)
I set new_conversation attribute to true (I assume it’s a flag) and excluded conversations without message_id
I still get less than in the front overview report

Archived conversation: https://help.front.com/en/articles/2396
For this, I couldn’t find a flag, so I wrote a query in Snowflake. If the last ‘type’ is archived or snoozed, then I counted the conversation ID.

max_message_date = message_date 

and type in (‘archived’,’snoozed’)

Here, first i used a timestamp but then used a date instead.
I can’t match the values, so any help is appreciated.

I can’t 100% match the time metrics either; I get slightly less, especially if I add the business hours flag. (But it’s minor compared to the above.)

Thank you!