Pipelinica

How to create scheduled report in Google Display & Video

In this article you will find out how to create scheduled report in Google Display and Video 360, so you can use it as a source in Pipelinica data pipeline.

  1. Log in your Google Display & Video account: https://displayvideo.google.com/
  2. Now click on a chart icon like below:
    The chart icon in the Display & Video 360 navigation
  3. Select “Reports” option:
    The Reports option in the menu
  4. Go to “Offline Reporting” section and click “New Offline Report”:
    The New Offline Report button in the Offline Reporting section
  5. Give your report any name, and select dynamic date range. For example “Last 30 days” or “Last 60 days”. It means that data destination will be overwritten everyday by selected amount of days, but older data will stay and will not disappear. Also select English language formatting:
    Report name, dynamic date range and English language formatting settings
  6. Now you can select any dimensions and metrics you want to appear in your report. You can also choose any templates, apply filters, etc.
  7. Scroll down and select schedule as Active (thanks to that report’s data will be refreshed every day), decide when schedule can be expired and select format as “CSV“:
    Schedule set to Active, with the expiry date and the CSV format
  8. Now – click “Save and Run” button. After that you can add this report in your pipeline as a data source.

Congratulations, now you can use this Google Display and Video 360 scheduled report as a data source in Pipelinica data pipeline. If you have any questions – feel free to contact us HERE.