Question
Why are some fields not found in the select list when creating a new report?
Environment
Connector: Google Ads
Answer
Resolution 1
Use Google's Dimensions and Metrics Explorer to test and identify valid combinations.
Resolution 2
-
- Navigate to Google's Report Types documentation.
- Select the report that you're going to sync.
- Select the field which is not appearing in the Fivetran connector setup page.
- Click The + sign next to Not compatible with the following field
- Remove incompatible fields in the Fivetran connector setup page.
- Search for the desired field within the Fivetran connector setup page and select it from the list.
Cause
Certain fields are incompatible with each other for a given report. Fivetran will not display additional fields in the select list which are incompatible with already selected fields.