To find if the keyword you are testing exists within your user behaviour data and return the corresponding time on site or bounce rate figure use a vlookup formula, then in an adjacent column use an if statement to determine the keyword’s score...
By creating a spreadsheet of canonical URLs that are crawled consistently and combining those over time using something like VLOOKUP, this functionality can be mimicked. Services like seoClarity and BrightEdge provide incredible insight, but are...
I do this using VLOOKUP. If you don’t know how to use VLOOKUP I suggest learning, but also suggest reading on as you will still understand the concept of how to theoretically regain some (not provided) data.
However, if you aren't able to rely on point of sale tracking to get components of ROI into your analytics package, there are a number of ways to reconcile that data after the fact (VLOOKUP, Pivot Tables, etc.
