Call Details - How to obtain the Ad ID associated to each call?

[Steve Begin]

When I look at the Call Details report in Google Ads (e.g., ads. google. com/aw/reporteditor/  ) one of the columns I see is "Ad ID". I can get every other column I need  except Ad ID (and the name of the Ad).


May you please help me know how what the GAQL search query is which is needed for using the Google Ads API to get a response inclusive of the Ad ID for each phone call shown in the Call Details report?


While I can get all Ad info. separately (from the ad_group_ad resource), and I can get the other Call Details report columns from a GAQL search query (of the call_view resource), I am missing a column to join them and I do not see another column I can add when I look in the Google Ads Query Builder tool.

Thank you for your help.

[Steve Begin]

h̶o̶w̶

[Steve Begin]

Just if I may try to please proactively clarify:

I definitely do not expect any single GAQL query with the join (because I understand my need to do joins in my own database with result data I have saved, and not do the join in any single API query; I do not believe it is supported in the Google Ads API query).

Toward our goal of knowing the Ad ID for each call shown in the Call Details GUI, I am looking for:

1. a call_view resource column name (in the case missed one in call_view's available fields, or a better resource to use if that is not it)
2. any other GAQL search query you might kindly provide where that query ultimately returns the specific single Ad ID based on that same per call_view record
3. (the query in #2 would have a column name that yields the same value as what I get from the column name in #1, or these two queries would come with info. on how their respective fields at least have the ability to be parsed in order ascertain how to match records between the two query results)

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

Please find the below responses for your queries:

1) A call_view resource column name (in the case missed one in call_view's available fields, or a better resource to use if that is not it).

• I would like to inform you that there's no direct way to link an Ad ID to a call in a single GAQL query.

2) Any other GAQL search query you might kindly provide where that query ultimately returns the specific single Ad ID based on that same per call_view record.

• Please be informed that the call_view resource doesn't directly provide an Ad ID. If gclid is present in the call_view data, use it to link to the click resource.

3) (The query in #2 would have a column name that yields the same value as what I get from the column name in #1, or these two queries would come with info. on how their respective fields at least have the ability to be parsed in order ascertain how to match records between the two query results).

• If gclid is not available, you could try correlating calls based on call_start_time and phone_number with ad serving data.

I hope this helps! Kindly get back to us if you have any further queries.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vEygP:ref" (ADR-00263524)

Thanks,
 

Google Ads API Team

 

[Steve Begin]

Thank you, but unfortunately it appears gclid is not a valid column name in the call_view. Though I do not see that in the query builder tool, I tried to add it based on your suggestion, and the API responded with:

[

    {

        "error": {

            "code": 400,

            "message": "Request contains an invalid argument.",

            "status": "INVALID_ARGUMENT",

            "details": [

                {

                    "@type": "type.googleapis.com/google.ads.googleads.v15.errors.GoogleAdsFailure",

                    "errors": [

                        {

                            "errorCode": {

                                "queryError": "UNRECOGNIZED_FIELD"

                            },

                            "message": "Unrecognized field in the query: 'gclid'."

                        }

                    ],

                    "requestId": "qFHc9yPziMsp9uU-_ATgHA"

                }

            ]

        }

    }

]

Best,

Steve Begin

RJP Systems

[Steve Begin]

Please pardon my still learning.

I researched what gclid could refer to and found that it is a field I do sometimes get back in response to the query below:

SELECT
  click_view.gclid,
  click_view.page_number,
  click_view.ad_group_ad
FROM click_view
WHERE
  segments.date = '2023-08-16'

... So with that, I believe I can determine how to gain the rest of this information.

Thank you again!

[Google Ads API Forum Advisor]

Hi,

In order to assist you further, please share with us the uncropped UI screenshot of the report by highlighting the specific fields that you are trying to duplicate via the Google Ads API. 

You can send the details via Reply privately to the author option, or direct private reply to this email.

[Steve Begin]

A moment ago, I used [Reply to author] and uploaded the requested screenshot. May you please confirm whether you received it? Thank you.

[Google Ads API Forum Advisor]

Hi,

Yes, we have received the screenshot provided by you. Could you please highlight the fields in the screenshot that you want to get via API. This would help us assist you accordingly.

[Steve Begin]

Hi,

Thank you.

I have re-uploaded the last image having now highlighted the Ad related fields which I hope to get from having a good way to get the correlating Ad ID.

While I am trying to get all fields shown in what I have just uploaded "call details - uncropped per google ads api team request3.png", I believe I mainly still need help primarily with Ad ID.

The highlighted Ad related fields are labeled in the Google Ads GUI as "Ad", "Ad group", "Dynamic ad target" and "Ad ID".

[Google Ads API Forum Advisor]

Hi,

Kindly note that any of these fields ("Ad", "Ad group", "Dynamic ad target" and "Ad ID") are not available under the call_view resource. I will raise a request for this feature to become available under call_view resource to fetch through the Google Ads API. However, I cannot provide a scheduled timeline for its availability in the API. So, I would recommend that you follow our blog Post and release notes for future updates. 

[Steve Begin]

Thank you. Even if Ad ID was made available and I could get what is related through another call, that would meet the need. I appreciate you raising the request and so thank you again for your help.