"I want to isolate IP addresses associated with bots."

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.

The following query isolates all IP addresses associated with bot traffic. Exclude bot-linked IPs from paid campaigns, and block them from key landing pages and content assets using a service like Cloudflare. See, for example, this Google Ads post and this Cloudflare help guide

To learn more about using your Confection account to manage bot traffic, see this blog post and this blog post.

To output all bot-linked IP addresses in your dataset, use this query:

To limit output to a particular timeframe, use this query:

Sample output for both follows:

To limit output to a particular timeframe and see how many times a bot-linked IP visited your site, use this query:

Sample output follows:

Other Recipes and Use Cases

See Confection in Action

Get started risk free.

Discussion

Questions or comments about "I want to isolate IP addresses associated with bots."? Leave them below.

Get Started. Risk Free.

IB QUIMBY MELTON