When enabled, Confection's BigQuery integration creates a dataset with two columns:
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.
The following query pulls URLs from the
data column and outputs the number of times those pages have been viewed. This can help you plan ads, identify popular content, and organize overall marketing strategy.
Sample output follows:
Get started risk free.
Questions or comments about
"I want to see a list of URLs and their associated pageview counts."? Leave them below.