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. To connect BigQuery to your Confection account, see this quick-start guide.
Use the following query to output the commercial value of channels, campaigns, geos, &c. This query supports the following channels: browser, referrer, source, campaign, content, id, medium, and term as well as city, region, and country.
Sample output (by campaign) follows:
| Campaign Name | Revenue | Number of Purchases |
|---|---|---|
| bogo | $86.906.00 | 42 |
| fall_2024 | $4,900.00 | 8 |
Sample output (by country) follows:
| Country | Revenue | Number of Purchases |
|---|---|---|
| US | $86.906.00 | 42 |
| MX | $4,900.00 | 8 |
Get started risk free.
Questions or comments about "I want to see the commerical value of my channels, campaigns, geos, &c."? Leave them below.
IB QUIMBY MELTON