寻找BigQuery分析的示例doubleclick广告投放日志 [英] Looking for a sample doubleclick ad serve logs for BigQuery analysis

问题描述

我正在构建一个BigQuery应用程序，并正在寻找来自双击发行商的示例数据集。具体而言，广告服务会以包含点击次数，展示次数和ActiveView在内的示例期间以CSV格式记录。有没有人遇到这样的线路样本？我查看了DCP文档，但没有发现任何可用于验证的东西，使用我的客户的示例查询。 来自DFP广告管理系统小组会纠正我，但AFAIK没有公开示例。我们还尝试在构建DFP广告管理系统 - > BigQuery摄入引擎时搜索类似内容，但当时找不到任何内容。

我们为初始POC /测试：

1. 使用找到的模式生成一些示例日志这里。这允许我们为我们的ETL管道构建最初的代码库。


2. 一旦我们根据我们生成的示例日志生成了一个粗略的应用程序，然后我们要求我们的DFP代表打开实际数据传输提要。我们的代码需要一些小的工作，但大部分工作。

BTW（无耻插件），我写了一篇关于如何我们在此处提取我们的DFP日志和此处。

希望这有助于。

I'm building a BigQuery application and am looking for a sample data set from Double Click for Publishers. Specifically, ad serve logs in CSV for a sample period including Clicks, Impressions, and ActiveViews. Has anyone come across a sample along these lines? I've looked through the DCP docs but haven't found anything useable for validation using my customer's sample queries.

解决方案

Maybe someone from the DFP team will correct me, but AFAIK there are no public samples available. We also tried searching for the something similar when we were building our DFP -> BigQuery ingest engine, but we could not find anything at that time.

What we did for initial POC/test:

1. Generate some sample logs using the schemas found here. This allowed us to get build the initial codebase for our ETL pipelines.
2. Once we had a rough application based off the sample logs we generated, we then asked our DFP rep to switch on the actual data transfer feeds. Our code needed some minor work, but for the most part it worked.

BTW (shameless plug), I wrote a blog about how we ingest our DFP logs here and here.

Hope this helps.

这篇关于寻找BigQuery分析的示例doubleclick广告投放日志的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！