google-bigquerydouble-click-advertising

BigQuery Data Transfer Service Transfer Setup (DCM)


Trying to figure out how to use the transfer service for DCM data and have been running into issues. https://i.sstatic.net/utKiB.jpg shows the error message I get.

I've scheduled a back fill with dates that are in my Google Bucket, yet still running into the same problem. Has anyone else had the same issue? Any help would be greatly appreciated!

This is the google documentation that I've been using to figure out what might be the issue but still coming up with nothing.


Solution

  • Well the problem is that data in your bucket contains info for the floodlight, and not for the account. gs://dcdt_-dcm_account3065/dcm_floodlight5199053_match_table_ad_placement_assignments_20170813_20170814_071344_596499640.csv.gz

    So, in DoubleClickID you should specify 5199053