SQL Code
SELECT name, id, COUNT(*) as amount, month, updated_at
FROM Api_Calls
GROUP_BY Api_Calls.date AS month
WHERE DATETIME(Api_Calls.date) > DATETIME("01-01-2023")
Explanation
The SQL Code pulls the report usage out of Postgres, including the content from Plaid, blah blah blah blah Lorem Ipsor Dolor Sit Columns Used: - Month - Name - UpdatedAt
Data
| Date | Amount | Transaction | Status |
|---|---|---|---|
| Jan | 100 | Enrichment | Completed |
| Feb | 200 | Enrichment | Completed |
| Mar | 500 | Enrichment | Completed |
| Apr | 100 | Enrichment | Completed |
| May | 300 | Enrichment | Completed |
Creator: Sarah Sarahson
Created On: July 23, 2023
Team: Sales
This report was created by Sarah Sarahson in order to prepare for a presentation for the Plaid team on the 31st of July. This report is accessible to everyone, and was validated by Nick Nicholson on August 3rd, 2023...
| Name | Source | Definition | |
|---|---|---|---|
| UpdatedAt | snowflake.postgres | Date the row was last updated | |
| Name | snowflake.postgres | Account name that consumed the API pull. More annoying text. Lorem Ipsum Dolor Sit | |
| Total_Api_Usage | dbt.metrics | Sum total of enrichment API calls |
What is the average price of products we sold last year?
This can provide insight into the pricing strategy that should be implemented going forward.
What is the average number of queries pulled over each month by industry?
This can provide insight into the pricing strategy that should be implemented going forward.
What percentage of orders included access to >10 seats on the account?
This can provide insight into the pricing strategy that should be implemented going forward.