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.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
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:
- Generate some sample logs using the schemas found here. This allowed us to get build the initial codebase for our ETL pipelines.
- 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.