3

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.

Graham Polley
  • 12,512
  • 3
  • 32
  • 64
atlascedar3
  • 31
  • 3
  • 1
    This was a good question, not sure why it was put on hold. We developed a PHP simple app using Faker to generate the schema. It's not too much but I can share what we have. – Pentium10 Feb 13 '17 at 08:37
  • I agree with @Pentium10. There is nothing wrong with this question as it pertains to development using DFP BigQuery integration. It's a valid question - I've been there myself. Can a mod please review for reopening. – Graham Polley Feb 13 '17 at 11:04

1 Answers1

3

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.

Graham Polley
  • 12,512
  • 3
  • 32
  • 64
  • Do you have sample schema for the files you tested? And does BigQuery also takes care of updates in the data? – RockSolid Feb 21 '18 at 06:45