Articles in this section

See more

How to Request an Ad Hoc (One-Time) Export of Your Outreach Data

Avatar
Liliana N.
Updated
Follow

Objective

There are multiple ways to export data from Outreach, including Data Sharing through Snowflake, the Outreach API, and various reports within the Outreach app. Outreach can also provide customers one-off data export request capability. Please review our information regarding various use cases and request procedure when data extraction is needed from an Outreach instance. To make sure we provide you the data you are looking for, carefully review the below and help us identify exactly what you need.

Applies To 

  • Outreach Admins

One-Time Data Extraction Request Process FAQ

How should I submit a one-off data export request? 

Please open a ticket in our Support Portal.

Complete these form fields as follows:

  • Please choose your issue below: General Questions
  • Subject: One-off Data Export Request
  • Product Area: Data Platform

What should I put in the ticket Description? 

In order to make sure your request is matching your expectations and we don’t miss any details, please ensure to:

  • Describe exactly the use case behind this request so the team knows better how to help you.
  • Provide a granular list of objects/fields you are looking for.
  • [Optional but very helpful] Include screenshots from the reports pointing to exact numbers.

EXAMPLE: If you are looking for sequences data, specify if you’re looking for:

  • the sequence name and specifics per sequence (openCount per sequence, when sequence was created, etc.)
  • the sequence step details with intervals
  • mailings, calls, and tasks along with users involved in those sequences
  • etc. 

What data/tables can be extracted today? 

accounts mailings schedules
calendar_events meeting_fields sequences
calendar_event_attendees meeting_types sequence_states
calls messenger_conversations sequence_steps
call_dispositions messenger_messages sequence_templates
call_purposes opportunities smart_views
content_categories opportunity_prospect_roles snippets
content_category_memberships opportunity_stages stages
content_category_ownerships personas tags
custom_duties phone_numbers tasks
custom_validations profiles task_priorities
duties prospects teams
email_addresses recipients templates
events referral_predictions users
favorites return_date_predictions webhooks
mail_aliases roles  
mailbox_contacts rulesets  

 

What if there's something I need that's not in the provided list? 

We want to hear from you and validate if it is indeed missing. In your Support ticket, please indicate your need in detail.

What format can/will this data be returned in?

It is a compressed JSON file.

How will the data be delivered?

Once the data is extracted, the Outreach team will share a cloud storage file with the email address associated with your initial request. You will have 14 days to download the report. We will delete the folder after that time. 

What is the turnaround time?

Approximately 1 month.

Can I see a sample of the file, so I can understand the structure and whether I can work with it?

Absolutely! Here are two examples:

Data Extract for one Prospect record 
{
  "accountId": 1762,
  "addressCity": "Italy",
  "addressCountry": "Italy",
  "addressState": "Italy",
  "clickCount": 0,
  "createdAt": "2022-03-31 04:43:57.000000",
  "creatorId": 32,
  "creatorType": "Import",
  "customFieldsLong": "{\"custom1\":\"4354612000\",
    \"custom2\":\"3964352200\",
    \"custom3\":\"Engineering \\u0026 Technical\",
    \"custom5\":\"Owner\",
    \"custom6\":\"2021-08-01\"}",
  "engagedScore": 0,
  "firstName": "Kagan",
  "histogramDirty": 1,
  "histogramInbound1": 0,
  "histogramInbound10": 0,
  "histogramInbound11": 0,
  "histogramInbound12": 0,
  "histogramInbound2": 0,
  "histogramInbound3": 0,
  "histogramInbound4": 0,
  "histogramInbound5": 0,
  "histogramInbound6": 0,
  "histogramInbound7": 0,
  "histogramInbound8": 0,
  "histogramInbound9": 0,
  "histogramOutbound1": 0,
  "histogramOutbound10": 0,
  "histogramOutbound11": 0,
  "histogramOutbound12": 0,
  "histogramOutbound2": 0,
  "histogramOutbound3": 0,
  "histogramOutbound4": 0,
  "histogramOutbound5": 0,
  "histogramOutbound6": 0,
  "histogramOutbound7": 0,
  "histogramOutbound8": 0,
  "histogramOutbound9": 0,
  "id": 2205,
  "lastName": "Gorgosl",
  "linkedIn": "https://www.linkedin.com/in/xxxxx",
  "linkedInSlug": "xxxx",
  "openCount": 0,
  "replyCount": 0,
  "source": "Apollo",
  "timeZone": "Asia/Kolkata",
  "title": "Product owner",
  "updatedAt": "2022-03-31 04:43:57.000000",
  "updaterId": 32,
  "updaterType": "Import",
  "website": "http://www.test.com"
}

 

Data extract for sequenceState 
{
"activatedAt": "2022-07-06 09:10:50.000000",
"batchItemCreatorId": 26594,
"bounceCount": 0,
"callCompletedCount": 0,
"callNoAnswerCount": 0,
"clickCount": 0,
"createdAt": "2022-07-06 09:10:50.000000",
"creatorId": 3,
"creatorType": "User",
"deliverCount": 5,
"failureCount": 0,
"id": 4760,
"isTrashed": 0,
"mailboxId": 5,
"meetingBookedCount": 0,
"negativeReplyCount": 0,
"neutralReplyCount": 0,
"openCount": 4,
"optOutCount": 0,
"positiveReplyCount": 0,
"prospectId": 4856,
"replyCount": 0,
"scheduleCount": 0,
"sequenceId": 146,
"sequenceStepId": 1203,
"sequenceTemplateId": 1207,
"state": "finished",
"stateChangedAt": "2022-10-07 08:30:29.000000",
"stepEnteredAt": "2022-10-07 08:04:07.000000",
"updatedAt": "2022-10-08 00:00:40.000000",
"userId": 3
}



 









    

Related articles