SFTP

Requirements

• You must have an SFTP server set up that is hosting the file to upload.
• File must be of the .csv or .tsv format.
• The first row of the file must contain the file header, which is used to name the data source fields during mapping.
• File should be updated before each import.
• For Customer Match, one file is required per audience list.

Set up SFTP as a data source

The following sections walk you through a single procedure to link a data source to a use case. Click on your use case to expand the steps.

Customer Match

1. From Google Ads, click Tools > Shared library > Audience manager > + (Create) > Customer list.
   1. Optional: If you already created a segment and skipped adding a data source, click Tools > Data manager > Connected products > Connect source. 
2. Under Data source, select Connect a file, then click Continue.
3. Enter your SFTP credentials.
4. Click Test connection, to make sure the connection is configured correctly, then click Next.
5. Enter the path to the file you want to upload, relative to the host address, then click Next. Note that port 21 is used by default. To specify a different port, append a colon and the port number to the path--for example, sftp://example.com/path/file.csv:2222.
6. To map fields, select the data source fields from the dropdown lists that match the Google fields.
7. Optional: To apply transformations, click Transform
8. Click Next.
9. Enter a name for this connection.
10. Optional: Edit connection details.
11. Click Finish.
12. Enter a name for the segment, confirm policy compliance and membership duration, then click Create.
13. Click Done.

Learn more about Customer Match.

Offline Conversion Import

Note: Conversions uploaded using the legacy Uploads page are not accessible from Data Manager. To make these conversions available, you must import them following these steps.

1. From Google Ads, click Goals > Summary > + New conversion action.
   1. Optional: If you already created a conversion and skipped adding a data source, click Tools > Data manager > Connected products > Connect source. 
2. Click Import.
3. Select CRMs, files, or other data sources.
4. Select a tracking method, then click Continue.
5. Under Data source, select Connect a file.
6. Select the Customer data box, to acknowledge that the data was collected and is being shared in compliance with Google's policies, then click Continue.
7. Select a conversion goal from the list, then click Set up.
8. Click Save and continue.
9. Enter your SFTP credentials.
   1. Host
   2. User name
   3. Password
10. Click Test connection, to make sure the connection is configured correctly.
11. Enter the path to the file you want to upload, relative to the host address, then click Continue. Note that port 21 is used by default. To specify a different port, append a colon and the port number to the path--for example, sftp://example.com/path/file.csv:2222.
12. To map fields, select the data source fields from the dropdown lists that match the Google fields, then click Continue.
13. Enter a name for this connection.
14. Optional: Edit connection details.
15. Click Save and continue.

Learn more about Offline conversion imports.