In engine track accounts, Search Ads 360 doesn't automatically download engine metrics such as clicks, impressions, and cost. But you can download the metrics directly from the engine and then upload them into Search Ads 360. Then you can view the metrics in Search Ads 360 reports, just as you can for fully supported engines.
Instead of using the Search Ads 360 UI to upload performance metrics, set up an sFTP endpoint in Search Ads 360 and then use third-party software to transfer files to the sFTP 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.
You may be able to automate part of the process of uploading performance metrics. For example, some sFTP software can automatically upload files on a schedule. Once you create an sFTP endpoint in Search Ads 360, you can set up automated uploads to occur on a regular basis.
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.
Export a keyword report from 360.cn
From 360.cn, export a keyword report for each 360.cn engine account. Make sure the export file is in a format supported by Search Ads 360 and that the report contains metrics from a single 360.cn account. If you've created multiple 360.cn engine accounts in Search Ads 360, export each account's data into a separate file.
Search Ads 360 won't import metrics if a file contains data from more than one engine account.
Duplicate campaign names, ad group names, or keywords
If the exported file contains active campaigns with the same name, active ad groups with the same name, or duplicate keywords in the same ad group, Search Ads 360 will ignore the duplicated items. That is, you won't see metrics for the campaigns, ad groups, or keywords in Search Ads 360. (If one of the duplicates is in the "removed" status, Search Ads 360 will apply metrics to the active item.)
Required and optional columns in the exported report
Search Ads 360 recognizes the following columns in the report you export:
| 360.cn column | Maps to this reporting column in Search Ads 360 | Required? |
|---|---|---|
| 日期 | Start date | Yes |
| 点击次数 | Clicks | Yes |
| 展示次数 | Impr | Yes |
| 总费用 | Cost | Yes |
| 账户名称 | Account (name) | Yes |
| 推广计划 | Campaign (name) | Yes |
| 推广组 | Ad group (name) | Yes |
| 关键词 | Keyword | Yes |
Search Ads 360 ignores any other columns that appear in the report.
Upload to an sFTP endpoint
To upload to an sFTP endpoint:
- Download sFTP software and enter the sFTP server address, port number, username, and password that Search Ads 360 generated when you created the sFTP endpoint.
- Use the sFTP software to transfer the file you exported from 360.cn to the Search Ads 360 endpoint.
The uploaded metrics appear in Search Ads 360 within approximately 24 hours.
Search Ads 360 deduplicates overlapping uploads
If the uploaded metrics overlap, Search Ads 360 overrides the previously uploaded metrics with the most recent upload. For example:
- Every afternoon you upload metrics from today and yesterday.
So Monday's upload contains all metrics from Sunday and metrics for Monday morning and afternoon. - Tuesday's upload contains all metrics from Monday and partial metrics from Tuesday.
Tuesday's upload will completely overwrite the partial data previously uploaded for Monday.
Next steps
View and customize reports in the engine track account.