Close
k

Projects

Contact

News

Capture Content Pattern
April 23, 2023
GoogleHow To's

How to upload ads from a spreadsheet

Google Ads bulk uploads capability is a lifesaver for anyone updating their campaigns, keywords, ads, ad groups and product groups regularly. This feature will not only save you time, but has the capability for users to make changes offline and then upload back into your account – hello amazing.

The ability to upload changes to your account via a spreadsheet allows you to be responsive to changes on your account quickly, bulk action on issues or opportunities and most importantly- allow you to analyse your Google Ads account data in an easy format. We are going to guide you through how to download the correct spreadsheet, edit and then upload your data.

What’s the alternative to uploading using an Excel spreadsheet? Doing it manually of course and that’s fun for no one. When creating ads manually, the possibilities of human error are increased.

So, what are the benefits of using an excel template to upload? There are numerous benefits of using Excel for campaign creations such as efficiency, fewer human errors plus:

Get to know your format

Once you have an Excel template that you know works for your business, the relevant information can be duplicated, speeding up your entry and upload time.

Back it up

Don’t worry about losing work on a campaign – when you are using a template, you can keep a backup or master file of your initial settings so you have a base to begin with each time.

Excel’s easy formatting

In excel you can take advantage of the conditional formatting and filters, allowing you to identify errors like duplicated keywords, misspellings, or terms when testing variations.

Excel’s easy formatting

Once signed in, select Keywords, Ads, Ad Group, Campaigns, Audiences or Product groups from the left menu. This will be dependent on the type of edits that you would like to make.

On the right side, select the download icon and select more options. Choosing the format for your spreadsheet, select Editable columns for Bulk Upload.

Click Download

Hot tip: Make sure you always keep an original download and the file you are working on. This is in case you ever need to refer to what your prior settings were before you made the upload changes.

Now to format your spreadsheet – the fun part!

Dependent on what information you want to update, you will need to create a new row in your spreadsheet. This simply means adding a row for keyword, ad or any other items. You can then enter the values that you want for each new item such as budget, status or bids. We’ve found a list of corresponding values here.

To remove items such as keywords or ads:

Find the row in your spreadsheet that contains the item you wish to remove

In the status column, enter remove

Upload the spreadsheet

Hot tip: never delete the header row containing the column names. You can leave columns blank under headers if you have no information to add.

To edit keyword spreadsheets, type the keyword you wish to add in the ‘keyword’ column. You can then enter the ad group name in the Ad group column. When uploading keywords, the old keywords are replaced, not edited. If you want to edit a keyword or match type, you will first need to remove the current keyword and create an entirely new keyword with the changes. Similarly, you cannot edit existing ads text. When you upload the spreadsheet, the old ad will be replaced.

Certain columns within your spreadsheet will only be edited when creating a campaign. Your spreadsheet will include these columns. We’ve listed them below:

The keywords that relate to what you entered will display by the most to least relevant alongside three columns:

Campaign (required)

Campaign ID (required)

Campaign state

Campaign type (can’t edit)

Campaign subtype (can’t edit)

Ad rotation

Start date

End date

Bidding and budget

Bid strategy type

Bid strategy

Budget

Target CPA

Target ROAS

Target impression share

Max CPC bid limit for target impression share

Measurement

Tracking template

Custom parameter

If you like to bulk edit ad extensions, you will need to download a new spreadsheet. To do this, sign in to your Google Ads account.

Once signed in, click the tools icon in the top right of your account

Under bulk actions, select uploads and click the blue plus button

Click view templates and download your template a CSV or Excel spreadsheet.

Once downloaded, open the spreadsheet and locate the ‘Campaign’ column. Enter the campaign where you want to add your extension or enter an ad group in the ‘Ad Group’ column.

To add a call extension, you must specify:

Phone number: The number that will be called when a customer clicks your extension.

Country code: The country where your phone number is listed. For example, if your phone number is in Australia, you would put AU.

Use forwarding number (optional): Whether you want to use a Google forwarding number with your ad. You can enter yes or no. The default is no.

