Jepto

Pricing

Blog

Sign In

Try For Free

Google Looker Studio

Looker Studio Connector

Take your reporting to the next level with your KPI predictive forecasts, Budget spend and Insights generated from Anomalies and Automations.

Create reports that showcase all the events happening with your client's marketing without lifting a finger.

Zapier Task Management integration
circle-4circle-3circle-1circle-2
Jepto - Management

Visualize your data

Reporting to clients or stakeholders can take many shapes and formats, so instead of locking you into a single report, you have the full flexibility to create a report that suits your needs.

Jepto Looker Studio Dashboard

Example of a dashboard created in Looker Studio with Jepto data.

kpi report
Google Analytics
Google Ads
Facebook Ads
Microsoft Ads
Google Sheets

KPI Data

Create native graphs in Looker Studio with your predictive data.

  1. Shareable reports
    Create custom styled reports that you can share with Clients to showcase the Machine Learning predictions.
  2. Add to existing reports
    Use Looker Studio's strength of making a single report that pulls in data from a variety of sources.
  3. Customizable
    With the full range of charts available to use in Looker Studio you can create anything from a table, pie graph or a Time Series chart.
budget report
Google Ads
Facebook Ads
Microsoft Ads

Budget Data

Centralize your Advertising spend data in Looker Studio reports with complete layout control.

  1. Cut costs
    If you are paying for a 3rd party tool to bring in your Facebook data to Looker Studio, you can ditch it and save costs as any data in your Jepto account can be used with this connector.
  2. Reduce Complexity
    As your Budgets are already configured in Jepto there is no need to create complicated spreadsheet integrations to pull in spend targets or filters for campaign filtering.
  3. Layout Control
    Create table or charts to show your spend data and even combine spend across multiple platforms for a layout and calculation that suits your needs.
Insight Report
Google Search Console
Google Business Profile
Google Ads
Google Analytics
Web Crawler
Facebook Ads
Microsoft Ads

Insights

View activities across all of your marketing data to create a rich report in seconds.

  1. Reduce Effort
    Building monthly reports is not a fun job, but it's a necessary part of running Digital Marketing campaigns and showcasing to Clients or stakeholders what has taken place. With the Looker Studio connector creating reporting to show events is now one less thing you need to worry about.
  2. Anomalies
    Every Anomaly is able to be included in the report along with an easy-to-read summary.
  3. Automation Jobs
    Insights created from Automation jobs provide a great way to showcase events that are created from a variety of data sources.

Jepto Connector Fields

Field Type Description

Acknowledged

BooleanBoolean When any User Acknowledges the Insight this is set to True

Budget Chart

ImageImage Image of the Jepto Chart (Note: Looker Studio down scales quality)

Budget Currency

TextText Text of the currency used in the Budget

Budget Daily Target Average

TextText The amount you should spend on a daily basis to meet your target

Budget Days Elapsed

NumericNumber The amount of days so far in the current budget period

Budget Days Remaining

NumericNumber The amount of days remaining in the current budget period

Budget End Date

CalendarDate (YYYYMMDD) Date of the end of the reporting period

Budget Estimate

NumericNumber Calculation of the daily average of the period to date, projected forward to the Budget end date

Budget Estimated (Cumulative)

NumericNumber Calculation of the daily average of the period to date, projected forward to the Budget end date. (Adjusted for Cumulative charts)

Budget Estimated Percent

NumericPercent Budget Estimate compared to your target as a percentage

Budget ID

TextText A 16 character alphanumeric System defined ID

Budget Name

TextText Auto generated name or custom name given to the Budget

Budget Pacing

NumericNumber The amount you are above or below the target for the period to date

Budget Pacing Direction

TextText Value showing if your period to date pacing is above or below your target

Budget Source

TextText Data source of the Budget (Google Ads, Facebook Ads, etc.)

Budget Source Image

ImageImage

Budget Spend

NumericNumber The amount you have spent

