I have a DV360 (Display and Video 360) account for my business and would like to import from the API directly into a Google Sheets document all the information in the account, separating by the campaign, insertion order, line item. Then I would need this to update every morning at 5 AM with all the metrics it is pulling UP TO the day before.
Then I want to create a pacing document in Google Sheets to carefully show the campaign's information.