Analytics
5.7K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

Search Term Segment

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi,

 

I have an excel spreadsheet of 3,800 keywords entered via my internal website search. I have pulled these out of a larger pool of keywords as they apply to a specific category of products. My goal is to see which of these keywords are searched the most during different time frames of the year. Can this be completed via Segments? If so please kindly advise


Thanks

Tristan

Search Term Segment

Explorer ✭ ✭ ☆
# 2
Explorer ✭ ✭ ☆

Unless those 3,800 keywords can be reduced to a fairly simple regular expression, using a segment will be very difficult, inefficient, if not plain impossible. You will probably not be able to do this directly in GA. Here's what I would do:

- since it's very likely there will be sampling, I would use Analytics Canvas and its "partitioning" ability to retrieve internal search terms by day from GA and export to Tableau

- use Tableau to connect this new data source and your Google Sheet

- use the search term as the key between both data sources

- have fun exploring and visualizing your data!

Search Term Segment

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Thanks for your response!