Meta Ads + Orcabase
Find the Meta ads that actually pay off.
Sync your Facebook and Instagram ads through Fivetran and see spend, reach and results next to your real orders. Ask which ads bring customers who stay, and which are wearing out, in plain words.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which ads are wearing out?
Two ads are wearing out: people have seen them 4 times, and clicks are down 37%.
- Together they spent $610 last week.
- The morning-ritual video is still fresh: seen twice on average, clicks steady.
- New customers from Meta cost $19 each in August.
Click rate of the two tired ads, % by week
How I got this· 4 steps
- Looked at your Meta ads and daily results
- Tracked each ad’s frequency and click rate
- Flagged ads seen often with falling clicks
- Added up what they spent last week
Example answer. Numbers are illustrative.
In plain words
How do I measure Facebook and Instagram ads against real sales?
Meta reports the results it attributes to your ads, by its own rules. Orcabase puts your ad spend, reach and results next to your actual orders and payments, synced through Fivetran into a database Orcabase hosts for you.
Ask “which ads bring customers who order again?” or “which ads are wearing out?” and get the answer with a chart.
Ask in plain words
What you can ask about your Meta Ads data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
What did we spend on Facebook and Instagram last month?
Which ads bring customers who order again?
Which ads are wearing out?
What does a new customer from Meta cost us?
Do Instagram or Facebook placements do better for us?
Which age groups and countries buy most?
Which campaigns should get more budget?
Show me spend and new customers by week.
What comes in
Your Meta Ads data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Campaigns, ad sets and ads
Spend and delivery
Clicks and results
Creative
Placements
Audiences
Numbers worth defining
Define them once. Every answer agrees.
Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Meta Ads data.
Cost per new customer
Ad spend divided by the first orders it brought in.
Return on ad spend
Revenue from ad-driven orders divided by ad spend.
Frequency
How many times, on average, each person saw an ad.
Click-through rate
Link clicks divided by impressions.
Dashboards to start with
Your Meta Ads numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Meta Ads
4 charts- Spend by campaign
- Frequency and click rate
- Results by placement
- Cost per new customer
Creative
3 charts- Top ads by return
- Ads wearing out
- New vs repeat customers by ad
Better together
Ask across Meta Ads and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect Meta Ads, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Meta Ads. Pick the database to sync into.
- 2
Connect Meta Ads on Fivetran’s page
Sign in with Facebook on Fivetran’s page, then sync all your ad accounts or just some.
- 3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
- 4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Meta Ads data.
What you’ll need
- A Facebook login with access to your ad accounts in Ads Manager.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- How it connects
- Synced by Fivetran
- How fresh
- Every 6 hours, as standard.
- Where your data lives
- A copy in a database Orcabase hosts for you, with its own folder for each app.
- Who can set it up
- An admin in your organization.
- Your login
- You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
- Cost
- Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.
Does it include Instagram ads?
Why don’t Meta’s purchases match our orders?
Do I need a Fivetran account?
How fresh is my Meta Ads data in Orcabase?
What does syncing cost?
Your Meta Ads data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.