If you manage advertising across multiple Facebook ad accounts -- for different brands, regions, or clients -- Datadrew supports connecting more than one ad account to a single Shopify store. This article explains how multi-account connections work and how to set them up.
How multiple ad accounts work in Datadrew
Each Facebook Ads connection in Datadrew is tied to a specific ad account. You can connect multiple ad accounts by repeating the connection process. Each connected account gets its own data pipeline and appears as a separate integration in your settings.
When you view your Ads dashboard or Blended Metrics, Datadrew aggregates data across all connected Facebook ad accounts by default. You can also filter by individual ad accounts where supported.
Connecting additional ad accounts
Go to Settings > Integrations in Datadrew.
Find the Facebook Ads section. You will see your existing connected account(s) listed.
Click Add Account or Connect Another.
The Facebook OAuth window will open. If you need to connect an ad account under a different Facebook profile, sign out of Facebook first.
Authorize Datadrew and select the additional ad account(s) you want to connect.
Click Confirm. A new data pipeline will be created for each selected account.
Using a Business Manager account
If you use Meta Business Manager, Datadrew will automatically detect all ad accounts accessible through your Business Manager profile. During the account selection step, you will see:
The ad account name and ID
The Business Manager (owner) that each account belongs to
The account status (active, disabled, etc.)
This makes it easy to connect multiple accounts in a single authorization flow -- just select all the accounts you need and confirm.
Important considerations
Same currency recommended -- For the most accurate blended metrics, we recommend connecting ad accounts that use the same currency as your Shopify store. Datadrew does not perform currency conversion.
Separate data pipelines -- Each connected ad account has its own sync schedule and data pipeline. If one account encounters an error, it will not affect the others.
Token sharing -- If multiple ad accounts are connected via the same Facebook profile, they share the same OAuth token. If that token expires or is revoked, all accounts tied to it will need to be reconnected.
Disconnecting one account -- You can disconnect individual ad accounts without affecting the others. Go to Settings > Integrations, find the specific account, and click Disconnect.
Drew AI and multiple accounts
Drew AI is aware of all your connected Facebook ad accounts. You can ask questions like:
"Compare ROAS across my Facebook ad accounts"
"Which ad account had the highest spend last month?"
"Show me campaign performance for [account name]"
Drew AI uses both historical data (from your synced data warehouse) and live data (via the MCP gateway) to answer these questions.
Need help? Contact us at support@datadrew.io.
Related articles
Need help?
If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.