Download this month's pacing as a CSV, copy it into a new Google Sheet, or create a private address that keeps a Google Sheet up to date about every hour.
On this page
Download a CSV
- Open ExportOn Pacing, press Export.
- Choose the rowsPress Download CSV (N shown) for the rows on screen, with your filters and sort, or Download CSV (all N) for every campaign.
The file opens in Excel, Numbers and Google Sheets. Its columns are: Campaign, Channel, Client, Account, Schedule, Budget, Spend, Expected, Pace %, Projected, Projected vs budget, Daily to hit, Daily set, Conversions, Cost per conversion, Forecast conversions, Target CPA, Status and Updated (ISO time).
Copy to Google Sheets
Press Copy to Google Sheets. The rows shown are copied and a new Google Sheet opens. Click cell A1 and paste.
Keep a Google Sheet up to date
- Create the addressIn Export, press Create live sheet address. Owners and editors can do this.
- Paste the formulaPress Copy formula and paste it into cell A1 of any Google Sheet. It looks like
=IMPORTDATA("https://pacing.planconversion.com/api/export.csv?t=..."). - Let it refreshGoogle refreshes the data on its own, about every hour.
- Replace or turn it offPress Replace address to issue a new one, or Turn off. Sheets that use the old address stop updating.
The live address is private and separate from the client report link. Anyone with it sees this month's pacing, so share the sheet, not the formula. In Excel, use Data, From web, with the address inside the quotes.
When the workspace is paused, the address returns a message that the workspace is paused instead of data.