Brightedge Web Data Connector

Bring SEO data into Tableau.

Steps to Connect

  1. In Tableau (10+), connect to Web Data Connector
  2. Input BrightEdge connector url
  3. Add authentication
  4. Connect and enter worksheet

Tips & Tricks

Date Format

The date inputs for the BrightEdge WDC are sent to BrightEdge's date-conversion API service that convert dates formatted as 'YYYYMMDD' into their desired 'YYYYWW' year-week formatting. The values returned from this service sometimes fail to extract data from the BrightEdge API. If you encounter issues surrounding the date conversion service, please try changing your start and ends dates to cover a larger duration. This issue will be addressed in our next update to the WDC.

Since the time field comes in as yyyyww, you may want to convert this unit to a more standard date format. Create this calculated field to convert your week number string into a dd/mm/yyyy format:

DATEADD('week',INT(MID(STR([time]), 5,2))-1,DATE("01/01/"+(MID(STR([time]), 1,4))))

Grouping by calculated fields

New keyword groups can be created using calculated fields. IF CONTAINS() and REGEXP_MATCH are useful here.

This connector pulls the following dimensions:

  • keyword
  • blended_rank
  • page_url
  • search_engine
  • time
  • avg_volume

Multiple Datasets

To connect to multiple data sets, simply add a Left Join between sheets. This connector uses the keyword and keyword_volume_trending datasets.

Contact Us

Have any questions about the Web Data Connector? Want more fields or data sets added? Please send all bug reports, enhancement requests, or other communications to the BrightEdge Web Data Connector's Github page. If you are a dev yourself, please fork a copy of the repo, modify it to suit your needs, and put in a pull request!

Don't have Tableau? Try it for free

Use this connector and hundreds of others in your full-version free trial. No credit card required.

Download Tableau