Looking for a sample doubleclick ad serve logs for

Question

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.

Answer 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:

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.