I have data from two sources.
In source A, each record is an Instagram posts with columns for various characteristics (including the date it was posted).
In source B, each record is a specific date with columns for various Instagram performance information (new followers, engagements, etc).
I want to “connect” the two sources of data to draw new insights.
Example: How did each post impact the performance on a specific date?
Airtable seems like it should be a great place to do this. I am an intermediate airtable user with a decent understanding of databases. However, I can’t quite conceptualize how to “connect” the data from these two different streams to gain new insights.
The various searches that I’ve done only seem to bring up very simple entry level concepts (like manually linking tables). Can someone point me in some possible directions?