Pipeline Reports

Your numbers in Google Sheets, Looker Studio or Excel

Feeds are secret links to your reports' data. They carry record ids, dates, numbers and the names of reps, pipelines, stages, calendars and sources. Never your customers' names, emails or phone numbers.

Google Sheets: one formula (Pro and Plus)

  1. In Pipeline Reports, open Feeds and create a key. Copy the formula for the dataset you want.
  2. In Google Sheets, click cell A1 and paste it. It looks like =IMPORTDATA("…/deals.csv?key=…&range=last_90_days").
  3. The sheet fills in. Google refreshes it about once an hour; you don't need to do anything.

Change range=last_90_days to any of: last_7_days, last_30_days, this_month, last_month, this_quarter, last_quarter, year_to_date. Or use from=2026-01-01&to=2026-03-31. A feed returns up to 50,000 rows; a longer range shows a clear message instead of cutting rows off. Each key allows 60 requests an hour.

Looker Studio (Plus)

  1. Open the Pipeline Reports connector link from the Feeds page, and authorize it.
  2. When it asks for a key, paste a feed key.
  3. Pick a dataset and click Connect. Looker's own date control sets the range.

Excel or anything that reads CSV (every plan)

Every table in Pipeline Reports has a Download CSV link, on every plan. On Pro and Plus, Excel can also load a feed link directly: Data → From Web, then paste the feed's CSV link.

Datasets

Deals deals

One row per deal created, won or lost in the range. Close date follows your close-month setting.

  • deal_id · The deal's record id in your CRM.
  • pipeline · Pipeline name.
  • stage · Current stage name.
  • status · open, won, lost or abandoned.
  • rep · The user the deal is assigned to.
  • value · Deal value in dollars (at the win, or current: your setting).
  • created_date · Day the deal was created.
  • close_date · Day it closed as won (first close by default).
  • lost_date · Day it was lost, if lost.
  • lost_reason · The CRM's lost reason, when given.
  • lead_source · The contact's lead source.
  • campaign · UTM campaign (first or last touch: your setting).
  • close_date_estimated · True for deals from before install, dated from the CRM's last status change.

Stage moves stage_moves

One row per move between stages (or pipelines) in the range.

  • deal_id · The deal's record id in your CRM.
  • date · Day of the move.
  • moved_at · Time of the move (account timezone).
  • pipeline · Pipeline moved into.
  • from_stage · Stage it left (blank when it started here).
  • to_stage · Stage it entered.
  • rep · Who the deal was assigned to at the move.
  • skipped_stages · How many stages the move jumped over.
  • backward · True when it moved back to an earlier stage.
  • estimated · True when the move was inferred (backfill or catch-up), not seen live.

Daily activity by rep activity_daily

One row per day per rep with any activity. Connected = answered and long enough (your setting).

  • date · Day (account timezone).
  • rep · Rep name (Unassigned for calls with no user).
  • dials · Outbound calls by people.
  • connected · Answered and at least the connected seconds.
  • voicemails · Calls that reached voicemail.
  • no_answer · Calls nobody answered.
  • talk_seconds · Seconds on connected calls.
  • texts · Texts sent by a person.
  • emails · Emails sent by a person.
  • inbound_answered · Inbound calls a rep answered.

Calls calls

One row per call (outbound by people, and inbound) in the range.

  • call_id · The call's record id in your CRM.
  • date · Day (account timezone).
  • hour · Hour of day, 0–23 (account timezone).
  • rep · Who made or answered it (Unassigned when none).
  • direction · outbound or inbound.
  • outcome · connected, short, voicemail, no_answer, busy, failed, answered_inbound or missed_inbound.
  • seconds · Call length.
  • crm_says_completed · What the CRM's own dashboard would count as completed.

Appointments appointments

One row per appointment booked or starting in the range.

  • appointment_id · The appointment's record id in your CRM.
  • calendar · Calendar name.
  • rep · Assigned user.
  • booked_date · Day it was booked.
  • start_date · Day of the appointment.
  • status · booked, confirmed, showed, noshow or cancelled.
  • lead_source · The contact's lead source.

Leads leads

One row per lead created in the range, with attribution and speed to lead. No names, emails or phones.

  • lead_id · The contact's record id in your CRM (no other contact data).
  • created_date · Day the lead came in.
  • lead_source · The contact's lead source.
  • utm_source · First or last touch (your setting).
  • utm_medium · First or last touch.
  • utm_campaign · First or last touch.
  • utm_content · First or last touch.
  • first_response_minutes · Minutes to the first call, text or email by a person.
  • first_response_rep · Who answered first.
  • first_response_channel · call, sms or email.
  • contacted · False when no person has reached out yet.

Goals and progress goals

One row per monthly goal for months in the range: target, actual so far, % and pace.

  • month · YYYY-MM.
  • goal · What's measured.
  • pipeline · Blank for the whole business.
  • target · Dollars for revenue, a count otherwise.
  • actual · So far (same count as the report).
  • percent · Actual ÷ target.
  • projected · So far ÷ days gone × days in the month.

Daily summary summary_daily

One row per day: the headline numbers, the same as the Overview for that day.

  • date · Day (account timezone).
  • leads · Leads created that day.
  • deals_won · Deals closed as won that day (net of won-then-lost).
  • revenue_won · Dollars won that day.
  • deals_lost · Deals lost that day.
  • dials · Outbound calls by people.
  • connected · Answered and long enough.
  • talk_seconds · Seconds on connected calls.
  • texts · By a person.
  • emails · By a person.
  • appts_booked · Created that day.
  • appts_showed · Starting that day and showed.
  • appts_noshow · Starting that day and no-show.

Lost a key, or think someone else has it? Revoke it on the Feeds page and make a new one. Questions: hello@goldstandardweb.com