Google App Usage Trend Analysis

I have a full export of my Google app usage history and I’d like to see clear trends hidden inside it. Your task is to take the raw CSV files, clean and normalise the Gmail data, to determine whether the app was accessed, or does it represent background sync activity.

Please summarise your findings and provide feedback on the above.

Let me know how quickly you can turn this around and if you foresee any data-quality checks I should run before sending the archive.