Questions Related to store sales data upload API and its Payload

[Paid Media]

Hi Team,

While working on integration with store sales direct data upload API (https://developers.google.com/google-ads/api/docs/conversions/upload-store-sales-transactions) . We had some questions which are listed below:

  

1. Is there any Sync API for uploading the Transactions to Conversion Actions created in Google Ads Manager(http://ads.google.com/)? And if yes then what are its limitations(like No of Customers in a single API call and total no of UserIdentifiers or Total Number of Transactions or any other limitations) 

2. Is there any way to validate the Data that we are uploading is correctly formatted or not.  

3.How many Conversion Actions can be created in the Google Ads Manager?

4. What is the minimum number of transactions which must be uploaded for them to be considered for matching operations. For Both Async and Sync API(if this exists).

 

Regards,

Paid Media Team

[Google Ads API Forum Advisor]

Hi,

Thank you for posting your concern. Please see my answer below for each question:

1. Is there any Sync API for uploading the Transactions to Conversion Actions created in Google Ads Manager(http://ads.google.com/)? And if yes then what are its limitations(like No of Customers in a single API call and total no of UserIdentifiers or Total Number of Transactions or any other limitations) 

-Please see the limitation that mentioned on this document:

• The operations collection for each AddOfflineUserDataJobOperationsRequest can contain at most 100,000 identifiers across all of the UserData objects in the operations.
• There are no limits on the number of operations you can add to a single job. However, for optimal processing, we recommend adding up to 10,000 operations in a single call to the OfflineUserDataJobService.AddOfflineUserDataJobOperations method and up to 1,000,000 operations to a single job.
• There must be at least 50 matched transactions in a job in order to avoid the job failing with OfflineUserDataJobFailureReason.INSUFFICIENT_MATCHED_TRANSACTIONS. Upload at least a few hundred transactions to increase the likelihood that your job reaches this matched transactions threshold.

2. Is there any way to validate the Data that we are uploading is correctly formatted or not.  

-Please see the formats that you need to follow on uploading Store Sales Conversions:

• The transaction_amount_micros must be greater than zero.
• The transaction_date_time can have an optional timezone specified, and the format is as yyyy-mm-dd hh:mm:ss+|-hh:mm, for example, 2019-01-01 12:32:45-08:00. The timezone can be for any valid value: it does not have to match the account's timezone. It should be the timezone where the transaction happened. When the timezone is not provided, the account's timezone will be used.
• Data such as emails, phone numbers, and names must be normalized and hashed using SHA-256.

3.How many Conversion Actions can be created in the Google Ads Manager?

-I would suggest to raise this question to the product team as they are more knowledgeable on entities limits of the Google Ads account such as the limit on the number of conversion action in an account. You can reach out to them via this link.

4. What is the minimum number of transactions which must be uploaded for them to be considered for matching operations. For Both Async and Sync API(if this exists).

-As discussed in #1, there must be at least 50 matched transactions in a job in order to avoid the job failing with OfflineUserDataJobFailureReason.INSUFFICIENT_MATCHED_TRANSACTIONS. Upload at least a few hundred transactions to increase the likelihood that your job reaches this matched transactions threshold.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2WvnsA:ref

[Paid Media]

Hi Team,

Based on your answer on my #1 Question, I am assuming that there is no Sync API for store sales direct data upload API.

Let me know if the assumption is incorrect. 

Regards,

PMM Team

[Google Ads API Forum Advisor]

Hi,

If what you are asking is if it is possible to request multiple transactions against the same resource at once, then I am afraid that this is not possible. If attempting to request multiple transactions against the same resource, then you will encounter the CONCURRENT_MODIFICATION error.

Let me know if you have further questions.