For customers using our Antenna Product (both Hosted and Integrated) customers. A number of Buzz Object lookup tables are included for your ease of querying and joining.
Our raw log tables typically do not contain information about the associated Buzz Objects, instead only containing their referent object IDs. For example, our log files may contain Campaign ID but not Campaign Name. For customers using our S3 log integration this data must be fetched from the Buzz API. For Antenna customers we have handled this step for you. These tables are available for you to query automatically in your Antenna instance.
For example, you could fetch Creative names from logs with a query similar to the following:
SELECT creatives.creative_name, deal_id, SUM(win_cost_micros_usd) AS spend_micros, AVG(bid_floor_micros_usd) AS avg_bid_floor_micros, COUNT(*) AS impressions FROM shared_impression_details_view LEFT OUTER JOIN creatives ON shared_impression_details_view.creative_id = creatives.creative_id
Update Cadence and Mutability
Buzz Object Tables are updated approximately once an hour. Therefore they are snapshots of your options approximately an hour ago. Some Buzz Objects are mutable so consider this when running queries on historical data where the objects may have been changed since the logs were emitted.
As of writing, the current Buzz Object Tables are available for querying in Antenna:
Line Item Flights
Creative Line Items
Updated almost 3 years ago