Jepto

Pricing

Blog

Sign In

Try For Free

Jepto

INTEGRATIONS

Pricing

BLOG

Sign In

Try For Free

Why create a Data Warehouse?

Centralise and combine data to inform crucial business decisions, guide marketing strategies and derive Insights. Create reports and data visualizations with all your favourite tools.

All Your Data in One Place

Consolidate your data for cross channel reporting with industry best practice standards.

Quick and Easy to get started

Set up takes only a few minutes and we handle the historic and daily data transfers for you.

Affordable Price

Pay only for what you need with no commitments and the data is always yours.

What is a Data Warehouse and how does it work?

A Data Warehouse is simply a centralised space to store your data. For most marketers this is essentially a powerful and flexible Spreadsheet that can scale without slowing down.

Simply select the data source and destination to create a Data Pipeline. The pipeline will then extract your historical data and run continuously to fetch new data and push into your Data Warehouse. Once in your warehouse you can use familiar tools like Google Data Studio to analyse and report on your data, all without writing any code.

Jepto Data Warehouse Comparison

Utilise the Built-In dashboard or create your own in Data Studio.

Competitors

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Jepto Data Warehouse

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Lorem Ipsum, giving information on its origins, as well as a random Lipsum generator.

Jepto Data Warehouse Fields

Field Name Type Description
name STRING Google identifier for this location in the form: accounts/{accountId}/locations/{locationId}
locationId STRING Location ID
entityType STRING Entity type
storeCode STRING External identifier for this location, which must be unique inside a given account. This is a means of associating the location with your own records.
locationName STRING Location name should reflect your business's real-world name, as used consistently on your storefront, website, and stationery, and as known to customers.
primaryCategory STRING Category that best describes the core business this location engages in.
primaryPhone STRING A phone number that connects to your individual business location as directly as possible.
additionalPhones STRING Up to two phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number.
address STRING A precise, accurate address to describe your business location.
additionalCategories STRING Additional categories to describe your business.
websiteUrl STRING A URL for this business.
regularHours STRING Operating hours for the business.
specialHours STRING Special hours for the business.
serviceArea STRING Service area businesses provide their service at the customer's location.
locationKey STRING A collection of keys that link this business to other Google properties, such as a Google+ page and Google Maps Places.
labels STRING A collection of free-form strings to allow you to tag your business.
adWordsLocationExtensions STRING Additional information that is surfaced in AdWords.
latlng STRING User-provided latitude and longitude. When creating a location, this field is ignored if the provided address geocodes successfully.
openInfo STRING Indicates the location other information
openInfoStatus STRING A flag that indicates whether the location is currently open for business.
locationState STRING A set of booleans that reflects the state of a location.
attributes STRING Attributes for this location.
metadata STRING Additional non-user-editable information.
languageCode STRING The language of the location.
priceLists STRING Describes your business in your own voice and shares with users the unique story of your business and offerings.
profile STRING Describes your business in your own voice and shares with users the unique story of your business and offerings.
relationshipData STRING All locations and chain related to this one.
date TIMESTAMP Date represented in ISO 8601 extended format (hh:mm)
followers INTEGER Total number of followers for the location.
directSearches INTEGER The number of times resource was shown when searching for location directly
discoverySearches INTEGER The number of times the resource was shown as a result of a categorical search (for example, restaurant).
brandedSearches INTEGER The number of times a resource was shown as a result of a search for the chain it belongs to, or a brand it sells.
viewsOnMap INTEGER The number of times the resource was viewed on Google Maps.
viewsOnSearch INTEGER The number of times the resource was viewed on Google Search.
websiteClicks INTEGER The number of times the website was clicked.
phoneClicks INTEGER The number of times the phone number was clicked.
requestDirection INTEGER The number of times driving directions were requested.
photosViewsMerchant INTEGER The number of views on media items uploaded by the merchant.
photosViewsCustomers INTEGER The number of views on media items uploaded by customers.
photosCountCustomers INTEGER The total number of media items that are currently live that have been uploaded by customers.
photosCountMerchant INTEGER The total number of media items that are currently live that have been uploaded by the merchant.
localPostViewsOnSearch INTEGER The number of times the local post was viewed on Google Search.
localPostPhoneClicks STRING The number of times the call to action button was clicked on Google.
mediaFormat STRING The format of this media item.
locationAssociation STRING Describes how this media item is connected to its location.
googleUrl STRING Google-hosted URL for this media item.
thumbnailUrl STRING Where provided, the URL of a thumbnail image for this media item.
dimensions STRING The dimensions (width and height) in pixels.
insights STRING Statistics for this media item.
description STRING Description for this media item.
mediaCustomerMediaFormat STRING The format of this media customer item.
mediaCustomerLocationAssociation STRING Describes how this media item is connected to its location.
mediaCustomerGoogleUrl STRING Google-hosted URL for media customer item.
mediaCustomerThumbnailUrl STRING Where provided, the URL of a thumbnail image for media customer item.
mediaCustomerDimensions STRING The dimensions (width and height) in pixels.
mediaCustomerInsights STRING Statistics for media customer item.
mediaCustomerDescription STRING Description for media customer item.
mediaCustomerAttribution STRING Attribution information for customer media items.
mediaCustomerSourceUrl STRING A publicly accessible URL where the media item can be retrieved from.
mediaCustomerDataRef STRING A reference to media item binary data as obtained by the media.
postLanguageCode STRING The language of the local post.
postSummary STRING Description/body of the local post.
callToAction STRING The URL that users are sent to when clicking through the promotion.
event STRING Event information.
state STRING The state of the post, indicating what part of its lifecycle it is in.
media STRING The media associated with the post.
searchUrl STRING The link to the local post in Google search.
topicType STRING The topic type of the post: standard, event, offer, or alert.
alertType STRING The type of alert the post is created for.
offer STRING Additional data for offer posts.
questionUpvoteCount INTEGER The number of upvotes for the question.
answerUpvoteCount INTEGER The number of upvotes for the answer.
questionAuthorDisplayName STRING The author of the of question
answerAuthorDisplayName STRING Display name of the author of the answer
answerAuthorProfilePhotoUrl STRING Photo URL of the author of the answer
questionAuthorProfilePhotoUrl STRING Photo URL of the author of the question
question STRING The content of the question.
topAnswers STRING A list of answers to the question, sorted by upvotes.
totalAnswerCount NUMERIC The total number of answers posted for this question.
answer STRING The answer to the question.
reviewId STRING The encrypted unique identifier.
reviewerProfilePhotoUrl STRING The reviewer profile photo URL
reviewerDisplayName STRING The reviewer display name
reviewReply STRING Reply on the review
starRating INTEGER The star rating of the review.
reviewComment STRING The body of the review as plain text with markups.

