Gravity
  • What is Gravity?
    • Jobs
      • Create Jobs
      • Update Jobs
  • Orchestration
    • Job Modes
    • Metadata
    • Logs
    • Allowing Gravity access to data behind a firewall
    • Core Concepts
  • Sources
    • Files Sources
      • Flattened Documents Model
      • Documents Model
      • SFTP
      • S3
    • Amazon Aurora MySQL
    • Adobe
    • Airtable
      • Setup Guide
      • Tables
        • SampleTable
        • SampleTable_Attachments
        • SampleTable_Collaborators
    • Amazon Aurora PostgreSQL
    • Amazon DynamoDB
    • Amazon RDS for MySQL
    • Amazon RDS for PostgresSQL
    • Amazon RDS for SQL Server
    • Amazon S3
      • Tables
        • Buckets
        • BucketsACL
        • BucketsAnalytics
        • BucketsCORS
        • BucketsInventory
        • BucketsLifecycle
        • BucketsReplication
        • Objects
        • ObjectsACL
        • PublicAccessBlock
    • AOL
    • Apache Kafka
    • AWIN
      • Setup Guide
    • Azure Database for MySQL
    • Azure Database for PostgreSQL
    • Amazon DocumentDB
      • Setup Guide
    • Azure for SQL
    • Azure Synapse
    • Big Commerce
      • Tables
        • Categories
        • Currencies
        • Customers
        • OrderItems
        • Orders
        • OrderShipments
        • PriceListRecords
        • PriceLists
        • ProductImages
        • ProductOptions
        • ProductOptionValues
        • ProductReviews
        • Products
        • ProductVariants
        • BlogTags
        • Brands
        • Coupons
        • CustomerAddresses
        • CustomerGroups
        • GiftCertificates
        • OrderCoupons
        • OrderMessages
        • OrderShippingAddresses
        • OrderStatuses
        • OrderTaxes
        • Pages
        • PaymentMethods
        • PriceListAssignments
        • ProductBulkPricingRules
        • ProductCustomFields
        • ProductRules
        • ProductSkus
        • ProductVariantValues
        • ProductVideos
        • Redirects
        • ShipmentItems
        • ShippingMethods
        • ShippingZones
        • Stores
        • TaxClasses
        • Blogposts
        • OrderItemOptionValues
    • BigQuery
      • Tables
        • Datasets
        • PartitionsList
        • PartitionsValues
        • Projects
    • Bing Ads
      • Tables
        • AccountPerformanceReport
        • Accounts
        • AdDynamicTextPerformanceReport
        • AdExtensionByAdReport
        • AdExtensionByKeywordReport
        • AdExtensionDetailReport
        • AdGroupPerformanceReport
        • AdGroups
        • AdPerformanceReport
        • Ads
        • AgeGenderAudienceReport
        • AudiencePerformanceReport
        • Audiences
        • BidOpportunities
        • BudgetOpportunities
        • Budgets
        • BudgetSummaryReport
        • CampaignPerformanceReport
        • Campaigns
        • ConversionPerformanceReport
        • DestinationUrlPerformanceReport
        • DSAAutoTargetPerformanceReport
        • DSACategoryPerformanceReport
        • DSASearchQueryPerformanceReport
        • GeographicPerformanceReport
        • GoalsAndFunnelsReport
        • KeywordDemographics
        • KeywordEstimatedBid
        • KeywordEstimatedPosition
        • KeywordHistoricalSearch
        • KeywordLocations
        • KeywordPerformance
        • KeywordPerformanceReport
        • Keywords
        • NegativeKeywordConflictReport
        • ProductDimensionPerformanceReport
        • ProductNegativeKeywordConflictReport
        • ProductPartitionPerformanceReport
        • ProductPartitionUnitPerformanceReport
        • ProductSearchQueryPerformanceReport
        • PublisherUsagePerformanceReport
        • SearchCampaignChangeHistoryReport
        • SearchQueryPerformanceReport
        • ShareOfVoiceReport
        • Tags
        • UserLocationPerformanceReport
    • Branch
      • Setup Guide
    • Bugsnag
    • Campaign Monitor
    • ClickUp
      • Setup Guide
    • Cloud SQL for MySQL
    • Cloud SQL for PostgreSQL
    • Cloud SQL for SQL Server
    • Convert Kit
    • CSV
    • Derby
    • Doordash
    • Elastic Search
    • Eventbrite
      • Setup Guide
      • Tables
        • AttendeeReport
        • Attendees
        • AttendeeTeams
        • Categories
        • CustomQuestions
        • DefaultQuestions
        • Discounts
        • DisplaySettings
        • Events
        • Formats
        • Orders
        • Organizations
        • Pricing
        • SalesReport
        • Subcategories
        • TicketClasses
        • TicketGroups
        • User
        • Venues
    • Exasol
    • Facebook Ads
      • Setup Guide
    • Facebook Page and Post Insights
    • Firebird
    • FreshDesk
      • Setup Guide
      • Tables
        • Agents
        • BusinessHours
        • CannedResponses
        • CannedResponsesFolder
        • Companies
        • Contacts
        • Conversations
        • Groups
        • Mailboxes
        • Products
        • Roles
        • SLAPolicies
        • TicketFields
        • Tickets
        • TimeEntries
    • FullStory
    • Github
    • Gmail
      • Gmail REST Data Model
        • Tables
          • Labels
          • Messages
          • SENT
          • Attachments
          • Filters
          • History
          • INBOX
          • Threads
          • Users
      • Gmail IMAP Data Model
        • Tables
          • MailMessages
    • Google Ads
      • AdWords Views
        • AccountPerformance
        • AdCustomizersFeedItem
        • AdGroupBidLandscape
        • AdgroupPerformance
        • AdGroups
        • AdPerformance
        • AgeRangePerformance
        • AudiencePerformance
        • AutomaticPlacementsPerformance
        • BidGoalPerformance
        • BudgetPerformance
        • CallMetricsCallDetails
        • CampaignAdScheduleTarget
        • CampaignCriteria
        • CampaignCriterionBidLandscape
        • CampaignGroupPerformance
        • CampaignLocationTarget
        • CampaignNegativeKeywordsPerformance
        • CampaignNegativeLocations
        • CampaignNegativePlacementsPerformance
        • CampaignPerformance
        • Campaigns
        • CampaignSharedSet
        • ClickPerformance
        • ConversionTrackers
        • CreativeConversion
        • CriteriaPerformance
        • CriterionBidLandscape
        • Customers
        • DisplayKeywordPerformance
        • DisplayTopicsPerformance
        • FinalUrl
        • GenderPerformance
        • GeoPerformance
        • KeywordlessCategory
        • KeywordlessQuery
        • KeywordsPerformance
        • Label
        • LandingPage
        • LocationCriterion
        • ManagedCustomers
        • ManagedCustomersLinks
        • MarketplacePerformance
        • PaidOrganicQuery
        • ParentalStatusPerformance
        • Placeholder
        • PlaceholderFeedItem
        • PlacementPerformance
        • ProductPartition
        • SearchQueryPerformance
        • SharedSet
        • SharedSetCriteria
        • ShoppingPerformance
        • TopContentPerformance
        • UrlPerformance
        • UserAdDistance
        • VideoPerformance
      • Google Ads Views
        • AccessibleBiddingStrategy
        • AccountBudget
        • AccountBudgetProposal
        • AccountLink
        • AdGroup
        • AdGroupAd
        • AdGroupAdAssetView
        • AdGroupAdLabel
        • AdGroupAsset
        • AdGroupAudienceView
        • AdGroupBidModifier
        • AdGroupCriterion
        • AdGroupCriterionLabel
        • AdGroupCriterionSimulation
        • AdGroupExtensionSetting
        • AdGroupFeed
        • AdGroupLabel
        • AdGroupSimulation
        • AdParameter
        • AdScheduleView
        • AgeRangeView
        • Asset
        • AssetFieldTypeView
        • BatchJob
        • BiddingDataExclusion
        • BiddingSeasonalityAdjustment
        • BiddingStrategy
        • BiddingStrategySimulation
        • BillingSetup
        • CallView
        • Campaign
        • CampaignAsset
        • CampaignAudienceView
        • CampaignBidModifier
        • CampaignBudget
        • CampaignCriterion
        • CampaignCriterionSimulation
        • CampaignDraft
        • CampaignExperiment
        • CampaignExtensionSetting
        • CampaignFeed
        • CampaignLabel
        • CampaignSharedSet
        • CampaignSimulation
        • CarrierConstant
        • ChangeEvent
        • ChangeStatus
        • ClickView
        • CombinedAudience
        • ConversionAction
        • ConversionCustomVariable
        • ConversionValueRule
        • ConversionValueRuleSet
        • CurrencyConstant
        • CustomAudience
        • Customer
        • CustomerAsset
        • CustomerClient
        • CustomerClientLink
        • CustomerExtensionSetting
        • CustomerFeed
        • CustomerLabel
        • CustomerManagerLink
        • CustomerNegativeCriterion
        • CustomerUserAccess
        • CustomerUserAccessInvitation
        • CustomInterest
        • DetailedDemographic
        • DetailPlacementView
        • DisplayKeywordView
        • DistanceView
        • DomainCategory
        • DynamicSearchAdsSearchTermView
        • ExpandedLandingPageView
        • ExtensionFeedItem
        • Feed
        • FeedItem
        • FeedItemSet
        • FeedItemSetLink
        • FeedItemTarget
        • FeedMapping
        • FeedPlaceholderView
        • GenderView
        • GeographicView
        • GeoTargetConstant
        • GroupPlacementView
        • HotelGroupView
        • HotelPerformanceView
        • IncomeRangeView
        • KeywordPlan
        • KeywordPlanAdGroup
        • KeywordPlanAdGroupKeyword
        • KeywordPlanCampaign
        • KeywordPlanCampaignKeyword
        • KeywordThemeConstant
        • KeywordView
        • Label
        • LandingPageView
        • LanguageConstant
        • LifeEvent
        • LocationView
        • ManagedPlacementView
        • MediaFile
        • MobileAppCategoryConstant
        • MobileDeviceConstant
        • OfflineUserDataJob
        • OperatingSystemVersionConstant
        • PaidOrganicSearchTermView
        • ParentalStatusView
        • ProductBiddingCategoryConstant
        • ProductGroupView
        • Recommendation
        • RemarketingAction
        • Resources
        • SearchTermView
        • SharedCriterion
        • SharedSet
        • ShoppingPerformanceView
        • SmartCampaignSearchTermView
        • SmartCampaignSetting
        • ThirdPartyAppAnalyticsLink
        • TopicConstant
        • TopicView
        • UserInterest
        • UserList
        • UserLocationView
        • Video
        • WebpageView
    • Google Ad Manager
    • Google Analytics
      • UniversalAnalytics Data Model
        • Tables
          • Accounts
          • Goals
          • Profiles
          • Segments
          • UserActivity
          • WebProperties
          • AdSense
          • AdWords
          • Ecommerce
          • Events
          • Global_Access_Object
          • GoalCompletions
          • SiteContent
          • SiteSearch
          • SiteSpeed
          • Traffic
      • GoogleAnalytics4 Data Model
        • Tables
          • Accounts
          • Properties
          • PropertiesAndroidAppDataStreams
          • PropertiesFireBaseLinks
          • PropertiesGoogleAdsLinks
          • PropertiesIosAppDataStreams
          • PropertiesWebDataStreams
          • AccountSummaries
          • Acquisitions
          • ActiveUsers
          • Demographics
          • Engagement
          • Events
          • GamesReporting
          • MetaData
          • Monetization
          • Tech
    • Google Analytics 360
    • Google Analytics 4 (Beta)
    • Google BigQuery
    • Google Campaign Manager
      • Tables
        • CrossDimensionReachReport
        • Files
        • FloodlightReport
        • PathToConversionReport
        • ReachReport
        • Reports
        • StandardReport
        • UserProfiles
    • Google Cloud for MySQL
    • Google Cloud for PostgreSQL
    • Google Cloud for SQL Server
    • Google Cloud Storage
    • Google Display & Video 360
    • Google DoubleClick Bid Manager
    • Google DoubleClick Campaign Manager
    • Google Search Ads 360
    • Google Seach Console
    • Google Sheets
      • Setup Guide
    • HubSpot
      • Setup Guide
    • ICloud
    • Instagram
    • Intercom
      • Setup Guide
    • JIRA
      • Setup Guide
      • Tables
        • Attachments
        • Boards
        • Comments
        • Issues
        • IssueTypes
        • ProjectComponents
        • Projects
        • ProjectVersions
        • Roles
        • Sprints
        • Users
        • Worklogs
        • AdvancedSettings
        • ApplicationRoles
        • Audit
        • BoardConfiguration
        • BoardIssues
        • BoardSprints
        • Configuration
        • Dashboards
        • Epics
        • FavouriteFilters
        • Fields
        • Filters
        • Groups
        • IssueAffectedVersions
        • IssueChangelogs
        • IssueComponents
        • IssueCustomFieldOptions
        • IssueCustomFields
        • IssueFixVersions
        • IssueLinks
        • IssueLinkTypes
        • IssueNavigatorDefaultColumns
        • IssuePriorities
        • IssueResolutions
        • IssueSubtasks
        • IssueTransitions
        • MyPermissions
        • Permissions
        • ProjectCategories
        • ProjectRoles
        • ProjectsIssueTypes
        • ProjectTypes
        • RoleDetails
        • SecurityLevels
        • SecuritySchemes
        • SprintIssues
        • Statuses
        • TimeTrackingProviders
        • Votes
        • Watchers
        • Workflows
        • WorkflowStatusCategories
        • WorkflowStatuses
    • Klaviyo
      • Setup Guide
    • LinkedIn Ads
    • Linkedin Social
      • Tables
        • CompanyStatusUpdates
        • Comments
        • CompanyDetails
        • CompanyFollowerStatistics
        • CompanyList
        • CompanyLocations
        • CompanyPageStatistics
        • CompanyUpdateStatistics
        • Positions
        • Profile
    • Magento
      • Tables
        • BundleProductLinkChildren
        • BundleProductOption
        • CatalogAttributeSet
        • CatalogCategoryAttribute
        • CatalogCategoryAttributeOptionOptions
        • CatalogCategoryLinkProducts
        • CatalogProductAttribute
        • CatalogProductAttributeTypesList
        • CatalogProductLinkTypeList
        • CatalogProductTierPriceTiers
        • CatalogProductTypeList
        • CheckoutAgreementsCheckoutAgreements
        • CmsBlock
        • CmsPage
        • ConfigurableProductLinkChildren
        • ConfigurableProductOption
        • CustomerAccountBillingAddress
        • CustomerAccountShippingAddress
        • CustomerAddress
        • CustomerGroup
        • CustomerGroupDefault
        • Customers
        • DirectoryCountryInformationAcquirer
        • DirectoryCurrencyInformationAcquirer
        • DownloadableLink
        • DownloadableSample
        • EavAttributeSet
        • GiftMessageCart
        • GiftMessageGuestCart
        • GiftMessageGuestItem
        • GiftMessageItem
        • GuestBillingAddresses
        • GuestPaymentInformation
        • GuestPaymentMethods
        • GuestShippingMethods
        • Inventory
        • OrderComments
        • BillingAddresses
        • OrderItems
        • PaymentMethods
        • PaymentSelectedMethods
        • ProductAttributeGroup
        • ProductAttributeOptions
        • ProductAttributes
        • ProductCategories
        • ProductCustomOption
        • ProductMedia
        • Products
        • QuoteCart
        • QuoteCartItem
        • QuoteCartTotal
        • QuoteGuestCart
        • QuoteGuestCartItem
        • QuoteGuestCartTotal
        • SalesCreditmemo
        • SalesCreditmemoComments
        • SalesInvoice
        • SalesInvoiceComments
        • SalesRule
        • SalesRuleCoupon
        • SalesShipment
        • SalesShipmentComments
        • SalesTransaction
        • ShippingMethods
        • StoreGroup
        • Stores
        • StoreWebsite
        • TaxClass
        • TaxRate
        • TaxRule
    • MailChimp
      • Setup Guide
      • Tables
        • AuthorizedApps
        • AutomationEmailQueues
        • AutomationsRemovedSubscribers
        • CampaignFeedback
        • CampaignFolders
        • Campaigns
        • ConversationMessages
        • EcommerceCartLines
        • EcommerceCarts
        • EcommerceCustomers
        • EcommerceOrderLines
        • EcommerceOrders
        • EcommerceProducts
        • EcommerceProductVariants
        • EcommerceStores
        • FileManagerFiles
        • FileManagerFolders
        • ListInterestCategories
        • ListInterests
        • ListMemberEvents
        • ListMemberNotes
        • ListMembers
        • ListMemberTags
        • ListMergeFields
        • ListMemberTags
        • Page 4
        • ListMergeFields
        • ListSegmentMembers
        • Lists
        • ListSegments
        • ListSegmentMembers
        • ListSegments
        • ListsTwitterLeadGenCards
        • ListsWebhooks
        • TemplateFolders
        • Templates
        • AutomationEmails
        • Automations
        • CampaignOpenEmailDetails
        • Conversations
        • ListAbuse
        • ListActivity
        • ListClients
        • ListGrowthHistory
        • ListMemberActivity
        • ListSignupForms
        • ReportAbuse
        • ReportAdvice
        • ReportClickDetails
        • ReportClickDetailsMembers
        • ReportDomainPerformance
        • ReportEmailActivity
        • ReportLocations
        • Reports
        • ReportSentTo
        • ReportUnsubscribes
    • Marin
    • Messagebird
    • Microsoft Dynamics CRM
    • Microsoft SQL
    • Mixpanel
    • Mix Max
    • MongoDB
    • MySQL
    • Navisite - SQL Server
    • Odoo
    • Office 365
      • Tables
        • Calendars
        • Contacts
        • Conversations
        • Events
        • Files
        • Groups
        • Messages
        • Plans
        • Tasks
        • Users
        • CalendarView
        • EventOccurrences
    • Open Exchange Rates
      • Setup Guide
    • Oracle Database
    • Outlook
    • Pinterest
    • PostgreSQL
    • Product Hunt
    • QuickBooks (Online)
      • Tables
        • Accounts
        • AttachableRefs
        • Attachables
        • BillLineItems
        • BillLinkedTransactions
        • BillPaymentLineItems
        • BillPayments
        • Bills
        • BudgetDetails
        • Budgets
        • Class
        • CompanyCurrency
        • CompanyInfo
        • CreditMemoLineItems
        • CreditMemos
        • Customers
        • Departments
        • DepositLineItems
        • Deposits
        • Employees
        • EstimateLineItems
        • EstimateLinkedTransactions
        • Estimates
        • ExchangeRates
        • InvoiceLineItems
        • InvoiceLinkedTransactions
        • Invoices
        • Items
        • JournalCode
        • JournalEntries
        • JournalEntryLineItems
        • PaymentLineItems
        • PaymentMethods
        • Payments
        • Preferences
        • PurchaseLineItems
        • PurchaseOrderLineItems
        • PurchaseOrderLinkedTransactions
        • PurchaseOrders
        • Purchases
        • RecurringInvoiceTransactions
        • RecurringInvoiceTransactionsLineItems
        • RecurringJournalEntryTransactions
        • RecurringJournalEntryTransactionsLineItems
        • RefundReceiptLineItems
        • RefundReceipts
        • SalesReceiptLineItems
        • SalesReceipts
        • TaxAgency
        • Terms
        • TimeActivities
        • Transfers
        • VendorCreditLineItems
        • VendorCredits
        • Vendors
        • BalanceSheetSummaryReport
        • CreditCardPayments
        • CustomerBalanceDetail
        • CustomerTypes
        • Entitlements
        • GetDeletedAsView
        • RecurringBillTransactions
        • TaxCodes
        • TaxRates
        • Thresholds
    • Rakuten
    • Redshift
    • Restaurant365
    • REST API
    • REST OAUTH
    • Service Now
    • Salesforce
      • Tables
        • AcceptedEventRelation
        • Account
        • AccountContactRole
        • AccountFeed
        • AccountHistory
        • AccountPartner
        • AccountShare
        • AdditionalNumber
        • ApexClass
        • ApexComponent
        • ApexLog
        • ApexPage
        • ApexTestQueueItem
        • ApexTestResult
        • ApexTrigger
        • AppMenuItem
        • Approval
        • Asset
        • AssetFeed
        • AssignmentRule
        • AsyncApexJob
        • Attachment
        • AuthProvider
        • AuthSession
        • BrandTemplate
        • BusinessHours
        • BusinessProcess
        • CallCenter
        • Campaign
        • CampaignFeed
        • CampaignMember
        • CampaignMemberStatus
        • CampaignShare
        • Case
        • CaseComment
        • CaseContactRole
        • CaseFeed
        • CaseHistory
        • CaseShare
        • CaseSolution
        • CaseStatus
        • CaseTeamMember
        • CaseTeamRole
        • CaseTeamTemplate
        • CaseTeamTemplateMember
        • CaseTeamTemplateRecord
        • CategoryData
        • CategoryNode
        • ChatterActivity
        • ClientBrowser
        • CollaborationGroup
        • CollaborationGroupFeed
        • CollaborationGroupMember
        • CollaborationGroupMemberRequest
        • CollaborationInvitation
        • Community
        • Contact
        • ContactFeed
        • ContactHistory
        • ContactShare
        • ContentDocument
        • ContentDocumentFeed
        • ContentDocumentHistory
        • ContentDocumentLink
        • ContentVersion
        • ContentVersionHistory
        • Contract
        • ContractContactRole
        • ContractFeed
        • ContractHistory
        • ContractStatus
        • CronJobDetail
        • CronTrigger
        • Dashboard
        • DashboardComponent
        • DashboardComponentFeed
        • DashboardFeed
        • DeclinedEventRelation
        • Document
        • DocumentAttachmentMap
        • Domain
        • DomainSite
        • EmailServicesAddress
        • EmailServicesFunction
        • EmailTemplate
        • EntitySubscription
        • Event
        • EventFeed
        • EventRelation
        • FeedComment
        • FeedItem
        • FeedPollChoice
        • FeedPollVote
        • FieldPermissions
        • FiscalYearSettings
        • Folder
        • ForecastShare
        • Group
        • GroupMember
        • HashtagDefinition
        • Holiday
        • Lead
        • LeadFeed
        • LeadHistory
        • LeadShare
        • LeadStatus
        • LoginHistory
        • LoginIp
        • MailmergeTemplate
        • MobileDeviceRegistrar
        • Note
        • ObjectPermissions
        • Opportunity
        • OpportunityCompetitor
        • OpportunityContactRole
        • OpportunityFeed
        • OpportunityFieldHistory
        • OpportunityHistory
        • OpportunityLineItem
        • OpportunityPartner
        • OpportunityShare
        • OpportunityStage
        • Organization
        • OrgWideEmailAddress
        • Partner
        • PartnerRole
        • Period
        • PermissionSet
        • PermissionSetAssignment
        • PermissionSetLicense
        • PermissionSetLicenseAssign
        • Pricebook2
        • Pricebook2History
        • PricebookEntry
        • ProcessDefinition
        • ProcessInstance
        • ProcessInstanceStep
        • ProcessInstanceWorkitem
        • ProcessNode
        • Product2
        • Product2Feed
        • Profile
        • PushTopic
        • QueueSobject
        • Quote
        • QuoteDocument
        • QuoteFeed
        • QuoteLineItem
        • RecentlyViewed
        • RecordType
        • Report
        • ReportFeed
        • Scontrol
        • SelfServiceUser
        • SetupEntityAccess
        • Site
        • SiteFeed
        • SiteHistory
        • Solution
        • SolutionFeed
        • SolutionHistory
        • SolutionStatus
        • StaticResource
        • Task
        • TaskFeed
        • TaskPriority
        • TaskStatus
        • Topic
        • TopicAssignment
        • TopicFeed
        • UndecidedEventRelation
        • User
        • UserFeed
        • UserLicense
        • UserLogin
        • UserPreference
        • UserProfile
        • UserRecordAccess
        • UserRole
        • Vote
        • WebLink
        • Formulas
        • JobRecordResultsV2
        • PickListValues
        • TableRelationships
    • Salesforce Pardot
    • SAP ERP (Netweaver)
    • Search Ads 360
      • Setup Guide
    • SendGrid
      • Tables
        • Alerts
        • ApiKeys
        • Bounces
        • CancelScheduledSends
        • CustomFields
        • GlobalUnsubscribes
        • InvalidEmails
        • Lists
        • MarketingCampaigns
        • NMCCustomFields
        • NMCLists
        • NMCSegments
        • NMCSenders
        • NMCSingleSends
        • Recipients
        • Schedules
        • Segments
        • SenderIdentities
        • Spam
        • Teammates
        • UnsubscribeGroups
        • AdvancedStats
        • Categories
        • CategoryStats
        • GlobalStats
        • GroupSuppressions
        • IPAccessManagement
        • MessageEvents
        • Messages
        • Recipients
        • NMCReservedFields
        • ReservedFields
        • SubuserStats
        • Users
    • Setting up an E-mail Data Source
    • SFTP
    • SharePoint
      • SOAP Data Model
        • Tables
          • Announcements
          • Attachments
          • Calendar
          • Contacts
          • Documents
          • Groups
          • IssueTracking
          • Links
          • Pictures
          • Roles
          • Tasks
          • Users
          • Views
          • FileVersions
          • GetValidTerms
          • Lists
          • Permissions
          • Subsites
      • REST Data Model
        • Tables
          • Attachments
          • Files
          • Groups
          • Lists
          • RoleAssignmentMember
          • RoleAssignments
          • RoleDefinitionBindings
          • Roles
          • Subsites
          • Users
    • Shopify
      • Setup Guide
      • Tables
        • ApplicationCharges
        • ApplicationCredit
        • Articles
        • Assets
        • Blogs
        • CollectionListings
        • Collects
        • Comments
        • Countries
        • CustomCollections
        • CustomerAddresses
        • Customers
        • DiscountCodes
        • DraftOrders
        • FulfillmentEvents
        • Fulfillments
        • FulfillmentServices
        • InventoryItems
        • InventoryLevels
        • MarketingEvents
        • OrderRisks
        • Orders
        • OrderTransactions
        • Pages
        • PriceRules
        • ProductImages
        • ProductListings
        • Products
        • ProductVariants
        • Provinces
        • RecurringApplicationCharges
        • Redirects
        • Refunds
        • ScriptTags
        • SmartCollections
        • Themes
        • UsageCharges
        • AbandonedCheckouts
        • AbandonedCheckoutsItems
        • AssignedFulfillmentOrders
        • DiscountApplications
        • DraftOrderItemProperties
        • DraftOrderItems
        • DraftOrderItemTaxLines
        • Events
        • FulfillmentOrders
        • Locations
        • NoteAttributes
        • OrderDiscountCodes
        • OrderItemDiscountAllocations
        • OrderItemProperties
        • OrdersItems
        • Payouts
        • PayoutTransactions
        • ProductOptions
        • RefundAdjustments
        • RefundsItems
        • RefundTransactions
        • Reports
        • ShippingItems
        • ShippingZones
        • Shop
        • TaxItems
    • Snapchat
      • Setup Guide
    • Square
    • SQL Server
    • Snowflake
    • Stripe
      • Setup Guide
      • Tables
        • Accounts
        • BankAccounts
        • BankAccountTokens
        • Cards
        • CardTokens
        • Charges
        • Coupons
        • CustomerDiscounts
        • Customers
        • InvoiceLineItems
        • Invoices
        • Payouts
        • Plans
        • Prices
        • Refunds
        • SubscriptionDiscounts
        • SubscriptionItems
        • Subscriptions
        • TransferReversals
        • Transfers
        • AvailableBalance
        • BalanceChangeFromActivitySummaryReport
        • BalanceSummaryReport
        • BalanceTransactions
        • CountrySpecs
        • Disputes
        • EndingBalanceReconciliationSummaryReport
        • Events
        • ItemizedBalanceChangeFromActivityReport
        • ItemizedEndingBalanceReconciliationReport
        • ItemizedPayoutReconciliationReport
        • ItemizedPayoutsReport
        • ItemizedReconciliationForASinglePayoutReport
        • Orders
        • PayoutsReconciliationSummaryForASinglePayoutReport
        • PayoutsReconciliationSummaryReport
        • PayoutsSummaryReport
        • PendingBalance
        • Products
        • Reports
        • Skus
    • The Trade Desk
    • Tiktok
    • TSV
    • Twilio
    • Twitter Ads
      • Tables
        • AdAudiencePermissions
        • AdAudiences
        • AdAccounts
        • AdCampaigns
        • AdFundingInstruments
        • AdLineItems
        • AdPromotedTweets
        • AdStats
        • AdTweets
    • Twitter Social
    • Typeform
    • Uber Eats
    • Vertica
    • Webhooks
    • Xero
      • Data Model
        • Accounting Data Model
          • Tables
            • Accounts
            • BankTransactions
            • BankTransfers
            • BatchPayments
            • ContactGroups
            • Contacts
            • CreditNotes
            • Employees
            • ExpenseClaims
            • HistoryBankTransactions
            • HistoryBatchPayments
            • HistoryContacts
            • HistoryCreditNotes
            • HistoryInvoices
            • HistoryPurchaseOrders
            • Invoices
            • Items
            • LinkedTransactions
            • ManualJournals
            • Payments
            • PurchaseOrders
            • Receipts
            • TaxRates
            • AgedPayablesByContact
            • AgedReceivablesByContact
            • BalanceSheet
            • BankStatement
            • BankSummary
            • BrandingThemes
            • BudgetLines
            • Budgets
            • BudgetSummary
            • ContactCISSettings
            • Currencies
            • ExecutiveSummary
            • ExpenseClaimPayments
            • ExpenseClaimReceipts
            • HistoryBankTransfers
            • HistoryExpenseClaims
            • HistoryItems
            • HistoryOverpayments
            • HistoryPayments
            • HistoryPrepayments
            • HistoryReceipts
            • HistoryRepeatingInvoices
            • Journals
            • Organisation
            • OrganisationActions
            • Overpayments
            • Prepayments
            • ProfitAndLoss
            • Quotes
            • RepeatingInvoices
            • Tenants
            • TrackingCategories
            • TrialBalance
            • Users
        • Australian Payroll Data Model
          • Tables
            • Employees
            • LeaveApplications
            • PayItemsDeductions
            • PayItemsEarnings
            • PayItemsLeave
            • PayItemsReimbursements
            • PayrollCalendars
            • PayRuns
            • SuperFunds
            • Timesheets
            • EmployeeBankAccounts
            • EmployeePayTemplateDeductions
            • EmployeePayTemplateEarnings
            • EmployeePayTemplateLeave
            • EmployeePayTemplateReimbursements
            • EmployeePayTemplateSupers
            • LeaveBalances
            • PaySlipDeductions
            • PaySlipEarnings
            • PaySlipLeaveAccrual
            • PaySlipLeaveEarnings
            • PaySlipReimbursements
            • PaySlips
            • PaySlipSuperannuations
            • PaySlipTaxes
            • PaySlipTimesheetEarnings
            • Tenants
        • Files Data Model
          • Tables
            • Associations
            • Files
            • Folders
            • Tenants
        • Fixed Assets Data Model
          • Tables
            • Assets
            • AssetTypes
            • Settings
            • Tenants
        • Projects Data Model
          • Tables
            • Projects
            • Tasks
            • Time
            • Tenants
            • Users
    • Yahoo
    • YouTube Analytics
      • Tables
        • Activities
        • AdPerformanceReports
        • Captions
        • Channels
        • ChannelSections
        • Comments
        • CommentThreads
        • Demographics
        • Devices
        • EngagementReports
        • Languages
        • PlayListItems
        • PlayLists
        • Regions
        • Subscriptions
        • TimeBasedReports
        • TopVideos
        • TrafficSources
        • VideoAbuseReportReasons
        • VideoCategories
        • Videos
        • Groups
        • GroupItems
    • Zendesk
      • Tables
        • AccountSettings
        • Automations
        • Brands
        • GroupMemberships
        • Groups
        • Holidays
        • JiraLinks
        • Macros
        • OrganizationFields
        • OrganizationMemberships
        • Organizations
        • OrganizationSubscriptions
        • PostComments
        • Posts
        • SatisfactionRatings
        • Schedules
        • Sessions
        • SharingAgreements
        • SupportAddresses
        • SuspendedTickets
        • TicketFields
        • TicketForms
        • Tickets
        • Topics
        • Triggers
        • UserFields
        • UserIdentities
        • Users
        • Views
        • ActivityStream
        • AppLocations
        • Attachments
        • Collaborators
        • CustomAgentRoles
        • JobStatus
        • Locales
        • MonitoredTwitterHandles
        • Requests
        • Requests_Collaborators
        • SlaPolicies
        • TicketAudits
        • TicketComments
        • TicketMetricEvents
        • TicketMetrics
        • Tickets_Collaborators
        • Tickets_Followers
        • Tickets_Followups
        • Tickets_Macros
        • Tickets_SatisfactionRatings
        • Tickets_SharingAgreements
        • Tickets_Tags
        • Tickets_Viasources
        • UserRelatedInformation
    • Zendesk Sell
    • Zoho CRM
      • Tables
        • Accounts
        • Activities
        • Attachments
        • Calls
        • Campaigns
        • Cases
        • Contacts
        • Currencies
        • Deals
        • Events
        • Invoices
        • Leads
        • Notes
        • Pipeline
        • PriceBooks
        • Products
        • PurchaseOrders
        • Quotes
        • SalesOrders
        • Solutions
        • Tasks
        • Vendors
        • ActionsPerformed
        • CustomFieldHistoryTracking
        • Fields
        • InvoiceProductDetails
        • Layouts
        • ModuleAttachedFiles
        • Modules
        • Organizations
        • PriceBookPricingDetails
        • Profiles
        • PurchaseOrderProductDetails
        • QuoteProductDetails
        • RecordCount
        • Roles
        • SalesOrderProductDetails
        • StageHistories
        • Territories
        • Users
        • Visits
    • Zoho Desk
  • Destinations
    • Amazon S3
    • AWS Redshift
    • Azure Storage
    • Azure SQL
    • Azure Synapse Analytics
    • Google BigQuery
    • FTP
    • Microsoft Azure SQL
    • Microsoft SQL Server
    • PostgreSQL
    • SFTP
    • Snowflake Database
    • About Google BigQuery
    • Files
      • Amazon S3
      • SFTP
      • FTP
  • Integrations
    • Slack
    • Microsoft Teams
  • Security
    • Gravity IP Addresses - Whitelisting
    • SSH Tunnel
    • Audit Log
    • Gravity Subprocessors
  • User Management
    • User Management
  • Billing
    • Billing
  • Community
    • Changelog
    • Roadmap
    • HAR file for troubleshooting
