Collecting data from BrightEdge

This guide explains how to collect data from BrightEdge. To learn how to collect data from a different data source, go back to the Available data sources in Adverity overview.


For a list of the fields that you can collect from BrightEdge, see BrightEdge.


Collecting data from BrightEdge comes with the following limitations:

  • BrightEdge can collect a maximum of 1 million rows per single report. To fetch more data than this, split your fetch into smaller date ranges in the Initial Fetch step of creating a datastream.

  • When using the report types Keyword Volume Trending and Keyword Group Volume Trending, the Search engine field displays values that imply the device type used for the search engine. For example, Google Australia (AU) (T) where the (T) indicates a tablet was used, or Bing Australia (AU) - English (D) where (D) indicates a desktop computer was used. However, the API call to BrightEdge cannot define the device type, and therefore data for all device types is collected.

Creating a datastream to collect data from BrightEdge

The basics of creating a datastream to collect data from any data source are explained in our guide to Creating a datastream. This guide contains information about the specific steps to create a datastream to fetch data from BrightEdge.

Configuration: Choose the data you want to collect from BrightEdge

To choose what data to collect and customize the BrightEdge datastream configuration, follow these steps:

  1. (Optional) Rename your datastream.

  1. In Report type, select the type of data to collect from BrightEdge. The selected report type determines the additional fields to populate.

  1. In Accounts, select the accounts for which to collect data.

  2. If you selected the Custom Query (BQL) report type, in Query, enter a BQL query defining what data to fetch.

    For information about using placeholders in the query for this report type, see Using placeholders for the Custom Query report type.

  1. In Domains, Competitors, Keywords, Keyword groups, and Search engines, select the domains, competitors, keywords, keyword groups, and search engines for which to collect data. If you do not select any items in a drop-down list, Adverity collects data for all items in the drop-down list.

  1. In Device types, select the device types for which to collect data.

  1. In Dimensions and Measures, change the list of fields that you want to see in your data extract.

  1. In Time frequency, select the time unit in which you want to retrieve your data.

What's next?

Advanced BrightEdge tips

Using placeholders for the Custom Query report type

If you select the Custom Query report type when configuring your datastream, you can use placeholders in your BQL query. As a result, you do not need to manually edit your query to change dates when fetching data.

Each of the placeholders represents the corresponding value in the date range that you choose to fetch data for. You can use the following placeholders to filter for a specific date range in your query:

  • @dt_start_week

  • @dt_end_week

  • @dt_start_month

  • @dt_end_month

  • @dt_start_quarter

  • @dt_end_quarter

For example, if you are fetching data for the period from September 25, 2023 (week 39) to November 22, 2023 (week 47), the placeholders will correspond to the following dates:

  • @dt_start_week will correspond to 202339 - week 39

  • @dt_end_week will correspond to 202347 - week 47

  • @dt_start_month will correspond to 202309 - September

  • @dt_end_month will correspond to 202311 - November

  • @dt_start_quarter will correspond to 202303 - Q3

  • @dt_end_quarter will correspond to 202304 - Q4