Upload your shop sales data

• Ideal if you're new to shop sales: If you haven’t uploaded shop sales data before, use this method first. As you gain experience with shop sales measurement, you may consider switching to the Google Ads API or using a shop sales data partner for uploading your shop sales data.
• Ease of use: Uploading shop sales data through Google Ads can help you verify if your shop sales data is formatted properly. After you upload your shop sales data, Google Ads will let you know if your shop sales data can be used for measurement or provide you with tips for fixing errors in your shop sales data.

• Ideal for uploading large numbers of transactions: If you frequently update your shop sales data or you've a large number of offline transactions that you want to upload, use the Google Ads API.
• Save time with uploads: While integrating your data management system with the Google Ads API requires some technical expertise, you’ll be able to reduce the time needed to make changes to your shop sales transaction data.
• Technical support: For technical questions concerning the Google Ads API (for example, questions directly related to API or SDK usage, errors received from the API or SDK and more), follow the troubleshooting steps outlined in the API technical support page.

• Supported uploads: Shop sales partners are directly integrated with our Google Ads API to automate the data upload process and ensure consistent and reliable data uploads.
• Technical support: All shop sales partners can troubleshoot technical issues, allowing you to focus on your core business.
• Data hygiene and formatting: Shop sales partners can help format your data to ensure correct and frictionless uploads. For example, shop sales partners can review columns in your shop sales data file to help troubleshoot common errors.
• Enhanced match rates: Some partners have robust customer information graphs which may increase match rates.

• Customer email addresses
• Customer phone numbers
• Customer first and last names

• City
• State
• Country
• Zip code/postcode
• Attribute data (for example, currency and conversion names)

File formats

• Excel
• CSV
• Google Sheets

Size limits

• One-time upload directly into your Google Ads account:
  • 150MB: For CSV files uploaded manually in Google Ads only (estimated 300,000 transaction rows).
  • 50MB: For all other formats, including CSVs uploaded using a schedule (estimated 100,000 transaction rows).
• Upload using Google Ads API: 1,000,000 transaction rows.
  Note: If you’re using a shop sales data partner to upload your shop sales data, check with your shop sales data partner on their file size limits.

1. In your Google Ads account, click the Goals icon .
2. Click the Conversions drop-down in the section menu.
3. Click Uploads from the page menu.
4. Click the plus button .
5. To download the template that fits with the type of conversions that you’d like to import, click View templates. You can choose Excel, CSV or Google Sheets to upload conversions from clicks, calls or shop sales.
6. Click Done.
7. Next to 'Source', select the source of the file that you want to upload: Upload a file, Google Sheets, HTTPS or SFTP.
   • If you’re uploading a file or using Google Sheets, click Choose file to select the file that you want to upload.
   • If you’re using HTTPs or SFTP, enter the URL for the file, and the username and password to access the file.
8. Click the tick box next to 'This upload contains shop sales data collected and shared in compliance with applicable Google policies', then confirm if you’re uploading Unhashed private customer data or Hashed data.
9. Click the Upload and preview or the Upload and apply button.
   • If you click Upload and preview, you’ll see a preview of the estimated changes in the 'History' tab.
   • To import the conversions into your account, click the Action drop-down menu and select Apply.
   • If you click Upload and apply, the file will start processing after all the rows are uploaded.
10. To see more details about the upload status (including any errors with the upload), click the links in the 'Results' column.

1. In your Google Ads account, click the Goals icon .
2. Click the Conversions drop-down in the section menu.
3. Click Uploads from the page menu.
4. Click Schedules.
5. Click the plus button .
6. Next to 'Source', select the source of the file that you want to upload: Google Sheets, HTTPS or SFTP.
   • If you’re using HTTPs or SFTP, enter the URL for the file, and the username and password to access the file.
7. Set a schedule by selecting the 'Frequency' and 'Time' of day that you'd like your uploads to occur. You can schedule weekly or daily uploads for any time of day.
8. To upload your file now, click Upload and preview.
9. Click Save. You'll see your saved schedule in the table.
10. (Optional) To edit, pause or remove a schedule, go to the 'Actions' column and click Options.
11. After making any edits, click Save. If you remove a schedule, confirm that you'd like to remove it by clicking Remove.

To make an upload via API, you need to integrate your CRM system with the Google Ads API. To learn more, contact your Google Account representative.

If you're working with a shop sales partner, the data uploads should be made directly by the partner in your Google Ads account. Contact your partner or your Google Account representative to know more. Learn more about shop sales partners.

The uploaded shop sales data failed processing. Here are some reasons why your data may fail to upload:

