Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Oct 21, 2022
I don’t know if this is possible to do - but if so would be of huge value to me.
I have records in Airtable that contain ‘Media Bookings’ for advertising campaigns
As an example:
booked Impressions: 1000000
Media Cost: $15000
Start Date: 01/10/2022
End Date: 31/12/2022
I need to easily convert this information into ‘Week commencing’ detail so that I can prorata the impressions and cost based on weeks of the campaign
e.g. W/C 03rd October, 10th October
Value of doing this:
this would help significantly with monitoring pacing of campaigns, and suporting accurate invoicing of costs to clients
Is there a way of doing this within Airtable…
thank you so much for your help!!!