After you set up your Google Ads account for store sales conversions, you’ll need to prepare your store sales data and then upload the data to Google Ads.
This article explains how to set up and upload your store sales data data to Google Ads using various upload methods.
Step 1: Choose an upload method
You can upload your store sales data using Google Ads, the Google Ads API, or a store sales partner. You should use only one method for any upload, since the same file uploaded using multiple methods will be de-duplicated and considered only once by Google during the upload.
1. Upload store sales data in Google Ads
You can upload your store sales data directly in Google Ads. With this upload method, you’ll prepare and manually upload your store transaction file to your Google Ads account every time you make a change. You can also schedule uploads so that any changes made to your data can be automatically uploaded from Google Sheets or using a file transfer method (HTTPS / SFTP).
Benefits of uploading store sales data in Google Ads
- Ideal for advertisers new to store sales: If you haven’t uploaded store sales data before, use this method first. As you gain experience with store sales measurement, you may consider switching to the Google Ads API or using a store sales data partner for uploading your store sales data.
- Ease of use: Uploading store sales data through Google Ads can help you verify if your store sales data is formatted properly. After you upload your store sales data, Google Ads will let you know if your store sales data can be used for measurement or provide you with tips for fixing errors in your store sales data.
2. Upload store sales data using the Google Ads API
You can securely integrate your data management system with the Google Ads API to upload your files on a regular basis. To get help and learn more about API uploads, please contact your Google account representative.
Benefits of uploading store sales data using the Google Ads API
- Ideal for uploading large numbers of transactions: If you frequently update your store sales data or you have a large number of offline transactions 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 store sales transaction data.
- Technical support: Google offers end-to-end onboarding support to help advertisers successfully onboard to store sales using the Google Ads API. Our technical support team can guide your technical specialists or developers through the process.
3. Upload store sales data using a store sales partner
Store sales partners are companies that can help you import your offline transaction data directly into Google Ads. Learn more about store sales partners.
Benefits of uploading store sales data using a store sales partner
- Supported uploads: Store 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 store sales partners can troubleshoot technical issues, allowing you to focus on your core business.
- Data hygiene and formatting: Store sales partners can help format your data to ensure correct and frictionless uploads. For example, store sales partners can review columns in your store sales data file to help troubleshoot common errors.
- Enhanced match rates: Some partners have robust customer information graphs which may increase match rates.
Step 2: Determine your Loyalty Rate and Transaction Upload Rate
The Loyalty Rate and Transaction Upload Rate determine how your store sales are reported in Google Ads. Before you prepare your store sales data file, you’ll need to determine the Loyalty Rate and Transaction Upload Rate for your sales.
- Loyalty Rate: The percent of overall sales that you can associate with a customer and that are uploaded in your data file. The Loyalty Rate is the total number of transactions with customer information divided by all transactions, represented as a number between 0 and 1.
Example
Let’s say you have 100 transactions over the past 30 days. Of the 100 transactions, you associate 70 transactions to a customer email address or customer phone number. Because you're uploading 70 customer transactions, your loyalty rate would be 0.7. However, if you’re only uploading 40 of these transactions, then the loyalty rate would be 0.4. - Transaction Upload Rate: The percent of overall sales with customer information that are already uploaded to Google Ads. Since we recommend uploading all of your transactions to Google Ads, your Transaction Upload Rate should be 1.
Step 3: Format and hash your store sales data
Hashing is a procedure that takes your sales data and randomizes it in a secure, privacy-safe way. Google only accepts properly-formatted and hashed user data. You can hash your data by:
- Using the SHA-256 algorithm: To keep your data secure, you can hash your customer data yourself using the SHA-256 algorithm, which is the industry standard for one-way hashing.
- Using automated hashing in Google Ads: If you have your store transactions data in a plain text (.CSV) file format, you can choose to upload the file unhashed to Google Ads. Google Ads automatically hashes any data that needs to be hashed using the SHA-256 algorithm before accepting the file for any processing.
Store sales data that needs to be hashed
- Customer email addresses
- Customer phone numbers
- Customer first and last names
Store sales data that doesn’t need to be hashed
- City
- State
- Country
- Zip code / postal code
- Attribute data (for example, currency and conversion names)
Accepted file formats and size limits
File formats
- Excel
- CSV
- Google Sheets
Size limits
- If you’re doing a one-time upload directly into your Google Ads account: 50MB (or up to 100,000 rows of transactions)
- If you’re uploading using the Google Ads API: 1,000,000 rows of transactions
Note: If you’re using a store sales data partner to upload your store sales data, check with your store sales data partner on their file size limits.
Step 4: Upload your store sales data
After you prepare your store sales data, the next step is to upload the data to your Google Ads account. The steps to upload your store sales data may differ depending on the upload method you choose.
Upload store sales data in Google Ads
If you’re uploading store sales data in Google Ads, you can choose to make it a one-time upload (you upload every time you update your store sales data) or a scheduled upload (Google Ads checks for updates to your store sales data hosted at a specific location and uploads those changes).
One-time upload
- Sign in to your Google Ads account.
- In the upper right corner of your account, click the tools icon
.
- Under “Measurement”, click Conversions.
- If you're using a manager account, click Conversions in the page menu on the left.
- Click Uploads from the page menu.
- Click the plus button
.
- To download the template that fits with the type of conversions you’d like to import, click View templates. You can choose Excel, CSV, or Google Sheets to upload conversions from clicks, calls, or store sales.
- Click Done.
- Next to “Source”, select the source of the file 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 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.
- Click the checkbox next to “This upload contains store sales data collected and shared in compliance with applicable Google policies”, then confirm if you’re uploading Unhashed private customer data or Hashed data.
- 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 dropdown menu and select Apply.
- If you click Upload and apply, the file will start processing after all the rows are uploaded.
- To see more details about the upload status (including any errors with the upload), click the links in the “Results” column.
Schedule an upload
- Sign in to your Google Ads account.
- In the upper right corner of your account, click the tools icon
.
- Under “Measurement”, click Conversions.
- Click Uploads from the page menu.
- Click Schedules.
- Click the plus button
.
- Next to “Source”, select the source of the file you want to upload: Google Sheets, HTTPS, or SFTP.
- If you’re uploading a file or using Google Sheets, click Choose file to select the file 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.
- Click the checkbox next to “This upload contains store sales data collected and shared in compliance with applicable Google policies”, then confirm if you’re uploading Unhashed private customer data or Hashed data.
- Set a schedule by selecting the "Frequency" and "Time" of day you'd like your uploads to occur. You can schedule weekly or daily uploads for any time of day.
- To upload your file now, click Upload and preview.
- Click Save. You'll see your saved schedule in the table.
- (Optional) To edit, pause, or remove a schedule, go to the "Actions" column and click Options.
- After making any edits, click Save. If you remove a schedule, confirm that you'd like to remove it by clicking Remove.
Upload store sales data using the Google Ads API
Upload store sales data using a store sales partner
Best practices
Below are some important call outs and best practices for uploads and reporting for retail and restaurant customers using store sales:
- Only upload in-store transaction data. Do not include transactions from other channels, such as online sales, phone sales, or online purchases with in-store pick-up. Store sales is intended to measure sales that happen at physical stores.
- Upload transaction data regularly and consistently. Uploading data daily or weekly is recommended to ensure the system has up-to-date data. Keep in mind that Google Ads will only update store sales reporting values from 35 days before the upload date.
- Ensure that your upload file contains some transactions that occurred within 14 days of the upload date. Recent transaction data is required in order for Google Ads to provide updated store sales conversion data. If the upload file does not contain transactions that are within 14 days of the upload date, Google Ads reporting will not update.
- Avoid uploading transactions that occurred more than 90 days before the upload date, as they won’t be processed.
- Avoid uploading the same transaction more than once. If 2 separate uploads contain transactions with the same user and timestamp, only the most recently uploaded transaction will be reported.
- If you need to re-upload existing transaction data, ensure that any previous uploads for the transactions have already been processed. You can check the status of upload processing in Google Ads or the API, depending on where you uploaded your data.
Step 5: Check the status of your upload and correct any errors
After you upload a file to Google Ads, you can check your file status in Google Ads account. This only applies to store sales data files uploaded directly through Google Ads (and not through the Google Ads API).
- Sign in to your Google Ads account.
- In the upper right corner of your account, click the tools icon
.
- Under “Measurement”, click Conversions.
- Click Uploads from the page menu.
- Look at the “Status” column to check the file status for a specific upload.
Upload statuses
Processing
Failed
The uploaded store sales data failed processing. 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. To check for the specific reason, check the “Results” column of the Google Ads statistics table.
Applied
Finished with errors
Finished successfully
Download an error report to correct any errors
If Google Ads encounters any errors while uploading your store sales data file, you can download a spreadsheet that lists the conversions from your file that failed to import. You can then fix any errors and re-upload the file to Google Ads.
- From the “Conversions” page in Google Ads, click Uploads.
- Find the store sales data file that has the errors.
- In the “Actions” column, click Download errors.
- Review the error messages in the “Results” column of the spreadsheet to determine why Google Ads couldn’t import your conversions.
- Make the necessary corrections to the spreadsheet and save it.
- Upload the corrected file again.