Learn how to enable SFTP for supported destinations.
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
- From Google Ads, click Tools > Shared library > Audience manager > + (Create) > Customer list.
- Optional: If you already created a segment and skipped adding a data source, click Tools > Data manager > + Connect Product.
- Under Data source, select Connect a file, then click Continue.
- Enter your SFTP credentials.
- Click Test connection, to make sure the connection is configured correctly, then click Next.
- 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.
- To map fields, select the data source fields from the dropdown lists that match the Google fields.
- Optional: To apply transformations, click Transform
- Click Next.
- Enter a name for this connection.
- Optional: Edit connection details.
- Click Finish.
- Enter a name for the segment, confirm policy compliance and membership duration, then click Create.
- 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.
- From Google Ads, click Goals > Summary > + New conversion action.
- Optional: If you already created a conversion and skipped adding a data source, click Tools > Data manager > + Connect Product.
- Click Import.
- Select CRMs, files, or other data sources.
- Select a tracking method, then click Continue.
- Under Data source, select Connect a file.
- 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.
- Select a conversion goal from the list, then click Set up.
- Click Save and continue.
- Enter your SFTP credentials.
- Host
- User name
- Password
- Click Test connection, to make sure the connection is configured correctly.
- 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.
- To map fields, select the data source fields from the dropdown lists that match the Google fields, then click Continue.
- Enter a name for this connection.
- Optional: Edit connection details.
- Click Save and continue.
Learn more about Offline conversion imports.