Can we query all account's promotion details using Google Ads API?

[Sudeep Datta]

Hi Team,

 

I would like to know if we can query all accounts with all promotion status which is present under Billing using Google Ads API? I want to query the account name, Id, promotion status, date redeemed, and If yes, then please guide me with link from the API docs.

 

Regards,

Sudeep

[Sudeep Datta]

I did query google client of type SearchGoogleAdsStreamRequest with a customer id and a query value. My query text is - 

query_text = """

    SELECT

        asset.promotion_asset.ad_schedule_targets,

        asset.promotion_asset.discount_modifier,

        asset.promotion_asset.end_date,

        asset.promotion_asset.language_code,

        asset.promotion_asset.money_amount_off.amount_micros,

        asset.promotion_asset.money_amount_off.currency_code,

        asset.promotion_asset.occasion,

        asset.promotion_asset.orders_over_amount.amount_micros,

        asset.promotion_asset.orders_over_amount.currency_code,

        asset.promotion_asset.percent_off,

        asset.promotion_asset.promotion_code,

        asset.promotion_asset.promotion_target,

        asset.promotion_asset.redemption_end_date,

        asset.promotion_asset.redemption_start_date,

        asset.promotion_asset.start_date

        FROM asset

    """

The search stream returns me response object and when I check it its result, I get results like this - 

asset {
  resource_name: "customers/1734******/assets/39213******"
}

So, I think it returns me asset ids of that customer. How to retreive the promotion details from the asset id?

Regards,

Sudeep

[Google Ads API Forum Advisor]

Hi Sundeep,
 

Thanks for reaching out to the Google Ads API team. I hope you are doing well today.

Upon checking your concern, regarding this, "I would like to know if we can query all accounts with all promotion status which is present under Billing using Google Ads API? I want to query the account name, Id, promotion status, date redeemed, and If yes, then please guide me with link from the API docs." It appears that you see the document you are looking for promotion status.
 

However, regarding this question, "How to retreive the promotion details from the asset id?" I'm afraid that retrieving the promotion details from asset id is not yet supported in our document based on this Asset Operation.
 

Let us know if you have further questions.

Regards,

Darwin Google Ads API Team

ref:_00D1U1174p._5004Q2dKHSD:ref

[Sudeep Datta]

Hi Google Ads Team,

Attached is the screenshot from the Google Ads Manager's Billing - Promotions. Can you please confirm that currently there is no way to extract this tabular information (Promotions, Account, Status, Amount granted, Date redeemed etc) using Ads API? And if not supported now then is there any information on when it will be available in future releases of Ads API?

Regards,

Sudeep

[Google Ads API Forum Advisor]

Hi Sudeep,

Thank you for sending over the screenshot of the UI view.

The Promotions that are included in the said screenshot does not appear to be similar to the promotion asset that you are querying using the asset resource. That being said, these appear to be more related to promotional codes that are given out to accounts.

We currently do not have information as to when this would be supported in the API. However, our team should be able to create a feature request, subject for review, for its support. So our team can raise this feature request, could you also share your complete use case that we can include when raising the said request?

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2dKHSD:ref

[Sudeep Datta]

Thanks Peter for your reply. Yes, our use case is to query all statuses promotional codes applied to the accounts and its related details (same previous attached screenshot table data). For example, the active status promotional code linked to an account (account number and manager account number), code's date redeemed, and expiration date. Currently, we cannot export this data from the UI so that we can work with it along with all account's performance data. 

I was searching with promotion in the Ads API doc filter and found it in under promotion asset. But yes, that's what I am not looking for. Our use case to query and get the promotional codes data preferable through API if not at least we can can export it from UI for now. Please let me know if you need any further information.

Regards,

Sudeep

[Google Ads API Forum Advisor]

Hi Sudeep,

Thank you for sharing more details.

Allow me now to create a feature request for the said Promotions details. For now, you may keep an eye on our blog for updates and announcements.

[Sudeep Datta]

Noted with thanks.

Regards,

Sudeep