fbpx

Using Mass Spreadsheet Upload For Your Google Ads

One of the fastest and most efficient ways to create campaigns is to use the mass spreadsheet upload method. If your campaign has over a hundred text ads or over a thousand keywords, it’ll simply take too much time to create it in AdWords Editor. The spreadsheet upload is the answer.

What Is the Spreadsheet Upload?

The mass spreadsheet upload involves creating all your text ads, Ad Groups, keyword lists, match types and bid amounts in an Excel spreadsheet.

The spreadsheet is then copied and pasted into the Google Ad Editor. AdWords Editor will parse all the data it receives, let you know of any errors and put all the text ads, keywords and AdGroups in the appropriate places.

Then all you need to do is correct any errors and click “Post Changes.” Once the changes go live on the server, you might get another few errors that you need to correct. Then you’re done!

Even the load times between switching tabs in AdWords Editor can add up when you get in the range of hundreds of keywords and text ads. The spreadsheet upload method can remove much of this lag time.

Here are a few tips for making the process easier.

Constructing Your Spreadsheet

Using Mass Spreadsheet Upload for Your Google Ads

To figure out exactly what fields AdWords Editor needs, go to:

The spreadsheet is then copied and pasted into the Google Ad Editor. AdWords Editor will scan all the data it receives, inform you of any error and put all text ads, keywords and AdGroups in the appropriate places.

Look at all the columns of data that AdWords needs for you to copy and paste from a spreadsheet. Create these columns in your spreadsheet program.

Repeat the process for your keywords by going to:

Data > Keywords > Add/Edit Multiple Keywords

Then do the same for text ads by going to:

Data > Text Ads > Add/Edit Text Ads

Once you’ve done these three steps, you should have a spreadsheet with all the values you need to plug in. These values will include the text headline and descriptions, destination URLs, keywords, match types, and bids.

Tips for Creating Text Ads

When you’re creating your text ads, if you want to create two ads per AdGroup so you’re split-testing ads, just select your whole AdGroup list and paste it back into the spreadsheet right below all the existing AdGroups.

This will create a duplicate of every AdGroup. Then sort by AdGroup name and you’ll have two of each AdGroup to write ads for.

When you’re writing ads, it often helps to create three columns that tell you the length of the text you’re writing. AdWords allows you to have 25 characters in your headline and 35 characters in description 1 and description 2.

In Excel, the formula for calculating length is =LEN(cell). Just put that formula in the three cells next to the text ad cells so you know how many characters you have left as you write the ads.

To wrap up, the spreadsheet method will make it much faster to write ads, edit keywords, compile AdGroups, and do just about everything you need to do in a really big campaign.

Share
Share on google
Share on facebook
Share on linkedin
Share on twitter
Tags

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Read Similar Articles

Subscribe to Digital Reviews Get Newest Update

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. View more
Cookies settings
Accept
Privacy & Cookie policy
Privacy & Cookies policy
Cookie name Active

Privacy Policy for Digital Reviews

At Digital Reviews, accessible from https://digitalreviews.co, one of our main priorities is the privacy of our visitors. This Privacy Policy document contains types of information that is collected and recorded by Digital Reviews and how we use it.

If you have additional questions or require more information about our Privacy Policy, do not hesitate to contact us.

This Privacy Policy applies only to our online activities and is valid for visitors to our website with regards to the information that they shared and/or collect in Digital Reviews. This policy is not applicable to any information collected offline or via channels other than this website.

Consent

By using our website, you hereby consent to our Privacy Policy and agree to its terms.

Information we collect

The personal information that you are asked to provide, and the reasons why you are asked to provide it, will be made clear to you at the point we ask you to provide your personal information.

If you contact us directly, we may receive additional information about you such as your name, email address, phone number, the contents of the message and/or attachments you may send us, and any other information you may choose to provide.

When you register for an Account, we may ask for your contact information, including items such as name, company name, address, email address, and telephone number.

How we use your information

