Advanced Excel Ad Tracker
Budget: $30 – $250 AUD
I need an excel spreadsheet that contains a list of ads that I sell. Some are sold with a date range and some are sold by quantity.
On a single booking sheet I need to enter the company name, select an ad type and enter either a date range or enter the quantity purchased depending on which type of ad is selected.
An output sheet or summary will show me the following at a glance:
Ads by Date Range
Company Name, Ad type selected, start date, finish date, status.
As ads approach 7 days until expiry the finish date text will turn orange, once it reaches the finish date it will go red. No two ad types can be given to the same customer.
Ads by Quantity
Company Name, Ad type selected, Quantity purchased, Ads completed, Ads remaining.
If 10 ads are purchased then 10 tick boxes or radio buttons will appear for manual recording. Once all ads are completed it will be auto marked as campaign completed. The same ad types can be given to many customers.
The sheet is for recording and analysis so it also must be simple for me to delete expired customer ads and continue with new entries on the booking sheet. The booking sheet must alert me if one of the date range ads is already in use. The quantity ads have no limit.
As many automations and triggers as possible. The attached file has the products and a basic idea but is far from what I want.
On a single booking sheet I need to enter the company name, select an ad type and enter either a date range or enter the quantity purchased depending on which type of ad is selected.
An output sheet or summary will show me the following at a glance:
Ads by Date Range
Company Name, Ad type selected, start date, finish date, status.
As ads approach 7 days until expiry the finish date text will turn orange, once it reaches the finish date it will go red. No two ad types can be given to the same customer.
Ads by Quantity
Company Name, Ad type selected, Quantity purchased, Ads completed, Ads remaining.
If 10 ads are purchased then 10 tick boxes or radio buttons will appear for manual recording. Once all ads are completed it will be auto marked as campaign completed. The same ad types can be given to many customers.
The sheet is for recording and analysis so it also must be simple for me to delete expired customer ads and continue with new entries on the booking sheet. The booking sheet must alert me if one of the date range ads is already in use. The quantity ads have no limit.
As many automations and triggers as possible. The attached file has the products and a basic idea but is far from what I want.