"I want to isolate popular keywords from my site."

When enabled, Confection's BigQuery integration creates a dataset with two columns: UUID and data. The data column includes JSON-formatted data associated with a UUID's site activity. To connect BigQuery to your Confection account, see this quick-start guide.

Use the following query to rank keywords from URLs and page titles by number of pageviews.

Sample output follows:

Keyword Pageviews Rank
Lorem 100 1
Ipsum 50 2

Search the Cookbook

See Confection in Action

Get started risk free.

  • Hidden

Next Steps

"I'm ready to try it."

Get Started (Risk Free)

"I want to see a demo."

Let’s Go

"I have some questions."

Contact Us

"I want to see this."

Share It

"How much does this cost?"

View Pricing Guide

Discussion

Questions or comments about "I want to isolate popular keywords from my site."? Leave them below.

Get Started. Risk Free.
IB QUIMBY MELTON

  • Hidden