Google Ads + Orcabase
See which Google Ads bring customers who stay.
Google Ads tells you about clicks and conversions. Orcabase tells you which campaigns bring customers who come back and pay. Sync Google Ads through Fivetran and ask in plain words, next to your orders and payments.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which campaigns brought customers who stayed?
Brand search brings the most loyal customers: 48% ordered again within 90 days.
- Shopping brings more first orders, but only 21% of those customers came back.
- A customer from brand search cost $14; from shopping, $23.
- Generic “coffee subscription” searches cost the most: $38 a customer.
Ordered again within 90 days, % by campaign
How I got this· 4 steps
- Looked at your Google Ads campaigns and clicks
- Matched ad clicks to first orders
- Checked who ordered again within 90 days
- Divided each campaign’s spend by its new customers
Example answer. Numbers are illustrative.
In plain words
How do I see the real return on Google Ads?
Google Ads reports the conversions it can see, counted its own way. The real question is what those customers were worth. Fivetran copies your campaigns, search terms, spend and conversions into a database Orcabase hosts for you, next to your orders.
Then ask “which campaigns bring customers who order again?” and the agent puts spend and revenue side by side, with the chart and the steps it took.
Ask in plain words
What you can ask about your Google 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 each campaign last month?
Which search terms bring customers, and which only bring clicks?
What does a new customer from Google Ads cost us?
Which campaigns bring customers who order again?
Which keywords should we stop paying for?
How did cost per click change this quarter?
Which devices convert best?
Show me spend and revenue by week, side by side.
What comes in
Your Google Ads data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Campaigns and ad groups
Spend and clicks
Keywords and search terms
Conversions
Ads
Devices and places
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 Google 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.
90-day customer value
What a campaign’s new customers spent in their first 90 days.
Cost per click
Spend divided by clicks.
Dashboards to start with
Your Google Ads numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Google Ads
4 charts- Spend by campaign
- Cost per new customer
- Top search terms
- Click-through rate
Paid growth
3 charts- Spend vs revenue by week
- Return on ad spend
- 90-day value by campaign
Better together
Ask across Google 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 Google Ads, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Google Ads. Pick the database to sync into.
- 2
Connect Google Ads on Fivetran’s page
Sign in with Google on Fivetran’s page and choose the Google Ads accounts to sync.
- 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 Google Ads data.
What you’ll need
- A Google account with access to your Google Ads account, and its customer ID.
- A Google Ads manager account linked to yours, if Fivetran asks for one. Google requires it for API access, and it’s free.
- 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.
Will conversions match what Google Ads shows?
Why might I need a manager account?
Can Orcabase change my bids or budgets?
Do I need a Fivetran account?
How fresh is my Google Ads data in Orcabase?
What does syncing cost?
Your Google Ads data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.