Back
3 mins read

No data feed? From now on, Google Sheets is enough!

Final maybe sheetsFinal maybe sheets
There’s one thing you can’t do without when creating a product, category, or DSA campaign in PPC Bee—a data feed. But what should you do if there’s no XML or CSV feed around? All you need is a Google Sheets file.
By
Adam Vašenda
| Oct 10, 2019
PPC Bee contains a new option in the data feed section – New Google Sheets data source. Click it, sign into your Google account, and authorize the necessary rights. Give the data source a name (3.), select the correct file (5.) from the account (4.) you’ve linked up, and the specific list (6.) the file contains. Last but not least, select the column which will be responsible for maintaining the uniqueness of each and every item, i.e. the column with unique IDs (7.). Save the feed, and then synchronization begins. The feed will be regularly updated depending on your subscription level.
https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdElEIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1e53b304db152aef4cf261387c54454225e2d1f4/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/Add%20GS.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdElEIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--1e53b304db152aef4cf261387c54454225e2d1f4/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/Add%20GS.png

https://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdE1EIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--fddc6a75513a664d9930dfa71555df8420dc9298/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQWxnQ2FRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--b1b529f8dfa4cfc5545b605b986d2f12cc3d32fa/Settings.pnghttps://blogadmin.ppcbee.com/rails/active_storage/representations/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBdE1EIiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--fddc6a75513a664d9930dfa71555df8420dc9298/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCam9VY21WemFYcGxYM1J2WDJ4cGJXbDBXd2RwQXJBRWFRT2doZ0U9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--21b5f9fec4a1a26d9fca8e4bc575ac97c48ec932/Settings.png



Naturally, we’ve taken safety into consideration as well. Once your account is connected, you’re the only one who can add files from your Drive—no other account within the organization can use your files and there’s no need for you to worry about someone else creating a data feed out of your files or even viewing their list. 

We recommend you use Google Sheets if you have no XML or CSV data feed at your disposal. Adding this type of feed is very easy and safe. This new function is already available in PPC Bee app and you can give it a try right now. And if you have any related feedback, don’t forget to share it with us at support@ppcbee.com. :) 

Adamv
Adam Vašenda
Editor of PPC Bee

Related articles

Read more

FAQs – Summer Edition

or Answers to the questions you’ve been asking us most often lately.

By Michaela ZákopčaníkováJun 24, 2019 | 2 mins read

Read more

Capitalization in Ads

In the past, PPC Bee automatically changed your capitalized words. Because of them your ads can be rejected (primarily by AdWords). There are, however, several clients whose brand name is comprised of uppercase letters, and there was no way for them to keep this in their ads. Thus we have decided to meet their needs and now we have enabled capitalized words in ads.

By Michaela ZákopčaníkováSep 5, 2017 | 1 min read

Read more

Responsive Search Ads Now in PPC Bee

Last year, Google Ads introduced the option of posting a new type of text ads - responsive search ads. And now you can create these in PPC Bee, too! What do they look like? How can you create them? Keep reading.

By Adam VašendaDec 12, 2019 | 4 mins read