Documentation

Where to Find Your Data Table Configuration

To see the configuration of a data table, you need to:

  • select the Data explorer item in the left menu
  • choose the required data table in the list.

Here you will see four tabs:

  • Overview tab
  • Settings tab
  • Automation tab
  • Schema Preview tab

Overview tab

This tab shows you the list of extraction orders related to this data table.

Also, you may see a list of load orders related to this data table above.

Settings tab

This tab includes the following settings blocks:

  • Data class
  • Add new fields after extraction
  • Available dimensions
  • Available metrics

Data class

Data class defines how the data is collected. For example, if the data is collected monthly, you will not be able to view the values for a single week or day.

  • Daily
  • Weekly
  • Monthly
  • Lifetime
  • Lifetime incremental
  • Default

Default data class means that the data collection model may change.

Add new fields after extraction

You can choose No to use the fixed data schema. In this case, no matter which dimensions and metrics were selected on the extraction order configuration page, they will not be added to the data table.

Available dimensions and metrics

Available dimensions and Available metrics are presented in 2 lists :

  • All possible fields are on the left side of your screen
  • All selected are on the right

Note that some dimensions and metrics are selected by default and can’t be deselected. Data won’t be extracted without those.

Automation tab

Note that the Automation tab is hidden if no extraction orders are related to this data table. Otherwise, you see the auto-extract settings on this tab.

Auto extract new accounts

Yes option allows Improvado to extract new accounts when they become available in the connected business account.

Extraction template

If you want Improvado to extract new accounts automatically, select the necessary extraction template from the drop-down list and click the Update button to save changes.

Then you need to confirm changes by answering the following question: “This action will extract new accounts automatically and will affect your usage stats. Apply the change?”

Note that if auto extraction is allowed, you can not save changes without selecting an extraction template. If you try, you will see the error message “Extract template is required when the Auto extract new accounts flag is enabled.”

After account updating that is carried once a day, extraction orders will be created via auto-extract. They will be marked with the Automated label next to their names in the extraction orders list. In the Created by column you will see the email of a user who has set the auto-extract.

Schema Preview tab

Here you see the Data structure preview. It works by the same logic as the preview for extraction orders:

  • Values are displayed if data exists. Otherwise, No data message is displayed.
  • Data structure preview includes all columns and only ten rows of data from this data table
Related articles
No items found.