“I want to know my top performing markets.”More Specific Prompt:
“What are my top 5 customer countries in terms of total approved transaction value this year?”
“For the top 10 BINs with the highest attempted transaction value, chart their approval rates over the past six months, shown in a monthly graph, restricted to USA for credit card transactions only.”The danger with this one is that Pagos AI may perform a query and analysis, but is more likely to make choices in setting up the analysis that don’t correspond to your intentions. Instead try the a series of prompts:
“In the last 6 months, what were my top 10 BINs in terms of attempted transaction value for credit cards issued in the US?”
“What were the approval rates for those same BINs in that time period?”
“Chart the monthly approval rates for those BINs over the last 6 months in a line graph, with each BIN having it’s own line”Following this thread, Pagos AI produced the following visualization:
“Show me the monthly transaction count in Canada from March 1 to June 30, 2024?”For this example, we’ve included the following elements:
“Show me the percentage change of that data month over month.”
Prompt A: “Plot my approval rates using a line for each stored credential, covering the past 3 months at a daily level. Use the Seaborn library theme darkgrid.”Response:
Prompt B: “Replot this up to September 1st, and remove the “unknown” category from the chart. Fix the y-axis between 80% and 100% with subticks for every percentile, but only label the even values. Make the x- and y-axis labels and the tick labels use a larger font, and ensure that the title font is 3 points larger than that. Use a linewidth of 2 units, but the same size marker. Add large open red circles around the values for card on file that fall below 91%.”Response:
Prompt C: “Display working python code that reproduces this plot exactly. Assume that the approval rate data is stored in a dataframe namedResponse:df
with these dates in the index and the stored credential column namedstored_credential
.”
Prompt D: “Create a similar plot where the approval rate lines use an alpha of 0.3. Then, calculate the straight line of best fit for each, ignoring the values below 91%, and overlay those lines on the plot using a solid, thick line of the same color corresponding to each type of stored credential time series. Add a box to the chart that indicates the slope of each fitted line to two significant figures.”Response:
Prompt E: Express those best fit gradients in a sentence about the rate of change of approval rate as percentage points, adjusted for time units of months instead of days.Response: Here are the sentences describing the rate of change of the approval rate per month for each stored credential type, based on the gradients computed earlier from the best fit lines: