Google Sheets Expert for Semi-Automated Report

We need to create semi-automated report on Google Sheets created from the raw data we have in our CRM system.

We will extract Google Sheets table with raw data (agreed table format). The task has 2 parts.

Part 1

* take the data from the raw table,
* use filters based on the cell contains and count certain records,
* calculate 3 KPIs (divided by country/traffic source)
* put KPIs in a final report table (agreed format)

Part 2:

* take the data from the raw table,
* use filters based on the cell contains (cancellation reasons),
* count different reasons' numbers,
* create a table reason - number of records - % of the total number (divided by country/traffic source)

All templates are 90% ready and will be provided upon contract signing.