Revealbot + Google Sheets: Use external data in automated rules

With Revealbot’s Google Sheets integration, you can now use external data and values from a spreadsheet in your automated rules.

This integration is perfect for customers who use Google Sheets for analyzing performance, forecasting, and calculating budget allocation and want to use that data to inform their rules.

It’s also great for customers who want to use their internal system’s conversion data with automated rules.

Ideas on how and why to integrate Google Sheets with automated rules

If you’re using a Google Sheet to measure performance and to strategize your ad campaigns for the rest of the month, quarter, or year, here’s some example metrics you can use this integration to import for use in automated rules:

• daily campaign or ad set budgets
• target cost-per-purchase by each campaign, ad set, or ad
• target return-on-ad-spend by each campaign, ad set, or ad

In a Google Sheet, you can also pull in external data to use for your automated rules. Here’s a few more ideas:

• purchase data from a database not connected to Facebook
• weather data to intelligently adjust budgets on days in locations with favorable weather conditions relevant to your product (e.g. increase budget on rainy days for umbrellas)
• stock market data to turn on/off ads to ensure relevant messaging with the day’s sentiment
• Shopify or Google Analytics data to adjust budgets based on today’s conversion rates

How it works

You can integrate Google Sheets with automated rules by creating a custom metric. You’ll see a new link in the custom metric toolbar, “Google Sheets.”

This link will allow you to paste a Google Sheets sharing link to integrate that spreadsheet to Revealbot. You will need to be able to upload one column of item IDs and one column of values. Use our template to help you get started.

Make sure to select “Anyone with the link” in the Sheets’ sharing settings for Revealbot to read your spreadsheet.

You can then describe the type of item you’ll be using from the spreadsheet, a campaign, ad set, or ad value. This selection won’t have any practical effect, but it will serve as a helpful reminder for what the value is for.

After making your value-type selection, you can then choose the individual sheet that contains the data you’re looking for, the column containing the assets’ IDs, and their corresponding values.

Once you selected everything, clicking the “Add” button will place a Google Sheets “variable” in the custom metric builder. From here, you can add any additional calculations to form your custom metric, or keep it as is if all the calculations are done inside the spreadsheet.

For example, if I wanted to pull in adjusted campaign budgets from my spreadsheet, I could leave my Google Sheets variable as is and give it an appropriate name.

Then clicking the “Create metric” button will save it as a custom metric you can use in automated rules. If you haven’t used custom metrics before or need a refresher, check out our article on how to use custom metrics in Facebook ad automated rules.

With our Google Sheets integration for Facebook automated rules, the possibilities for automation just went up a few notches.

How will you use this as your next competitive advantage?