System, method, and apparatus for generating analytics with structured query files
Provided is a system, method, and apparatus for generating analytics with structured query files. The method includes the steps of generating at least one graphical user interface configured to receive query parameters from a user for querying transaction data, generating a request file based on the query parameters, the request file including a request definition object and a segment object, processing the request file to query at least one transactional database based at least partially on the request file, and generating a response file including transaction data based on a return from the query of the at least one database, the response file structured based on the request definition object from the request file.
1. A computer-implemented method for generating analytics with structured query files, comprising:
generating, with at least one processor, at least one graphical user interface configured to receive query parameters from a user for querying transaction data;
generating, with at least one processor, a request file based on the query parameters, the request file comprising a request definition object and a segment object;
transmitting, with at least one processor, the request file;
transmitting, with at least one processor, at least one external segment file separately from the request file, wherein the segment object identifies the at least one external segment file;
receiving, with at least one processor, the request file and the at least one external segment file;
querying, with at least one processor, at least one transaction database based on the request definition object and the at least one external segment file, the at least one external segment file representing a population associated with a subset of the transaction data in the at least one transaction database;
receiving, with at least one processor, a return from the query of the at least one transaction database; and
generating, with at least one processor, a response file comprising transaction data based on the return from the query, the response file structured based on the request definition object from the request file.
2. The computer-implemented method of claim 1 , wherein the request file comprises a plurality of separate queries, and wherein the response file comprises results from each of the separate queries.
3. The computer-implemented method of claim 1 , wherein the request file is structured in Javascript Object Notation (JSON) format.
4. The computer-implemented method of claim 1 , wherein the request file comprises a request type parameter identifying at least one application.
5. The computer-implemented method of claim 1 , wherein the request definition object comprises at least one of the following metadata fields: requestor identifier, project identifier, client identifier, or any combination thereof.
6. The computer-implemented method of claim 1 , wherein the request file comprises at least one query, and wherein each query of the at least one query comprises at least one of the following: a query identifier, a date filter, a dimension filter, a metric filter, an output dimension, an output metric, or any combination thereof.
7. The computer-implemented method of claim 6 , wherein the at least one query identifies the segment object.
8. A system for generating analytics with structured query files, comprising at least one processor programmed or configured to:
generate at least one graphical user interface configured to receive query parameters from a user for querying transaction data;
generate a request file based on the query parameters, the request file comprising a request definition object and a segment object;
transmit the request file;
transmit at least one external segment file separately from the request file, wherein the segment object identifies the at least one external segment file;
receive the request file and the at least one external segment file;
query at least one transaction database based on the request file and the at least one external segment file, the at least one external segment file representing a population associated with a subset of the transaction data in the at least one transaction database;
receive a return from the query of the at least one transaction database; and
generate a response file comprising transaction data based on the return from the query, the response file structured based on the request definition object from the request file.
9. The system of claim 8 , wherein the request file comprises a plurality of separate queries, and wherein the response file comprises results from each of the separate queries.
10. The system of claim 8 , wherein the request file is structured in Javascript Object Notation (JSON) format.
11. The system of claim 8 , wherein the request file comprises a request type parameter identifying at least one application.
12. The system of claim 8 , wherein the request definition object comprises at least one of the following metadata fields: requestor identifier, project identifier, client identifier, or any combination thereof.
13. The system of claim 8 , wherein the request file comprises at least one query, and wherein each query of the at least one query comprises at least one of the following: a query identifier, a date filter, a dimension filter, a metric filter, an output dimension, an output metric, or any combination thereof.
14. The system of claim 13 , wherein the at least one query identifies the segment object.
15. The system of claim 8 , wherein the segment object identifies a plurality of segment files.
16. A computer program product for generating analytics with structured query files, comprising at least one non-transitory computer-readable medium including program instructions that, when executed by at least one processor, cause the at least one processor to:
generate at least one graphical user interface configured to receive query parameters from a user for querying transaction data;
generate a request file based on the query parameters, the request file comprising a request definition object and a segment object;
transmit the request file;
transmit at least one external segment file separately from the request file, wherein the segment object identifies the at least one external segment file;
receive the request file and the at least one external segment file;
query at least one transaction database based on the request file and the at least one external segment file, the at least one external segment file representing a population associated with a subset of the transaction data in the at least one transaction database;
receive a return from the query of the at least one transaction database; and
generate a response file comprising transaction data based on the return from the query, the response file structured based on the request definition object from the request file.