# Export Excel report

Generates and downloads an Excel (.xlsx) report containing insight data and ratings for all filtered locations. The report includes per-location rows with metrics from connected directories (Google, Facebook, Yelp, Bing). Only columns for directories with connected listings are included. Defaults to the last week if startDate is not provided.

Endpoint: GET /dashboard/excel-export
Version: 20260701

## Query parameters:

  - `startDate` (any)
    Start date (inclusive) as an ISO-8601 date or date-time, with or without zone/offset (e.g. 2025-01-01, 2025-01-01T14:30:00, 2025-01-01T14:30:00Z, 2025-01-01T14:30:00%2B02:00). Zone-aware values are normalised to UTC. The formats yyyy.MM.dd, dd.MM.yyyy, dd-MM-yyyy HH:mm:ss and dd.MM.yyyy HH:mm:ss are also accepted. Optional for most endpoints — defaults to a period before end date if omitted.

  - `endDate` (any)
    End date (inclusive) as an ISO-8601 date or date-time, with or without zone/offset. Zone-aware values are normalised to UTC. The formats yyyy.MM.dd, dd.MM.yyyy, dd-MM-yyyy HH:mm:ss and dd.MM.yyyy HH:mm:ss are also accepted. Defaults to today.

  - `group` (string)
    Overrides the automatic granularity of the date range. Case-insensitive. When omitted, granularity is derived from the range length. Legacy values DAY, WEEK, MONTH and YEAR are also accepted. HOUR returns the whole range as a single bucket holding the ACTIONS_PHONE hour-of-day profile (phone0..phone23) and is only valid for the ACTIONS_PHONE metric; other endpoints treat it as DAILY.

  - `filterCategory` (string)
    Filter strategy to use for scoping locations

  - `locationIds` (any)
    Comma-separated location IDs (used when filterCategory=location)

  - `businessIds` (any)
    Comma-separated business IDs (used when filterCategory=business)

  - `labels` (any)
    Label names (used when filterCategory=labels)

  - `locationGroupIds` (any)
    Location group IDs (used when filterCategory=location-groups)

  - `excludedLocationIds` (any)
    Comma-separated location IDs to exclude from results

  - `excludedBusinessIds` (any)
    Comma-separated business IDs to exclude from results

  - `excludedLabels` (any)
    Label names to exclude from results

  - `excludedLocationGroupIds` (any)
    Location group IDs to exclude from results