Budget Spend Average

NumericNumber The daily average spent, over the period to date

Budget Spend Percent

NumericPercent The percentage you have spent compared to your target

Budget Start Date

CalendarDate (YYYYMMDD) Date of the start of the reporting period

Budget Status

TextText Value of the Budget Status (On Track, Warning, Critical)

Budget Target

NumericNumber

Budget Target Range Lower

NumericNumber The lower limit of your daily threshold to be On Track

Budget Target Range Lower (Cumulative)

NumericNumber The lower limit of your daily threshold to be On Track. (Adjusted for Cumulative charts)

Budget Target Range Upper

NumericNumber The upper limit of your daily threshold to be On Track

Budget Target Range Upper (Cumulative)

NumericNumber The upper limit of your daily threshold to be On Track. (Adjusted for Cumulative charts)

Client Name

TextText Client Name

Comment

TextText The comment text (Note: Formatting may be stripped)

Comment Date

CalendarDate and Time When the comment was created

Comment Method

TextText How the comment was added (App, Slack, API or Zapier)

Comment Type

TextText Comment or Note

Date

CalendarDate (YYYYMMDD) Date the Insight was created or data point of a KPI

Insight External ID

TextText A reference that can be used for linking external Project Management tools

Insight ID

TextText A 16 character alphanumeric System defined ID

Insight Reference

TextText A sequential numeric ID used to easily reference an individual Insight

Insight Report

NumericText Information regarding the Insight (Note: Only available for Anomalies)

Insight Summary

TextText Top level summary of why the Insight was created

Insight Title

TextText Auto generated title of the Insight

Job Type

TextText Feature of the item (KPI, Budget, Anomaly, Automation)

KPI Actual

NumericNumber Value of the KPI metric you are tracking for a Date

KPI Actual Percentage

NumericPercent Value achieved so far of your target

KPI Calculated Metric

BooleanBoolean Value for determining if metric used in KPI is Calculated

KPI Chart

ImageImage Image of the Jepto Chart (Note: Looker Studio down scales quality)

KPI Currency

TextText Symbol of the currency used in the data source of the KPI

KPI End Date

CalendarDate (YYYYMMDD) Date of the end of the reporting period

KPI ID

TextText A 16 character alphanumeric System defined ID

KPI Name

TextText Auto generated name or custom name given to the KPI

KPI Pacing

NumericPercent The amount you are above or below the target for the period to date

KPI Pacing Direction

TextText Value showing if your period to date pacing is above or below your target

KPI Period

TextText Period of time the KPI is calculated over

KPI Period Days Remaining

NumericNumber Number of days left in the reporting period

KPI Period Days Remaining Percentage

NumericPercent Value representing the percentage of time left in the reporting period

KPI Period To Date Performance

NumericNumber Daily value for Calculated metrics

KPI Prediction

NumericNumber Value predicted by the Machine Learning algorithm for a Date

KPI Prediction (Cumulative)

NumericNumber Value predicted by the Machine Learning algorithm for a Date

Jepto Connector Fields

Field Type Description

Acknowledged

BooleanBoolean When any User Acknowledges the Insight this is set to True

Budget Chart

ImageImage Image of the Jepto Chart (Note: Looker Studio down scales quality)

Budget Currency

TextText Text of the currency used in the Budget

Budget Daily Target Average

TextText The amount you should spend on a daily basis to meet your target

Budget Days Elapsed

NumericNumber The amount of days so far in the current budget period

Budget Days Remaining

NumericNumber The amount of days remaining in the current budget period

Budget End Date

CalendarDate (YYYYMMDD) Date of the end of the reporting period

Budget Estimate

NumericNumber Calculation of the daily average of the period to date, projected forward to the Budget end date

Budget Estimated (Cumulative)

NumericNumber Calculation of the daily average of the period to date, projected forward to the Budget end date. (Adjusted for Cumulative charts)

Budget Estimated Percent

