Q1 QBR Data QC

Warning: package 'tidyr' was built under R version 4.2.3
Warning: package 'readr' was built under R version 4.2.3
Warning: package 'dplyr' was built under R version 4.2.3
Warning: package 'stringr' was built under R version 4.2.3
Warning: package 'flextable' was built under R version 4.2.3

Attaching package: 'flextable'
The following object is masked from 'package:purrr':

    compose
Rows: 10000 Columns: 10
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (5): Category_clean, Cadence_clean, Channel_clean, Action Code, Clean Ca...
dbl (5): JMID, Sent, Delivered, Opens, Total Clicks

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Notes/FYI

  • Pulled all Q1 and 2024 campaigns (using Quarter and Year cols) from Data Repository (pulled in some older campaigns w/ 0 data, see notes later to confirm if we are including in QBR)
  • Using ‘CampaignKey’ tab (from Ben’s xlsx) as source of truth for all clean campaign names, cadence, channel, categories. (Not using corresponding cols that were based on formula lookups in excel; there was lots of missing data bits)
  • Will we need to break out anything by touch and/or segment? Need QC there?
  • Caro still working on QoQ performance changes
  • Caro still working on benchmarks: Rolling 6 month benchmarks will be using Q4 2023 and Q1 2024 data

List of all campaigns, by campaign category and clean campaign name

Questions:

  • Do we need to include any of the ‘Other’ campaigns? They look like service messages that could be excluded?
  • Do these cleaned campaign names look correct? Can we combine touches and/or segments for the charts/tables? (in previous QBRs we have combined)
  • Are these the correct buckets? ACP, Brand/Loyalty, Device, Enterprise, HSI, Onboarding, VAS/Revenue
  • Correct campaigns in each bucket?

Please fill in notes category with the correct category and/or clean campaign name if any of these need to be corrected.

Performance by campaign category

Questions:

  • Does anything look odd here?
  • Any deployment issues to call out?
  • Missing anything?
  • Do we need to include ‘Other’ campaigns? (Might all be service messages? See table/list above)

Performance by cadence

Questions:

  • What should blanks be categorized as? Removed because they are service messages? (All campaigns missing Cadence are ‘Other’ category)
  • Does anything look odd here?
  • Any deployment issues to call out?
  • Missing anything?
Campaigns missing cadence:

Please fill in notes category with the correct cadence if any of these should be included. Or confirm that we are excluding all of these from the QBR.

Performance by channel

Questions:

  • Should ‘Other’ category campaigns be removed? Service messages?
  • Does anything look odd here?
  • Any deployment issues to call out?
  • Missing anything?

More granular QC

Now we’re getting into performance by individual campaigns, grouped by bucket. There are many campaigns that were categorized as Q1 2024 campaigns but don’t have any send/delivery/open/click data. Can we safely omit these from the QBR? Please indicate in appropriate Notes section if we should include a campaign with 0 data. Else I will remove all campaigns with 0 data.

Please make a note if anything looks unexpected and/or not right. Or should be excluded from the report.

Performance by Category: ACP

Performance by Category: Brand/Loyalty

Should ‘T Life Messaging’ campaign clicks be combined with another campaign? Odd to only have clicks.

Performance by Category: Device

Performance by Category: Enterprise

Performance by Category: HSI

Performance by Category: Onboarding

Performance by Category: VAS/Revenue

Performance by Category: Other

These are probably service messages that shouldn’t be included in QBR? Please confirm.

Language (English vs Spanish)

  • Are we including language breakout in QBR?
  • May be able to categorize from Action Code (see table below). Is this valid? Or categorize with JMID or DLIST?
  • If we are including language, please indicate appropriate language for any campaigns that are missing language, or are incorrect based on Action Code
  • Note that some campaigns may be deleted from earlier QC, for having 0 data (e.g. Q4’23 ACP Awareness T1)