Retrieving split of conversions and conversion rate for Campaigns with experiments

[David Felton]

Hi there I'm retrieving my conversion and conversion rate data from the new Google Ads API.

My AWQL is along the lines of the following:

SELECT
  campaign.name,
  metrics.conversions,
  metrics.conversions_from_interactions_rate
FROM
  campaign
WHERE
  segments.date >= '2019-02-01'
AND segments.date <= '2019-02-31'
AND campaign.status IN ('ENABLED', 'PAUSED', 'REMOVED')
LIMIT 1000

This is fine apart from when the campaign contains an experiment. In the Google Ads UI these are showing up with two campaign names on the same line. In the results from the Adwords API I am only getting one row back for the campaign, and I can't seem to breat a breakdown of the conversion data.

I'd like to be able to get the conversion data for the original campaign and the experiement.

Many thanks.

[David Felton]

Is it still not possible to retrieve experiments / trials via the new Google Ads API?

[Google Ads API Forum Advisor Prod]

Hi David,

You should already be able to retrieve information of your campaign trials/experiments using the campaign report of the Google Ads API, and you can use the campaign.experiment_type field to identify them (ex. BASE, DRAFT, EXPERIMENT, etc.).

I hope this helps.

Thanks and regards,
Peter
Google Ads API Team

ref:_00D1U1174p._5001UAqJ2r:ref

[David Felton]

Thanks for the response. I have found that for a specific date period that has 3 experiments / trials appearing in Google Ads - all linked to the same original campaign, I only get one of them back from the API. It's the last one in the list when viewing via Google Ads, I don't know if that is relevant. I can send you the details privately if you would like to verify?

[Google Ads API Forum Advisor Prod]

Hi David,

Thank you, that would be great! You can send to me via the Reply privately to author option your clientCustomerId and the complete GAQL you used so I can have a closer look.

Best regards,

[David Felton]

I sent the info over via private reply on 23rd May and I haven't heard anything back. Can you confirm if the info was received? Shall I resend?

Many thanks.

[Google Ads API Forum Advisor Prod]

Hi David,

Were you able to receive my private response on June 10, 2019? If you are not able to locate it, I asked if you could send your customer_id and the complete GAQL so I can further investigate.

Also, as stated in this old guide, which should still apply in the new API, draft campaigns would not be returned in the reports. Could you confirm if the missing campaigns are indeed draft campaigns or are experiment ones?

Thanks and regards,

[David Felton]

The only thing I have received is reply notifications to this thread. Here's the message I sent privately:

Thanks for your kind assistance.

I'm using a manager account with ID 444-573-6786. This is pulling in three accounts:

ACS All Cargo: 124-921-8559
ACS All Other Pax (Passenger): 160-445-8660
ACS Madrid Pax (Passenger): 189-370-1978


I've attached a screenshot from the Google Ads managers account showing the period I'm interested in (2019-02-01 -> 2019-02-28), filtering by campaign name 'SAOPAULO'.

You should see that there are three experiments/trials: SAOPAULO-PT-PAX-MAXCONV, SAOPAULO-PT-PAX-BMM, NEW-SAOPAULO-pax-tcpa

In my Google Ads API code I can't use the manager account ID so I need to use each of the Customer IDs separately.
This is the query I'm running:

SELECT
  campaign.name,
campaign.experiment_type,

  metrics.conversions,
  metrics.conversions_from_interactions_rate
FROM
  campaign
WHERE
  segments.date >= '2019-02-01'

AND segments.date <= '2019-02-28'

AND campaign.status IN ('ENABLED', 'PAUSED', 'REMOVED')
LIMIT 1000

I've attached the results for each customer ID. If you take a look through them you should see that the only experiment / trial that comes back (type=4) that matches 'SAOPAULO' is NEW-SAOPAULO-pax-tcpa, so SAOPAULO-PT-PAX-MAXCONV and SAOPAULO-PT-PAX-BMM are missing.

(I haven't attached the screenshot or the query results on the public forum. If you have an email address I can send them to I can send them there. I've also just tried 'reply privately to author' again and attached them there.)

[Google Ads API Forum Advisor Prod]

Hi David,

Thank you so much, I was now able to receive the files that you sent. Upon checking your account 160-XXX-XXXX via the All Campaigns > Drafts & Experiments > Campaign Drafts view, I could see that the (SAOPAULO-PT-PAX-MAXCONV (no experiement/trial), SAOPAULO-PT-PAX-BMM (with experiment/trial) ) campaigns you are looking for are indeed both Draft campaigns. In the AdWords API guide that I sent, draft campaigns would not be returned in the reports, and this also applies in the Google Ads API reporting.

I also took a closer look under the Campaign Experiments view and I could see that the SAOPAULO-PT-PAX-BMM was indeed created as an experiment campaign. However, its start and end dates are Mar 19, 2019 and Apr 5, 2019 respectively. That said, your current segments.date (segments.date >= '2019-02-01'AND segments.date <= '2019-02-28') filter would not capture the said experiment/trial campaign in the report.

Let me know if this helps clear things on your end.

Best regards,