How are people building a impression and conversion tracking system?


Not sure if this is the best place for this question, but I thought it would be interesting to hear how people are building models with require joining across large impression and conversion tables to calculate stats.

The main issue I am trying to figure out best practice for right now is how to handle the fact that conversions can happen up 30 days days in the future past impressions. This means each time I run my jobs, I need to select a whole 30 days of data from the tables. This seems extremely inefficient, especially when running this hourly.

Would love to hear how people are tackling this!

I am using dbt + Bigquery.