Brightedge Web Data Connector
Bring SEO data into Tableau.
Steps to Connect
- In Tableau (10+), connect to Web Data Connector
- Input BrightEdge connector url
- Add authentication
- Connect and enter worksheet
Tips & Tricks
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:
To connect to multiple data sets, simply add a Left Join between sheets. This connector uses the keyword and keyword_volume_trending datasets.
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.