To add a review extension, you must specify:

Source URL: The URL where the person or organisation printed your review.

Source name: The person or organisation that provided the review.

Is exact quote (optional): Whether your text is exactly the words in the review. You can enter yes or no. The default is no.

To add a sitelink extension, you must specify:

Sitelink text: The text that you want to appear as the clickable link in your sitelink.

Final URL: The URL where the link in your sitelink will lead.

You have the option to leave the description fields blank, however if you do enter description you must fill out both fields. We recommend adding descriptions to make your ad more relevant to prospective customers.

To add callout extensions, you must specify:

To add callout extensions, you must specify:

So now that you know how to add your information to ad extensions, how are you able to remove these same extensions?

Simply, enter Remove in the Action column of that ad extension’s row. It’s that easy and will remove the extension from the campaign or ad group.

Now it’s time to edit your bid strategy. You can do this by assigning existing portfolio bid strategies to your campaigns or by editing the standard bid strategies. How to assign a portfolio bid strategy?

Go to the 'Campaigns' page.

To add callout extensions, you must specify:

Click the download icon and select 'More options' at the bottom of the drop-down menu.

Under 'Include', tick the box for 'Editable columns for Bulk Upload' and click 'Download'.

Under 'Include', tick the box for 'Editable columns for Bulk Upload' and click 'Download'.

Leave the 'Bid strategy type' column and other columns such as 'Target CPA' or 'Target ROAS' blank. If there happens to be a value in one of these columns, simply enter 'remove_value'.

Please note- you won’t be able to create a new portfolio bid strategy in the bulk upload spreadsheet.

And what if you want to edit a standard bid strategy? follow these steps.

Move to the 'Campaigns' page.

Click the download icon and choose 'More options' at the bottom of the drop-down menu.

Under 'Include', tick the box for 'Editable columns for Bulk Upload' and click the 'Download' button.

Edit the 'Bid strategy type' column with the style of bid strategy you’d like.

Edit any additional columns like 'Target CPA' or 'Target ROAS'.

Finally, editing your audiences. Similarly, to bid strategy, you can’t create new audiences within the bulk edit upload. You can only assign audiences that you have previously created for campaigns or ad groups.

Hot tip: if you have multiple audiences under the same names, you must add an extra column for the Audience ID to be entered.

You can edit your bid adjustment by entering a worth within the “bid adjustment” column. All other edits, like audience name and targeting setting don’t seem to be supported.

If you’re adding an audience for the first time, it’ll use the “smart default” targeting setting. this feature will keep your current audience targeting settings. If you haven’t yet chosen a setting, your targeting will default to the subsequent options supported your campaign type:

Targeting is the default for Video and Display campaigns.

Observation for Search and Shopping campaigns.

Detailed demographics

Affinity

In-market

Remarketing

Similar Audiences

Customer match

Finally, we are able to upload our spreadsheets!

Like everything else Google, there isn’t only one way to do this. You have the choice to upload your spreadsheets from the left menu pages: Keywords, Ads, Campaigns, Ad Groups or product groups pages. To do this sign into your Google Ads account and follow these steps:

Select Keywords, Ads, Ad Group, Campaigns or Product groups (depending on the kind of edits that you’d like to make) and click on the three-dot icon.

Click the upload icon and choose the spreadsheet that you want to upload.

Click preview to see the data before uploading and click apply if everything looks correct.

The alternative option to upload your spreadsheet is in the Bulk Actions section. To do this sign into your Google Ads account and follow these steps:

Under 'Source', you can choose to Upload a file or connect to Google Sheets.

Under 'Source', you can choose to Upload a file or connect to Google Sheets.

Click the tools & settings icon.

Under 'Bulk actions', select 'Uploads'.

Upload a file: Click 'Select a file from your computer' and add your file.

Google Sheets: Click 'Link an existing Google Sheet' and select a spreadsheet from your Google Drive account.

(Optional) To see any potential issues with uploading your file, click 'Preview'.

Click 'Apply'.

And that’s it! You can now view the results of your uploads. Good luck!

Post a Comment