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
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.
Modify your connector
Want more fields or data sets? The code, along with BrightEdge API documentation for this connector, are available on Github. Modify it to suit your needs.
If you have any questions on this connector, reach out to Blake Levy.
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.