Jepto

Pricing

Blog

Sign In

Try For Free

Jepto

Pricing

BLOG

Sign In

Try For Free

Data Studio Connector

Visualise 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 Data Studio Dashboard

Example of a dashboard created in Data Studio with Jepto data

kpi report
Google Analytics
Google Ads
Facebook

KPI Data

Create native graphs in Data 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 Data Studio's strength of making a single report that pulls in data from a variety of sources.
  3. Customisable
    With the full range of charts available to use in Data Studio you can create anything from a table, pie graph or a Time Series chart.
budget report
Google Ads
Facebook

Budget Data

Centralise your Advertising spend data in Data 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 Data 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 Analytics
Google Ads
Facebook
Facebook
Facebook

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 Data 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.

VIEW in data studio

Dashboard TEMPLATE

Jepto Connector Fields

Index Field Type Description
1

Acknowledged

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

Budget Chart

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

Budget Currency

TextText Text of the currency used in the Budget
4

Budget Daily Target Average

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

Budget Days Elapsed

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

Budget Days Remaining

NumericNumber The amount of days remaining in the current budget period
7

Budget End Date

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

Budget Estimate

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

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)
10

Budget Estimated Percent

NumericPercent Budget Estimate compared to your target as a percentage
11

Budget ID

TextText A 16 character alphanumeric System defined ID
12

Budget Name

TextText Auto generated name or custom name given to the Budget
13

Budget Pacing

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

Budget Pacing Direction

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

Budget Source

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

Budget Source Image

ImageImage
17

Budget Spend

NumericNumber The amount you have spent
18

Budget Spend Average

NumericNumber The daily average spent, over the period to date
19

Budget Spend Percent

NumericPercent The percentage you have spent compared to your target
20

Budget Start Date

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

Budget Status

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

Budget Target

NumericNumber
23

Budget Target Range Lower

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

Budget Target Range Lower (Cumulative)

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

Budget Target Range Upper

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

Budget Target Range Upper (Cumulative)

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

Client Name

TextText Client Name
28

Comment

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

Comment Date

CalendarDate and Time When the comment was created
30

Comment Method

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

Comment Type

TextText Comment or Note
32

Date

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

Insight External ID

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

Insight ID

TextText A 16 character alphanumeric System defined ID
35

Insight Reference

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

Insight Report

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

Insight Summary

TextText Top level summary of why the Insight was created
38

Insight Title

TextText Auto generated title of the Insight
39

Job Type

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

KPI Actual

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

KPI Actual Percentage

NumericPercent Value achieved so far of your target
42

KPI Calculated Metric

BooleanBoolean Value for determining if metric used in KPI is Calculated
43

KPI Chart

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

KPI Currency

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

KPI End Date

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

KPI ID

TextText A 16 character alphanumeric System defined ID
47

KPI Name

TextText Auto generated name or custom name given to the KPI
48

KPI Pacing

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

KPI Pacing Direction

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

KPI Period

TextText Period of time the KPI is calculated over
51

KPI Period Days Remaining

NumericNumber Number of days left in the reporting period
52

KPI Period Days Remaining Percentage

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

KPI Period To Date Performance

NumericNumber Daily value for Calculated metrics
54

KPI Prediction

NumericNumber Value predicted by the Machine Learning algorithm for a Date
55

KPI Prediction (Cumulative)

NumericNumber Value predicted by the Machine Learning algorithm for a Date
56

KPI Prediction Percentage

NumericPercent Predicted value at the end of the reporting period
57

KPI Rolling Average Percentage

NumericPercent Rolling average compared to your target as a percentage. Note: Calculated metrics only
58

KPI Source

TextText Data source of the KPI (Google Analytics, Google Ads, Facebook, etc.)
59

KPI Start Date

NumericDate (YYYYMMDD) Date of the start of the reporting period
60

KPI Status

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

KPI Target

NumericNumber Value that the KPI is trying to meet
62

Budget Target

NumericNumber Value that the Budget is trying to meet
63

KPI Unit

