PARTNERSHIPS
Sponsor reporting
For Joblife, I prepare the reports sent to three sponsors: Logitech G, HOLY and Acer Predator. Every month and every quarter, in French and English.
- 01
Consolidating the data
Exports from the measurement tool and the editorial tracking are gathered by brand and by channel: stream, YouTube, social media and verbal mentions. For the quarter, the totals must match the sum of the three months.
- 02
Automating production
Production runs on scripts: the reports are generated from the consolidated data, then exported to PDF. The next month's report starts from the same base, without redoing everything by hand.
- 03
Checking consistency
Before each send-out, the reports are checked: totals, figures carried over from one page to another, discrepancies between the French and English versions. An audit of one quarter's reports made it possible to spot and correct several errors.
- 04
Highlighting key moments
For each brand, a selection of the period's standout activations, for example the Logitech Play Days, with their visuals, without counting them twice in the totals.
- 05
Delivering in two languages
Each report comes out in French and English, in Joblife's branding: a report every month, and a presentation deck for the quarter.
In pictures
WHAT I TOOK FROM IT
A useful report is an accurate one: better to check twice than to correct after sending.