Pacing Console docs

Export to CSV and Google Sheets

Available onFirst month freeProEnterprise

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.

Download a CSV

  1. Open Export
    On Pacing, press Export.
  2. Choose the rows
    Press 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

  1. Create the address
    In Export, press Create live sheet address. Owners and editors can do this.
  2. Paste the formula
    Press Copy formula and paste it into cell A1 of any Google Sheet. It looks like =IMPORTDATA("https://pacing.planconversion.com/api/export.csv?t=...").
  3. Let it refresh
    Google refreshes the data on its own, about every hour.
  4. Replace or turn it off
    Press 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.

Was this page helpful? If something is missing, unclear or wrong, tell our support team.

Last updated