Media buy loader, graphical user interface, and method of correlating media buys to customer intakes
A method includes recording client intakes, the client intakes including information about potential customers; recording a time and date when each intake was initiated by one of the potential customers; recording data about an advertising campaign including a start date and end date of the campaign, cost of the campaign, durations of advertisements in the campaign, name of a broadcast program into which the advertisements are inserted, and times when the program is broadcast; converting the data about advertising campaigns into ad time slot data including a time range in which a broadcast program runs and average number of times the advertisements run during the time range; and selectively generating an output visually indicating cost of advertisements versus time of day, number of intakes versus time of day, and cost of the advertisements versus time of day. Other systems and methods are provided.
1. A system comprising:
a PBX configured to be coupled to at least one phone line having multiple different channels to receive incoming phone calls from potential customers;
an OAI gateway coupled to the PBX server and configured to provide an interface to the PBX;
a main server coupled to the OAI gateway, and configured to be accessed by client workstations, the main server including:
an OAI listener coupled to the OAI gateway;
a notification server coupled to the OAI listener;
a memory defining a database and coupled to the OAI listener; and
an intake application server coupled to the database and configured to present to a workstation a graphical user interface for receiving intake information about the potential customer; and
a media buy loader configured to:
record the information about the potential customer and to record a time and date when an intake was initiated by the potential customer;
record data about a television advertising campaign comprised of purchased broadcast television advertisements, including a start date and end date of the campaign, cost of the campaign, durations of advertisements in the campaign, name of a television broadcast program into which the advertisements are inserted, and times when the television program is broadcast;
convert the data about advertising campaigns into ad time slot data including a time range in which a broadcast program runs and average number of times the advertisements run during the time range; and
generate a graphical user interface configured to visually illustrate cost of television advertisements versus time of day.
2. A system in accordance with claim 1 wherein the media buy loader is configured to receive and record a name of a channel that broadcasts a program into which the advertisements are inserted.
3. A system in accordance with claim 2 wherein the media buy loader is further configured to receive and record a day of the week when the television program into which the advertisements are inserted is broadcast.
4. A system in accordance with claim 1 wherein the graphical user interface is configured to selectively generate superimposed graphs simultaneously visually indicating duration of the advertisements versus time of day, number of intakes versus time of day, and cost of the advertisements versus time of day.
5. A system in accordance with claim 1 wherein the graphical user interface includes a user operable element which, when actuated by a user, allows the user to save a graphical file containing an image of a generated graph in any of a number of file formats.
6. A system in accordance with claim 1 wherein the graphical user interface includes a user operable element which, when actuated by a user, allows the user to filter by when intakes occurred.
7. A system in accordance with claim 2 wherein the graphical user interface includes a user operable element which, when actuated by a user, allows the user to filter by program.
8. A system in accordance with claim 2 wherein the graphical user interface includes a user operable element which, when actuated by a user, allows the user to filter by channel.
9. A system comprising:
a PBX configured to be coupled to at least one phone line having multiple different channels to receive incoming phone calls from potential customers, the different channels coupling to the PBX different phone numbers to be called by potential customers;
an OAI gateway coupled to the PBX server and configured to provide an interface to the PBX;
a main server coupled to the OAI gateway, and configured to be accessed by client workstations, the main server including:
an OAI listener coupled to the OAI gateway;
a notification server coupled to the OAI listener;
a memory defining a database and coupled to the OAI listener; and
an intake application server coupled to the database and configured to present to a workstation a graphical user interface for receiving intake information about the potential customer; and
a media buy loader configured to:
record the information about the potential customer and to record a time and date when an intake was initiated by the potential customer;
record data about a broadcast advertising campaign comprised of purchased broadcast advertisements, the data including a start date and end date of the campaign, cost of the campaign, durations of advertisements in the campaign, name of a broadcast program into which the advertisements are inserted, and times when the program is broadcast;
normalize the data about advertising campaigns into ad time slot data including a time range in which a broadcast program runs and average number of times the advertisements run during the time range; and
selectively generate an output graphically indicating cost of advertisements versus time of day.
10. A system in accordance with claim 9 wherein the media buy loader is configured to receive and record a name of a broadcast channel broadcasting the program into which the advertisements are inserted.
11. A system in accordance with claim 9 wherein the media buy loader is further configured to receive and record a day of the week when the program into which the advertisements are inserted is broadcast.
12. A system in accordance with claim 9 wherein the media buy loader is configured to selectively generate an output visually indicating duration of advertisements versus time of day.
13. A system in accordance with claim 9 wherein the media buy loader is configured to selectively generate an output visually indicating number of intakes versus time of day.
14. A system in accordance with claim 9 wherein the media buy loader is configured to selectively generate an output simultaneously visually indicating duration of the advertisements versus time of day, number of intakes versus time of day, and cost of the advertisements versus time of day.
15. A system in accordance with claim 9 wherein the ad timeslot data includes average length of the advertisements during the time range.
16. A system in accordance with claim 9 wherein the ad timeslot data includes average cost of the advertisements during the time range.
17. A method comprising:
providing a PBX configured to be coupled to at least one phone line having multiple different channels to receive incoming phone calls from potential customers;
providing an OAI gateway coupled to the PBX server and configured to provide an interface to the PBX;
providing a main server coupled to the OAI gateway, and configured to be accessed by client workstations, the main server including:
an OAI listener coupled to the OAI gateway;
a notification server coupled to the OAI listener;
a memory defining a database and coupled to the OAI listener; and
an intake application server coupled to the database and configured to present to a workstation a graphical user interface for receiving intake information about the potential customer;
recording client intakes, the client intakes including information about potential customers;
recording a time and date when each intake was initiated by one of the potential customers;
recording data about an advertising campaign comprised of previously purchased advertisements, the data including a start date and end date of the campaign, cost of the campaign, durations of advertisements in the campaign, name of a broadcast program into which the advertisements are inserted, and times when the program is broadcast;
converting the data about advertising campaigns into ad time slot data including a time range in which a broadcast program runs and average number of times the advertisements run during the time range; and
selectively generating an output graphically indicating cost of advertisements versus time of day, number of intakes versus time of day, and cost of the advertisements versus time of day.
18. A method in accordance with claim 17 wherein selectively generating an output comprises generating a graphical user interface that includes a user operable element which, when actuated by a user, allows the user to filter by when intakes occurred.
19. A method in accordance with claim 17 wherein selectively generating an output comprises generating a graphical user interface that includes a user operable element which, when actuated by a user, allows the user to filter by program.
20. A method in accordance with claim 17 wherein selectively generating an output comprises generating a graphical user interface that includes a user operable element which, when actuated by a user, allows the user to filter by channel.