Easy App Reports

Returns a table's columns, types and meaning, plus any rules for querying it. Call it for each table you will use in run_query.

get_table_schema

Lists the company's Easy App Reports tables: what each one is for, the latest date it has data for, and which data sources are not connected. Call this first, before writing any query.

list_tables

Runs one read-only SELECT on the company's Easy App Reports data in Google BigQuery (GoogleSQL, https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax) that calculates revenue per download for an app, by country, and returns the rows. The calculation: App Store (iOS), joined on territory: - Downloads: as_analytics_downloads, SUM(counts) where download_type IN ('First-time download', 'Redownload'); other download types are updates and restores, not downloads. - Revenue: as_analytics_purchases, SUM(proceeds_in_usd), already in USD. - App filter: app_name. Google Play (Android), joined on gdc_earnings.buyer_country = gdc_installs_country.country: - Downloads: gdc_installs_country, SUM(daily_user_installs). - Revenue: gdc_earnings, SUM(amount_merchant_currency) where transaction_type = 'Charge' (gross charges, before Google's fee and refunds). - App filter: package_name in gdc_installs_country, product_id in gdc_earnings. - Currency: amounts are in merchant_currency, the developer's payout currency (for example BRL for a Brazilian developer), which is USD only for some accounts. Revenue per download = revenue / NULLIF(downloads, 0), per country, over the same date range for both. Countries with no downloads have no revenue per download.

revenue_per_download_analysis

Runs one read-only SELECT on the company's Easy App Reports data in Google BigQuery and returns the rows. The query is BigQuery GoogleSQL (https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax). Table names come from list_tables (e.g. gdc_reviews or ear_all_sources.gdc_reviews; the project is filled in) and columns from get_table_schema; name the columns you need rather than SELECT *.

run_query

Sends the user's feedback about the Easy App Reports connector (a problem, a wrong answer or a suggestion) to the Easy App Reports team. Use it only when the user asks to send feedback; the text is sent as the user wrote or confirmed it.

send_feedback

Shows the user a dashboard in the chat: KPI tiles, up to 4 line or bar charts and a table, from data you already got with run_query. Use it when the user asks for a dashboard, chart, trend or comparison. Use only numbers from query results, say the period in the subtitle, give money a currency code, and add notes for data that is not recent. Line charts for change over time, bar charts to compare items; at most 4 series per chart. Table rows appear in the order given; for a ranked table (top countries, top apps) set table.sortBy and the widget sorts them. Users can re-sort by clicking a column header.

show_dashboard