Google Sheets exports
Stop exporting Display & Video 360 to CSV every Monday
Datanable keeps a range in your spreadsheet connected straight to your Display & Video 360 tables in BigQuery. Open the sheet, it's already up to date, no download, no copy-paste, no broken pivot table.
Display & Video 360Google Sheets
Who this is for
Three ways teams use Display & Video 360 in Sheets
Weekly reportingA recurring deck or client report that pulls this week's Display & Video 360 numbers automatically, no manual refresh.
Combining with manual dataPut Display & Video 360 numbers next to data you enter by hand, targets, budgets, notes, in the same sheet.
Ad hoc pivot tablesDrop a pivot table on top of the Display & Video 360 range to slice by campaign, date, or account without asking for a new export.
Set it up once
1.Sign in to Display & Video 360 through Datanable
2.Select the accounts to fetch
3.Create a Google Data Share
4.Insert a connected sheet from the BigQuery table
Why the range stays correct
✓The range refreshes on the same schedule as your BigQuery tables, no manual pull
✓History doesn't get truncated when the sheet grows past a few thousand rows
✓Renamed or merged Display & Video 360 accounts don't silently drop out of the range
✓Anyone with the sheet sees the same numbers as the dashboard, same source table
Without third-party connectors
Instant integrations
Display & Video 360 to Google Sheets: FAQ
Will this break like IMPORTRANGE does on large datasets?
No. IMPORTRANGE reads a live range and slows down as it grows; Datanable's connected range reads from a table sized for exactly the Display & Video 360 history you need.
Can I share the sheet without giving away my Display & Video 360 login?
Yes. Access is controlled through a Google Data Share tied to the reader's own Google account, not your source credentials.
What happens if I add more accounts later?
New accounts appear as new rows in the same table; existing ranges and formulas keep working.
Can I build a pivot table or chart directly on the range?
Yes, it behaves like any normal range of cells, pivot tables, QUERY formulas, and charts all work on it.
What is Display & Video 360?
Display & Video 360 is a Google advertising platform that enables businesses to plan, execute, and measure digital advertising campaigns across display, video, and other digital formats, using powerful targeting and analytics tools.
Do I have to pay for a Data Warehouse?
No, we provide you with a Managed Data Warehouse that enables ultra-fast dashboards at no additional cost.
Can I use my own Data Warehouse?
Yes, with the Enterprise Plan. Please reach out to us through the contact form.
Do I need a Data Engineer or a Data Analyst to use Datanable?
No, Datanable is a no-code platform, offering powerful Data Engineering capabilities to everyone.
Where is Datanable based?
Datanable is based in France.
See it running on your own accounts.
Seven days free, no credit card required. Connect your first source in a few minutes.