With Revealbot’s Google Sheets integration, now you can use exterior knowledge and values from a spreadsheet in your automated guidelines.
This integration is ideal for purchasers who use Google Sheets for analyzing efficiency, forecasting, and calculating finances allocation and need to use that knowledge to tell their guidelines.
It’s additionally nice for purchasers who need to use their inner system’s conversion knowledge with automated guidelines.
Concepts on how and why to combine Google Sheets with automated guidelines
For those who’re utilizing a Google Sheet to measure efficiency and to strategize your advert campaigns for the remainder of the month, quarter, or yr, right here’s some instance metrics you should use this integration to import to be used in automated guidelines:
- each day marketing campaign or advert set budgets
- goal cost-per-purchase by every marketing campaign, advert set, or advert
- goal return-on-ad-spend by every marketing campaign, advert set, or advert
In a Google Sheet, it’s also possible to pull in exterior knowledge to make use of in your automated guidelines. Right here’s a couple of extra concepts:
- buy knowledge from a database not related to Fb
- climate knowledge to intelligently regulate budgets on days in places with favorable climate circumstances related to your product (e.g. enhance finances on wet days for umbrellas)
- inventory market knowledge to activate/off advertisements to make sure related messaging with the day’s sentiment
- Shopify or Google Analytics knowledge to regulate budgets primarily based on at present’s conversion charges
The way it works
You may combine Google Sheets with automated guidelines by making a customized metric. You’ll see a brand new hyperlink within the customized metric toolbar, “Google Sheets.”
This hyperlink will assist you to paste a Google Sheets sharing hyperlink to combine that spreadsheet to Revealbot. You have to to have the ability to add one column of merchandise IDs and one column of values. Use our template to help you get started.
Ensure to pick out “Anybody with the hyperlink” within the Sheets’ sharing settings for Revealbot to learn your spreadsheet.
You may then describe the kind of merchandise you’ll be utilizing from the spreadsheet, a marketing campaign, advert set, or advert worth. This choice gained’t have any sensible impact, however it would function a useful reminder for what the worth is for.
After making your value-type choice, you’ll be able to then select the person sheet that accommodates the info you’re on the lookout for, the column containing the belongings’ IDs, and their corresponding values.
As soon as you chose the whole lot, clicking the “Add” button will place a Google Sheets “variable” within the customized metric builder. From right here, you’ll be able to add any further calculations to type your customized metric, or preserve it as is that if all of the calculations are achieved contained in the spreadsheet.
For instance, if I needed to drag in adjusted marketing campaign budgets from my spreadsheet, I might go away my Google Sheets variable as is and provides it an acceptable title.
Then clicking the “Create metric” button will put it aside as a customized metric you should use in automated guidelines. For those who haven’t used customized metrics earlier than or want a refresher, try our article on the way to use customized metrics in Fb advert automated guidelines.
With our Google Sheets integration for Fb automated guidelines, the chances for automation simply went up a couple of notches.
How will you utilize this as your subsequent aggressive benefit?