BigQuery Data Transfer Service Transfer Setup (DCM)

0
votes

Trying to figure out how to use the transfer service for DCM data and have been running into issues. https://imgur.com/a/X75V4 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.

1
google-bigquerydouble-click-advertising
Please copy and paste your error, not use image for this. - Wilson Vargas
It looks like you have scheduled regular transfer and it happens that you do not have data currently. Instead, for back filling data you should use Schedule Backfill - Mikhail Berlyant
I've used the schedule back fill as well in order to pull dates in August and July. Still coming up with the same error of "Import failed - no data was available for import. Please verify that data existence was expected." - Goon28

1 Answers

1
votes

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