Looker Studio dashboards,with your ClickFlare profit

Chart your ClickFlare revenue, cost and profit in Looker Studio, now called Data Studio, in the reports your team already shares. There is no native connector: the data comes from the ClickFlare API into a Google Sheet on a schedule you set, and the report reads it from there.

LS
Looker Studio
Google dashboards, now Data Studio

Looker Studio integration at a glance

How it connects
ClickFlare API into a Google Sheet, or a community connector
What syncs
Visits, clicks, conversions, revenue, cost and profit
How fresh the data is
On the schedule you set, for example hourly or daily
What you can optimize
Campaigns, traffic sources, countries and devices by profit
Works with
Data Studio reports built on Google Sheets
Good to know
No native connector. Looker Studio is now called Data Studio.
BI & dashboards
Profit in shared reports
Scheduled refresh

Your ClickFlare numbers in the reports you share

One report the whole team reads

Revenue, cost and profit by day and campaign sit in a Data Studio report you already share, so clients and teammates see results where they look.

Late conversions on the right day

Each run rewrites the last 30 days, so conversions that arrive days after the click still land on the right day.

Pick the date range in the report

With a community connector, the report asks ClickFlare for data when it loads, using the date range the viewer picks.
How it works

From ad click to profit per campaignattributed revenueattributed salesa matched conversionautomated actionyour dashboardsclosed revenue

01
Your ad
Visitor clicks
Ad on Looker Studio
02
ClickFlare
Click recorded
Every click gets its own ID
03
Your offer
Conversion
Lead, sale or custom event
04
ClickFlare
Sent back to Looker Studio
Through the Conversion API or postback
05
Cost API
Spend pulled in
Looker Studio cost matched to each campaign
01
Your ad
Looker Studio click
Placement, device and country come along
02
ClickFlare
Click recorded
Zone, site and device data stored
03
Offer or lander
Visitor converts
On your page or the offer
04
ClickFlare
Conversion logged
With payout and event type
05
Postback
Reported to Looker Studio
So its optimization sees the result
01
Your ad
Visitor clicks
Any traffic source
02
ClickFlare
Click recorded
Every click gets its own ID
03
Your article
Keyword block
Click ID passed to the feed
04
Results page
Paid click
Conversion fired to ClickFlare
05
Looker Studio API
Revenue matched
Pulled on a schedule and reconciled
01
Your ad
Visitor clicks
Any traffic source
02
ClickFlare
Click recorded
The click follows the visitor to the offer
03
Looker Studio
Offer or call
The network tracks the action
04
Looker Studio
Conversion
Lead, sale, call or rebill
05
Postback
Payout in ClickFlare
Matched to the original click
01
Your ad
Visitor clicks
Any traffic source
02
ClickFlare
Click recorded
Every click gets its own ID
03
Looker Studio
Store or funnel
Click ID kept through checkout
04
Events
View, cart, checkout
Each step tracked
05
ClickFlare
Purchase recorded
Order value matched to the ad
01
Your ad
Visitor clicks
Form, call or landing page
02
ClickFlare
Click recorded
Every click gets its own ID
03
Looker Studio
Lead or call stored
The ad stays linked to the lead
04
Looker Studio
Qualified or closed
Workflow or call rule fires
05
ClickFlare
Revenue recorded
Tied to the ad that drove it
01
ClickFlare
Event happens
Click, conversion or custom event
02
Webhook or API
Data goes out
Or comes back in
03
Looker Studio
Your workflow
Rules, apps or an AI assistant
04
Looker Studio
Action
Alert, update, pause or scale
05
ClickFlare
Back in reports
Changes show in your data
01
ClickFlare
Report data
Campaigns, sources, offers
02
ClickFlare API
Your numbers go out
Secured with your API key
03
Your setup
Scheduled refresh
A sheet, script or connector
04
Looker Studio
Data lands
Tables refreshed on schedule
05
Looker Studio
Dashboards
Blended with your other data
BI & dashboards

From your ClickFlare account to a Data Studio chart

A small script pulls your report data from the ClickFlare API into a Google Sheet on the schedule you set. Data Studio reads the sheet like any other source, so revenue, cost and profit refresh in your charts after every run.
  • Refreshes hourly or daily, as you choose
  • The last 30 days rewritten on every run
  • Your API key stays out of the sheet
Today, one campaign
example
Spend pulled from Looker Studio
cost
$412.30
Conversions recorded
today
38
Sent back to Looker Studio
per event
38/38
Profit
campaign
$227.70
Example numbers. Cost and conversions sit in the same report row.
ROI per placement
example
Placement A · mobile
cost
$38.20
Placement A
revenue
$71.40
Placement A
ROI
+87%
Placement B · desktop
ROI
−42%
Example numbers. Keep the placements that pay and cut the ones that lose money.
Revenue for one click
example
Paid click
day 0
$0.00
First revenue pull
+1h
$0.41
Scheduled updates
next days
$0.58
Final pull
last sync
$0.62
Example amounts. Sync timing for Looker Studio is in the facts above.
Events for one click
example
Lead
day 0
$0.00
Sale
day 0
+$40.00
Upsell
day 1
+$15.00
Refund
day 9
−$15.00
Example events. Each one arrives by postback and is matched to the click.
One visitor's path
example
Product view
step 1
—
Add to cart
step 2
—
Checkout
step 3
—
Purchase
step 4
$68.00
Example order. Each event is tied to the ad that brought the visitor.
One lead, followed to revenue
example
Lead created
day 0
$0.00
Qualified
day 2
+$25.00
Deal closed
day 14
+$480.00
Renewal
day 45
+$120.00
Example values. Each stage can be its own event type in ClickFlare.
A scheduled report refresh
example
Campaigns
in the report
1,240 rows
Cost, revenue, profit
per campaign
included
Refresh
your schedule
done
Dashboards fed
Looker Studio
3
Example numbers. You choose the breakdowns, date range and schedule.
One event, end to end
example
Conversion recorded
event
sent
Event delivered
Looker Studio
received
Workflow ran
Looker Studio
done
Team notified
your apps
done
Example run. What happens after the event is up to your workflow.
10
Breakdowns per pull
50,000
Rows per page
2.3B
Events tracked
Setup

Connected in three steps

You need a ClickFlare account with an API key, a Google account with Google Sheets, and Data Studio.
  1. Create a ClickFlare API key Generate a key in ClickFlare. It lets your sheet read your report data, so keep it private.
  2. Fill a Google Sheet from ClickFlare Add the ready-made script from the guide to a Google Sheet and set how often it runs. It pulls revenue, cost and profit by day and campaign.
  3. Build your Data Studio report Add the sheet as a data source and chart it. Your numbers refresh in the report after every scheduled run.
app.clickflare.com/integrations
LS
Looker Studio
BI & dashboards
Connected
Looker Studio account connected
Signed in from ClickFlare
Cost syncing
Spend matched to campaigns
Conversions sent back
Your chosen events
Looker Studio template selected
Macros pre-filled
Tracking URL in Looker Studio
Click ID captured
Conversions reported
Payout included where supported
Looker Studio connected
Credentials saved in ClickFlare
Conversion event set
Click ID passed to the feed
Revenue syncing
On the feed's schedule
Looker Studio added
Offer URL carries the click ID
Postback set in Looker Studio
Payout and event included
Conversions arriving
Matched to the click
Looker Studio connected
Click ID kept to checkout
Events mapped
View, cart, checkout, purchase
Purchases tracked
Order value in reports
Click ID stored in Looker Studio
Hidden field or call data
Workflow or rule set
Fires on the stage you choose
Conversions arriving
With payout and event type
API key created
Settings, then Security
Report pull scheduled
Dimensions and date range set
Looker Studio dashboards live
Refreshed on schedule
Connection set up
Webhook, API key or MCP
Events chosen
Only what the workflow needs
Workflow running
Tested end to end
Ready to track
The API key has the same access as your ClickFlare account. Keep it in the script's settings, never in a sheet cell.
Looker Studio setup guide
Open the guide
In your reports

What you see once it's connected

  • Revenue, cost and profit by day
  • Conversions per campaign
  • Revenue by traffic source
  • Breakdowns by country and device
  • Custom conversion columns
  • Results by your tracking fields
Use cases

How media buyers run it

Client-ready reports

Agencies share one Data Studio report per client, with the data limited to that client's ClickFlare workspace.

Daily profit board

Pull revenue, cost and profit by day and campaign into one board the whole team checks each morning.
Meta → article → RSOC

Social to search roll-up

Chart revenue and cost per ad, kept in a tracking field, to see which ads earn back their spend.
Frequently asked questions

Looker Studio integration FAQ

Does ClickFlare integrate with Looker Studio?

Yes, through the ClickFlare API. There is no native connector: report data flows into a Google Sheet on a schedule, or through a community connector, and Data Studio charts it.

Is Looker Studio now Data Studio?

Yes. Google renamed it back to Data Studio in April 2026, and existing reports keep working.

How often do the numbers refresh?

As often as you schedule the pull, for example hourly or daily. Each run brings in your data as it is in ClickFlare at that moment.

Should I use a Google Sheet or a community connector?

The Sheet is the simplest route. Choose a community connector when you want live date ranges in the report or want to share the connector with other people.

Why does yesterday keep changing?

Conversions can arrive days after the click, and cost can update. Each run re-pulls recent days, so the report catches up with ClickFlare.

Why don't my numbers match ClickFlare?

Use the same timezone, currency and conversion timing as the ClickFlare report you compare with, and work out ROI from totals instead of adding up ratios.

No items found.
Setup guides
Looker Studio setup guide
ClickFlare API overview
{"@context": "https://schema.org", "@graph": [{"@type": "FAQPage", "mainEntity": [{"@type": "Question", "name": "Does ClickFlare integrate with Looker Studio?", "acceptedAnswer": {"@type": "Answer", "text": "Yes, through the ClickFlare API. There is no native connector: report data flows into a Google Sheet on a schedule, or through a community connector, and Data Studio charts it."}}, {"@type": "Question", "name": "Is Looker Studio now Data Studio?", "acceptedAnswer": {"@type": "Answer", "text": "Yes. Google renamed it back to Data Studio in April 2026, and existing reports keep working."}}, {"@type": "Question", "name": "How often do the numbers refresh?", "acceptedAnswer": {"@type": "Answer", "text": "As often as you schedule the pull, for example hourly or daily. Each run brings in your data as it is in ClickFlare at that moment."}}, {"@type": "Question", "name": "Should I use a Google Sheet or a community connector?", "acceptedAnswer": {"@type": "Answer", "text": "The Sheet is the simplest route. Choose a community connector when you want live date ranges in the report or want to share the connector with other people."}}, {"@type": "Question", "name": "Why does yesterday keep changing?", "acceptedAnswer": {"@type": "Answer", "text": "Conversions can arrive days after the click, and cost can update. Each run re-pulls recent days, so the report catches up with ClickFlare."}}, {"@type": "Question", "name": "Why don't my numbers match ClickFlare?", "acceptedAnswer": {"@type": "Answer", "text": "Use the same timezone, currency and conversion timing as the ClickFlare report you compare with, and work out ROI from totals instead of adding up ratios."}}], "dateModified": "2026-11-12"}, {"@type": "BreadcrumbList", "itemListElement": [{"@type": "ListItem", "position": 1, "name": "Integrations", "item": "https://www.clickflare.com/integrations"}, {"@type": "ListItem", "position": 2, "name": "Analytics & BI", "item": "https://www.clickflare.com/integrations/analytics-bi"}, {"@type": "ListItem", "position": 3, "name": "Looker Studio"}]}]}