When we implemented our ETL (Extract-Transform-Load) between Trello and BigQuery, we faced an issue: Trello wasn’t exposing the creation dates of the cards.
After investigating in their documentation, they revealed that they were using MongoDB ID as the exposed IDs, and the timestamp is deductable from it.
The rule to deduct the timestamp is not too complicated, and well explained in this article. From this rule, we wrote a BigQuery UDF as we might need it quite often for Trello Analysis.
– ae