Pipelinica

How to create scheduled report in Google Campaign Manager

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

  1. Log in your Google Campaign Manager account: https://campaignmanager.google.com/
  2. Go to Campaign Manager report builder: https://campaignmanager.google.com/reporting
    How to create scheduled report in Google Campaign Manager step 1
  3. Next – go to “Offline reporting” section and click “New offline report” button:
    The New offline report button in the Offline reporting section
  4. 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.
    Report name and dynamic date range settings
  5. Now you can select any dimensions and metrics you want to appear in your report. You can also choose any templates, apply filters, etc.
  6. 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
  7. Now click “Save and Run” button.

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