In engine track accounts, Search Ads 360 doesn't automatically download engine metrics such as clicks, impressions, and cost. But if you create an sFTP endpoint in Search Ads 360, you can set up adMarketplace to automatically upload metrics to the endpoint on a schedule. Then you can view the metrics in Search Ads 360 reports, just as you can for fully supported engines.
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.
Create an sFTP endpoint in Search Ads 360
Create a separate endpoint for each type of engine track account you use:
- Sign into Search Ads 360 with a Google account that has agency manager or advertiser manager permissions and navigate to an advertiser.
Steps for navigating to an advertiser
-
Click the navigation bar to display navigation options.
-
In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.
-
In the "Advertiser" list, click on the advertiser.
-
Click Apply or press the Enter key.
Search Ads 360 displays the advertiser page, which contains data for all of the advertiser’s engine accounts.
-
-
In the left navigation panel, click Advertiser settings.
-
Click the Integrations▼ tab and select sFTP connections.
-
Click + sFTP connection, which appears above the reporting table.
-
In sFTP connection name, enter a name for the connection.
The name only appears in Search Ads 360. Choose a name that clarifies the purpose of the connection. -
From the Purpose list, select Engine track cost metrics upload.
-
From the Engine type list, select the type of performance metrics you'll be uploading to the endpoint.
-
Click Generate.
Search Ads 360 creates an endpoint and displays an sFTP server address, port number, username, and password under Connection details (generated by Search Ads 360).
The username and password generated by Search Ads 360 cannot be edited. -
Copy the password and paste it into a password manager or some other system you use to store passwords securely.
Once you click Save, you can't view the password again. If you lose the password, you can reset it. -
Click Save to close the endpoint details and permanently hide the password.
While you can't view the password again once you've closed the endpoint details, you can view the other connection details at any time, and reset the password.
Set up a scheduled report in adMarketplace
In adMarketplace, set up a scheduled report for each account and specify the following information:
- For report type, select Search Ads 360 Report.
- Enter the sFTP connection server address, port number, username and password for the endpoint you created. Be sure you specify the port number. Search Ads 360 does not use the standard FTP port number.
As reports are delivered to Search Ads 360, you'll start seeing engine data (clicks, cost, impressions) in your Search Ads 360 adMarketplace account.
Search Ads 360 won't import metrics if a file contains data from more than one engine account.
Required and optional columns in the scheduled report
Search Ads 360 recognizes the following columns in the scheduled report:
| adMarketplace column | Maps to this reporting column in Search Ads 360 | Required? |
|---|---|---|
| Date | Start date | Yes |
| Account ID | External engine account ID | Yes |
| Campaign ID | Campaign ID | Yes |
| Ad Group ID | Ad group ID | Yes |
| Keyword ID | Keyword ID | Yes |
| Clicks | Clicks | Yes |
| Spend | Cost | Yes |
| Device Type Name | Device | No |
| Impressions | Impr | No |
| From | ignored | No |
| To | ignored | No |
Search Ads 360 ignores any other columns that appear in the report.
Recognized device types
If any of the following values appear in the Device Type Name column, Search Ads 360 can map them to the Desktop, Mobile, or Tablet device type:
| Value in "Device Type Name" | Maps to this device type in Search Ads 360 |
|---|---|
| Apple Mac OS | Desktop |
| Chrome OS | Desktop |
| UNIX | Desktop |
| Windows | Desktop |
| Android Phone | Mobile |
| BlackBerry | Mobile |
| iPhone | Mobile |
| iPod | Mobile |
| Windows Mobile | Mobile |
| Android Tablet | Tablet |
| iPad Tablet | Tablet |
Other values map to "Other" device type in Search Ads 360.
Upload historical metrics
To provide historical performance metrics for any adMarketplace item that appears in Search Ads 360:
- In adMarketplace create a Search Ads 360 Report that contains up to 2 years of data.
- Segment the report by day.
- Send the report to your Search Ads 360 sFTP endpoint.
Keep reports under 600MB or 100k rows. If you have larger reports, you'll need to break them into shorter time frames and upload each report separately.
The historical metrics will appear in Search Ads 360 within approximately 24 hours.
Next steps
View and customize reports for the engine track account.