Jepto Data Warehouse Fields

Field Name Type Description
name STRING Google identifier for this location in the form: accounts/{accountId}/locations/{locationId}
locationId STRING Location ID
entityType STRING Entity type
storeCode STRING External identifier for this location, which must be unique inside a given account. This is a means of associating the location with your own records.
locationName STRING Location name should reflect your business's real-world name, as used consistently on your storefront, website, and stationery, and as known to customers.
primaryCategory STRING Category that best describes the core business this location engages in.
primaryPhone STRING A phone number that connects to your individual business location as directly as possible.
additionalPhones STRING Up to two phone numbers (mobile or landline, no fax) at which your business can be called, in addition to your primary phone number.
address STRING A precise, accurate address to describe your business location.
additionalCategories STRING Additional categories to describe your business.
websiteUrl STRING A URL for this business.
regularHours STRING Operating hours for the business.
specialHours STRING Special hours for the business.
serviceArea STRING Service area businesses provide their service at the customer's location.
locationKey STRING A collection of keys that link this business to other Google properties, such as a Google+ page and Google Maps Places.
labels STRING A collection of free-form strings to allow you to tag your business.
adWordsLocationExtensions STRING Additional information that is surfaced in AdWords.
latlng STRING User-provided latitude and longitude. When creating a location, this field is ignored if the provided address geocodes successfully.
openInfo STRING Indicates the location other information
openInfoStatus STRING A flag that indicates whether the location is currently open for business.
locationState STRING A set of booleans that reflects the state of a location.
attributes STRING Attributes for this location.
metadata STRING Additional non-user-editable information.
languageCode STRING The language of the location.
priceLists STRING Describes your business in your own voice and shares with users the unique story of your business and offerings.
profile STRING Describes your business in your own voice and shares with users the unique story of your business and offerings.
relationshipData STRING All locations and chain related to this one.
date TIMESTAMP Date represented in ISO 8601 extended format (hh:mm)
followers INTEGER Total number of followers for the location.
directSearches INTEGER The number of times resource was shown when searching for location directly
discoverySearches INTEGER The number of times the resource was shown as a result of a categorical search (for example, restaurant).
brandedSearches INTEGER The number of times a resource was shown as a result of a search for the chain it belongs to, or a brand it sells.
viewsOnMap INTEGER The number of times the resource was viewed on Google Maps.
viewsOnSearch INTEGER The number of times the resource was viewed on Google Search.
websiteClicks INTEGER The number of times the website was clicked.
phoneClicks INTEGER The number of times the phone number was clicked.
requestDirection INTEGER The number of times driving directions were requested.
photosViewsMerchant INTEGER The number of views on media items uploaded by the merchant.
photosViewsCustomers INTEGER The number of views on media items uploaded by customers.
photosCountCustomers INTEGER The total number of media items that are currently live that have been uploaded by customers.
photosCountMerchant INTEGER The total number of media items that are currently live that have been uploaded by the merchant.
localPostViewsOnSearch INTEGER The number of times the local post was viewed on Google Search.
localPostPhoneClicks STRING The number of times the call to action button was clicked on Google.
mediaFormat STRING The format of this media item.
locationAssociation STRING Describes how this media item is connected to its location.
googleUrl STRING Google-hosted URL for this media item.
thumbnailUrl STRING Where provided, the URL of a thumbnail image for this media item.
dimensions STRING The dimensions (width and height) in pixels.
insights STRING Statistics for this media item.
description STRING Description for this media item.
mediaCustomerMediaFormat STRING The format of this media customer item.
mediaCustomerLocationAssociation STRING Describes how this media item is connected to its location.
mediaCustomerGoogleUrl STRING Google-hosted URL for media customer item.
mediaCustomerThumbnailUrl STRING Where provided, the URL of a thumbnail image for media customer item.
mediaCustomerDimensions STRING The dimensions (width and height) in pixels.
mediaCustomerInsights STRING Statistics for media customer item.
mediaCustomerDescription STRING Description for media customer item.
mediaCustomerAttribution STRING Attribution information for customer media items.
mediaCustomerSourceUrl STRING A publicly accessible URL where the media item can be retrieved from.
mediaCustomerDataRef STRING A reference to media item binary data as obtained by the media.
postLanguageCode STRING The language of the local post.
postSummary STRING Description/body of the local post.
callToAction STRING The URL that users are sent to when clicking through the promotion.
event STRING Event information.
state STRING The state of the post, indicating what part of its lifecycle it is in.
media STRING The media associated with the post.
searchUrl STRING The link to the local post in Google search.
topicType STRING The topic type of the post: standard, event, offer, or alert.
alertType STRING The type of alert the post is created for.
offer STRING Additional data for offer posts.
questionUpvoteCount INTEGER The number of upvotes for the question.
answerUpvoteCount INTEGER The number of upvotes for the answer.
questionAuthorDisplayName STRING The author of the of question
answerAuthorDisplayName STRING Display name of the author of the answer
answerAuthorProfilePhotoUrl STRING Photo URL of the author of the answer
questionAuthorProfilePhotoUrl STRING Photo URL of the author of the question
question STRING The content of the question.
topAnswers STRING A list of answers to the question, sorted by upvotes.
totalAnswerCount NUMERIC The total number of answers posted for this question.
answer STRING The answer to the question.
reviewId STRING The encrypted unique identifier.
reviewerProfilePhotoUrl STRING The reviewer profile photo URL
reviewerDisplayName STRING The reviewer display name
reviewReply STRING Reply on the review
starRating INTEGER The star rating of the review.
reviewComment STRING The body of the review as plain text with markups.

