How to Export Budgets and KPIs

How to export the budgets and KPIs

You can now export all the budget and KPI data from the Budget/KPI page.

  • Filter the rows to select the data you wish to export - or export it all
  • Select a date range or pick a custom time period
  • Press export to download a CSV of the data

Details on what the columns in the exported file are can be reviewed here.


Detail on the exported columns

Column Description Expected Data Example
Platform Ad platform google
microsoft
google
Ad Account Name of Ad Account free text ACME stationery supplies
Account ID ID of Ad account, without dashes numerical 1234567890
Budget Name Name of budget free text Brand Campaigns
Budget Period Budget Schedule monthly
weekly
(blank = custom time period)
monthly
Start Date Start date of budget yyyy/mm/dd 2022-01-23
End Date End date of budget yyyy/mm/dd 2022-02-23
Account Budget? Is it a Google Account Budget (formerly known as a Budget Order)? true
false
TRUE
All Campaigns? Is it an 'All Campaigns' Budget? all = yes
blank = no
blank = Google Account Budget
all
Budget Target The budget target value number 500
Rollover The amount of rollover from the last period as a number number 32.5
Spent The amount spend so far number 287
Pacing The budget pacing as a number number 57.4
Ideal Daily Spend Calculated by dividing the remaining budget by the number of days left in the period number 65.2
Yesterdays Spend The amount spent yesterday number 62.3
KPI Type The type of KPI number_of_conversions
conv_value_cost
cost_per_conversion
number_of_conversions
KPI Details The KPI detail fixed_value
same_as_last_year
previous_period
previous_period
KPI Period If KPI Detail = previous_period, shows the number of periods to the maximum of 3, otherwise n/a 1
2
3
2
KPI Target If KPI Detail = fixed_value, shows the value of the entered target, otherwise n/a number 6
Rollover Strategy The rollover strategy selected zero
max_amount
max_percentage
all
max_percentage
Rollover Limit If Rollover Strategy = max_amount, displays the amount as a number, if Rollover Strategy = max_percentage, displays the percentage as a number, otherwise n/a number 25
AutoPacing Active? Has AutoPacing been enabled? true
false
TRUE
AutoPacing Emails emails, comma separated email format name@example.com
AutoProtect Threshold Percentage threshold when the AutoProtect will pause the campaigns, expressed as a number number 105
AutoProtect Emails emails, comma separated email format name@example.com, name2@example.com
Budget Alert Threshold Percentage threshold when the alert will trigger, expressed as a number number 95
Budget Alert Emails emails, comma separated email format name@example.com
Client Name Typically the same as the Budget Name free text ACME stationery supplies
Budget ID Adpulse unique identifier for the budget number bdg_u3j4idqgl5cyjduonbkilk72sq
Schedule Budget Target The budget target for an ongoing scheduled budget (monthly or weekly). Will be 'google' if Google Account Budget number
google
500
Number of Campaigns How many campaigns are within the budget number 6
Entry ID Adpulse unique identifier for the budget entry. Used when there are multiple periods within a budget, for example; custom periods or multiple weeks within the exported range number 26
% Spent Percentage of the budget spent, displayed as a number number 62
KPI Percentage Percentage result of the KPI towards its target number 62.32
Pacing Type Currently, there is only Linear linear linear
Schedule From yyyy/mm/dd 2022-01-23
Schedule To yyyy/mm/dd 2022-02-23
Schedule Repeat Start Start day of the period, can be 'day of month' as a number OR 'day of week' as a word. 1-30 + End of Month
MONDAY
TUESDAY
WEDNESDAY
THURSDAY
FRIDAY
SATURDAY
SUNDAY
7
Schedule Repeat Length Applied as multiplier for the period, ie. if monthly, entering 3 would set the budget as 3 months in duration OR if weekly, entering 2 would set the budget as fortnightly in duration. Typically this will be 1. number 1
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.