Hello everyone,
I’m wondering if the following idea could be created in Airtable.
Suppose I have a business that sells online adverts. When a client buys an advert, we’ll put it online and the advert will be shown on specific newspaper websites.
When the client agrees with the offer, we provide the client with 2 things:
- An amount of clicks (the advert is clickable an redirects to his homepage)
- A period between a start and an end date that the advert is online.
Now, what do I want to create in Airtable:
I have a sales team that can spent a budget 500.000 clicks a year.
So, I’d like to create a table in Airtable, where my sales team can add new clients and each client is then granted an amount (1.000, 2.000, 5.000, …) of clicks, a start and an end date.
I would then be great that Airtable calculates the average amount of clicks between the start and end date and also subtracts the amount of clicks of the yearly budget.
Can this be done in Airtable?
Any help is much appreciated. Thanks very much