How To Generate Word Cloud From Search Terms Report In Power BI

There's lots of features being added in Power BI and custom visuals are one cool area to check. 

The data we're gonna use for Power BI is from Google Merchandise Store's Google Analytics>Behavior>Search terms report [Jan 01, 2017-Sep 19, 2017].

Download the Excel/CSV version and load the file in Power BI [or connect to GA API].

Once in, head to Visualizations > ... > Search from store > Type in 'word cloud'.

 

Load your Search term as the Category and Total Unique Searches under values.

You should now see the keyword cloud loaded with the size of the keyword representing the number of searches. Hover over any of the keyword to view the total unique searches as a data label.