Building automated rules with attribution data using Google Sheets

Pull in attribution data to build automated rules using Revealbot’s Google Sheets integration.

As many of us are still struggling with the impact of the iOS 14.5 update, Revealbot is working on solutions to reduce the roadblocks due to these changes.

If you’ve started using an attribution tool to help you measure Facebook ad performance, then our Google Sheets integration can help you use that attribution data to build automated rules within Revealbot.

Why integrate external attribution data with automated rules?

If you’re unsure about using automated rules because of the data discrepancy caused by the iOS update, then our Google Sheets integration might be a good solution.

Because Facebook no longer provides certain data that once helped so many advertisers strategize ad campaigns, we’re seeing advertisers turn to alternative attribution solutions. Of course, even with 3rd-party attribution solutions in place, targeting prospects continue to be more challenging than ever before. Unfortunately, these solutions seem to be the best alternative to what was available.

How do you integrate external attribution data with Revealbot?

We’ve recently seen many customers relying on alternative attribution solutions and have been asking our team how to use that data when building their automations. With all of the requests, we’ve been diligently working on solutions to help bring attribution data into Revealbot so that they can be used when building automated rules.

This is where our Google Sheets Integration feature comes in. Currently, you can integrate your attribution data via Google Sheets with automated rules by creating a custom metric. You’ll see the integration link as a “Google Sheets” button in the custom metric toolbar.

This option allows you to paste a Google Sheets link and integrate that spreadsheet into Revealbot. You’ll be able to upload one column of item IDs and one column of values. We’ve also updated our feature so you can now use just a single value and not have to associate an ad id, adset id, or campaign id with your values. Use our template to help you get started.

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 of the value.

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 select everything, click the “Add” button to 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 want to pull in adjusted campaign budgets from my spreadsheet, I can leave my Google Sheets variable as is and give it an appropriate name.

Next, click the “Create metric” button to save it as a custom metric that 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, the possibilities for building automated rules with your attribution data for Facebook are endless.

Not using an attribution tool yet?

There are many attribution tools out there, but a few that we’ve seen our customers gravitate towards are Wicked Reports and Elevar. Each platform has its pros and cons - one may work better than the other depending on your needs. We’ve had lengthy discussions with both teams, and they are both extremely knowledgeable. If you’re more mobile-focused, then we’d suggest looking into a platform like Appsflyer. They’re one of the leaders in the mobile attribution space. Stay tuned as we’ll be releasing more features to help you seamlessly use your 3rd party attribution data in your Revealbot automated rules.