To correctly parse the Google sheet and avoid any connector failures, it is mandatory to ensure the initial formatting of the Google sheet is correct.
The tab in the Google sheet should be formatted as 'standard tabular data'. This means:
The first row of the selected tab must include the headers.
Any subsequent rows must contain the values corresponding to those headers.
Here is an example of such a structure in a Google sheet:
The names as you see them in the first row or column headers will be parsed and made ‘BigQuery friendly', so they might not have the exact same name when you see them in the output table. For example, we replace non-alphanumeric characters with '_' and make everything lowercase.
When you select a specific pre-defined report, you need to use specific headers for the columns in the file (and the corresponding values in the rows).
For the sample screen provided above, if you select the 'Budget and targets' report, you will need to use specific dimensions and metrics as mentioned in the black tooltip:
Metrics: budget, target, target_roas, target_cpa
Dimensions: date_from, date_to, market, channel
Alternatively, you can obtain the same level of detail regarding specific metrics and dimensions from this page for each specific pre-defined report.
Using the example above, the results in a BigQuery table will look like this:
As you can see, the original column from the Google sheet 'Target ROAS' will be named as 'target_roas' to meet the BigQuerry formatting requirements.