Powered by GitBook
On this page
  • Columns
  • Pseudo-Columns

Was this helpful?

  1. Sources
  2. Google Analytics
  3. UniversalAnalytics Data Model
  4. Tables

SiteContent

Columns

Name

Type

Dimension

DefaultMetric

DefaultDimension

Description

Date

Date

True

The date of the session formatted as YYYYMMDD.

Year

Integer

True

The year of the session. A four-digit year from 2005 to the current year.

Month

Integer

True

The month of the session. An integer from 01 to 12.

Week

Integer

True

The week of the session. A number from 01 to 53. Each week starts on Sunday.

Day

Integer

True

The day of the month. A number from 01 to 31.

Hour

Integer

True

An hour of the day ranging from 00-23 in the timezone configured for the account. This value is also corrected for daylight savings time.

Country

String

True

The country of users, derived from IP addresses.

City

String

True

The cities of property users, derived from IP addresses.

Browser

String

True

The names of browsers used by users to your website. For example, Internet Explorer or Firefox.

PagePath

String

True

True

A page on your website specified by path and/or query parameters. Use in conjunction with host name to get the full URL of the page.

PageTitle

String

True

The title of a page. Keep in mind that multiple pages might have the same PageTitle.

PageViews

Integer

False

True

The total number of page views for your property.

