Integration

Adjust to Google Sheets reporting automation

Stop exporting Adjust data and pasting it into Google Sheets by hand. Opera reads your existing sheet, appends the right numbers to the right rows, and keeps it current.

Yes — you can automate Adjust reporting in Google Sheets without exporting anything or breaking a formula. Opera reads your existing sheet, pulls installs (attributed), skan conversions (ios), sessions & events at your grain, and appends each period to the right rows on a schedule you set.

What you can pull from Adjust

Opera pulls at the exact grain you report on and uses your KPI definitions, not generic defaults.

What you can pull
MetricsInstalls (attributed), SKAN conversions (iOS), Sessions & events, Cohorts & retention, Revenue
Grainnetwork, campaign, geo and date
DestinationYour existing Google Sheets — append-only, formulas preserved
CadenceDaily, weekly or monthly

How the pull actually works

Report Service API — aggregated KPIs (installs, sessions, events, revenue) by network, campaign, geo and day.

Raw event exports — event-level data via callbacks or CSV export for counting specific conversion events.

Attribution windows and click/impression de-duplication settings directly move install counts — Opera reads them rather than assuming defaults.

Source mechanics
Account modelPer app token; pulls scoped per app, with environment (production/sandbox) respected
Example pullLast 7 days · network = Meta + TikTok · event = purchase → installs and events by campaign

Filters that make the numbers client-correct

A correct pull is mostly correct filtering. Opera applies this client's rules on every run — not whoever-exported-it's defaults:

date rangecountrynetwork / partnercampaignevent token

Date ranges resolve in the right timezone, campaign prefixes scope to the right market, and event names match this client's taxonomy exactly.

The manual Adjust workflow today

Every cycle, someone exports Adjust, reshapes the columns, finds the right week, pastes it in, fixes formatting, and hopes no formula broke. It's an hour lost on every report, every client, every week.

"Update last week's report with installs (attributed), skan conversions (ios), sessions & events from Adjust, by channel."

How Opera updates your Google Sheets

Opera reads your sheet's structure first — tabs, headers, weekly blocks, monthly sections — then appends the new data to the right row. Formulas are extended, never overwritten; writes are append-only by default.

Attribution settings have to match your platforms

Adjust splits standard attribution from SKAN much like AppsFlyer, and its click- vs impression-based attribution and de-duplication windows directly move install counts. If Adjust's attribution windows don't match how Meta, Google and TikTok credit conversions, your installs won't reconcile — so align the settings first, then automate.

Spend and installs that actually tie out

Adjust attributes installs and events its own way; your ad platforms report their own spend and conversions. Opera builds the reconciliation into the report — both sides side by side — so blended CAC and ROAS stay honest and the variance is visible, not buried.

What one refresh writes

Illustrative — the structure of one appended week, not real figures.

Week Installs CPI New customers CAC D7 ROAS
Wk 23 12,480 $1.84 1,910 $12.02 0.71
Wk 24 13,205 $1.79 2,070 $11.41 0.78
Bottom line

Opera turns the weekly Adjust export into a scheduled job that keeps your existing Google Sheets current and reconciled — so your team spends its time on decisions, not data entry.

Rolling it out

Implementation checklist
Connect Adjust and share the target Sheet (view access is enough to map it)
Confirm the mapping — Opera shows you the tabs, sections and columns it detected
Run once with preview — review the diff of exactly what will be appended
Schedule it — pick the cadence and the Slack/email channel for the summary

Schedule it and forget it

Run it daily, weekly or monthly. Opera refreshes the data, updates the sheet, and posts a Slack or email summary — without anyone touching an export again.

Safe enough for production

Opera is built to touch production reports and live ad accounts without breaking anything:

  • No destructive writes. Updates are append-only by default — your existing data and formulas are never overwritten.
  • Preview before execution. You see exactly what Opera will change before a single cell is written.
  • Campaigns paused by default. New campaigns are created paused, with approvals required before any spend.
  • Full audit logs and client-level isolation. Every action is logged, and each client's data and rules stay separate.

See this running on your own reports.A 45-minute workflow audit maps your current process and shows exactly what Opera automates — step by step.

Frequently asked questions

Will Opera overwrite my formulas?
No. Opera appends to the right rows; formulas are extended, not replaced. Writes are append-only by default.
How does it handle Adjust's attribution quirks?
Adjust splits standard attribution from SKAN much like AppsFlyer, and its click- vs impression-based attribution and de-duplication windows directly move install counts. If Adjust's attribution windows don't match…
Which Adjust metrics are supported?
Installs (attributed), SKAN conversions (iOS), Sessions & events, Cohorts & retention, Revenue — at the grain you report on (network, campaign, geo and date).
Do I need to migrate my reports?
No. Opera works inside the Google Sheets you already use — no template, no rebuild.

Watch Opera run a real workflow, end to end.

Three minutes: a plain-language request, a Sheet schema read, an AppsFlyer pull, a previewed append, a Slack summary — then a paused campaign launch.