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

Note: It’s recommended that you add an audience segment to a connection that you created. You can either set up an audience segment before you link a data source or you can create an audience segment in the final step of setting up a data source.

Open Tools > Data manager. Select the connection you just made from “Connected products” and under “Usage”, click + Add audience segment.

1. From Google Ads, click Tools > Shared library > Audience manager > + (Create) > Customer list.
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 and audience segments.

Offline Conversion Import

Tip: Upgrade from offline conversion import to enhanced conversions for leads for more accurate reporting, easier data import, and engaged-view and cross-device conversion attribution.

To set up enhanced conversions for leads, you can either use an existing offline conversion import conversion action or create a new conversion action.

Note: It’s recommended that you add a conversion action to a connection that you created. You can either set up a conversion action before you link a data source or you can create a conversion action in the final step of setting up a data source.

Open Tools > Data manager. Select the connection you just made from “Connected products” and under “Usage”, click + Add conversion action.

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.
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 and how to Create a conversion.