UniquePageviews

Integer

False

True

The number of different (unique) pages within a session. This takes into both the PagePath and PageTitle to determine uniqueness.

AvgTimeOnPage

Double

False

True

The average amount of time users spent viewing this page or a set of pages.

Entrances

Integer

False

True

The number of entrances to your property, measured as the first page view in a session. Typically used with LandingPagePath.

BounceRate

Double

False

True

The percentage of single-page sessions.

EntranceRate

Double

False

True

The percentage of page views in which this page was the entrance.

Exits

Integer

False

True

The number of exits from your property.

PageValue

Double

False

True

The average value of this page or set of pages. Page Value is the sum of TransactionRevenue and GoalValueAll, columns in the Ecommerce table, divided by UniquePageviews (for the page or set of pages).

TimeOnPage

Double

False

True

How long a user spent on a particular page in seconds. Calculated by subtracting the initial view time for a particular page from the initial view time for a subsequent page. Thus, this metric does not apply to exit pages for your property.

ExitRate

Double

False

True

The percentage of exits from your property that occurred out of the total page views.

StartDate

String

Start date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).

EndDate

String

End date for fetching Analytics data. Either a date string or a relative date (e.g., today, yesterday, or #daysAgo).

Dimensions

String

A comma-separated list of dimensions to retrieve in addition to the columns defined in the schema. Set to empty string to retrieve no dimensions.

Metrics

String

A comma-separated list of metrics to retrieve in addition to the columns defined in the schema.

CohortTypes

String

Available only when using the V4 API. A comma-separated list of cohort types. The default value is FIRST_VISIT_DATE

CohortStartDates

Date

Available only when using the V4 API. A comma-separated list of cohort start dates.

CohortEndDates

Date

Available only when using the V4 API. A comma-separated list of cohort end dates.

SamplesReadCounts

String

Comma separated list of samples read counts when the response data is sampled.

SamplingSpaceSizes

String

Comma separated list of samples space sizes counts when the response data is sampled.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name

Type

Description

Segments

String

Segments the data returned for your request. Either a SegmentId or a custom segment.

Profile

String

The Profile ID or website URL to retrieve data from.

PreviousGoalCompletionsNextSiteSearch

Last updated 3 years ago

Was this helpful?