Notification

Got 5 minutes? Help us with a quick study about the Search Ads 360 Help Center.

About using sFTP to upload bulksheets

What's a secure FTP endpoint?

FTP (File Transfer Protocol) is a standard way of uploading files into a computer system. Secure FTP encrypts data as it's transferred over the internet. This ensures privacy and integrity of your data. Secure FTP is usually abbreviated as sFTP. The endpoint provides a unique internet address and a separate storage area that Search Ads 360 uses to process the files. Only users with access to the username and password can upload files to your endpoint.

In Search Ads 360, you can use sFTP to upload bulk changes to campaigns, costs, and conversions. You can view and schedule all uploads from the Schedules tab on the Bulk Actions page. sFTP endpoints you create on this tab will be immediately available for use on the Uploads tab.

You can use your own sFTP endpoint, or you can set up a Google-owned endpoint directly in Search Ads 360.

What's a Google-owned sFTP?

A Google-owned sFTP is a secure connection owned by Google. You can set this up directly in Search Ads 360. To ensure the privacy of your data, endpoints you create in Search Ads 360 are protected by a username and password. Because the server is owned by Google, Search Ads 360 can detect when your bulksheets are updated, and automatically apply changes to your campaigns.

You can create sFTP endpoints from a manager, sub-manager, or client account. The top-level manager which you log in as always owns the endpoints. If you create sFTP endpoints at the manager-account level, you can upload conversions for all related sub-manager accounts to that single endpoint.

If your organization regularly creates bulksheets, Google sFTP provides a fully automated solution. It allows bulksheets to be sent to Search Ads 360 immediately upon creation via a Google-owned sFTP connection.

Alternatively, if you upload bulksheets frequently, you can use your own software to upload bulksheets to a sFTP endpoint instead of manually uploading through the Search Ads 360 UI. Some third-party sFTP programs allow you to schedule bulksheet uploads.

Furthermore, you can create a scheduled sFTP connection. With this option, you define a specific frequency and time, and Google will automatically pull the files from your sFTP server according to that schedule.

Port number for the sFTP endpoint

Search Ads 360 uses port 19321 to receive sFTP connections. This port number can't be changed.

How soon does processing start?

Search Ads 360 starts processing bulksheets as soon as possible after the sFTP upload completes. You may see a slight delay if multiple bulksheets were uploaded to Search Ads 360 at roughly the same time (for example, if different users upload bulksheets simultaneously).

If you require bulksheets to be fully processed in a specific order, make sure processing of the first file is complete before uploading the next one. Search Ads 360 attempts to start processing in the order in which bulksheets are uploaded—either through the UI or an sFTP endpoint—but processing order isn't guaranteed. In addition, Search Ads 360 may finish processing a smaller bulksheet before a larger one, even if it started on the larger bulksheet first.

If you or other users upload more than one bulksheet with the same name:

  • If Search Ads 360 starts processing a bulksheet before you upload the second one with the same name, the second bulksheet is treated as a separate file (even though it has the same name as the first file).
  • If you upload a bulksheet through sFTP and then immediately use sFTP to upload a second bulksheet with the same name before Search Ads 360 has a chance to start processing the first bulksheet, Search Ads 360 ignores the first bulksheet and only processes the second one.
Note: Search Ads 360 doesn't email confirmation or status information about bulksheets that you upload through sFTP. Instead, you can use the Search Ads 360 UI to view upload status and history and download any error sheets, which list errors for items that Search Ads 360 couldn't process.

Related links

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Google apps
Main menu
4641142589287328967
true
Search Help Center
false
true
true
true
true
true
5055977
true
false
false
false