ADM-01Admin / Operations Assistant

Influencer Campaign Tracker (Spreadsheet Build)

Design a simple spreadsheet structure to track 10 influencer campaigns, including columns, key formulas/features, and usability notes.

Suggested time: 1 to 2 hours

Full task instructions

A marketing team needs a spreadsheet to track 10 influencer campaigns. Design the structure. List the columns you would include, describe any key formulas or features (such as status automation, date calculations or summary metrics), and add usability notes explaining how the spreadsheet should be used and maintained. Think about what a team actually needs to track and what makes a spreadsheet easy to use. You do not need to build the spreadsheet. This is a design brief.

Deliverable

A spreadsheet structure document with columns, formulas/features and usability notes.

Constraints

Do not use real influencer names or brand names. Keep the structure practical and realistic.

Skills assessed

Spreadsheet designData organisationUsabilityPractical thinking

Your progress

Register or login to start this Lab Brief.

Login to startRegister free

Your submission is private. Only you and employers with relevant subscription access can view your work. It will not be publicly displayed.