TextText Text description of the metric being tracked
64

Resolved

BooleanBoolean When any User Resolves the Insight this is set to True
65

KPI Rolling Average

NumericNumber Calculation of the daily average over the last 30 Days, projected forward to the KPI end date. Note: Calculated metrics only
66

User Name

TextText Name of the User

Jepto Connector Fields

Index Field Type Description
1

Acknowledged

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

Budget Chart

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

Budget Currency

TextText Text of the currency used in the Budget
4

Budget Daily Target Average

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

Budget Days Elapsed

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

Budget Days Remaining

NumericNumber The amount of days remaining in the current budget period
7

Budget End Date

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

Budget Estimate

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

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)
10

Budget Estimated Percent

NumericPercent Budget Estimate compared to your target as a percentage
11

Budget ID

TextText A 16 character alphanumeric System defined ID
12

Budget Name

TextText Auto generated name or custom name given to the Budget
13

Budget Pacing

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

Budget Pacing Direction

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

Budget Source

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

Budget Source Image

ImageImage
17

Budget Spend

NumericNumber The amount you have spent
18

Budget Spend Average

NumericNumber The daily average spent, over the period to date
19

Budget Spend Percent

NumericPercent The percentage you have spent compared to your target
20

Budget Start Date

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

Budget Status

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

Budget Target

NumericNumber
23

Budget Target Range Lower

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

Budget Target Range Lower (Cumulative)

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

Budget Target Range Upper

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

Budget Target Range Upper (Cumulative)

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

Client Name

TextText Client Name
28

Comment

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

Comment Date

CalendarDate and Time When the comment was created
30

Comment Method

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

Comment Type

TextText Comment or Note
32

Date

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

Insight External ID

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

Insight ID

TextText A 16 character alphanumeric System defined ID
35

Insight Reference

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

Insight Report

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

Insight Summary

TextText Top level summary of why the Insight was created
38

Insight Title

TextText Auto generated title of the Insight
39

Job Type

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

KPI Actual

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

KPI Actual Percentage

NumericPercent Value achieved so far of your target
42

KPI Calculated Metric

BooleanBoolean Value for determining if metric used in KPI is Calculated
43

KPI Chart

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

KPI Currency

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

KPI End Date

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

KPI ID

TextText A 16 character alphanumeric System defined ID
47

KPI Name

TextText Auto generated name or custom name given to the KPI
48

KPI Pacing

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

KPI Pacing Direction

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

KPI Period

TextText Period of time the KPI is calculated over
51

KPI Period Days Remaining

NumericNumber Number of days left in the reporting period
52

KPI Period Days Remaining Percentage

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

KPI Period To Date Performance

NumericNumber Daily value for Calculated metrics
54

KPI Prediction

NumericNumber Value predicted by the Machine Learning algorithm for a Date
55

KPI Prediction (Cumulative)

NumericNumber Value predicted by the Machine Learning algorithm for a Date
56

KPI Prediction Percentage

NumericPercent Predicted value at the end of the reporting period
57

KPI Rolling Average Percentage

NumericPercent Rolling average compared to your target as a percentage. Note: Calculated metrics only
58

KPI Source

TextText Data source of the KPI (Google Analytics, Google Ads, Facebook, etc.)
59

KPI Start Date

NumericDate (YYYYMMDD) Date of the start of the reporting period
60

KPI Status

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

KPI Target

NumericNumber Value that the KPI is trying to meet
62

Budget Target

NumericNumber Value that the Budget is trying to meet
63

KPI Unit

TextText Text description of the metric being tracked
64

Resolved

BooleanBoolean When any User Resolves the Insight this is set to True
65

KPI Rolling Average

NumericNumber Calculation of the daily average over the last 30 Days, projected forward to the KPI end date. Note: Calculated metrics only
66

User Name

TextText Name of the User

Marketing Intelligence and Automation

Google AnalyticsGoogle AdsGoogle Search ConsoleWeb CrawlerGoogle My BusinessFacebookFacebookBing Microsoft Advertising