Skip to main content
Feedback

Moat analytics walkthrough

Connection

To connect Moat Analytics with your destination, follow the Moat Analytics connection guide. After you create a connection, select a Source connection.

Moat Analytics options and settings in Data Integration

The integration between Data Integration and Moat let you retrieve data using Moat's Analytics report—the available options and settings in Data Integration is determined by the features provided by Moat's reporting services.

note

Moat does not offer dynamic entities and fields fetching. You must configure some settings manually. To check the available brands, fields, and grouping options, refer to the Moat Analytics documentation and enter your token in the appropriate format.

Brands

From the Brands field, choose the specific brand from which you want to fetch data. This selection determines the data source for the report.

Report columns

Select the desired report columns you want to include in your data fetch. The list displays all available metrics, and you can choose the appropriate columns based on your reporting requirements.

Field aliases

Moat lets you alias the report column names. By enabling the Include Field Aliases option, the system adds any chosen report column field with aliases (previous names) to the target schema mapping with the same values. The results include the new and old fields' names as target table columns with their corresponding values.

For example, if a selected report column field is "new_field_name" with a value of 1, and it has an old name "old_field_name," then the system adds both "new_field_name" and "old_field_name" as target table columns with a value of 1 in the results.

Predefined filters

You can apply predefined filters to the report to restrict the data returned in the response. Moat Analytics provides multiple filter options divided into the following sections:

  • Levels: Add filters based on the selected "Brand Levels" Values.
  • Slicers: Add filters based on the selected "Brand Slicers" Values.
  • Include OS Browser: Add an "OS Browser" filter to include or exclude specific browsers. Enabling this option filters the data based on the selected OS Browser and adds an os_browser report column.
note

Adding Levels, Slicers, and the OS Browser filters to the report columns acts as a group-by function (roll-up) and changes the granularity and structure of the results.

Free text filters

In addition to the predefined filters, Data Integration also supports free text filters based on the Moat report capabilities.

To add a filter:

  • Select the + Add Filter option.

  • Choose the desired dimension for filtering, and specify the corresponding value.

    • If multiple filters are applied within the same column, the system joins them as options using "OR".
    • When multiple filters are used across different columns, the system combines them using "AND".

Set the time period

Data Integration handles data updates for the Rivers and uses optimal techniques to retrieve incremental data from the source, according to the source's recommended practices.

When opting for the Date Range feature, take note of the following:

  • Start Date is mandatory.
  • The system retrieves the data for the date range specified between the start and end dates.
  • If you leave the end date blank, the system pulls the data at the current river run time.
  • Date timezone: UTC.
  • Use the Last Days Back For Each Run option to retrieve data from a specified number of days before the selected start date.
info

Data Integration interprets the date_grouping key as "day". Each row of data in the Target represents a single day.

On this Page