## Response 200 fields (application/octet-stream):

  - `Location Identifier` (any)
    External identifier of the location

  - `Location Name` (any)
    Name of the location

  - `Address` (any)
    Street address of the location

  - `Average Rating` (any)
    Average rating on the given date range

  - `Total Rating` (any)
    Total number of ratings received in the date range

  - `Google Followers` (any)
    The number of people following the location on Google Maps.

  - `Google Action Driving Direction` (any)
    The number of times driving directions were requested.

  - `Google Actions Phone` (any)
    The number of times the phone number was clicked.

  - `Google Action Website` (any)
    The number of times the website was clicked.

  - `Google Local Post Actions to Call to Action` (any)
    The number of times the call to action button was clicked.

  - `Google Local Post Views Search` (any)
    The number of times the local post was viewed on Google Search.

  - `Google Photos View Customer` (any)
    The number of views on photos uploaded by customers.

  - `Google Photos View Merchant` (any)
    The number of views on photos uploaded by the merchant.

  - `Google queries chain` (any)
    The number of times a resource was shown as a result of a search for the chain it belongs to.

  - `Google Direct Queries` (any)
    The number of times the resource was shown when searching for the location directly.

  - `Google Indirect Queries` (any)
    The number of times the resource was shown as a result of a categorical search (for example, restaurant).

  - `Google Maps Views` (any)
    The number of times the resource was viewed on Google Maps.

  - `Google Search` (any)
    The number of times the resource was viewed on Google Search.

  - `Google Phone Calls 00:00-01:00` (any)
    Number of phone calls received between 00:00-01:00

  - `Google Phone Calls 01:00-02:00` (any)
    Number of phone calls received between 01:00-02:00

  - `Google Phone Calls 02:00-03:00` (any)
    Number of phone calls received between 02:00-03:00

  - `Google Phone Calls 03:00-04:00` (any)
    Number of phone calls received between 03:00-04:00

  - `Google Phone Calls 04:00-05:00` (any)
    Number of phone calls received between 04:00-05:00

  - `Google Phone Calls 05:00-06:00` (any)
    Number of phone calls received between 05:00-06:00

  - `Google Phone Calls 06:00-07:00` (any)
    Number of phone calls received between 06:00-07:00

  - `Google Phone Calls 07:00-08:00` (any)
    Number of phone calls received between 07:00-08:00

  - `Google Phone Calls 08:00-09:00` (any)
    Number of phone calls received between 08:00-09:00

  - `Google Phone Calls 09:00-10:00` (any)
    Number of phone calls received between 09:00-10:00

  - `Google Phone Calls 10:00-11:00` (any)
    Number of phone calls received between 10:00-11:00

  - `Google Phone Calls 11:00-12:00` (any)
    Number of phone calls received between 11:00-12:00

  - `Google Phone Calls 12:00-13:00` (any)
    Number of phone calls received between 12:00-13:00

  - `Google Phone Calls 13:00-14:00` (any)
    Number of phone calls received between 13:00-14:00

  - `Google Phone Calls 14:00-15:00` (any)
    Number of phone calls received between 14:00-15:00

  - `Google Phone Calls 15:00-16:00` (any)
    Number of phone calls received between 15:00-16:00

  - `Google Phone Calls 16:00-17:00` (any)
    Number of phone calls received between 16:00-17:00

  - `Google Phone Calls 17:00-18:00` (any)
    Number of phone calls received between 17:00-18:00

  - `Google Phone Calls 18:00-19:00` (any)
    Number of phone calls received between 18:00-19:00

  - `Google Phone Calls 19:00-20:00` (any)
    Number of phone calls received between 19:00-20:00

  - `Google Phone Calls 20:00-21:00` (any)
    Number of phone calls received between 20:00-21:00

  - `Google Phone Calls 21:00-22:00` (any)
    Number of phone calls received between 21:00-22:00

  - `Google Phone Calls 22:00-23:00` (any)
    Number of phone calls received between 22:00-23:00

  - `Google Phone Calls 23:00-00:00` (any)
    Number of phone calls received between 23:00-00:00

  - `Google Business Impressions Desktop Maps` (any)
    Number of impressions during time period from a Desktop computer on the customer's map listing.

  - `Google Business Impressions Desktop Search` (any)
    Number of impressions during time period from a Desktop computer on the customer's search listing.

  - `Google Business Impressions Mobile Maps` (any)
    Number of impressions during time period from a Mobile Device on the customer's map listing.

  - `Google Business Impressions Mobile Search` (any)
    Number of impressions during time period from a Mobile Device on the customer's search listing.

  - `Google Business Conversation` (any)
    Count of number of customers who clicked on the chat function associated with the customer.

  - `Google Business Direction Requests` (any)
    Count of number of customers who clicked on the Directions (Google) function associated with the customer's location.

  - `Google Call Clicks` (any)
    Count of number of customers who clicked on the call function associated with the customer

  - `Google Website Clicks` (any)
    The number of clicks on your Business Profile's website link.

  - `Google Business Bookings` (any)
    Count of number of customers who clicked on the Bookings function (Google) associated with the customer.

  - `Google Business Food Orders` (any)
    Count of number of customers who clicked on the Food Order function (Google) associated with the customer.

  - `Google Business Food Menu Clicks` (any)
    Count of number of customers who clicked on the menu (Google) associated with the customer.

  - `Facebook Page Consumptions` (any)
    The number of times people clicked on any of the page's content

  - `Facebook page link clicks` (any)
    The number of times people clicked on links in the Facebook page

  - `Facebook page other clicks` (any)
    The number of times people clicked on other content on the page

  - `Facebook page photo views` (any)
    The number of times photos on the Facebook page were viewed

  - `Facebook page video plays` (any)
    The number of times videos on the Facebook page were played

  - `Facebook page other consumptions` (any)
    The number of other types of content consumptions on the page

  - `Facebook page new likes` (any)
    The number of new likes the Facebook page received

  - `Facebook page new unlikes` (any)
    The number of unlikes the Facebook page received

  - `Facebook page fans` (any)
    The total number of people who have liked the Facebook page

  - `Female fans aged 18-24` (any)
    Number of female fans aged 18-24

  - `Male fans aged 18-24` (any)
    Number of male fans aged 18-24

  - `Fans aged 18-24 with an undisclosed gender` (any)
    Number of fans aged 18-24 with an undisclosed gender

  - `Female fans aged 55-64` (any)
    Number of female fans aged 55-64

  - `Male fans aged 55-64` (any)
    Number of male fans aged 55-64

  - `Fans aged 55-64 with an undisclosed gender` (any)
    Number of fans aged 55-64 with an undisclosed gender

  - `Female fans aged 45-54` (any)
    Number of female fans aged 45-54

  - `Male fans aged 45-54` (any)
    Number of male fans aged 45-54

  - `Fans aged 45-54 with an undisclosed gender` (any)
    Number of fans aged 45-54 with an undisclosed gender

  - `Female fans aged 65+` (any)
    Number of female fans aged 65 and above

  - `Male fans aged 65+` (any)
    Number of male fans aged 65 and above

  - `Fans aged 65+ undisclosed gender` (any)
    Number of fans aged 65 and above with an undisclosed gender

  - `Female fans aged 13-17` (any)
    Number of female fans aged 13-17

  - `Male fans aged 13-17` (any)
    Number of male fans aged 13-17

  - `Fans aged 13-17 with an undisclosed gender` (any)
    Number of fans aged 13-17 with an undisclosed gender

  - `Female fans aged 35-44` (any)
    Number of female fans aged 35-44

  - `Male fans aged 35-44` (any)
    Number of male fans aged 35-44

  - `Fans aged 35-44 with an undisclosed gender` (any)
    Number of fans aged 35-44 with an undisclosed gender

  - `Female fans aged 25-34` (any)
    Number of female fans aged 25-34

  - `Male fans aged 25-34` (any)
    Number of male fans aged 25-34

  - `Fans aged 25-34 with an undisclosed gender` (any)
    Number of fans aged 25-34 with an undisclosed gender

  - `Facebook Page Impressions` (any)
    The total number of times the Facebook page was viewed

  - `Facebook page impressions via unpaid distribution` (any)
    Number of times the page was displayed through unpaid distribution

  - `Facebook page impressions via paid distribution` (any)
    Number of times the page was displayed through paid distribution

  - `Facebook page impressions with social information` (any)
    Number of times the page was displayed with social information attached

  - `Facebook post from a Facebook page via unpaid distribution` (any)
    Number of times posts were displayed through unpaid distribution

  - `Facebook post from a Facebook page via paid distribution` (any)
    Number of times posts were displayed through paid distribution

  - `Facebook post from a Facebook page with social information` (any)
    Number of times posts were displayed with social information attached

  - `Facebook post entering a person's screen` (any)
    Total number of times posts entered a person's screen

  - `Facebook post that a person has interacted with` (any)
    Total number of interactions people had with posts

  - `Facebook story on your page` (any)
    The number of stories created about your Page (Stories)

  - `Facebook page follows` (any)
    The total number of people who follow your Page

  - `Facebook page media views not from ads` (any)
    The number of times your content was played or displayed. Content includes videos, posts, stories and ads.

  - `Facebook page media views from ads` (any)
    The number of times your content was played or displayed in ads.

  - `Facebook page views` (any)
    Total number of times the Facebook page or its content was viewed

  - `Facebook Page Media View` (any)
    The number of times media on the Facebook page were viewed

  - `Yelp Calls` (any)
    The number of phone calls initiated from the Yelp business listing.

  - `Yelp directions and map views` (any)
    The number of times users viewed directions or maps for the business on Yelp.

  - `Yelp page views` (any)
    The number of times the business page was viewed on Yelp.

  - `Yelp clicks` (any)
    The number of times users clicked on links from the Yelp business listing.

  - `Bing Search page desktop directions clicks` (any)
    The number of times users clicked on directions from the desktop Bing search page.

  - `Bing Search page desktop photos clicks` (any)
    The number of times users clicked on photos from the desktop Bing search page.

  - `Bing Search page desktop website clicks` (any)
    The number of times users clicked on the website link from the desktop Bing search page.

  - `Bing Search page mobile directions clicks` (any)
    The number of times users clicked on directions from the mobile Bing search page.

  - `Bing Search page mobile website clicks` (any)
    The number of times users clicked on the website link from the mobile Bing search page.

  - `Bing Maps desktop views` (any)
    The number of times the business was viewed on Bing Maps from desktop devices.

  - `Bing Search page desktop views` (any)
    The number of times the business listing was viewed on the desktop Bing search page.

  - `Bing Maps mobile views` (any)
    The number of times the business was viewed on Bing Maps from mobile devices.

  - `Bing Search page mobile views` (any)
    The number of times the business listing was viewed on the mobile Bing search page.

