Data Studio Connector Fields

Acknowledged
‍Type: Boolean
Description: When any User Acknowledges the Insight this is set to True

‍Budget Chart
‍Type: Image
Description: Image of the Jepto Chart (Note: Data Studio down scales quality)

Budget Currency
‍Type: Text
Description: Text of the currency used in the Budget

Budget Daily Target Average
‍Type: Text
Description: The amount you should spend on a daily basis to meet your target

Budget Days Elapsed
‍Type: Number
Description: The amount of days so far in the current budget period

Budget Days Remaining
‍Type: Number
Description: The amount of days remaining in the current budget period

Budget End Date
‍Type: Date (YYYYMMDD)
Description: Date of the end of the reporting period

Budget Estimate
‍Type: Number
Description: Calculation of the daily average of the period to date, projected forward to the Budget end date

Budget Estimated (Cumulative)
‍Type: Number
Description: Calculation of the daily average of the period to date, projected forward to the Budget end date. (Adjusted for Cumulative charts)

Budget Estimated Percent
‍Type: Percent
Description: Budget Estimate compared to your target as a percentage

Budget ID
‍Type: Text
Description: A 16 character alphanumeric System defined ID

Budget Name
‍Type: Text
Description: Auto generated name or custom name given to the Budget

Budget Pacing
‍Type: Number
Description: The amount you are above or below the target for the period to date

Budget Pacing Direction
‍Type: Text
Description: Value showing if your period to date pacing is above or below your target

Budget Source
‍Type: Text
Description: Data source of the Budget (Google Ads, Facebook Ads, etc.)

Budget Spend
‍Type: Number
Description: The amount you have spent

Budget Spend Average
‍Type: Number
Description: The daily average spent, over the period to date

Budget Spend Percent
‍Type: Percent
Description: The percentage you have spent compared to your target

Budget Start Date
‍Type: Date (YYYYMMDD)
Description: Date of the start of the reporting period

Budget Status
‍Type: Text
Description: Value of the Budget Status (On Track, Warning, Critical)

Budget Target Range Lower
‍Type: Number
Description: The lower limit of your daily threshold to be On Track

Budget Target Range Lower (Cumulative)
‍Type: Number
Description: The lower limit of your daily threshold to be On Track. (Adjusted for Cumulative charts)

Budget Target Range Upper
‍Type: Number
Description: The upper limit of your daily threshold to be On Track

Budget Target Range Upper (Cumulative)
‍Type: Number
Description: The upper limit of your daily threshold to be On Track. (Adjusted for Cumulative charts)

Client Name
‍Type: Text
Description: Client Name

Comment
‍Type: Text
Description: The comment text (Note: Formatting may be stripped)‍

Comment Date
Type: Date & Time
Description: When the comment was created

Comment Method
‍Type: Text
Description: How the comment was added (App, Slack, API or Zapier)

Comment Type
‍Type: Text
Description: Comment or Note

Date
‍Type: Date (YYYYMMDD)
Description: Date the Insight was created or data point of a KPI

Insight External ID
‍Type: Text
Description: A reference that can be used for linking external Project Management tools

Insight ID
‍Type: Text
Description: A 16 character alphanumeric System defined ID

Insight Reference
‍Type: Text
Description: A sequential numeric ID used to easily reference an individual Insight

Insight Report
‍Type: Text
Description: Information regarding the Insight (Note: Only available for Anomalies)

Insight Summary
‍Type: Text
Description: Top level summary of why the Insight was created

Insight Title
‍Type: Text
Description: Auto generated title of the Insight

Job Type
‍Type: Text
Description: Feature of the item (KPI, Budget, Anomaly, Automation)

KPI Actual
‍Type: Number
Description: Value of the KPI metric you are tracking for a Date

KPI Actual Percentage
‍Type: Percent
Description: Value achieved so far of your target

KPI Chart
‍Type: Image
Description: Image of the Jepto Chart (Note: Data Studio down scales quality)

KPI Currency
‍Type: Text
Description: Symbol of the currency used in the data source of the KPI

KPI End Date
‍Type: Date (YYYYMMDD)
Description: Date of the end of the reporting period

KPI ID
‍Type: Text
Description: A 16 character alphanumeric System defined ID

KPI Name
Type: Text
Description: Auto generated name or custom name given to the KPI

KPI Pacing
‍Type: Percent
Description: The amount you are above or below the target for the period to date

KPI Pacing Direction
‍Type: Text
Description: Value showing if your period to date pacing is above or below your target

KPI Period
‍Type: Text
Description: Period of time the KPI is calculated over

KPI Period Days Remaining
‍Type: Number
Description: Number of days left in the reporting period

KPI Period Days Remaining Percentage
‍Type: Percent
Description: Value representing the percentage of time left in the reporting period

KPI Period To Date Performance
‍Type: Number
Description: Daily value for Calculated metrics

KPI Prediction
‍Type: Number
Description: Value predicted by the Machine Learning algorithm for a Date

KPI Prediction (Cumulative)
‍Type: Number
Description: Value predicted by the Machine Learning algorithm for a Date

KPI Prediction Percentage
‍Type: Percent
Description: Predicted value at the end of the reporting period

KPI Rolling Average Percentage
‍Type: Percent
Description: Rolling average compared to your target as a percentage. Note: Calculated metrics only

KPI Source
‍Type: Text
Description: Data source of the KPI (Google Analytics, Google Ads, Facebook, etc.)

KPI Start Date
‍Type: Date (YYYYMMDD)
Description: Date of the start of the reporting period

KPI Status
‍Type: Text
Description: Value of the KPI Status (On Track, Warning, Critical)

KPI Target
‍Type: Number
Description: Value that the KPI is trying to meet

Budget Target
‍Type: Number
Description: Value that the Budget is trying to meet

KPI Unit
‍Type: Text
Description: Text description of the metric being tracked

Resolved
‍Type: Boolean
Description: When any User Resolves the Insight this is set to True

KPI Rolling Average
‍Type: Number
Description: Calculation of the daily average over the last 30 Days, projected forward to the KPI end date. Note: Calculated metrics only

User Name
‍Type: Text
Description: Name of the User

‍