NumericPercent Budget Estimate compared to your target as a percentage

Budget ID

TextText A 16 character alphanumeric System defined ID

Budget Name

TextText Auto generated name or custom name given to the Budget

Budget Pacing

NumericNumber The amount you are above or below the target for the period to date

Budget Pacing Direction

TextText Value showing if your period to date pacing is above or below your target

Budget Source

TextText Data source of the Budget (Google Ads, Facebook Ads, etc.)

Budget Source Image

ImageImage

Budget Spend

NumericNumber The amount you have spent

Budget Spend Average

NumericNumber The daily average spent, over the period to date

Budget Spend Percent

NumericPercent The percentage you have spent compared to your target

Budget Start Date

CalendarDate (YYYYMMDD) Date of the start of the reporting period

Budget Status

TextText Value of the Budget Status (On Track, Warning, Critical)

Budget Target

NumericNumber

Budget Target Range Lower

NumericNumber The lower limit of your daily threshold to be On Track

Budget Target Range Lower (Cumulative)

NumericNumber The lower limit of your daily threshold to be On Track. (Adjusted for Cumulative charts)

Budget Target Range Upper

NumericNumber The upper limit of your daily threshold to be On Track

Budget Target Range Upper (Cumulative)

NumericNumber The upper limit of your daily threshold to be On Track. (Adjusted for Cumulative charts)

Client Name

TextText Client Name

Comment

TextText The comment text (Note: Formatting may be stripped)

Comment Date

CalendarDate and Time When the comment was created

Comment Method

TextText How the comment was added (App, Slack, API or Zapier)

Comment Type

TextText Comment or Note

Date

CalendarDate (YYYYMMDD) Date the Insight was created or data point of a KPI

Insight External ID

TextText A reference that can be used for linking external Project Management tools

Insight ID

TextText A 16 character alphanumeric System defined ID

Insight Reference

TextText A sequential numeric ID used to easily reference an individual Insight

Insight Report

NumericText Information regarding the Insight (Note: Only available for Anomalies)

Insight Summary

TextText Top level summary of why the Insight was created

Insight Title

TextText Auto generated title of the Insight

Job Type

TextText Feature of the item (KPI, Budget, Anomaly, Automation)

KPI Actual

NumericNumber Value of the KPI metric you are tracking for a Date

KPI Actual Percentage

NumericPercent Value achieved so far of your target

KPI Calculated Metric

BooleanBoolean Value for determining if metric used in KPI is Calculated

KPI Chart

ImageImage Image of the Jepto Chart (Note: Looker Studio down scales quality)

KPI Currency

TextText Symbol of the currency used in the data source of the KPI

KPI End Date

CalendarDate (YYYYMMDD) Date of the end of the reporting period

KPI ID

TextText A 16 character alphanumeric System defined ID

KPI Name

TextText Auto generated name or custom name given to the KPI

KPI Pacing

NumericPercent The amount you are above or below the target for the period to date

KPI Pacing Direction

TextText Value showing if your period to date pacing is above or below your target

KPI Period

TextText Period of time the KPI is calculated over

KPI Period Days Remaining

NumericNumber Number of days left in the reporting period

KPI Period Days Remaining Percentage

NumericPercent Value representing the percentage of time left in the reporting period

KPI Period To Date Performance

NumericNumber Daily value for Calculated metrics

KPI Prediction

NumericNumber Value predicted by the Machine Learning algorithm for a Date

KPI Prediction (Cumulative)

NumericNumber Value predicted by the Machine Learning algorithm for a Date

Marketing Intelligence and Automation

Google Analytics 4Google AdsGoogle Search ConsoleGoogle Business ProfileFacebookWeb CrawlerFacebookBing Microsoft AdvertisingTiktokLinkedInTwitterInstagram
Google Looker Studio
Google Big Query

Data Warehouse

Fully managed data pipelines to your warehouse.

Data Warehouse