I have a subscription startup and we are using airtable as our backbone. In one table I have all the information of my customers with the usual information: name, address, email, phone number, etc.
A couple of weeks ago we did a digital marketing campaign using Instagram where we gave a present to the health professionals to celebrate them and thank thank them for their service in this pandemic. In another table I have the instagram user name, name, phone number and address.
Some of them turn to customers and now I do not have a simple way to check who are the new customers that decided to purchase a subscription.
Is there any way to cross check both tables and find those that received a gift and are now customers? Adding a label or anything to identify them?
Thanks in advance. Hope someone can help me.