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.
Example of a dashboard created in Data Studio with Jepto data.
Create native graphs in Data Studio with your predictive data.
Centralize your Advertising spend data in Data Studio reports with complete layout control.
View activities across all of your marketing data to create a rich report in seconds.
| Field | Type | Description |
|---|---|---|
|
Acknowledged |
 Boolean
|
When any User Acknowledges the Insight this is set to True |
|
Budget Chart |
 Image
|
Image of the Jepto Chart (Note: Data Studio down scales quality) |
|
Budget Currency |
 Text
|
Text of the currency used in the Budget |
|
Budget Daily Target Average |
Text
|
The amount you should spend on a daily basis to meet your target |
|
Budget Days Elapsed |
 Number
|
The amount of days so far in the current budget period |
|
Budget Days Remaining |
Number
|
The amount of days remaining in the current budget period |
|
Budget End Date |
 Date (YYYYMMDD)
|
Date of the end of the reporting period |
|
Budget Estimate |
Number
|
Calculation of the daily average of the period to date, projected forward to the Budget end date |
|
Budget Estimated (Cumulative) |
Number
|
Calculation of the daily average of the period to date, projected forward to the Budget end date. (Adjusted for Cumulative charts) |
|
Budget Estimated Percent |
Percent
|
Budget Estimate compared to your target as a percentage |
|
Budget ID |
Text
|
A 16 character alphanumeric System defined ID |
|
Budget Name |
Text
|
Auto generated name or custom name given to the Budget |
|
Budget Pacing |
Number
|
The amount you are above or below the target for the period to date |
|
Budget Pacing Direction |
Text
|
Value showing if your period to date pacing is above or below your target |
|
Budget Source |
Text
|
Data source of the Budget (Google Ads, Facebook Ads, etc.) |
|
Budget Source Image |
Image
|
|
|
Budget Spend |
Number
|
The amount you have spent |
|
Budget Spend Average |
Number
|
The daily average spent, over the period to date |
|
Budget Spend Percent |
Percent
|
The percentage you have spent compared to your target |
|
Budget Start Date |
Date (YYYYMMDD)
|
Date of the start of the reporting period |
|
Budget Status |
Text
|
Value of the Budget Status (On Track, Warning, Critical) |
|
Budget Target |
Number
|
|
|
Budget Target Range Lower |
Number
|
The lower limit of your daily threshold to be On Track |
|
Budget Target Range Lower (Cumulative) |
Number
|
The lower limit of your daily threshold to be On Track. (Adjusted for Cumulative charts) |
|
Budget Target Range Upper |
Number
|
The upper limit of your daily threshold to be On Track |
|
Budget Target Range Upper (Cumulative) |
Number
|
The upper limit of your daily threshold to be On Track. (Adjusted for Cumulative charts) |
|
Client Name |
Text
|
Client Name |
|
Comment |
Text
|
The comment text (Note: Formatting may be stripped) |
|
Comment Date |
Date and Time
|
When the comment was created |
|
Comment Method |
Text
|
How the comment was added (App, Slack, API or Zapier) |
|
Comment Type |
Text
|
Comment or Note |
|
Date |
Date (YYYYMMDD)
|
Date the Insight was created or data point of a KPI |
|
Insight External ID |
Text
|
A reference that can be used for linking external Project Management tools |
|
Insight ID |
Text
|
A 16 character alphanumeric System defined ID |
|
Insight Reference |
Text
|
A sequential numeric ID used to easily reference an individual Insight |
|
Insight Report |
Text
|
Information regarding the Insight (Note: Only available for Anomalies) |
|
Insight Summary |
Text
|
Top level summary of why the Insight was created |
|
Insight Title |
Text
|
Auto generated title of the Insight |
|
Job Type |
Text
|
Feature of the item (KPI, Budget, Anomaly, Automation) |
|
KPI Actual |
Number
|
Value of the KPI metric you are tracking for a Date |
|
KPI Actual Percentage |
Percent
|
Value achieved so far of your target |
|
KPI Calculated Metric |
Boolean
|
Value for determining if metric used in KPI is Calculated |
|
KPI Chart |
Image
|
Image of the Jepto Chart (Note: Data Studio down scales quality) |
|
KPI Currency |
Text
|
Symbol of the currency used in the data source of the KPI |
|
KPI End Date |
Date (YYYYMMDD)
|
Date of the end of the reporting period |
|
KPI ID |
Text
|
A 16 character alphanumeric System defined ID |
|
KPI Name |
Text
|
Auto generated name or custom name given to the KPI |
|
KPI Pacing |
Percent
|
The amount you are above or below the target for the period to date |
|
KPI Pacing Direction |
Text
|
Value showing if your period to date pacing is above or below your target |
|
KPI Period |
Text
|
Period of time the KPI is calculated over |
|
KPI Period Days Remaining |
Number
|
Number of days left in the reporting period |
|
KPI Period Days Remaining Percentage |
Percent
|
Value representing the percentage of time left in the reporting period |
|
KPI Period To Date Performance |
Number
|
Daily value for Calculated metrics |
|
KPI Prediction |
Number
|
Value predicted by the Machine Learning algorithm for a Date |
|
KPI Prediction (Cumulative) |
Number
|
Value predicted by the Machine Learning algorithm for a Date |
| Field | Type | Description |
|---|---|---|
|
Acknowledged |
Boolean
|
When any User Acknowledges the Insight this is set to True |
|
Budget Chart |
Image
|
Image of the Jepto Chart (Note: Data Studio down scales quality) |
|
Budget Currency |
Text
|
Text of the currency used in the Budget |
|
Budget Daily Target Average |
Text
|
The amount you should spend on a daily basis to meet your target |
|
Budget Days Elapsed |
Number
|
The amount of days so far in the current budget period |
|
Budget Days Remaining |
Number
|
The amount of days remaining in the current budget period |
|
Budget End Date |
Date (YYYYMMDD)
|
Date of the end of the reporting period |
|
Budget Estimate |
Number
|
Calculation of the daily average of the period to date, projected forward to the Budget end date |
|
Budget Estimated (Cumulative) |
Number
|
Calculation of the daily average of the period to date, projected forward to the Budget end date. (Adjusted for Cumulative charts) |
|
Budget Estimated Percent |
Percent
|
Budget Estimate compared to your target as a percentage |
|
Budget ID |
Text
|
A 16 character alphanumeric System defined ID |
|
Budget Name |
Text
|
Auto generated name or custom name given to the Budget |
|
Budget Pacing |
Number
|
The amount you are above or below the target for the period to date |
|
Budget Pacing Direction |
Text
|
Value showing if your period to date pacing is above or below your target |
|
Budget Source |
Text
|
Data source of the Budget (Google Ads, Facebook Ads, etc.) |
|
Budget Source Image |
Image
|
|
|
Budget Spend |
Number
|
The amount you have spent |
|
Budget Spend Average |
Number
|
The daily average spent, over the period to date |
|
Budget Spend Percent |
Percent
|
The percentage you have spent compared to your target |
|
Budget Start Date |
Date (YYYYMMDD)
|
Date of the start of the reporting period |
|
Budget Status |
Text
|
Value of the Budget Status (On Track, Warning, Critical) |
|
Budget Target |
Number
|
|
|
Budget Target Range Lower |
Number
|
The lower limit of your daily threshold to be On Track |
|
Budget Target Range Lower (Cumulative) |
Number
|
The lower limit of your daily threshold to be On Track. (Adjusted for Cumulative charts) |
|
Budget Target Range Upper |
Number
|
The upper limit of your daily threshold to be On Track |
|
Budget Target Range Upper (Cumulative) |
Number
|
The upper limit of your daily threshold to be On Track. (Adjusted for Cumulative charts) |
|
Client Name |
Text
|
Client Name |
|
Comment |
Text
|
The comment text (Note: Formatting may be stripped) |
|
Comment Date |
Date and Time
|
When the comment was created |
|
Comment Method |
Text
|
How the comment was added (App, Slack, API or Zapier) |
|
Comment Type |
Text
|
Comment or Note |
|
Date |
Date (YYYYMMDD)
|
Date the Insight was created or data point of a KPI |
|
Insight External ID |
Text
|
A reference that can be used for linking external Project Management tools |
|
Insight ID |
Text
|
A 16 character alphanumeric System defined ID |
|
Insight Reference |
Text
|
A sequential numeric ID used to easily reference an individual Insight |
|
Insight Report |
Text
|
Information regarding the Insight (Note: Only available for Anomalies) |
|
Insight Summary |
Text
|
Top level summary of why the Insight was created |
|
Insight Title |
Text
|
Auto generated title of the Insight |
|
Job Type |
Text
|
Feature of the item (KPI, Budget, Anomaly, Automation) |
|
KPI Actual |
Number
|
Value of the KPI metric you are tracking for a Date |
|
KPI Actual Percentage |
Percent
|
Value achieved so far of your target |
|
KPI Calculated Metric |
Boolean
|
Value for determining if metric used in KPI is Calculated |
|
KPI Chart |
Image
|
Image of the Jepto Chart (Note: Data Studio down scales quality) |
|
KPI Currency |
Text
|
Symbol of the currency used in the data source of the KPI |
|
KPI End Date |
Date (YYYYMMDD)
|
Date of the end of the reporting period |
|
KPI ID |
Text
|
A 16 character alphanumeric System defined ID |
|
KPI Name |
Text
|
Auto generated name or custom name given to the KPI |
|
KPI Pacing |
Percent
|
The amount you are above or below the target for the period to date |
|
KPI Pacing Direction |
Text
|
Value showing if your period to date pacing is above or below your target |
|
KPI Period |
Text
|
Period of time the KPI is calculated over |
|
KPI Period Days Remaining |
Number
|
Number of days left in the reporting period |
|
KPI Period Days Remaining Percentage |
Percent
|
Value representing the percentage of time left in the reporting period |
|
KPI Period To Date Performance |
Number
|
Daily value for Calculated metrics |
|
KPI Prediction |
Number
|
Value predicted by the Machine Learning algorithm for a Date |
|
KPI Prediction (Cumulative) |
Number
|
Value predicted by the Machine Learning algorithm for a Date |
Fully managed data pipelines to your warehouse.
Data Warehouse
© Jepto 2024. All rights reserved.
