I've created an airtable where i store (anonymously) every lead generated for our clients by our agency.
i have différent informations : ID of the lead, client, agency of the client, campaign, Revenue, Cost, source and a few other field.
The problem is in 3 months we are already reaching 50K records and even getting the 250K plan won't be an option. So i plan to have 2 bases :
- One (the current) where the leads keeps arriving every day (the history will stop at the previous month included)
- One where i merge the records by month (by doing the sum of the cost and the revenue). This would reduce greatly the number of records.
For example, let's say i have 200 records of leads for one of my client that came from Facebook in november, I would reduce that to one line only.
Then 1500 leads for that same client come from Google and it would also be reduced to a line.
Any idea how i could do this ? via a Script ?
or is there a better way to manage this ?
thanks in advance !
I've been meaning to investigate condense methods for myself. I suspect that the scripting will be fairly simple - take data from several records and map it into a condensed object, and posted as one record - but... as with all things scripting, easier said than done!
There's things to consider here;
Solutions will be unique per base, so any further info you could provide might help your cause.
Thanks for your reply !
You are right, i should give more information :
In a perfect work i would keep everything in one table as we don't really work inside the tables, the real feature that will be used is the different interfaces that will allow us to have statistics for our campaign, or interfaces that we create for our clients.
Having two tables won't give us a complete view of our stats but it could do the job for the time being as we most of the time are looking for stats for the current and previous month.