Skip to main content
Feedback

Brandwatch walkthrough

Prerequisites

A Brandwatch connection.

Pulling data from Brandwatch using Data Integration

  1. Log in to Data Integration Console.

  2. Select Create New Data Flow from the top right-hand corner.

  3. Choose Data Source to Target as your Data Flow type.

  4. Enter a suitable Data Flow name, describe it, and choose a group in the General Info tab.

  5. Go to the Source tab and find Brandwatch in the list of data sources and select it under Marketing.

  6. Under Source Connection, select your connection, or create a new one.

  7. Select a report type: You can filter All reports by Projects. Leave this input empty to pull data for all available projects under your Brandwatch connection.

    • Queries/Queries groups filter

      You can filter some reports by Queries / Queries Groups. After selecting the filter type (by Query ID or Query Group ID) and filtering desired Projects, click the Queries / Queries Group input to get a list of all available Queries / Queries Groups. Leave this input empty to get data for all queries.

      When you enable the Skip Errors, the Data Flow issues a warning when it fails to get data for some queries and continue processing the next ones. If you do not enable it, the entire Data Flow fails when an error occurs on a particular query.

    • Basic charts report

      To retrieve Mentions pages, you can also create charts. Select an Aggregate field and a Dimension field for the charts data report (required). You can find more information about aggregates and dimensions fields.

      You can select a second dimension in the Dimension 2 input or leave this input empty to get data for one dimension.

  • Mentions report

The Mentions report returns individual mention records for your selected projects and queries. The following field is available in the report schema:

  • tags: An array of tag names applied to a mention. If no tags are applied to a mention, this field returns an empty array.

  1. Select report time period

    Select the Time Period of the report. All the reports support two kinds of time periods:

    • Date range:

      • Pulls data in the date range between the start and end date provided, including the end date.
      • You must select a start date.
      • Leaving the end date empty pulls data according to the current Data Flow run time.
      • Select a timezone offset to send dates based on the offset.
      • Use the Last Days Back For Each Run to expand the start date and pull data for a specified number of days before the chosen start date.

    • Predefined date- A date range defined by Data Integration:

      • Day: Yesterday.
      • Week (From Monday to Sunday): Week to date, Previous week, Previous week to date.
      • Month: Month to date, Previous month, Previous month to date.
      • Year: Year to date.

  2. Select Interval chunks

    Data Integration can run over the increment using chunks, making the loading more efficient and precise. You can choose from:

    • Don't Split: Data Integration pulls the data from the chosen start date to the end date in one bulk.
    • Daily: The run is chunked daily from the start to the end date.
    • Monthly: The run is chunked monthly from the start to the end date.
    • Yearly (less recommended): The run is chunked yearly from the start to the end date.

    Interval size: Set the size of each interval. For example, setting the Interval Size to 4 with a Daily Interval Chunk splits the date period into 4-day chunks. The period from 01/01/2020 until 08/01/2020 is split into two intervals: 01/01/2020 until 04/01/2020 and 05/01/2020 until 08/01/2020.

On this Page