How To Use Mass Spread Sheet Upload - Mandarin

 How To Use Mass Spread Sheet Upload - Mandarin

How to Use Mass Spreadsheet Upload

 

Using a mass spreadsheet upload method is one of the quickest and most efficient ways to construct campaigns. It will just take too long to develop your campaign in Google Advertisements Editor if it has over a hundred text ads or over a thousand keywords. The answer is to use a spreadsheet upload.

 

What Does a Spreadsheet Upload entail?

 

All of your text advertising, AdGroups, keyword lists, match kinds, and bid amounts are created in an Excel spreadsheet for the spreadsheet upload.

 

After that, you copy and paste the spreadsheet into Google Ads Editor. Google Advertisements Editor will parse all of the data it receives, notify you of any mistakes, and insert all of the text ads, keywords, and AdGroups where they belong.

 

Then click "Post Changes" after correcting any problems. You might get a few more issues when the modifications go live on the server, which you'll have to fix. You're finished now!

 

When you're working with hundreds of keywords and text advertising, even the lag times between moving tabs in Google Ads Editor might add up. Much of this lag time can be eliminated using the spreadsheet upload approach.

 

Here are some pointers to help you through the procedure.

How to Make a Spreadsheet

 

Go to: to learn more about the fields Google Ads Editor requires.

 

Add/Edit Multiple AdGroups > Data > AdGroups >

 

Examine all of the data fields Google Ads requires you to copy and paste from a spreadsheet. In your spreadsheet programme, make these columns.

 

Go to: and repeat the process with your keywords.

 

Add/Edit Multiple Keywords (Data > Keywords)

 

Then go to:

 

Add/Edit Text Ads > Text Ads > Data

 

After you've completed these three steps, you should have a spreadsheet that contains all of the values you need to enter. Text headlines and descriptions, destination URLs, keywords, match types, and bids will all be included in this list of data.

 

Text Ads: Some Advice

 

If you want to generate two ads per AdGroup so you can split test advertising, simply pick all of your AdGroups and paste them back into the spreadsheet underneath all of the existing AdGroups when creating your text ads.

 

Every AdGroup will be duplicated. Then sort by AdGroup name, and there will be two of each AdGroup for you to write ads for.

 

When creating adverts, having three columns to indicate the length of the content you're writing might be very helpful. Your headline can be 25 characters long, and your description 1 and 2 can be 35 characters long.

 

To calculate length in Excel, use the formula =LEN (cell). Simply enter that formula in the three cells adjacent to the text ad cells to see how many characters remain as you compose the adverts.

 

To summarise, using a spreadsheet to write advertisements, modify keywords, compile AdGroups, and handle just about everything else in a large campaign will save you a lot of time.

 

Thanks for listening

Join our Facebook Group My Learning Centre

Subscribe to our channel My Learning Centre on YouTube

Visit our website for quality eBooks, audio courses, HD video courses and many more.