"I want to isolate platform identifiers for anonymous users."

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.

Use the following queries to output platform identifiers for anonymous (ie., email-less) UUIDs. Use these IDs in retargeting campaigns and to audit reports, enhance CRM data, and otherwise capture information that goes missing as a result of blocked scripts.

To use these queries, you'll first want to add some code to your site. We outline that process in this post. You'll also want to connect BigQuery to your Confection account. See this quick-start guide for more information.

For more information about leveraging this information in meaningful ways, see these posts:

• Consolidate Identities and Retarget Anonymous Visitors
• Use Confection Event Values to Create Custom JSON Objects and Arrays
• Write Confection Event Data to the Facebook/Meta Conversions API (CAPI) and Google Ads API

Output will differ by platform. One may output 10+ identifiers and columns. Another may output just one. However, all will follow this basic model:

patformIDname	patformParameterName
id1234	parameterABC

"I want to isolate a list of anonymous Google IDs."

"I want to isolate a list of anonymous Facebook IDs."

"I want to isolate a list of anonymous LinkedIn IDs."

"I want to isolate a list of anonymous Microsoft IDs."

"I want to isolate a list of anonymous HubSpot IDs."

"I want to isolate a list of anonymous Snap IDs."

"I want to isolate a list of anonymous Twitter IDs."

"I want to isolate a list of anonymous Yahoo IDs."

"I want to isolate a list of anonymous Reddit IDs."

"I want to isolate a list of anonymous Adobe Marketing Cloud IDs."

"I want to isolate a list of anonymous Pinterest IDs."

"I want to isolate a list of anonymous Shopify IDs."

"I want to isolate a list of anonymous Squarespace IDs."

"I want to isolate a list of anonymous Klaviyo IDs."

"I want to isolate a list of anonymous AdRoll/NextRoll IDs."

"I want to isolate a list of anonymous Cloudflare IDs."

"I want to isolate a list of anonymous TikTok IDs."

Other Recipes and Use Cases

Search the Cookbook

See Confection in Action

Get started risk free.

Discussion

Questions or comments about "I want to isolate platform identifiers for anonymous users."? Leave them below.

Get Started. Risk Free.

IB QUIMBY MELTON