If you are already running campaigns on Google Ads to advertise on the search engine, you may want to use Semrush tools to optimize and improve your strategy. Here’s how you export your campaigns from Google Ads and Google Ads Editor and upload them into Semrush so you can start making changes.
Exporting campaigns from Google Ads and Google Ads Editor
In your Google Ads account go to the “Campaigns” section. To export keywords from all your campaigns in Google Ads, go to the “Keywords” tab and hit “Download”. In the drop-down menu you can choose a format to download the file. The PPC Keyword tool supports .txt, .csv, or .xlsx files.
If you use Google Ads Editor to manage your Google Ads campaigns, you can export them directly from the Editor app. The downloadable app provides you with various options on the data that can be exported from your account.
Go to the Account menu to open the “Account manager” window. Since the Editor allows you to manage multiple accounts, here you can select one or more accounts to export into a single file. Click “Export” and select CSV files (*.csv) as the file type. Information from your account will be saved as a .csv file that you can view and edit in any spreadsheet editor.
With the export function, you can easily share your account data with those who don’t use Google Ads Editor. You can export your entire account, a single campaign or ad group, or several campaigns and ad groups that you select.
Uploading data to Semrush tools
Semrush allows you to upload files from your device to the PPC Keyword Tool so that you can make improvements to your existing advertising campaign.
PPC Keyword Tool
When you create a PPC Keyword Tool campaign, you have three options for adding keywords to the campaign:
- From a file
- Manually (typing one keyword at a time)
- Importing from Semrush Domain and Keyword Analytics
To import your file to the tool, choose a preferred format and then upload it by browsing the file on your device or using the drag-and-drop function. PPC Keyword Tool supports the following file formats: .txt, .csv, and .xlsx.
There are several requirements to each format of file that you’re going to upload:
- If you import keywords from a .txt file, make sure to place one keyword per line.
- When uploading a .csv or .xlsx file, you need your spreadsheet to be formatted with columns for a keyword, campaign, and ad group.
For more information on how to upload a file to the PPC Keyword tool and requirements to its format, read the article “How do I format a file to upload to the PPC Keyword Tool?”