We use the information we collect in various ways, including to:

  • Provide, operate, and maintain our webste
  • Improve, personalize, and expand our webste
  • Understand and analyze how you use our webste
  • Develop new products, services, features, and functionality
  • Communicate with you, either directly or through one of our partners, including for customer service, to provide you with updates and other information relating to the webste, and for marketing and promotional purposes
  • Send you emails
  • Find and prevent fraud

Log Files

Digital Reviews follows a standard procedure of using log files. These files log visitors when they visit websites. All hosting companies do this and a part of hosting services' analytics. The information collected by log files include internet protocol (IP) addresses, browser type, Internet Service Provider (ISP), date and time stamp, referring/exit pages, and possibly the number of clicks. These are not linked to any information that is personally identifiable. The purpose of the information is for analyzing trends, administering the site, tracking users' movement on the website, and gathering demographic information.

Cookies and Web Beacons

Like any other website, Digital Reviews uses 'cookies'. These cookies are used to store information including visitors' preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information.

For more general information on cookies, please read "What Are Cookies" from Cookie Consent.

Google DoubleClick DART Cookie

Google is one of a third-party vendor on our site. It also uses cookies, known as DART cookies, to serve ads to our site visitors based upon their visit to www.website.com and other sites on the internet. However, visitors may choose to decline the use of DART cookies by visiting the Google ad and content network Privacy Policy at the following URL – https://policies.google.com/technologies/ads

Our Advertising Partners

Some advertisers on our site may use cookies and web beacons. Our advertising partners are listed below. Each of our advertising partners have their own Privacy Policy for their policies on user data. For easier access, we hyperlinked to their Privacy Policies below.

Advertising Partners Privacy Policies

You may consult this list to find the Privacy Policy for each of the advertising partners of Digital Reviews.

Third-party ad servers or ad networks uses technologies like cookies, JavaScript, or Web Beacons that are used in their respective advertisements and links that appear on Digital Reviews, which are sent directly to users' browser. They automatically receive your IP address when this occurs. These technologies are used to measure the effectiveness of their advertising campaigns and/or to personalize the advertising content that you see on websites that you visit.

Note that Digital Reviews has no access to or control over these cookies that are used by third-party advertisers.

Third Party Privacy Policies

Digital Reviews's Privacy Policy does not apply to other advertisers or websites. Thus, we are advising you to consult the respective Privacy Policies of these third-party ad servers for more detailed information. It may include their practices and instructions about how to opt-out of certain options.

You can choose to disable cookies through your individual browser options. To know more detailed information about cookie management with specific web browsers, it can be found at the browsers' respective websites.

CCPA Privacy Rights (Do Not Sell My Personal Information)

Under the CCPA, among other rights, California consumers have the right to:

Request that a business that collects a consumer's personal data disclose the categories and specific pieces of personal data that a business has collected about consumers.

Request that a business delete any personal data about the consumer that a business has collected.

Request that a business that sells a consumer's personal data, not sell the consumer's personal data.

If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.

GDPR Data Protection Rights

We would like to make sure you are fully aware of all of your data protection rights. Every user is entitled to the following:

The right to access – You have the right to request copies of your personal data. We may charge you a small fee for this service.

The right to rectification – You have the right to request that we correct any information you believe is inaccurate. You also have the right to request that we complete the information you believe is incomplete.

The right to erasure – You have the right to request that we erase your personal data, under certain conditions.

The right to restrict processing – You have the right to request that we restrict the processing of your personal data, under certain conditions.

The right to object to processing – You have the right to object to our processing of your personal data, under certain conditions.

The right to data portability – You have the right to request that we transfer the data that we have collected to another organization, or directly to you, under certain conditions.

If you make a request, we have one month to respond to you. If you would like to exercise any of these rights, please contact us.

Children's Information

Another part of our priority is adding protection for children while using the internet. We encourage parents and guardians to observe, participate in, and/or monitor and guide their online activity.

Digital Reviews does not knowingly collect any Personal Identifiable Information from children under the age of 13. If you think that your child provided this kind of information on our website, we strongly encourage you to contact us immediately and we will do our best efforts to promptly remove such information from our records.

Save settings
Cookies settings