• Your data hasn’t been hashed or was hashed incorrectly.
• Your data was incorrectly formatted or contains missing values or columns.
• You have a very low number of transactions.
• There aren’t enough transactions matched to customers.
• The average value of transactions is significantly higher or lower compared with the account’s 90-day average.
• The currency code within the upload doesn't match the historic values within the account.

To check for the specific reason, check the 'Results' column of the Google Ads statistics table.

Your shop sales data upload is finished, but it contains errors. Google Ads can’t process the data until the errors are fixed.

Your shop sales data upload is finished and contains no errors. Since there were no updates in the file, Google Ads didn’t update any data.

This error indicates that there's a potential issue with the parameter or header formatting for your shop sales upload. Review the following steps if you encounter this error:

1. Make sure that you’re using the correct template to upload shop sales data and that it contains all of the required rows and columns. To download the shop sales upload templates, refer to Format your shop sales data.
   • Ensure that the parameters and headers are in English as per the default template. The rest of the submitted data may be in any language, but the parameters and headers must remain in English.
2. If you’re creating and uploading in a CSV format, open and review the parameter and header rows in a basic text editor to ensure no unexpected characters were added. For example, ensure that:
   • There are no quotation marks (") surrounding the Parameters row.
   • Different parameter values are separated by a single semicolon (;).
   • Header columns are comma-separated (,) with a single comma.
3. Make sure that the following columns are present in the file: conversion name, conversion time, conversion value and conversion currency.
   • You must also include at least one user identifier, such as email, phone number or address (first name, last name, city, state, postcode and country).
   • If you’re uploading a CSV file and choose to hash the data yourself, review Format your shop sales data.

This error indicates that there’s a potential issue with the parameter or header formatting for your shop sales upload. Review the following if you encounter this error:

1. Make sure that you’re using the correct template to upload shop sales data and that it contains all of the required rows and columns. To download the shop sales upload templates, refer to Format your shop sales data.
   • Ensure that the parameters and headers are in English as per the default template. The rest of the submitted data may be in any language, but the parameters and headers must remain in English.
2. If you’re creating and uploading in a CSV format, open and review the parameter and header rows in a basic text editor to ensure no unexpected characters were added. For example, ensure that:
   • There are no quotation marks (") surrounding the Parameters row.
   • Different parameter values are separated by a single semicolon (;).
   • Header columns are comma-separated (,) with a single comma.
3. Make sure that the following columns are present in the file: conversion name, conversion time, conversion value and conversion currency.
   • You must also include at least one user identifier such as email, phone number or address (first name, last name, city, state, postcode and country).
   • If you’re uploading a CSV file and choose to hash the data yourself, review Format your shop sales data.

This error indicates that the upload couldn’t be completed due to taking too much time or a network interruption. Review the following steps to try and improve this:

1. Review your file and make sure that it meets the upload file size requirements listed in Format your shop sales data.
   • If your file is near or over the limit, try splitting the file into separate smaller files.
   • If you’re uploading multiple files, try uploading one file at a time.
2. If the file size is within the limits, try uploading the file at a later time or from a different network connection.

Review your upload settings and verify that your SFTP URL, name and/or password are correct.

• Tip: Try downloading the file with a separate SFTP program to ensure that the file location and credentials are correct.

This error indicates that the transaction upload has a significantly higher or lower average transaction value compared with the account’s 90-day historical average. Such uploads are initially blocked in order to prevent potentially incorrect data from being ingested which could result in reporting errors. If you receive this error when uploading, please review the following steps:

1. Review the intended transaction upload file and confirm that the provided transaction values are correct and the upload average is aligned with your expectations.
   1. If there are any errors in the file values, please correct them and try the upload again
   2. You can review the average order value for the last 90 days within your Google Ads account
2. If the file contents and transaction values are correct and intended, please reach out to your Google Ads account management team or to Google Ads support to request an exemption to allow the file to be processed.
   1. Note that the validation exemption for these errors can only be reprocessed if the upload attempt happened within the last 25 days.

This error indicates that the currency code within the upload doesn't match the historic values within the account. Such uploads are initially blocked in order to prevent potentially incorrect data from being ingested which could result in reporting errors. If you receive this error when uploading, please review the following steps:

1. Review the intended transaction upload file and confirm that the provided currency code values are correct and aligned with your expectations.
   1. If there are any errors in the currency code values, please correct them and try the upload again
2. If the file contents and currency code values are correct and intended, please reach out to your Google Ads account management team or to Google Ads support to request an exemption to allow the file to be processed.
   1. Note that the validation exemption for this can only be reprocessed if the upload attempt happened within the last 25 days.