IB QUIMBY MELTON <GO>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:
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 |
By default, this Confection feature captures all available cookie and parameter data as well as local and session storage data. This gives our customers a diverse range of data from a large number of platforms and applications. We store this data in four custom events:
URLParametersAllCookiesAllLocalStorageAllSessionStorageAllHere are three sample queries you can use to return data for common ad platforms:
"I want to isolate a list of anonymous Facebook IDs."
"I want to isolate a list of anonymous Google IDs."
"I want to isolate a list of anonymous LinkedIn IDs."
To explore all the data available to you, use this query to return data from your BigQuery dataset:
You can also use your Confection account API to return data from the current 24-hour period. Just visit dashboard.confection.io/live-api and enter the following endpoints:
leads/event/URLParametersAllleads/event/CookiesAllleads/event/LocalStorageAllleads/event/SessionStorageAllTo return data for individual values, just enter the value name as the endpoint. For example, if I saw this in the CookiesAll value array:
"value": {"_ga":"GA1.1.240647536.1721295425","_fbp":"fb.1.1721295431700.4822751796732438"}
I'd use leads/event/_ga or leads/event/_fbp as the enpoints to return data about these specific cookies.
Get started risk free.
Questions or comments about "I want to isolate platform identifiers for anonymous users."? Leave them below.
IB QUIMBY MELTON