Improvado Data Dictionary
The Improvado Data Dictionary lists the fields Improvado can extract from each data source, grouped by report type. Use it to check whether a metric or dimension is available, and what it will be called in your destination, before you set up an extraction.
The dictionary is an interactive table at the bottom of this page, under Data Dictionary. Click Load Looker Studio report to open it on this page, or open the Data Dictionary in a new tab.
How to find a field
- Load the dictionary below.
- Pick your connector in Filter by Data Source.
- Narrow it down with Filter by Report Type.
- Search for a specific field with Filter by Field Name or Filter by API Field.
What each column means
| Column | What it shows |
|---|---|
| Data Source | The connector the field comes from, for example Google Ads or Facebook. |
| Report Type/Use Case | The report type the field belongs to. See Report types below. |
| Field Name | The field name you see in Improvado when you set up an extraction. |
| SQL Field Name | The column name in your data table and destination. |
| API Field Name | The field name in the data source's API. |
| Field Type | metric (a numeric value), dimension (a key that defines the rows of the report), property (a descriptive attribute) or date_key (the date of the row). |
| Mandatory | 1 if the field is always extracted with this report type, 0 if it is optional. |
| Dataflow Type | Extract Service (ETL) for fields Improvado extracts from the data source, or Data Activation (Reverse ETL) for fields Improvado sends to the platform. The table shows Extract Service (ETL) fields by default; change Filter by Dataflow type to see Data Activation fields. |
Report types
A report type is a set of fields that can be used for your data extraction. It's the same thing as an extraction template, except that an extraction template also has scheduling and custom settings. The two terms are used interchangeably.
We also build many custom reports that aren't listed here. If the field you need isn't in the dictionary, talk to our experts and we'll check whether it can be extracted.
Data Dictionary
Was this page helpful?
Thanks for the feedback!
Questions? The Improvado team is always happy to help. Send us an email, contact your Customer Success Manager, or raise a request in the Improvado Service Desk.