The Scenario
You are a growth analyst at a mobile-first fintech. Your campaign team is about to split the ad budget between three carriers but wants actual session data to back the decision — not assumptions about where users are. You have 4,000 app session IP addresses sitting in an Excel workbook. The question is: how many sessions came from T-Mobile users, how many from Vodafone, how many from smaller regional carriers?
Column A has the IPs. Columns B through F are blank. The campaign budget meeting is tomorrow at 10 AM.
The bad version:
- Try to find a carrier lookup database you can download and VLOOKUP against. Find two, neither is current.
- Look up the first 20 IPs in ipdata.co manually and note the carrier field.
- Realize you have 3,980 left and no realistic path to finishing before the meeting.
The ad spend is real money. Going into the meeting with a gut guess instead of carrier data is the kind of thing that ends conversations early.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the session IP column, calls ipdata.co for carrier metadata on each row, and writes the results back into the columns you specify.
For each IP in column A, fetch the carrier name, MCC, and MNC from ipdata.co and write them to columns B, C, and D, then count sessions per carrier in a summary table starting at row 4005.
What You Get
- Column B: carrier name string (e.g., "T-Mobile USA," "Vodafone UK," "Orange France")
- Column C: MCC (Mobile Country Code) numeric value
- Column D: MNC (Mobile Network Code) numeric value
- Rows where the IP is not a mobile network come back with blank carrier fields, letting you filter mobile vs. non-mobile in one step
- Summary table below the data showing session counts per carrier, sorted by volume
What If the Data Is Not Quite Ready
The session log mixes IPv4 and IPv6 addresses
Enrich all IP addresses in column A with ipdata.co carrier data — handling both IPv4 and IPv6 formats. Write carrier name, MCC, and MNC to columns B, C, and D.
You need to segment by mobile vs. non-mobile before doing carrier analysis
Enrich all IPs in column A with ipdata.co carrier data and write carrier name to column B. In column C, write "Mobile" if a carrier name is present and "Non-Mobile" if not. Add a count of Mobile vs. Non-Mobile rows in a summary table below the data.
Session IPs span multiple date-range worksheets and need combining
Pull all IP addresses from the Sessions-Week1, Sessions-Week2, and Sessions-Week3 worksheets (column A each). Combine into a single list on a new worksheet called All-Sessions, then enrich each IP with ipdata.co carrier name and write to column B. Add a carrier frequency summary below.
Kill-chain: clean IPs, enrich carriers, segment, and build campaign targeting table
In column A, strip whitespace from each IP. Enrich each with ipdata.co carrier name, MCC, and MNC — writing to columns B, C, and D. In column E, label rows "Mobile" or "Non-Mobile." Build a summary table on a new worksheet called Carrier-Targeting showing: carrier name, session count, percentage of total, sorted descending.
One prompt delivers the full carrier breakdown your campaign team needs to allocate budget with actual data.
Try It
Get the 7-day free trial of SheetXAI and open your app session workbook, then ask SheetXAI to enrich the IP column with ipdata.co carrier data and build a carrier frequency summary. See also geo-segmenting session IPs by region and time zone or the ipdata.co integration overview.