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 |
Get started risk free.
Questions or comments about "I want to isolate popular keywords from my site."
? Leave them below.