Frequently asked questions

1. What is a Data Warehouse?

A Data Warehouse is a Database that companies use to centralise data for querying and reporting.

2. What is a Source and Destination?

A Data Source is where the data is coming from and the Destination is where the data is being stored. An example of a Data Source is Google My Business and a Destination is Google Big Query.

3. Do I really need a Data Warehouse?

Although Data Warehouse's sound technical and only for large business they are essentially just centralised storage of data. The warehouse part is almost invisible in most applications as you can use Data Studio in the same way you use any other connector. You get the same drag and drop functionality you are familiar with but with the added speed benefit of using Google database produce, Big Query. If you are non-technical and want to simplify things, you can think of the data warehouse as your very own super fast spreadsheet that can store unlimited amounts of data and never get slow.

4. How does the pricing work?

Each connection to a data source is counted in credits, with the credits varying depending on the complexity of the data. For Google My Business (GMB), each location is one credit.

5. Does the trial have any restrictions?

You will have 10 credits to create Pipelines and all historical data is included. Just choose the plan that is right for you to get full access to that plans base features and then start your 7 day Pipeline trial. If you get to the end of trial and need some help working out the correct plan, just let us know.

6. What happens to my data if I cancel?

Need to cancel? No problems, just cancel the plan in the subscription management section of the App and the account will continue to run until the end of your billing period. No fees, no hoops to jump through and you keep your data in Big Query.

7. I'm still unsure on the pricing, can you help me?

We sure can, please get in touch with us and we will happily take you through the costs and explore the right plan for you.

Marketing Intelligence and Automation

Google AnalyticsGoogle AdsGoogle Search ConsoleGoogle My BusinessFacebookWeb CrawlerFacebookBing Microsoft Advertising