How are people building a impression and conversion tracking system?

Hello there

I think first you should efficiently handle the delayed conversions in your model building process through dbt and bigquery.
and then divide your data according to your requirements.
I think you should divide your data into 15 days or 7 days.

For more information read this How to make good sense of how to connect to and reference dbt sources, for example referencing 'dbt-tutorial' following dbt BigQuery set up guidelines?