GAM API - Programmatic Buyer Match Table: PartnerClientId Missing

[Anthony Caccioppoli]

Hi Support,

Hope all is well! We are looking at the Progammtic_Buyer match table (located in the doc here for reference) and we are missing the PartnerClientID field in the match table. Are you able to enable that for us? Screenshots below for reference:

GCS Match Table Details:

GAM Article Details:

Best,

Anthony

[Ad Manager API Forum Advisor]

Hi Anthony,

 

Thanks for contacting the Ad Manager API support team, this is Yasmin.

 

Can you please confirm if one of your colleagues have reached out to us with the same concern as mentioned in your post?

 

That being said, I'd advise you reach out to the BigQuery connector support team for further assistance on this, via this link. On that note, you can use the Ad Manager API to query the table with the column included. You can check out this link for the available client libraries the Ad Manager API currently supports and choose the client library of your liking. You can then navigate to its PublisherQueryLanguageService folder and check its corresponding distribution of the GetAllProgrammaticBuyers (reference in the Java client library).

 

Should you have any further questions, just let me know.

 

Best regards,

 

Yasmin Gabrielle Ad Manager API Team

ref:_00D1U1174p._5004Q2ar8T0:ref

[Anthony Caccioppoli]

Hi Yasmin,

Confirming that nobody outside of myself has asked for this field (to my knowledge). I work very closely with Leigh (Head of Ad Operations here at Insider who manages GAM) and chatted with her prior to this communication.

As for the links you provided, we will test this out. But please keep this ticket/communication open in case we have questions or issues. If this does work, we will confirm via this email that it works.

Best,

Anthony

--
You received this message because you are subscribed to the Google Groups "Google Ad Manager API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-p...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-doubleclick-for-publishers-api/HfTeo000000000000000000000000000000000000000000000RBPJUB00ia5TkcImRqanNZm3PYatMA%40sfdc.net.

--

Anthony Caccioppoli

Head of AdTech & Solutions

Business - News - Life - Markets

C: 201.306.8313

One Liberty Plaza, 8th FL, New York, NY 10006

[Anthony Caccioppoli]

Hi Yasmine,

It looks like the link for GCP support isn't the right one for us. We are actually receiving data directly to our GCP account by Google (i.e. we aren't making an API call to retrieve that data). Can you please update the table to include the PartnerClientID field? All details below:

GCP Data Set ID: bi-gam.gam_transfer

GCP Project ID: bi-gam

GCP Project Number: 503130546555

GCP Project Name: bi-gam

GCP Table ID: bi-gam.gam_transfer.p_MatchTableProgrammaticBuyer_4442842

Best,

Anthony

[Ad Manager API Forum Advisor]

Hi Anthony,

 

The link I had sent out is the link which you may go to for the BQ Connector support team. I would highly recommend you reach out to the Google Cloud Platform support team for further assistance as your concern is already outside our Ad Manager API team's scope of support. You may reach out to them via this link.

 

Regards,

[Anthony Caccioppoli]

Hi Yasmine,

Understand that the link you sent is for BQ Connector Support, but it is asking us to pay for that level of support (i.e. there's no contact for us there, which is problematic). So the problem here is that the missing field in the Programmatic_Buyer table does not stem from Insider's end, but on Google's end since we are not the ones initiating any API calls, etc.; Google is actually doing a straight data transfer to BQ. If you can facilitate a direct email conversation with the BQ Connector Support team on our behalf (or add that rep to this email chain) that would be ideal and we can chat with all parties here together.

@Sarah Rothstein - Can you help facilitate this for us? The bottom line is we need that field and are not in control of the way we receive the data from Google via BQ today and need a Google support rep to just enable it for us.

Let me know if this makes sense

Best,

Anthony

[Ad Manager API Forum Advisor]

Hi Anthony,

 

Thanks for providing your insights on this. Allow me to raise this to the team in order to be further investigated. Rest assured that our team will get back and update this thread soon.

[Sepideh Jahangiri]

Hi Anthony, 

Nice to e-meet you. I'm a Data specialist working as a Customer Engineer for Business Insider. As you have found out, you do not have the level of Cloud support to raise a case with the Technical Support team. While the Google Ad Manager team is supporting you in parallel, I hope I can help you from the Google Cloud side, but I don't have required visibility into your project. Therefore, I shall ask you to provide me with two screenshots. As far as I know, the Google Ad Manager transfer files are provided to you in a GCS Bucket. To get the data from the GCS to BigQuery, you must have set up a BigQuery Data Transfer service job. Would you send me two screenshots of the file schema in the gcs bucket(you may need to download a file as a sample) and the BigQuery DTS job?

Kindest,

Sepi

--

You received this message because you are subscribed to the Google Groups "Google Ad Manager API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-doubleclick-for-p...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-doubleclick-for-publishers-api/zNWsp000000000000000000000000000000000000000000000RBYRXW00jnAoLv0PRK24Ev3JTGnh-w%40sfdc.net.

--

Sepideh Jahangiri Google Cloud Platform Customer Engineer Data Analytics Specialist sjaha...@google.com +491735402896 Schedule a meeting with me here

[Anthony Caccioppoli]

Hi Sepi,

Thanks for the quick reply! I've gone ahead and gathered everything you require. See details below:

Programmatic Buyer Table Schema in Insider, Inc.'s GCP:

Programmatic Buyer Table Schema in Google Support Article:

Programmatic Buyer Table's CSV Sample Report from Insider, Inc.'s GCP:

*Attached to this email

GCP DTS Screenshot:

Let us know if there's anything else you need from us.

Best,

Anthony

[Sepideh Jahangiri]

Hi Anthony,

Thank you for providing the screenshots. As you have also mentioned, the data that is transferred to you by Google does not have the required field. It's an issue with the GAM API. We are tracking this internally with the GAM API team. +Yasmin Gabrielle Padua has raised this with their team and they will get back to us with feedback. 

Kindest regards,

Sepi

[Anthony Caccioppoli]

Hi Sepi,

Thank you so much for this! We will wait on your updates.

Best,

Anthony

[Anthony Caccioppoli]

Hi Sepideh,

Hope all is well! Wanted to check in and see if there was any update on this? Let me know when you can.

Best,

Anthony

[Ad Manager API Forum Advisor]

Hi everyone,

I'll try to provide some context. The short answer here is that Google's Big Query Data Connector team will need to add additional support for this field. It's not currently supported in their table. Their reference documentation links to the Ad Manager SOAP API, which does have support. I'll raise a feature request with their team but I don't have any information about when this might be available.

If you need this data today, you can retrieve it from the Ad Manager SOAP API and import it into BigQuery yourself. The Ad Manager SOAP API has no additional cost.

Thanks,

Chris Seeley Ad Manager API Team

ref:_00D1U1174p._5004Q2ar8T0:ref

[Anthony Caccioppoli]

Hi Chris,

Thanks. Keep us posted on the feature request and progress. We found a way to retrieve the data today, but it's not automated.

Best,

Anthony